Bounties on Farcaster bountycaster.xyz. Tag @bountybot to post and check out /bounties. FAQ: bountycaster.xyz/faq

Farcaster dry powder

* Problem
What is the aggregate dollar value of crypto assets ("dry powder") held in all protocol-linked addresses?

* Output
1. A GitHub repo / gist with a reproducible script (assume API key) to generate the figure; include instructions for how to run, avoid rate limits, etc.

2. Tiebreaker: a good Dune dashboard with the figure

* Criteria
Bias for first correct submission, but will give everyone at least 24 hours to submit before making a decision.

* Amount
500 USDC

@bountycaster

How much dry powder is held in Farcaster connected wallets?

This new dashboard shows the total $ amount of tokens held by Farcaster users, plus the top tokens held:

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

Here’s my attempt at calculating Farcaster dry powder

I grabbed all connected addresses of all users regardless of how active they are, then got all holdings for those addresses across Base, Ethereum, and Optimism. I included USD value of total holdings, plus a separate calculation for stablecoin holdings. I also included a breakdown of the top tokens and $ amount held of each.

There are a lot of relatively inactive accounts holding large amounts, so this may be overstating it a bit, but I’m open to refining it or creating different versions if needed!

Here’s my attempt at calculating Farcaster dry powder

I grabbed all connected addresses of all users regardless of how active they are, then got all holdings for those addresses across Base, Ethereum, and Optimism. I included USD value of total holdings, plus a separate calculation for stablecoin holdings. I also included a breakdown of the top tokens and $ amount held of each.

There are a lot of relatively inactive accounts holding large amounts, so this may be overstating it a bit, but I’m open to refining it or creating different versions if needed!

https://warpcast.com/emptyblock/0xf3db8542