yesyes

@yesyes

483 Following

1912 Followers

yesyes pfp

Just launched a new hypersub focusing on Farcaster Analytics! First Article comes out at the end of the week. Consider subscribing if you want to see me consistently analyze farcaster Data! https://www.hypersub.xyz/s/yesyes-analytics-qr0v8onrvev4

3 replies

6 recasts

16 reactions

Patrick Collins pfp

Patrick Collins

I'm sorry. I should have told you this knowledge could save you $1.4B not $50M. https://youtu.be/Gf8_ovO-jBI

0 reply

4 recasts

10 reactions

Geoff Golberg pfp

8.4K accounts that have at least 2K Followers These are the largest accounts here 6.6 million Following/Followers relationships among them are being visualized Second image shows subset that are followed by @dwr.eth This network graph visualization looks like something.. but I can't tell what 🧐🤨

30 replies

13 recasts

74 reactions

yesyes pfp

The doctor is trying to maximally extract before that

0 reply

0 recast

0 reaction

yesyes pfp

This is very cool! one thing - use a query like to get the connected addresses - select JSON_EXTRACT_scalar(claim, '$.address'), fid from dune.neynar.dataset_farcaster_verifications where length(JSON_EXTRACT_scalar(claim, '$.address')) = 42 and deleted_at is null (this has a deleted_at column which allows you to filter out disconnected addresses)

1 reply

0 recast

1 reaction

yesyes pfp

Bountycaster has been helpful in earning me money as I figure out my own analytics work. But more importantly, it is a really good platform for showcasing your skills and helping connect to the right people. This is incredibly useful if you're new to an industry and want to make yourself stand out.

1 reply

1 recast

3 reactions

yesyes pfp

Also, the base prices table is a bit unreliable sometimes so be careful with that.

0 reply

0 recast

1 reaction

yesyes pfp

Will look at it after waking up in the morning @nmadd For now - Simply put a "where deleted_at is null" clause to not count disconnected addresses.

1 reply

0 recast

1 reaction

yesyes pfp

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

yesyes pfp

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

yesyes pfp

oh i noticed that i accidentally had the native tokens filter on. let me remove that real quick lol(the code only lists ETH and matic for now)

1 reply

0 recast

0 reaction

yesyes pfp

I preferred to do it using the dune's API and not Dune's SQL because some prices tables in dune SQL are highly unreliable. This API fetches more accurate prices data. It also uses pagination so technically SOME coins that are on the next page of an address's token list will not be included but they are liquidity spam coins doesn't make much of a difference.(The api lists highly liquid coins before the lower liquidity ones). i can completely exclude the low liquidity coins too which will speed up the query even more. Let me know if you were thinking in this direction. Will invest more time in it if it seems worthwhile. Let me know if this is the direction

0 reply

0 recast

2 reactions

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

yesyes pfp

https://explorer.neynar.com/

1 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

luc pfp

very excited by @atlas graph intelligence been looking for a long time for an agent to build continuous context on me in a way that's portable to other LLMs @jrf is onto something really interesting

3 replies

3 recasts

9 reactions

yesyes pfp

Will have some by the end of week 🫡

0 reply

0 recast

2 reactions

yesyes pfp

Doing research for the MMO Also, tryndamere is such a cool character, even the founder likes him.

1 reply

0 recast

1 reaction

yesyes pfp

Current popular channels are nowhere near June in terms of number of users but i would say the post quality of channels have gone up.

1 reply

0 recast

2 reactions

yesyes pfp

Really good article on TEEs

0 reply

1 recast

3 reactions