dune
/dune2752
a place to discuss dune.com features, issues, and content
Question, how can I use a `varbinary` in a CONCAT function?
Use case: Trying to create a warpcast link from fname and hash.
https://dune.com/queries/4168832/7016753/
Use case: Trying to create a warpcast link from fname and hash.
https://dune.com/queries/4168832/7016753/
Sharing my very first query on Dune.
https://dune.com/queries/4168745/7016706/
Purpose: How many times a keyword appears on a daily basis?
Usage:
- How many times your brand is tagged in a day?
- How many times a problem is mentioned in a day?
- How many times you're tagged in a day?
I'm using it for
- Measuring popularity with the movie game and Percs.
Ps. I wish @buoy had this feature.
https://dune.com/queries/4168745/7016706/
Purpose: How many times a keyword appears on a daily basis?
Usage:
- How many times your brand is tagged in a day?
- How many times a problem is mentioned in a day?
- How many times you're tagged in a day?
I'm using it for
- Measuring popularity with the movie game and Percs.
Ps. I wish @buoy had this feature.
Working on some Solana APIs
The calm before the storm... Minted on @dune.eth / @zora the culture 🫡
https://zora.co/collect/base:0xdc6b3687d5d9ada19faad9e782e3ece41e1da7ba/6927
https://zora.co/collect/base:0xdc6b3687d5d9ada19faad9e782e3ece41e1da7ba/6927
Less than one month to dunecon 👀
Great opportunity to look at some /dune /neynar data.
Here are some insights:
19 days ago I looked at two metrics:
1) total number of active fids in 24h
2) total number of massive spammers (more than 1k casts per day)
19 days ago:
Number of active fids: ~16-17k
Number of massive spammers 13
Today:
Number of active fids: ~13k
Number of massive spammers: 7
An active caster in the query is someone who did at least 2 casts, obviously in this number automated accounts also are included.
What we are missing in data is a way to find how many authorized active fids are, meaning subtracting from 13k people those that have casted using the protocol in channels where they didn't have a membership, logic tells us that this will further decrease the 13k number.
So this is a very long way of saying that, there's less activity than before.
Whether that is good or not, depends totally on the preferences of users.
Here are some insights:
19 days ago I looked at two metrics:
1) total number of active fids in 24h
2) total number of massive spammers (more than 1k casts per day)
19 days ago:
Number of active fids: ~16-17k
Number of massive spammers 13
Today:
Number of active fids: ~13k
Number of massive spammers: 7
An active caster in the query is someone who did at least 2 casts, obviously in this number automated accounts also are included.
What we are missing in data is a way to find how many authorized active fids are, meaning subtracting from 13k people those that have casted using the protocol in channels where they didn't have a membership, logic tells us that this will further decrease the 13k number.
So this is a very long way of saying that, there's less activity than before.
Whether that is good or not, depends totally on the preferences of users.
Have personally loved this new upgrade to /interface and the fact that it’s powered by /dune just makes it better
Each and every chain’s most important milestones. Visualized on Dune.
had fun learning more dune this week, just a draft but its saturday so I can share
https://dune.com/proxystudio/draftpooltracker
https://dune.com/proxystudio/draftpooltracker
43 000 lego blocks deployed
This and pnl in profiles are entirely powered by @dune.eth API.
If you are building in crypto and not yet leveraging most powerful infrastructure in the space, ngmi
Also I think there is huge potential to build out community driven pnl for all sort of market makers and significantly improve what we have shipped so far.
Image comprehensive market markers analysis available inside any wallet, app, etc for all sorts of markets be that generic erc20s, /zora, /polymarket or any other.
If you are building in crypto and not yet leveraging most powerful infrastructure in the space, ngmi
Also I think there is huge potential to build out community driven pnl for all sort of market makers and significantly improve what we have shipped so far.
Image comprehensive market markers analysis available inside any wallet, app, etc for all sorts of markets be that generic erc20s, /zora, /polymarket or any other.
Can’t wait to analyze this on Dune
Dune is getting really good. AI + Fix query helped me make this query in 10mins despite not understanding the dune sql flavour at all.
These materialized views look interesting too.
These materialized views look interesting too.
So many cool conversations this week
Lining up some good stuff for Dunecon
Quick win?
@bountybot
bounty: revise a /dune dashboard tracking @proxyswap fees on base + degen layer 3
payment: $50
note: degen data on L3 is raw blockchain data https://docs.dune.com/data-catalog/evm/degen/overview
I have a semi-functional draft, looking to improve it with guidance from someone smarter than me in this arena!
bounty: revise a /dune dashboard tracking @proxyswap fees on base + degen layer 3
payment: $50
note: degen data on L3 is raw blockchain data https://docs.dune.com/data-catalog/evm/degen/overview
I have a semi-functional draft, looking to improve it with guidance from someone smarter than me in this arena!
BTC.B seems to be the most popular token among LayerZero OFT token transfers between blockchains - over 3 million total cross-chain transfers.
gotta love Dune-based cast analysis
coming out of today's live stream session we have a new materialized view on /dune of the /farcards big data set. materialized views allow anyone to use the data set in their own queries. big updates incoming
https://dune.com/workspace/u/beachcrypto/library/materialized-views
https://dune.com/workspace/u/beachcrypto/library/materialized-views
What’s the population overlap between DAU on Lens vs Farcaster? Is there a dashboard comparing these groups?
My hypothesis is that the overlap is significant
My hypothesis is that the overlap is significant