# The Blockchain Data Your Team Actually Needs

Most blockchain data requires weeks of cleaning before you can use it. Ours doesn't. **20+ chains, standardized schemas, delivered through Snowflake or explored in Flipspace.** USD values, entity labels, and balance snapshots are already there.

## What Makes Flipside Data Different

### Standardized Schemas Across 20+ Chains

Ethereum, Solana, Bitcoin, Arbitrum, Base, Aptos, NEAR, Cosmos, and more — all normalized to the same table structures. Write a query once, run it on any chain. No per-chain data engineering.

### 700M+ Entity Labels Pre-Joined

Every address classified as exchange, DeFi protocol, token contract, treasury, or deployer. Labels are already joined in `ez_` tables — no separate lookup step. Bitcoin has UTXO-based entity clustering you won't find elsewhere as queryable SQL.

### USD Values Already Computed

Every transfer, swap, and lending event includes the USD amount at time of execution. Hourly OHLC price feeds and daily balance snapshots with valuations. No external price oracle stitching required.

### Delivered Through Snowflake

Not an API with rate limits. Not a dashboard. Direct SQL access through your own Snowflake credentials. Connect with Python, dbt, Tableau, Looker, or whatever your team already uses.

### Explore & Analyze in Flipspace

Prefer a visual interface? [Flipspace](https://flipsidecrypto.xyz/flipspace) gives you a full analytics suite on top of the same data — SQL editor, AI chat, automated reports, and specialized agents. Request a demo when you fill out the form.

## What's in the Data

Seven years of production data, curated by analysts who've been decoding onchain activity since 2019.

### Curated `ez_` Tables

Pre-built tables for transfers, swaps, lending, NFTs, staking, and more. Decimal-adjusted, USD-valued, entity-labeled. Ready to query, not parse.

- ez_native_transfers 
- ez_dex_swaps 
- ez_lending

### Entity Labels & Classification

700M+ addresses classified with hierarchical type/subtype taxonomy. Exchanges, protocols, treasuries, deployers, and more. Bitcoin entity clustering via UTXO analysis.

- dim_labels
- dim_tags

### Pricing & Balances

Hourly OHLC price feeds. Daily balance snapshots across 17+ chains with USD valuations. The pricing data is already joined into every curated table.

- ez_prices_hourly
- ez_balances_daily

### DeFi Protocol Data

Dedicated tables for every DeFi event type. Swaps, lending, liquidations, flash loans, staking rewards, and bridge activity — each in its own queryable table.

- ez_dex_swaps 
- ez_lending_* 
- ez_nft_sales

### Crosschain Views

Unified `crosschain.*` views span all EVM chains. Query wallet activity, token flows, and entity interactions across every chain in a single statement.

- crosschain.core 
- crosschain.defi

### Raw & Decoded Data

Need the raw blocks, transactions, and logs? They're there too. Plus ABI-decoded event logs and execution traces across all EVM chains for deep protocol analysis.

- fact_transactions 
- fact_decoded_events 
- fact_traces

## The Problem with Most Blockchain Data

We built Flipside because we got tired of solving the same problems every customer has.

### Without Flipside

✕ Build and maintain separate pipelines per chain  
✕ Stitch in pricing data from external oracles  
✕ Build your own address labeling system  
✕ Decode raw event logs and normalize schemas manually  
✕ Handle decimal adjustments for every token  
✕ Months of data engineering before asking your first question

### With Flipside

- Standardized schemas across 20+ chains — query any chain the same way  
- USD amounts pre-computed in every table  
- 700M+ addresses classified across all chains  
- Curated tables for transfers, DeFi, NFTs, staking, and bridges  
- Decimal adjustments and token metadata handled  
- Start querying in hours, not months

## Chain Coverage

Every chain goes back to genesis. New chains added regularly.

| Category | Chains |
| --- | --- |
| EVM L1s | Ethereum, BSC, Avalanche, Gnosis |
| EVM L2s / Rollups | Polygon, Arbitrum, Optimism, Base, Ink, Monad, Somnia |
| Non-EVM | Solana, Bitcoin, NEAR, SUI, Flow, Cosmos, Axelar, Canton, Aptos |
| Crosschain | Unified views spanning all EVM chains |

### Common Questions About Our Data

### How is the data delivered?

Through Snowflake. You get your own credentials and query directly with SQL. Connect any tool that speaks to Snowflake — Python, dbt, Tableau, Looker, Hex, or your own applications via REST API.

### What's the difference between raw and curated tables?

Raw tables (`fact_*`) contain every block, transaction, and log exactly as it appears onchain. Curated tables (`ez_*`) are cleaned, normalized, and enriched — decimal-adjusted amounts, USD values, entity labels, and event-specific columns. Most teams start with curated tables and drop to raw when they need something specific.

### How fresh is the data?

Curated tables update within minutes of onchain finality. Raw data is even faster. Hourly aggregate tables (metrics, prices) update on the hour. Daily balance snapshots land by early morning UTC.

### Can I bring my own data?

Yes. Upload wallet lists, internal transaction data, or custom segments directly into your workspace. Your data becomes queryable alongside Flipside's blockchain data in the same SQL environment.

### What does "standardized schemas across 20+ chains" actually mean?

It means the `ez_native_transfers` table on Ethereum has the same columns as on Solana, Arbitrum, or Aptos. Same column names, same data types, same logic. Write a query for one chain, change the schema prefix, and it works on another. No per-chain data engineering.