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

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/

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

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!

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

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