Jackie | agaperste 🎩

@agaperste-

243 Following

568 Followers

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

Gm I feel like I’m back

0 reply

0 recast

2 reactions

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

🤖 Only AI help help in catching some small errors like this (debugging bloated TVL 🫠 ) """ I noticed an incorrect join condition in your query, leading to data duplication or filtering issues by using "t.pool = t.pool" instead of "t.pool = s.pool". """

1 reply

0 recast

3 reactions

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

Back at it after a while The fear itself is perhaps worse than the very thing we are afraid of

1 reply

0 recast

3 reactions

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

Data, across every chain. 11/11. Join me at #DuneCon2024 🇹🇭

0 reply

6 recasts

18 reactions

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

Was looking into Solayer and liquid restaking on Solana today, and 2 things surprised me 1/ >90% SOL staked are native stake 2/ Altho Marinade (mSOL) is still growing a lot in TVL, @jito is absolutely dominating in growth and now takes up 50%+ marketshare in SOL Staked in LSTs Why is that?🤔 Also curious to see we have similar stats for restaking on Ethereum/EigenLayer already?👀 cc @eekeyguyy @yulia @tomwanhh Shoutout to chad @ilemi for the charts🙏

2 replies

95 recasts

41 reactions

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

who checked me lol

2 replies

549 recasts

209 reactions

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

💫 ZK Rollups are constantly innovating to reducing their L1 gas spend! Last week on Aug 21, @scrollzkp's Darwin upgrade went live. It uses single aggregated proofs for multiple batches and eliminates the need to finalize each one individually. As you can see here, we can observe a massive drop in daily ZKP (zero-knowledge proof) verification spend (in ETH) below. Note: L1 gas spend for Scroll consists of three parts 1/ proof verification 2/ data availability and 3/ proof hardware. Part 1 for proof verification consumes the most cost. Scroll isn't alone—ZkSync Era, Linea, and Starknet are all innovating to reduce fees for users via bundling, parallelization and more. The future is more affordable on-chain activity! 💫 - Reference query https://dune.com/queries/4017703/6763457?sidebar=none - Dashboard on ZKP Verification https://dune.com/nebra/zero-knowledge-proof-verification-cost-ethereum - Post on Darwin Upgrade https://scroll.io/blog/proof-recursion-scrolls-darwin-upgrade

2 replies

4 recasts

11 reactions

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

When the border control officer in Amsterdam sees your passport and start speaking Chinese with you 😮😮😮

4 replies

211 recasts

85 reactions

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

xposting https://warpcast.com/agaperste-/0x549efcfd Excited to push out the ZKP Metrics dash! Would love to get more zkp projects added and discussed methodology on how to capture the metrics the best!

0 reply

2 recasts

6 reactions

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

Lots of buzz going on for zero-knowledge, but how is zkp actually being adopted? I've teamed up with @nebra and @ournetwork to bring to you the ultimate ZKP Metrics Dashboard and Report https://www.ournetwork.xyz/p/on-261-zoomed-in-on-zero-knowledge-proofs https://dune.com/nebra/zero-knowledge-proof-verification-cost-ethereum Over $60M have been spent to on ZKP verification on Ethereum L1 so far 😮, and teams across the board like @LineaBuild, @zksync, @Starknet, and @Scroll_ZKP are constantly innovating to make zkp more efficient. 💫 While OFAC sanctions in late 2022 slowed down adoption, the ZKP space is now rebounding stronger than ever. 🌱 To learn more and track how the ZKP space is evolving, make sure to check out the report and dashboard linked above. P.S. Huge thanks to @stevech @snoon.eth @ofernau @codygarrison_ , and @Bhami628 for making this possible 🙏🤝

0 reply

0 recast

1 reaction

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

TIL: There are 4 types of Ethereum txns 😮 and one of them is called AccessList! Was doing some ZKP data stuff then went down this 🐇🕳️ of different types of Eth txns and how to calculate gas fees for each 😵‍💫 Obviously we all know dynamic txns (EIP1159) are the dominant type, but Blob txn is also growing decently Gas fee formulas for each type included at the end of this dash! https://dune.com/agaperste/ethereum-transaction-types#transaction-types-gas-cost-formulas

2 replies

0 recast

7 reactions

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

I wonder if anyone is working on an AI which delivers personalized daily newsletter to your inbox on what threads to catch up on social media

0 reply

0 recast

1 reaction

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

Stumbled upon this contract for Soswap (https://basescan.org/address/0xbc097e42bf1e6531c32c5cee945e0c014fa21964), which seemed to be consuming a lot of gas/popular back in winter of 2023 Anyone has more context on this project? (I just heard about it for the first time today) query source: https://dune.com/queries/3934953/6617053?Project_t6c1ea=soswap

1 reply

0 recast

0 reaction

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

GM I’m back on FC after a quick break 👻 excited to see what I’ve missed in the past month 👀

0 reply

0 recast

0 reaction

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

Has anyone looked into Aerodrome's latest update on Base, Slipstream? Would love to see it added to dex.trades (on Dune) 👀 🔮

1 reply

0 recast

3 reactions

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

Heard the best vision for where to live today — front yard is NYC , back yard is rural Switzerland with Alps in the background 🌆🏔️

1 reply

0 recast

2 reactions

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

I am a level 2 caster! Powered by @airstack.eth Social Capital Rank. Time to be more active 👀😂

1 reply

0 recast

0 reaction

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

Wow AI really is the wing-person I need to boost productivity, no longer do I need to worry that I forgot certain math concepts I learned but have not used :')

0 reply

0 recast

2 reactions

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

@chuxin and I kick off S2 of the podcast with a special guest @zaak 🟦 Get inspired for yourself on his journey from Australia to NYC, from b̵o̵r̵i̵n̵g̵ web2 to /zora! ✨ We had lots of fun chatting and getting to know him, hope you enjoy the episode too! 🤗

0 reply

1 recast

5 reactions

Jackie | agaperste 🎩 pfp

Jackie | agaperste 🎩

I just spent 30+ minute trying to figure out some Discord setting so I can join a server... WOW.. talking about user UNfriendliness 🙃

0 reply

0 recast

0 reaction