Bounties and services 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

if someone does this in dune i suggest making the ledger foundational query with user-level rollups since that is the most useful to anyone forking it later
columns: username, connected address count, base total, mainnet total, etc

cc @oinkoink 

here is how to get the price of a single erc20 token (degen, on basechain)

Warzone enthusiast and gaming connoisseur. 

Catch me live on twitch.tv/oink_plays

if someone does this in dune i suggest making the ledger foundational query with user-level rollups since that is the most useful to anyone forking it later
columns: username, connected address count, base total, mainnet total, etc

cc @oinkoink 

here is how to get the price of a single erc20 token (degen, on basechain)
https://dune.com/queries/4704305?category=asset-tracking