Dan Romero pfp
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
8 recasts
39 reactions

Dan Romero pfp
Dan Romero
@dwr.eth
And to be clear: Ethereum to start is fine. Ideally, Ethereum (across L1 and L2s) and then Solana.
2 replies
0 recast
19 reactions

amc pfp
amc
@amc
Minor tweak but probably best addressed as Farcaster AUM - dry powder would imply dollars that are yet to be invested
1 reply
0 recast
0 reaction

yesyes pfp
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
2 reactions

Pichi pfp
Pichi
@pichi
@saxophone55.eth @rjs @mvr You are all Dune wizards so want to make sure you see this cast.
1 reply
0 recast
4 reactions

​woj pfp
​woj
@woj.eth
@luc please
0 reply
0 recast
3 reactions

kenanie.base.eth pfp
kenanie.base.eth
@kenanie.eth
@fookinnowan get in here fam. you're a dune wizard.
0 reply
0 recast
1 reaction

Abbas🎩👾 pfp
Abbas🎩👾
@abbass.eth
@patxol.eth have a cool tool that can help. troopcast.xyz
1 reply
0 recast
1 reaction

Matthew Fox 🌐 pfp
Matthew Fox 🌐
@matthewfox
@arek u still got that incredibly inefficient script for this from farcon last year?
1 reply
0 recast
1 reaction

Nate Maddrey pfp
Nate Maddrey
@nmadd
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
0 reply
0 recast
0 reaction

James McComish pfp
James McComish
@jamco.eth
If you think you know the answer you can bet @onit Onit is a new type of prediction market that lets you bet on exact outcomes, not predefined buckets set by the market 👀 https://www.onit.fun/m/0x5b641E5e9454009F028fDDE080a05aE957FcDd63
0 reply
0 recast
0 reaction

yesyes pfp
yesyes
@yesyes
i am suprised that no one have answered it yet. I have a method for this but it can take several hours to run so i didn't want to submit it but will submit it if no one else answers soon.
0 reply
0 recast
0 reaction

↑langchain pfp
↑langchain
@langchain
I protect myself from this sleuthing by LPing and using Defi - good luck dune wizards!
0 reply
0 recast
0 reaction

tricil pfp
tricil
@tricil.eth
I'll make this easy: tricil.eth currently has $29.75; feel free to add that to the calculations
0 reply
0 recast
0 reaction

adrienne pfp
adrienne
@adrienne
@gregarious @ilaz if you have your script that calculated "$18B Total Value Locked in the Farcaster Ecosystem"
0 reply
0 recast
0 reaction

dycp pfp
dycp
@tn100x.eth
woj only has like $225 in eth and .16c in poopcoins
0 reply
0 recast
0 reaction

niftytime pfp
niftytime
@niftytime.eth
@kompreni ran a similar exercise a little over a month ago focused on the value of eth held in FC associated address (base + mainnet) good base to start from https://warpcast.com/kompreni/0x02c9d7b5
0 reply
0 recast
3 reactions

Marcelo Terça-Nada 💎🎩✨ pfp
Marcelo Terça-Nada 💎🎩✨
@marcelonada
@maheshb maybe you will like this ✨
0 reply
0 recast
1 reaction

Bounty Bot pfp
Bounty Bot
@bountybot
Your bounty deadline just passed (2 week default unless specified). If you'd like to edit the bounty amount or deadline, please update through the bounty frame "admin" button If the bounty was completed, please update through the "admin" button
0 reply
0 recast
0 reaction

Codingsh pfp
Codingsh
@codingsh
@bountybot @bountycaster @dwr.eth my submisson: https://gist.github.com/developerfred/857a84bf6ac07138a28da56a3421a32b I've been working on this since yesterday, I still haven't managed to get all the user addresses, but we've already managed to get some values, the flow is well explained in the readme. Good hacking to everyone
2 replies
0 recast
0 reaction