farcasterunion

When I run @mvr ‘s cool new Dune query for active, non spammy followers, I get some interesting results. 

1. Quality casters (level 2 spam label: the good one) who casted at least 4 times in 30 days (aka once a week):
5640

2. Who casted 2/3 times a week: 
3,191

3. Who casted every day for the past month: 
1,122

If you are here to vibe everyday, probably more important to engage with group 3 the most.  

You can change the parameters of the Dune query yourself to what you consider “active/engaged”.

hamst.art $hamster /hamster 
martinvr.eth 
deploy.degen.eth

When I run @mvr ‘s cool new Dune query for active, non spammy followers, I get some interesting results. 

1. Quality casters (level 2 spam label: the good one) who casted at least 4 times in 30 days (aka once a week):
5640

2. Who casted 2/3 times a week: 
3,191

3. Who casted every day for the past month: 
1,122

If you are here to vibe everyday, probably more important to engage with group 3 the most.  

You can change the parameters of the Dune query yourself to what you consider “active/engaged”. 

https://dune.com/queries/4761620?previous_days_t6c1ea=30&times_casted_t6c1ea=4

Pi-chi.eth (she/her) Artist /animeoutcasts
Purple Promoter| Hosting: /moxietools /kyoto /momiji  /anime-manga /farcasterunion

https://portrait.so/pichi

So interesting! Love how much data is available through farcaster

/cal 

Photographer, Artist, Web3 Educator, IP Lawyer, Patent Agent, Explorer 📸⛰️✨ 

 Building /flowcast with /mindfulness 🌊

https://wanderloots.com/links

Oh I know, one of my favourite parts of being here 

The question is how do we get more people to care about this distinction?

It’s crazy how open it really is. Farcaster as a protocol is game changer. No Web2 company would ever let us dig into their data like this.