a place to discuss dune.com features, issues, and content

Join: https://modbot.sh/channels/dune/join

Main

Dune

dune

New dSheets Upgrade🧙‍♀️⁺₊✧
Dune wizardry & Accounting magic

🍰Live price updates: no more re-running queries, cells will auto-update & move w/ the market

🍵New @dune.eth function: query data from 60+ chains->wallet tx activity, balances, token metrics, holders info & moore 👇

You can now pull Dune data straight into your spreadsheets with =dune on dsheets.new 🧑‍🔬

Does anyone know if I can count "comments/replies" per cast? I found the big table (dune.neynar.dataset_Farcaster_reactions) to count likes and recasts, but I don't think replies are as simple. 

Appreciate any insight and leads!

$WLFI trading just went live with $30B FDV out the gate and $223M DEX Volume. Uniswap dominates 94% of on-chain activity although volume cooled after the initial hour rush.

Will be interesting to see if trading picks up tomorrow post-US Holiday.

Dune Dashboard below ⬇️

another day, another degraded dune. 

its just annoying, because we are all context switching in the age of ai agentic workflows.

we are spending more time becoming managers, rather than just full on makers. a little paradigm shift.

▶ You forked a Dune query!
Novice Dune Witch appears (Lv. 1)
HP: ████▒▒▒▒▒▒ 34/60
MP: ██▒▒▒▒▒▒▒▒ 8/40
EXP: 42 → next level in sight
Command? [ CAST SQL ]

[ A ] Save and continue
[ B ] Panic and close tabs

Forking a Dune query is just copying someone else’s work…but that’s the point.

You don’t start from scratch.
You tweak the variables.
You see what breaks.

Best way to learn is to FAFO.

And I stayed up way too late doing it. 

If you're already used to using multiple AI agents anyway (across projects), this sort of queue isn't actually a bad thing. 

Part of your maker schedule is actually the manager schedule.

@dune.eth Dashboard for Farcaster - USDC Rewards - Detailed stats from the start of this rewards (17th Dec, 2024) with score, rank, rewards for every week. You can also find top creators and their rewards stats.

@dune.eth Dashboard for Farcaster - USDC Rewards - Detailed stats from the start of this rewards (17th Dec, 2024) with score, rank, rewards for every week. You can also find top creators and their rewards stats. 

https://dune.com/jkavithamahesh/farcaster-usdc-rewards-with-points-and-ranks

Worth checking this out

https://dune.com/blog/the-state-of-evm-indexing

dune free, becomes less free. thank you for being kind for so long, might be time for that upgrade.

strangely the large query engine is a steep jump from $49 -> $399 per month

cc: @cryptonjal @mvr @pichi

day job pays the bills, night job builds the future

Hamster

Pi-chi.eth artist of /animeoutcasts
Hosting: /kyoto /anime-manga /farcasterunion

https://portrait.so/pichi

pichi

Interests: crypto, economics, TA & blockchain related innovations | 🔗 https://linktr.ee/cryptonjal 🔗 https://dune.com/nhejyht

McWarp

New @dune.eth Dashboard

Track Farcaster users activity over the past 30 days — broken down by hour (UTC).

Find the best time to post, or view when your followers are most active by entering your FID and run the dashboard.

New @dune.eth Dashboard

Track Farcaster users activity over the past 30 days — broken down by hour (UTC).

Find the best time to post, or view when your followers are most active by entering your FID and run the dashboard. 

https://dune.com/jkavithamahesh/farcaster-activities-utc-time-zone

Adding Dune charts on spreadsheet w/ dsheets.new

Is there dune dash for casts that gives accurate cast time and date graphs for all casts (not interested in specific casts, so rather a broad overview) and adding is there a similar dune dash that would give you time, date and engagement data for a specific user?

@dune.eth Dashboard for Farcaster Stats

- Farcaster User Growth
- DAU Last 3 Months (Spam Label 2 and all)
- Daily and Monthly Casts
- Daily and Monthly reactions

@dune.eth Dashboard for Farcaster Stats

- Farcaster User Growth
- DAU Last 3 Months (Spam Label 2 and all)
- Daily and Monthly Casts
- Daily and Monthly reactions

https://dune.com/jkavithamahesh/farcaster-growth-stats

Created a new @dune.eth dashboard for the Base App Rewards.

Created a new @dune.eth dashboard for the Base App Rewards.

https://dune.com/jkavithamahesh/tba-the-base-app-rewards