One of the key innovation in blockchain is that data is available for everyone, so anyone can use that data to their advantage and Top-ledger will enable protocols to see deep insights in their project. Let’s take a example of ‘Protocol X’, it’s could be a Defi protocol/aggregator a NFT marketplace. We will analyse the projectX completely by making a dashboard.

Visit the Live dashboards at :

List of popular dashboards on solana | Top Ledger

Sample Structure of a SQL query

User Base

Transactions

Volume

User Classification

Writing SQL queries for Dune Solana