Farcaster dry power Dune dashboard from @nmadd

https://dune.com/empty_block/farcaster-dry-powder

Here are the queries I used for calculating Farcaster dry powder, broken down step by step 👇

first I get a list of all farcaster connected addresses

one small thing to note here, Dune includes all connected addresses even if someone added it and then later removed it. I haven't found a way to filter out deleted addresses yet, so if anyone knows how to please lmk:

@emptyblock + art, music, onchain data. former Director of Research @coinmetrics

then I take all those addresses and get all of their balances across chains:

then I take all those addresses and get all of their balances across chains:

https://dune.com/queries/4709024/7826622/

then take the balances and pull in most recent prices for each token, and use that to compute balances in USD:

then take the balances and pull in most recent prices for each token, and use that to compute balances in USD:

https://dune.com/queries/4704522/7819684/

and from there I create the aggregate stats which are shown on the dashboard:

and from there I create the aggregate stats which are shown on the dashboard:

https://dune.com/queries/4704420/7819525/a08d605d-1502-4f90-a3a7-08a78ee1eeda

I checked each step against third party data, but it’s still a relatively complex query so I’d love to get more eyes on it. Let me know if you spot anything that needs fixing!

first I get a list of all farcaster connected addresses

one small thing to note here, Dune includes all connected addresses even if someone added it and then later removed it. I haven't found a way to filter out deleted addresses yet, so if anyone knows how to please lmk:

https://dune.com/queries/4708757/7826249/

Blockchain data analyst. Interested in data science and blockchain.

Analysis-
https://www.hypersub.xyz/s/yesyes-analytics-qr0v8onrvev4,
https://dune.com/yesyes

This is very cool!

one thing - 
use a query  like to get the connected addresses - 
select JSON_EXTRACT_scalar(claim, '$.address'), fid from dune.neynar.dataset_farcaster_verifications
where length(JSON_EXTRACT_scalar(claim, '$.address')) = 42 and deleted_at is null

(this has a deleted_at column which allows you to filter out disconnected addresses)

prev founded rocketr.net, swish.id now exploring aiXcrypto identity ai. expired sprint car driver & energy data engineer. idol worship on shoni_eth.X

should work now - the last query was accidentally still set to private but I just made it public

any idea why these weren't available via clicking from the dash? weird anyway thanks for sharing