Dan Romero on Farcaster

Dan Romero pfp

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

7 recasts

34 reactions

Dan Romero pfp

And to be clear: Ethereum to start is fine. Ideally, Ethereum (across L1 and L2s) and then Solana.

2 replies

0 recast

9 reactions

amc pfp

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

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

@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

0 reply

0 recast

2 reactions

kenanie.base.eth pfp

kenanie.base.eth

@fookinnowan get in here fam. you're a dune wizard.

0 reply

0 recast

1 reaction

Abbas🎩👾 pfp

@patxol.eth have a cool tool that can help. troopcast.xyz

1 reply

0 recast

1 reaction

Matthew Fox 🌐 pfp

Matthew Fox 🌐

@arek u still got that incredibly inefficient script for this from farcon last year?

1 reply

0 recast

1 reaction

Nate Maddrey pfp

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

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

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

I protect myself from this sleuthing by LPing and using Defi - good luck dune wizards!

0 reply

0 recast

0 reaction

tricil pfp

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

@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

woj only has like $225 in eth and .16c in poopcoins

0 reply

0 recast

0 reaction

niftytime pfp

@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 💎🎩✨

@maheshb maybe you will like this ✨

0 reply

0 recast

1 reaction

Bounty Bot pfp

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

@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