Dan Romero on Warpcast

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

23 replies

15 recasts

73 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

23 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

1 reaction

Pichi 🟪🍖🐹🎩 🍡🌸 pfp

Pichi 🟪🍖🐹🎩 🍡🌸

@saxophone55.eth @rjs @mvr You are all Dune wizards so want to make sure you see this cast.

1 reply

0 recast

5 reactions

woj pfp

0 reply

0 recast

4 reactions

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

3 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

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

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

↑langchain 🎩

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

0 reply

0 recast

0 reaction

shoni.eth pfp

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

0 reply

0 recast

0 reaction

Bounty Bot pfp

Confirmed! On your bounty page, you can pay users and view their bounty completion history Frame buttons - Admin: manage bounty status (in progress, complete), edit amount and deadline - Boost: get more attention on your bounty 🤖 commands - @bountybot cancel - @bountybot in progress - @bountybot complete (optional: tag winners) - @bountybot shoutout (optional: tag winner and write a positive review)

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

Ran Domero pfp

@randomerror.eth

ser if it's deployed already how'd it be dry

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

4 reactions

Marcelo Terça-Nada 💎🎩✨ pfp

Marcelo Terça-Nada 💎🎩✨

@maheshb maybe you will like this ✨

0 reply

0 recast

1 reaction