Content pfp
Content
@
0 reply
20 recasts
20 reactions
tomu pfp
tomu
@tomu.eth
what's the easiest way to get a list of fids/fname and their addresses? ie most active users in the last 6 months any dune dashboard?
2 replies
0 recast
9 reactions
Itsai ⌐◨-◨ pfp
Itsai ⌐◨-◨
@itsai
I think this is what you are looking for, let me know if it isn’t https://dune.com/queries/3418402/5739663
1 reply
0 recast
1 reaction
tomu pfp
tomu
@tomu.eth
i can play with it, yes, thanks!
2 replies
0 recast
0 reaction
wizard not parzival pfp
wizard not parzival
@alexpaden
https://chatgpt.com/g/g-lKnQHXJKS-dune-x-farcaster-gpt
1 reply
0 recast
1 reaction
tomu pfp
tomu
@tomu.eth
thanks!! this is great 👌
1 reply
0 recast
0 reaction
wizard not parzival pfp
wizard not parzival
@alexpaden
tx lmk if you have issues might do an update eventually
1 reply
0 recast
0 reaction
tomu pfp
tomu
@tomu.eth
actually, what i need is a csv file with fname, fid and their wallet (the connected one) if that's smth you're able to get, happy to create a bounty
1 reply
0 recast
0 reaction
wizard not parzival pfp
wizard not parzival
@alexpaden
did you write the query already? i can probably get it from my personal sql otherwise you need the $500 dune subscription sadly
2 replies
0 recast
0 reaction
tomu pfp
tomu
@tomu.eth
yeah have the query, but need to get premium to download the csv file haha i thought you can also get this directly from neynar
1 reply
0 recast
0 reaction
wizard not parzival pfp
wizard not parzival
@alexpaden
oh right they have redash but idk if it’s free to access. @rish otherwise i have a db on my mac studio i can run your query
1 reply
0 recast
0 reaction
tomu pfp
tomu
@tomu.eth
this is the query: https://dune.com/queries/4207340/7081465 i might just pay premium but if there's another way to get this data out, better or if you're able, i'll tip you for sure
2 replies
0 recast
1 reaction
wizard not parzival pfp
wizard not parzival
@alexpaden
i thought you wanted active users? yeah i can run this easily
2 replies
0 recast
1 reaction
wizard not parzival pfp
wizard not parzival
@alexpaden
do you want me to filter down to active users with my own metrics? do you want results with no addresses?
2 replies
0 recast
0 reaction
tomu pfp
tomu
@tomu.eth
both would work for me tbh here's a 6m active: https://dune.com/queries/4207424
0 reply
0 recast
0 reaction