# The deepest Solana dataset available.

78 curated tables. 7 schemas. 3x the curated coverage of other providers.

Validator economics, Jupiter routing, lending lifecycles, governance voting, sybil scores. We index Solana from genesis and run our own validator. Nobody else goes this deep.

## Complete Solana history from genesis.

Flipside was an early mover in indexing all Solana blockchain history, working directly with the Solana Foundation as a growth partner. 16 core tables cover blocks, transactions, events, transfers, balances, and decoded instructions.

Daily balance snapshots for SOL and SPL tokens. Pre-computed daily balance tables are unique to Flipside.

Token account ownership tracking maps which owner controlled which token account and when.

Enriched transfers with pre-parsed amounts, USD values, and token symbols in `ez_transfers`.

Curated IDL registry for decoded program instructions. Failed transactions separated for query performance.

### Daily SOL Balances

Unique accounts and total SOL held, last 30 days

| Date      | Total SOL Held | Unique Accounts |
|-----------|----------------|-----------------|
| Mar 28    | 105M           |                 |
| Apr 3     | 70M            |                 |
| Apr 9     | 105M           |                 |
| Apr 15    | 140M           |                 |
| Apr 21    | 200M           |                 |

Pre-computed daily snapshots. No need to aggregate transaction-level balance changes yourself.

### Top 5 Tokens by Transfer Volume

Last 7 days on Solana

| Token | Transfer Volume |
|-------|-----------------|
| WSOL  | $70B           |
| USDC  | $105B          |
| USDT  | $140B          |
| USD   | $35B           |
| SPY   | $0             |

Enriched transfers with pre-parsed amounts, USD values, and token symbols. No manual price joins or mint address lookups required.

**Data powered by the [Flipside API](https://docs.flipsidecrypto.com/api-reference/queries/get-latest-query-run-result-data).**

## 22 tables that don't exist anywhere else.

Flipside runs its own Solana validator. That operational experience shaped a governance schema no other platform has built.

Validator APY rankings, uptime benchmarking, MEV revenue breakdowns, data center concentration, SFDP participation, reward type splits, and on-chain governance voting across Realms & more.

Questions only Flipside can answer:

- Which validators had the highest APY last epoch?
- What's the MEV revenue breakdown for Jito validators?
- How concentrated is stake across data centers?
- Which validators missed their leader slots?
- Which governance proposals passed this epoch?

### Validator Performance

7 tables

Epoch metrics with 36 columns: earnings in SOL + USD, APR/APY, uptime, miss rates, blocks produced vs. assigned, commission, delinquency, Jito MEV, SFDP participation.

### Staking & Rewards

7 tables

Stake account delegation, activation/deactivation, and four separate reward tables: staking, voting, fees, and rent. Full reward breakdown by type and epoch.

### Governance

5 tables

Proposal creation and voting across Realms & more. Governance actions tracked from creation through final vote.

### Infrastructure

3 tables

Epoch boundaries, vote account status, and aggregated consensus participation data.

## DEX, lending, bridges, liquid staking, and LPs.

17 curated DeFi tables. One `fact_swaps` table covers every major DEX. New protocols get added without changing your queries.

### DEX Trading

Raydium, Orca, Meteora, Phoenix, Bonkswap, and more through unified tables. Token verification flags identify trusted tokens in Solana's memecoin-heavy environment.

### Jupiter Aggregator

Three layers of depth. Raw routes, intermediate routing steps, and user-level summaries with DCA and limit order classification. Nobody else does this.

### Lending

Full lifecycle for Kamino and MarginFi. Five separate tables for borrows, deposits, liquidations, repayments, and withdrawals. Most other providers have no standardized Solana lending.

### Bridges

Wormhole, DeBridge, and Mayan Finance. Track crosschain capital flows to and from Solana. Bridge coverage for Solana is rare among data providers.

### Liquid Staking

Lido, Marinade, and Jito. Deposit, unstake, and claim actions across all three major providers in one table.

### Liquidity Pools

LP deposits and withdrawals for Raydium, Orca, and Meteora. Plus stablecoin supply metrics and token mint/burn tracking.

## The only Solana protocol with its own dedicated schema.

Flipside's Marinade schema includes AI analytics modules for staking propensity scores and influential staker identification.

Five dedicated tables covering MNDE/MSOL liquidity pools, liquid staking lifecycle, LP activity, native staking, and MSOL/MNDE swaps. No other platform has built anything like this for a single Solana protocol.

## Score every Solana wallet. Catch the sybils.

Flipside User Score rates wallets 0-15 based on on-chain activity across DeFi, NFTs, and multiple token types. Sybil detection uses a 105-point scoring system across four behavioral signals.

### Sybil Detection Signals

CEX deposit wallet sharing 40 pts
Funding source sharing 35 pts
Identical transaction amounts 15 pts
High daily transaction volume 15 pts

Applied to real protocols: Raydium, Pump.fun, Jupiter, and Orca user populations. Use it for user quality assessment, anti-sybil filtering, and airdrop targeting.

## How does Flipside compare on Solana?

Multiple platforms offer Solana data. They differ in depth, delivery, and what you can actually answer with them.

|  | Flipside | Other Providers | Community |
|---|----------|----------------|-----------|
| Curated Solana tables | 78 across 7 schemas | ~25-30 | ~15-20 standardized |
| SQL dialect | Snowflake (standard SQL) | Snowflake / BigQuery / Databricks | Proprietary SQL dialects |
| Validator & governance | 22 tables | None | None |
| Jupiter depth | 3 tables (routes, inner legs, summary) | 1 flat table | Raw decoded only |
| Lending lifecycle | 5 tables | Partial | None standardized |
| Marinade protocol schema | 5 dedicated tables | None | None |
| Daily balance snapshots | SOL + SPL daily | Transaction-level only | Not available |
| Sybil detection | 105-point scoring | None | None |
| Bridge data | 3 protocols | Not documented | Limited |
| Address labels | 700M+ addresses, curated | Varies by provider | Community-contributed |
| Data delivery | Snowflake + Flipspace + API | Multi-warehouse + streaming | Web IDE + API |
| Data latency | Core 30 min–1h, Decoded 1–2h | Streaming (seconds) | Raw <1 min, Decoded varies |

Based on public documentation research. Last updated February 2026.

## Standard SQL. 3,000+ quality checks. Your AI tools already know it.

Flipside runs on Snowflake SQL. AI coding assistants (ChatGPT, Claude, Cursor) produce better queries against standard SQL than proprietary dialects. In an agentic world, that matters.

### Up-to-Date Data

Data freshness as fast as 30 minutes.

### Quality Testing

3,000+ automated checks every hour.

### Standard SQL

No proprietary dialect. AI-friendly.

### Unified Tables

One table per activity type. New protocols added automatically.

## Every Solana table, organized by schema.

7 schemas, 78 tables. 
Schemas

- Core: 16
- DeFi: 17
- Gov: 22
- Marinade: 5
- NFT: 5
- Price: 4
- Stats: 1

### fact_blocks

#### Description
Block-level metadata for every Solana block.

#### Columns
| Column Name                 |
|-----------------------------|
| BLOCK_ID                    |
| BLOCK_TIMESTAMP             |
| BLOCK_HEIGHT                |
| BLOCK_HASH                  |
| PREVIOUS_BLOCK_HASH         |
| NUM_TRANSACTIONS            |

**Showing sample columns. Full schema available in Flipspace.**