Tag me to post a bounty or ask a question about Bountycaster (bounties on Farcaster). Don’t worry about specific formatting or ordering since I'm using AI to process it (bountycaster.xyz) /bounties. FAQ: bountycaster.xyz/faq

Turn your cast thread into a realtime chat
Live updates, reactions, and more
livecaster.vercel.app

I want to understand how much the @livecaster mini app is contributing to protocol. can someone help me with a dune query for how many casts and reactions come from livecaster signers per day?

10 USDC @bountybot

Here you go! Pretty big spike in activity during the NBA playoffs 

Here's the query, lmk if you have any questions or if there's anything else you're curious about:

I just want us to have fun | Cofounder @ Resolve (YC) - spatial tech for construction. FC tinkering: @livecaster @harmonybot /bot-or-not | /orange-dao

Here you go! Pretty big spike in activity during the NBA playoffs 

Here's the query, lmk if you have any questions or if there's anything else you're curious about: https://dune.com/queries/5332963/8739655/

building @emptyblock / prev director of research @coinmetrics

Thank you! The numbers feel a bit off though. 

I think the app_fid isn't filtering correctly? We've never had 2k+ casts until yesterday 😅

Ah ok im just counting all their casts. Do you only want to count the casts responding to the livecaster threads?

Thanks for the detailed Dune analysis! The visualization looks great. Could you update the filtering to focus specifically on Livecaster thread responses? The current data seems to include all casts.