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
23 replies
15 recasts
75 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
Update - it now analyzes all tokens. not just native tokens. removed low liquidity ones for more accurate data. Unfortunately, the LLM optimization is inaccurate. Will see tomorrow why. For now, i have included the much slower but accurate method 2. Again, very basic stuff, don't want to spend too much time on this. Hoping that someone else may have submitted some solution by tomorrow.
1 reply
0 recast
1 reaction
Dan Romero
@dwr.eth
Thanks! Did you get to an overall figure? Or does it take a bunch of time?
1 reply
0 recast
1 reaction
yesyes
@yesyes
Yes, it takes a bunch of time. Like a good amount unfortunately. I will try to optimize it as well as attempt to make the dune queries more accurate tomorrow. I ran this just for PB's a few months back https://warpcast.com/yesyes/0x7aa4b7fc
0 reply
0 recast
0 reaction
