The Data Explorer lets you browse Flipside’s complete data catalog—schemas, tables, and columns
across 20+ blockchain networks.
Accessing the Data Explorer
In Flipspace, browse available datasets in the Data Explorer or use Chat to ask about specific
tables.
What’s Available
Blockchain Networks
Flipside maintains curated data for 20+ blockchain networks including:
- EVM chains: Ethereum, Arbitrum, Optimism, Base, Polygon, Avalanche, BSC
- Non-EVM chains: Solana, Aptos, Sui, Near, Cosmos, Osmosis
- Specialized: Bitcoin, Flow, Stellar, THORChain
Data Categories
Each network includes standardized schemas:
| Schema | Description |
|---|
| Core | Blocks, transactions, event logs, traces |
| DeFi | DEX swaps, lending, liquidity pools, bridges |
| NFT | Mints, sales, transfers, collections |
| Price | Token prices, market data, OHLC |
| Stats | Aggregated metrics, daily/hourly summaries |
| Gov | Governance votes, proposals, validators |
| Balances | Token balances, historical snapshots |
Table Naming Conventions
fact_* tables: Raw, granular event dataez_* tables: Curated, analysis-ready views (recommended)dim_* tables: Dimension/reference data (labels, metadata)
Start with ez_* tables. These are optimized for common queries and include human-readable
columns. Use fact_* tables when you need granular detail.
Using the Data Explorer
Browse by network
Each network has a structured hierarchy:
ethereum/
├── core/
│ ├── fact_blocks
│ ├── fact_transactions
│ └── ez_native_transfers
├── defi/
│ ├── ez_dex_swaps
│ ├── ez_lending_borrows
│ └── fact_liquidity_pool_actions
├── nft/
│ ├── ez_nft_sales
│ └── ez_nft_mints
└── price/
├── ez_prices_hourly
└── fact_prices_ohlc_hourly
Preview table structure
Ask Chat about any table:
"What columns are in ethereum.defi.ez_dex_swaps?"
"Show me the schema for solana.core.fact_transactions"
Common Tables
DeFi Analysis
| Table | Use Case |
|---|
{chain}.defi.ez_dex_swaps | DEX trading activity |
{chain}.defi.ez_lending_borrows | Lending protocol borrows |
{chain}.defi.ez_bridge_activity | Cross-chain bridge flows |
Token Analysis
| Table | Use Case |
|---|
{chain}.core.ez_token_transfers | Token transfer history |
{chain}.core.dim_labels | Address labels and tags |
{chain}.price.ez_prices_hourly | Historical token prices |
User Behavior
| Table | Use Case |
|---|
{chain}.core.fact_transactions | All on-chain transactions |
{chain}.core.ez_native_transfers | Native token transfers |
crosschain.address_labels | Cross-chain address metadata |
Data Freshness
Tables are updated on different schedules:
- Hourly tables: Updated every hour
- Daily tables: Updated daily
- Real-time: Use Live Query Mode for current state
Check freshness:
"When was ethereum.defi.ez_dex_swaps last updated?"
Next Steps
