mvr 🐹 on Warpcast

Content pfp

0 reply

20 recasts

20 reactions

Garrett pfp

Farcaster is almost to the millionth FID or registered account What’s the best data source to track DAU now? Does anyone have a good dune?

5 replies

0 recast

23 reactions

tldr (tim reilly) pfp

tldr (tim reilly)

my mental approximation for qDAU is ~50x the number of likes on the most liked cast of the day

3 replies

0 recast

7 reactions

Pichi 🟪 🍡🌸 pfp

Pichi 🟪 🍡🌸

This is my new Bible. Who’s here daily. https://dune.com/queries/4733142

1 reply

0 recast

0 reaction

Garrett pfp

This seems pretty accurate from my personal experience. I had always thought that Farcaster Daily Posters oscillated between 10-20k

1 reply

0 recast

1 reaction

Pichi 🟪 🍡🌸 pfp

Pichi 🟪 🍡🌸

My gut stays its right. And the number of good accounts is even lower but I don’t know how you’d pull qDAU? @jc4p is it possible to cross reference this with the public spam labels? I’d like to know how many of these are level 2. My guess would be 2-3k but I’d love to know for real. @mvr would line your thoughts too

1 reply

0 recast

0 reaction

Kasra Rahjerdi pfp

i’m like 80% sure @rish added the labels to the Dune dataset recently, will investigate and see if i can add into my query!

2 replies

0 recast

1 reaction

rish pfp

It’s in our sql playground, not on dune yet

1 reply

0 recast

1 reaction

Kasra Rahjerdi pfp

ty!! @pichi i’ll run the data for you in neyar’s sql playground so we have a snapshot then add it to the dune later :)

2 replies

0 recast

2 reactions

mvr 🐹 pfp

fwiw this is the source thats imported to multiple datasets in Dune https://github.com/warpcast/labels not sure if you can rely on any (I mean no guarentees they are updated every week with a fresh set) @rish yours also updates weekly or realtime?

2 replies

0 recast

1 reaction

rish pfp

neynar data updates every 30 mins or so

2 replies

0 recast

2 reactions

mvr 🐹 pfp

wow that would be great! are we both talking about the spam labels? 😅

1 reply

0 recast

1 reaction

rish pfp

no I was talking about the general neynar dataset, warpcast labels are not pushed by us yet https://warpcast.com/rish/0xdf6be95c

1 reply

0 recast

2 reactions

mvr 🐹 pfp

Yeah I read that but was wondering where you're pulling it from the same github source we have (so weekly) or do you have more up to date data for the playground (and future dune) since the labels are updated every hour

1 reply

0 recast

1 reaction

rish pfp

no warpcast label latency is decided by warpcast so same for everyone

1 reply

0 recast

2 reactions

mvr 🐹 pfp

0 reply

0 recast

2 reactions