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.
78
Curated Solana tables
7
Dedicated schemas
22
Validator & governance tables
3,000+
Quality checks per hour
01 / Platform Comparison
Multiple platforms offer Solana data. They differ in depth, delivery, and what you can actually answer with them.
| Flipside | Other Blockchain Data Providers | Community Platforms | |
|---|---|---|---|
| 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.
02 / Validator & Governance
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 onchain governance voting across Realms & more.
Questions only Flipside can answer:
Validator Performance
7 tablesEpoch 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 tablesStake account delegation, activation/deactivation, and four separate reward tables: staking, voting, fees, and rent. Full reward breakdown by type and epoch.
Governance
5 tablesProposal creation and voting across Realms & more. Governance actions tracked from creation through final vote.
Infrastructure
3 tablesEpoch boundaries, vote account status, and aggregated consensus participation data.
03 / DeFi Coverage
17 curated DeFi tables. One fact_swaps table covers every major DEX. New protocols get added without changing your queries.
Raydium, Orca, Meteora, Phoenix, Bonkswap, and more through unified tables. Token verification flags identify trusted tokens in Solana's memecoin-heavy environment.
fact_swaps
ez_dex_swaps
Three layers of depth. Raw routes, intermediate routing steps, and user-level summaries with DCA and limit order classification. Nobody else does this.
fact_swaps
fact_swaps_jupiter_inner
fact_swaps_jupiter_summary
Full lifecycle for Kamino and MarginFi. Five separate tables for borrows, deposits, liquidations, repayments, and withdrawals. Most other providers have no standardized Solana lending.
ez_lending_borrows
ez_lending_deposits
+ 3 more
Wormhole, DeBridge, and Mayan Finance. Track crosschain capital flows to and from Solana. Bridge coverage for Solana is rare among data providers.
ez_bridge_activity
fact_bridge_activity
Lido, Marinade, and Jito. Deposit, unstake, and claim actions across all three major providers in one table.
fact_stake_pool_actions
LP deposits and withdrawals for Raydium, Orca, and Meteora. Plus stablecoin supply metrics and token mint/burn tracking.
ez_liquidity_pool_actions
ez_stablecoins_supply
04 / Marinade Protocol
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.
dim_pools MNDE/MSOL liquidity pools across DeFi protocols
ez_liquid_staking_actions Deposits, unstakes, and claims for mSOL
ez_liquidity_pool_actions MSOL/MNDE pool activity tracking
ez_native_staking_actions Native staking via Marinade
ez_swaps MSOL/MNDE swaps across DEXes
05 / Core Data
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.
SELECT address, balance, balance_usd
FROM solana.core.fact_sol_daily_balances
WHERE date = CURRENT_DATE - 1
AND balance_usd > 100000
ORDER BY balance_usd DESC
LIMIT 50 Pre-computed daily snapshots. No need to aggregate transaction-level balance changes yourself.
SELECT validator_name, apy, uptime_pct,
blocks_produced, blocks_assigned
FROM solana.gov.ez_validator_epoch_metrics
WHERE epoch = (SELECT MAX(epoch)
FROM solana.gov.dim_epoch)
ORDER BY apy DESC
LIMIT 20 One query. 36 columns of context per validator. Not available from other Solana data providers.
06 / Wallet Scoring & Sybil Detection
Flipside User Score rates wallets 0-15 based on onchain activity across DeFi, NFTs, and multiple token types. Sybil detection uses a 105-point scoring system across four behavioral signals.
Applied to real protocols: Raydium, Pump.fun, Jupiter, and Orca user populations. Use it for user quality assessment, anti-sybil filtering, and airdrop targeting.
07 / Infrastructure
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.
Data freshness as fast as 30 minutes.
3,000+ automated checks every hour.
No proprietary dialect. AI-friendly.
One table per activity type. New protocols added automatically.
08 / Explore the Schema
7 schemas, 78 tables. Click a schema, pick a table, see what's inside.
solana.core.fact_blocks
Block-level metadata for every Solana block.
| Column Name |
|---|
| BLOCK_ID |
| BLOCK_TIMESTAMP |
| BLOCK_HEIGHT |
| BLOCK_HASH |
| PREVIOUS_BLOCK_HASH |
| NUM_TRANSACTIONS |
Showing sample columns. Full schema available in Flipspace.
78 curated tables across 7 schemas
solana.core
Block-level metadata for every Solana block.
Get started
78 curated tables, 22 validator tables nobody else has, and standard SQL your team already knows. Talk to us.