Content pfp
Content
@
0 reply
0 recast
0 reaction
moritz 💧🔑 pfp
moritz 💧🔑
@moritz
ok, I couldn’t find this so I’m starting a bounty to make it happen :) the closest I came across is this dashboard from @yesyes https://dune.com/yesyes/farcaster-users-onchain-activities I'm looking for a /dune dashboard that shows: - total USD amount of tokens in Farcaster user wallets - USD amount of monthly token inflows in Farcaster user wallets - USD amount of monthly token outflows in Farcaster user wallets for each of these: (1) visualize distribution of USD amounts - i.e. how many users have: - < $100 - $100-$1k - $1k-$10k - $10k-$50k - $50k-$200k - $200k-$500k - $500k-$2m - > $2m (2) add a table to show these amounts for each user (searchable by username) - 250 USDC for the first Dune dashboard showing all of these metrics - 50 USDC for sharing a third party dashboard that already covers this (needs to cover everything requested, 10 USDC for something that covers it only partly) feel free to reach out with any questions! https://warpcast.com/moritz/0x68323b6d
10 replies
2 recasts
13 reactions
Hamza pfp
Hamza
@canhamzacode
@moritz Last minute submission haha Let me know what you think https://dune.com/canhamzacode/farcaster-user-wallet-metrics
1 reply
0 recast
0 reaction
moritz 💧🔑 pfp
moritz 💧🔑
@moritz
hi @canhamzacode - thanks for submitting this the number of users in your dashboard is much lower than the total number of Farcaster users, can you explain what your methodology was? also I checked a few FIDs to confirm that the reported balances match numbers onchain but this wasn't the case, e.g.: FID 238,324 is supposed to have a balance of 15,727 but I'm unable to find this user
2 replies
0 recast
0 reaction
Hamza pfp
Hamza
@canhamzacode
So basically what I did was to query for farcaster wallet address with USDC in it. I.e wallet without USDC will not be returned For this FID, are you referring the the USDC balance
1 reply
0 recast
0 reaction
moritz 💧🔑 pfp
moritz 💧🔑
@moritz
I see, thanks for clarifying with USD amount of tokens, I meant the $ value of the tokens a user holds, not just USDC - I understand it might be difficult to cover all possible tokens but it should ideally cover the top 20 tokens by market cap (e.g. ETH, rETH, wstETH, USDT, DAI, etc.) also it's unclear which chains you are checking this for regarding the FID: I wasn't even able to find a connected address when querying the fname API: https://docs.farcaster.xyz/reference/fname/api
1 reply
0 recast
0 reaction
Hamza pfp
Hamza
@canhamzacode
Okay noted. I am getting the data from Ethereum. Regarding the api, are you referring to the query?
1 reply
0 recast
0 reaction
moritz 💧🔑 pfp
moritz 💧🔑
@moritz
well it looks like the user with that FID doesn't exist: https://fnames.farcaster.xyz/transfers?fid=238324
2 replies
0 recast
0 reaction
Hamza pfp
Hamza
@canhamzacode
Yeah just to be sure. Is there a specific chain you want me to focus on. And finally a short description on the remaining requirement will be appreciated
1 reply
0 recast
0 reaction
moritz 💧🔑 pfp
moritz 💧🔑
@moritz
Ethereum is fine as a focus most important requirements: 1. accurate data, i.e.: -- max 20% discrepancy between actual user balances onchain and data in Dune if I check a sample -- covers all Farcaster users -- this also goes back to our discussion above on making sure there are only FIDs that actually match to a user 2. covers all top tokens by marketcap (at least top 20)
1 reply
0 recast
0 reaction
Hamza pfp
Hamza
@canhamzacode
Everything is working fine. Can you check to confirm that. I sent you a DM earlier but you haven't seen it yet
1 reply
0 recast
0 reaction
moritz 💧🔑 pfp
moritz 💧🔑
@moritz
hey! just checked this, I'm still seeing pretty big inaccuracies - e.g. the two top addresses by balance are supposed to have over $1m but checking onchain I can see they have both less than $100k
1 reply
0 recast
0 reaction
Hamza pfp
Hamza
@canhamzacode
Do you have a way of validating this information. Just as you confirmed that the amount shiuld be less than 100k instead of over 1m
1 reply
0 recast
0 reaction
moritz 💧🔑 pfp
moritz 💧🔑
@moritz
just checking on Etherscan:
2 replies
0 recast
1 reaction