Solana Validators' Revenue Breakdown has changed drastically in 2024 thanks to the increase in DeFi activities 1. In early Jan: - 95% from issuance - 1.9% from MEV - 3.1% from Fee 2. On 29th July: - 78.2% from issuance - 15.3% from MEV - 6.5% from Fee

Now that everyone is jumping on the zkTLS train, go watch this great video that covers the problem space and demos some cool actual app examples the opacity team built 😁

One of the best protocol dives I've seen, this should be your go to example for learning how to analyze a lending protocol. Congrats on earning an "editors pick" badge 🫡

always cool to see teams utilising dune to it's full extent 👀 the problem: "I don't want to manually update metadata anymore 😡" the solution: "use http_get() api call within a query to grab the relevant metadata from an api endpoint 😌" Spotted this banger in Spellbook

📊 Ethereum Foundation Spending Dashboard 📊 0/ there has recently been some discussion/debate about Ethereum Foundation spending i've created a report that combines both onchain data (ethdev wallet inflows and outflows + balances) and offchain data (EF spending reports + ESP

Learning SQL with Dune has been the best practice for me so far. I went through a guide yesterday (been on it for days now), "Basic Wizard Guide to Dune SQL" by ilemi, and I came across a new SQL function I had never seen before since I started learning SQL.

I'll be speaking on the right curve stage at Breakpoint in two weeks - if you want to really level up your understanding and analysis of Solana data then make sure to come to my talk! It'll be in the morning on the 20th :)

this is a token2049/eth singapore/breakpoint roll callllll Ash Egan Katherine Wu Danny Sursock and i will all be there hit us up to meet, plug your events, you know the drillll 🇸🇬🫰