Data from every major blockchain ecosystem
SQL-ready blockchain data. No nodes, no decoding, no pipelines.
Flipside covers dozens of chains and thousands of protocols across DeFi, NFT, and token activity. Every chain is normalized to the same schema, so a query written for Ethereum runs on Arbitrum, Base, or Polygon with minimal changes.
Data from every major blockchain ecosystem
20+
Blockchains covered
3,000+
Quality checks hourly
6
Data domains per chain
168+
AI agents on the data
01 / Chain Coverage
EVM chains share a near-identical schema. Non-EVM chains like Solana and Bitcoin are adapted to their native data models but use the same naming conventions.
EVM LAYER 1
EVM LAYER 2 / ROLLUPS
NON-EVM LAYER 1
COSMOS & SPECIALIZED
Crosschain access: Query all chains at once through a unified crosschain namespace — or all EVM chains together via crosschain.evm. No separate connections needed.
02 / Data Domains
Six schemas per chain, each focused on a different activity type. DEX swaps, lending, bridges, NFT sales, pricing, and governance all live in their own consolidated tables.
Blocks, transactions, event logs, traces, smart contract metadata, address labels, and native + token transfers. All with decoded fields and USD values.
DEX swaps, lending (borrows, deposits, liquidations, flash loans), bridge transfers, liquidity pool actions, protocol TVL, and stablecoin supply metrics.
Sales, transfers, and minting events across EVM chains, Solana, Aptos, Flow, and NEAR. Includes buyer, seller, USD price, platform, and fee breakdowns.
Hourly pricing from multiple providers. Curated (one price per hour, deduplicated) and raw multi-provider OHLC data. Daily fundamentals including market cap and supply.
Onchain governance votes, proposal submissions, staking/delegation events, and validator metadata. Deep coverage for Ethereum beacon chain, Solana, Monad, and Cosmos.
Pre-computed hourly and daily metrics: transaction counts, unique active addresses, fees in native and USD. Chain-level, address-level, and protocol-level aggregations.
03 / Curation Pipeline
Three tiers of tables, each with a different level of curation. Most analysis starts with ez_ tables. Drop down to fact_ tables when you need granular event-level data.
SELECT block_timestamp, platform, token_in, token_out, amount_in_usd
FROM ethereum.defi.ez_dex_swaps
WHERE block_timestamp >= CURRENT_DATE - 7
ORDER BY amount_in_usd DESC
LIMIT 100Token pair, amounts in human-readable form, USD values, DEX platform, and pool — without decoding event logs, looking up token decimals, or joining price data yourself.
One table per activity type. ez_dex_swaps covers every major DEX protocol on a chain. ez_lending_borrows covers all lending platforms. New protocols are added continuously — your queries automatically capture new activity without code changes.
04 / Data Quality
Over 3,000 automated tests run every hour. They catch data gaps, schema drift, stale ingestion, and transformation errors before any of it reaches your queries. Bad data means wrong trades for institutional investors and broken dashboards for teams building onchain.
Raw
Multi-provider data, not deduplicated — good for provider comparison
Curated
Deduplicated, prioritized providers, one record per entity
Enriched
Joined with prices, labels, metadata, decoded fields, and USD values
Aggregated
Pre-computed metrics ready for dashboards and monitoring
05 / Chain-Specific Depth
Every chain follows the same base schema. Chains with unique capabilities also get specialized tables that go deeper into their native features.
| Chain | Specialized Data |
|---|---|
| Ethereum | Beacon chain validators, attestations, deposits, withdrawals, blob sidecars, ENS domains |
| Solana | Validator intelligence (rewards, uptime, block production, leader schedules), Jupiter DEX, stake pools, token minting/burning |
| Bitcoin | UTXO model (inputs/outputs), entity clustering for address grouping |
| Thorchain | 40+ tables covering the full liquidity pool lifecycle — swaps, bonds, loans, RUNEPool |
| Canton | DAML-specific model with amulet lifecycle, mining rounds, validator governance |
| Monad | Validator analytics — APR, uptime, miss rates, earnings, consensus logs |
| Flow | Dual-layer (native Flow + EVM), rewards/points system, testnet data |
| NEAR | Receipt-based model, crosschain intents protocol, token supply metrics |
| Axelar | Bridge-specific analytics (GMP, satellite, Squid) |
Explore our Solana data: 78 curated tables, 22 exclusive to Flipside
Validator economics, Jupiter routing, lending lifecycles, governance, and sybil detection — coverage you won't find anywhere else.
06 / Delivery
Snowflake Data Share, provisioned directly into your account. No ETL pipelines, no data movement, no sync jobs. You query the same tables that power Flipside's own products.
Standard SQL, no proprietary query language
Flipside handles ingestion, curation, and updates
Same data that powers Flipside's 168+ AI agents
Raw and decoded blockchain data — transactions, events, traces, blocks across all supported chains.
Everything in Core plus curated ez_ tables with labels, prices, decoded fields, and enriched analytics views.
07 / AI-Native Data
Yes. The chain.schema.table naming convention and clear prefix system (fact_, dim_, ez_) mean agents can discover and query the right tables without human guidance.
Flipside has 168+ AI agents that sit on top of this data. General-purpose analysts, chain-specific specialists for Solana validators, EVM DeFi monitors, crosschain intelligence, and more.
Learn more about agents08 / Explore the Schema
Every chain follows the same chain.schema.table convention. Pick a database, pick a schema, see what tables are available.
solana.defi.fact_bridge_activity
This table contains bridging actions across major crosschain protocols including Wormhole, DeBridge, and Mayan Finance. It tracks token transfers between Solana and other blockchains.
| BLOCK_TIMESTAMP | BLOCK_ID | TX_ID |
|---|---|---|
| 2025-01-30 23:42:22 | 317444556 | 5rsR4e64Hgcby... |
| 2025-01-30 23:04:52 | 317439027 | 5cKDtN3MEZgF... |
Browse schemas and tables across 20+ blockchains
solana.defi
Bridging actions across Wormhole, DeBridge, and Mayan Finance.
09 / FAQ
Over 20, including Ethereum, Solana, Bitcoin, Polygon, Arbitrum, Optimism, Base, BSC, Avalanche, Aptos, NEAR, Sui, Flow, Cosmos, Axelar, Thorchain, and Monad. EVM chains share a near-identical schema, so a query written for Ethereum works on Arbitrum or Base with minimal changes.
fact_ tables contain raw, cleaned event-level data — every transaction, log, and trace. dim_ tables are reference lookups — contract metadata, address labels, token info. ez_ tables join everything together with USD pricing, decoded fields, and human-readable names. Most analysis starts with ez_ tables.
Snowflake Data Share. It gets provisioned directly into your Snowflake account. No ETL pipelines, no data movement, no sync jobs. You query it with standard SQL like any other Snowflake table.
Over 3,000 automated tests run every hour. They check for data gaps, schema drift, stale ingestion, and transformation errors. Data moves through multiple curation tiers, from raw multi-provider inputs to deduplicated, enriched tables ready for analysis.
Yes. The crosschain namespace puts data from all supported blockchains into unified tables. You can compare DEX volumes across Ethereum, Solana, and Arbitrum in a single query. crosschain.evm gives you all EVM chains with identical column structures.
Both. Every chain has a defi schema with one consolidated table per activity type. ez_dex_swaps covers all major DEX protocols on a chain. ez_lending_borrows covers all lending platforms. New protocols get added to these tables on an ongoing basis.
Yes. The chain.schema.table naming convention and the fact_/dim_/ez_ prefix system mean agents can find and query the right tables without human guidance. Flipside also has 168+ AI agents for data exploration, crosschain analysis, and validator monitoring.
Get started
20+ chains, standardized schemas. Over 3,000 quality checks every hour. Start querying in minutes.