Content pfp
Content
@
0 reply
20 recasts
20 reactions
Garrett pfp
Garrett
@garrett
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?
6 replies
1 recast
34 reactions
tldr (tim reilly) pfp
tldr (tim reilly)
@tldr
my mental approximation for qDAU is ~50x the number of likes on the most liked cast of the day
3 replies
1 recast
11 reactions
Pichi 🟪🍖🐹🎩 🍡🌸 pfp
Pichi 🟪🍖🐹🎩 🍡🌸
@pichi
This is my new Bible. Who’s here daily. https://dune.com/queries/4733142
1 reply
0 recast
1 reaction
Garrett pfp
Garrett
@garrett
This seems pretty accurate from my personal experience. I had always thought that Farcaster Daily Posters oscillated between 10-20k
1 reply
0 recast
2 reactions
Pichi 🟪🍖🐹🎩 🍡🌸 pfp
Pichi 🟪🍖🐹🎩 🍡🌸
@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
2 reactions
Kasra Rahjerdi pfp
Kasra Rahjerdi
@jc4p
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
2 reactions
rish pfp
rish
@rish
It’s in our sql playground, not on dune yet
1 reply
0 recast
3 reactions
Kasra Rahjerdi pfp
Kasra Rahjerdi
@jc4p
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
3 reactions
mvr 🐹 pfp
mvr 🐹
@mvr
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
3 reactions
rish pfp
rish
@rish
neynar data updates every 30 mins or so
2 replies
0 recast
4 reactions
mvr 🐹 pfp
mvr 🐹
@mvr
wow that would be great! are we both talking about the spam labels? 😅
1 reply
0 recast
3 reactions
rish pfp
rish
@rish
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
3 reactions
mvr 🐹 pfp
mvr 🐹
@mvr
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
2 reactions