Basic Solana Data Analytics In One Hour (Youtube)
Learn to read block explorers, understand tokens/accounts, and query transfers and balances - in under an hour.
In the video above, I walk through the very basics of Solana data and how to get started. The slides from the video are here. I’ll outline the video content below, but you should watch it to get a deeper understanding.
I start with an explanation of reading instructions off of a block explorer, with a liquid staking transaction:
After you get familiar with the block explorer, I explain how concepts in the explorer map to tables on Dune:
These are all queryable tables on Dune, and each have their own specific use cases. While you should try and find a spell or decoded table to use for your analysis, you might use raw tables when you can’t decode the program or need to pull more granular transaction balances.
Once you’re familiar with Dune table lineage, I take you through the basics of a token mint and token associated account:
This is the most important concept for you to get comfortable with in Solana, as this multi-account structure is repeated for many things outside of just tokens. At this point, you’ll have learned all the concepts you need to know to start querying.
The first query I walk you through teaches you how to calculate weekly mints and burns of JitoSOL.
If that’s too easy, try to answer “Can you figure out the circulating supply of USDC on Solana?”
The second query I walk you through teaches you how to calculate top holders of the JitoSOL token:
If you can figure that out, try to answer the question “can you get the top 100 holders of JitoSOL at any given date in time, using solana_utils.daily_balances?”
That’s it! If you found the video walkthrough helpful, let me know and I’ll do more. For further learning, try out these resources: