Request for dune query: a table of farcasters sorted by descending by number of consecutive weeks active on Farcaster into the past since this week. Active means like or cast once in that week, weeks go Mon -> Sun. 

Will tip my ~10K daily degen allocation to a correct query

95% of the way there, I think... sanity check shows 200,707 unique casters, while query is returning 201,008 rows. Have some tests in there, but it's fiddly testing in Dune... Need to eat dinner, though!

Building open source via @frames, /open-frames to help Farcaster and decentralized social win. a16z CSX23. Side proj: farcasterchannels.com farcaster.id @search

Husband, dad, dev. I document what I see.

⛔ NOT FINANCIAL ADVICE OR A RECOMMENDATION ⛔

My DEGEN Tips FAQ: https://paragraph.xyz/@rjs/degen-tips-ultimate-faq

really cool, thanks! Curious where Dan went on this list.. 12000 $degen

95% of the way there, I think... sanity check shows 200,707 unique casters, while query is returning 201,008 rows. Have some tests in there, but it's fiddly testing in Dune... Need to eat dinner, though! https://dune.com/queries/3669223

Bounties

should also cast in /bounties if you haven't already

i wish i was good with sql :')