One insight can change everything

Sometimes, the biggest opportunities in blockchain aren’t hidden in complex dashboards, they’re sitting in plain sight.
But here’s the thing: most people don’t know what to look for.

That’s the edge analysts gain when they combine SQL with blockchain data: the power to uncover patterns others overlook, and turn them into insights that matter.

And that’s exactly what we’re diving into in today’s edition of The Data Edge 👇

Query Breakdown

This query analyzes token mints on the Solana blockchain, focusing on two specific platforms (pump.fun and letbonk.fun) over a defined time window. It counts how many unique tokens were minted per day per platform.

What It Selects;

1. block_date: The date of each block (day-level aggregation).

2. platform: Labels transactions based on the outer executing account:

a. If the account is 6EF8...F6P, label as pump.fun.

b. If the account is LanMV...3uj, label as letbonk.fun.

3. num_tokens: The count of unique token mint addresses per platform per day.

Where the Data Comes From;

1. Table: tokens_solana.transfers (records of Solana token transfers).

2. Only counts mint actions (new tokens being created).

Filters Applied;

1. Action filter: action = 'mint' → Only token creation events are considered.

2. Platform filter: Only rows where outer_executing_account is one of the two specific accounts.

3. Date range: Only blocks between 2025-06-22 and 2025-07-22.

Our learners don’t just study SQL, they create real dashboards that solve real problems.

Here’s an image of one of one of our Alumni’s Dashboard;

Read more: Insight Into Somnia ($SOMI)

This isn’t just practice dashboard, it’s proof that learning SQL and on-chain analysis opens doors to building things that matter and tell a story.

Become a Blockchain Data Analyst
Learn Onchain Analysis using SQL and Dune in our hands-on, guided training program.

Deadline: 30th Sept, 2025
Start Date: 1st Oct, 2025

Read details and Secure Your Spot here:
https://analyticsages.io/beginner-blockchain-analytics-sql/

This is your chance to learn the skills that power dashboards, insights, and data-driven decision-making in Web3. Don’t miss it.