ilemi

@ilemi

267 Following

3447 Followers

ilemi pfp

I heard there were some builders here 👀

5 replies

2 recasts

11 reactions

ilemi pfp

What comes to mind when you think of a “crypto native” person? as in things they need to have done to qualify

13 replies

0 recast

18 reactions

ilemi pfp

Here are my slides from Farcon - I talked about farcaster data structures, the "context of a cast" that links structures together, and then a bunch of examples of user, channel, and cast data analysis. https://slideframe.replit.app/Qmbn7kn7vrPrVvw2sjqwTve8q3kCujtcCTFnFV5gGmS9jg

2 replies

6 recasts

41 reactions

ilemi pfp

This is fixed now! Shout out to both the dune and neynar engineers for fixing this, more data improvements to come soon

1 reply

1 recast

8 reactions

ilemi pfp

We're working on some fixes with @neynar, but for now if you're using the verifications table then use this to parse out the address: from_hex(COALESCE(try(split(claim, '"')[4]), try(split(claim, '''')[4]))) for mentions col in casts, use: split(replace(replace(replace(cancel.mentions,'[',''),']',''),' ',''),',')

3 replies

0 recast

14 reactions

ilemi pfp

This week I built a /dune dash showcasing memecoins, with in depth stats on social and financial elements. Basically all of them were deployed on base 🫡 https://warpcast.com/ilemi/0x17699bc3

5 replies

2 recasts

25 reactions

ilemi pfp

the meme rotation into $NOGS is clear, one of the only coins to grow in casters and dex volume this week ⌐◨-◨ it's also now one of the top three memecoins on farcaster!

10 replies

5 recasts

30 reactions

ilemi pfp

I added in symbol tracking for my memecoins dashboard. It's obvious having a symbol leads to a magnitude higher level of engagement than not having one.

5 replies

3 recasts

32 reactions

ilemi pfp

been confused by these tradfi firms launching random tokens. Blackrock's $BUIDL? Franklin Templeton's $BENJI? what's going on? Feels like they came out of nowhere and are also getting very little attention from my circles lol.

5 replies

0 recast

10 reactions

ilemi pfp

There are only three memecoins that have hit 1000 daily casters for more than seven days. $DEGEN, $TN100X, and $ONCHAIN. The time it has taken has decreased with each one - $DEGEN took 72 days, $ONCHAIN took 30 days.

3 replies

3 recasts

15 reactions

ilemi pfp

added in two more memecoins, $ONCHAIN and $NOGS. reply with any others I should add! just need the ticker and a link to the contract :)

6 replies

2 recasts

25 reactions

ilemi pfp

I created a dashboard that gives Farcaster memecoins financial and social scores, so communities can understand how they stack up against one other and investors can better understand risks. Let me detail the methodology (article and dashboard linked below)

39 replies

14 recasts

95 reactions

ilemi pfp

Farcaster monthly cohort retention rates for casting, solidly above 40% with some uptrend for 6 months of cohorts now.

11 replies

7 recasts

37 reactions

ilemi pfp

adding zora uniswap data into /dune, you'll be able to enjoy some charts soon tm 😁

2 replies

0 recast

28 reactions

ilemi pfp

Here are my closest Farcaster friends. Click the frame to view your circles. Gm farfriends

5 replies

0 recast

20 reactions

ilemi pfp

Short blurb on a farcaster data dive lightning talk I'd like to do :) https://paragraph.xyz/@[email protected]/farcon-lightning-talk-farcaster-data

4 replies

8 recasts

34 reactions

ilemi pfp

fun gacha game, decided to look at who was spinning the most 👀 @renstern.eth, @blankyname, @wakkin.eth at the top! Points below don't include the 2X bonus since I can't figure out when that started. https://dune.com/queries/3578163

5 replies

1 recast

9 reactions

ilemi pfp

Ready to become a top crypto data analyst? I've created an interactive roadmap with tips, guides, and reference material for you to follow. You can leverage this resource to go from using basic explorer tools to becoming a respected expert in a domain. Video guide: https://www.youtube.com/watch?v=QdcQQKpTBZs

31 replies

16 recasts

110 reactions

ilemi pfp

Lol, today I learned that I spend roughly 25% of my month on Dune, and that @hildobby @0xkofi and henrystats spend basically the exactly same amount of time as me Same growth pattern too, you can see how the bull market made us 2x busier. In case you were wondering how much time top analysts put into building in data.

8 replies

2 recasts

24 reactions

ilemi pfp

Ive been thinking about creating an rss style feed of top data work thats governed/curated by the /bytexplorers Who is building a product for this and needs a community to test with? :)

0 reply

0 recast

11 reactions