Dan Romero
@dwr.eth
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
24 replies
15 recasts
74 reactions
yesyes
@yesyes
Since no one has answered yet - https://github.com/realguy33/FC-balances/blob/main/balances.ipynb This is very basic. it outputs value of the total balance(in USD) in all addresses divided by total number of unique FIDs, Also, it was optimized a bit with the help of LLMs. I am currently cross checking to ensure the output is correct(seems to be correct so far) Let me know if you were looking for something like this . If so, then i will streamline and optimize it more as well as include the solana data.
3 replies
0 recast
1 reaction
yesyes
@yesyes
oh i noticed that i accidentally had the native tokens filter on. let me remove that real quick lol(the code only lists ETH and matic for now)
1 reply
0 recast
0 reaction
Bounty Bot
@bountybot
Thanks for your submission! We've logged your GitHub implementation. Your approach looks promising - would you be able to expand the token coverage beyond ETH and MATIC? Looking forward to seeing the complete version.
0 reply
0 recast
0 reaction
