Farcaster

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?

I think this is what you are looking for, let me know if it isn’t

researching onchain | writing tomu.xyz founded overgie.com mintgate.io | nf.td/tomu

I think this is what you are looking for, let me know if it isn’t https://dune.com/queries/3418402/5739663

Freezerverse founder. Multimedia designer. Do you like /icecream ?

https://chatgpt.com/g/g-lKnQHXJKS-dune-x-farcaster-gpt

tx lmk if you have issues might do an update eventually

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

did you write the query already? i can probably get it from my personal sql otherwise you need the $500 dune subscription sadly

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

working @ /neynar   🪐  casting @ /rish

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

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