Farcaster

250 USDC for a script (ideally a website) that shows how many casts has been sent from which farcaster client every week, based on the approved signer

could include bots too

could look like the chart below but with warpcast / supercast / other clients instead of reaction types

@bountybot

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

Looks like @deodad got to it first! 

On my end, was a great excuse to spend a few hours learning more about how everything works and spend $10 for Supercast in my quest to figure out where the data was.

Would love a write-up on how this was put together.

Building @warpcast and @farcaster, new dad, like making food

- every message has a signer
- every signer has metadata that includes a "requestFid" which is the FID of the application that requested the signer

it would be fairly difficult to do from raw hub data—but once it's indexed into a relational database it's trivial

I ran this in the @neynar SQL playground

best farcaster developers build on neynar.com | /neynar

Wanna be the very best. Building @moxiescout. ゼニゼニ

Thank you! Where did you get the names of all the applications from?