# Blockchain Data / Balances

## Every wallet. Every token. Every chain. Daily.

Daily balance snapshots across 20+ blockchains.

End-of-day token holdings for every active address, with USD valuations and crosschain rollups. Sourced from direct onchain state, not inferred from transfers. All in standard SQL.

## 01 / What it is
### Onchain state, not guesswork.

Flipside captures daily end-of-day balance snapshots for every active wallet across 20+ blockchains. Each record shows what an address held, how much, and its USD value — sourced from direct contract calls (`balanceOf` for ERC20s, `eth_getBalance` for native assets), not estimated from transfer logs.

### Verified onchain state

Balances come from RPC calls to the chain itself. What you query is what the blockchain reports — no reverse-engineering from transfer history.

### USD valuations included

Every EVM balance record includes `BALANCE_USD` at end-of-day prices. No price feed joins or valuation logic to build yourself.

### Crosschain in one table

The `crosschain.balances` schema rolls up every supported EVM chain. One query, standardized schemas, no multi-chain stitching.

## 02 / Coverage
### Native assets and tokens, side by side.

Two table types split the work: one for tokens, one for native assets. Use both for a full portfolio view of any address on any chain.

### Token balances

- ERC20, SPL, and verified fungible assets
- Every verified token contract with symbol, decimals, and USD value. Covers ERC20 tokens on EVM chains, SPL tokens on Solana, and verified fungible assets on Aptos.
- Full token metadata (symbol, name, decimals)
- USD valuations at end-of-day prices
- Crosschain rollup available

### Native balances

- ETH, SOL, AVAX, MATIC, BNB, APT...
- Native asset holdings for every active address. Sourced from `eth_getBalance` and chain-native RPC calls. Includes USD value and multiple precision formats.
- Direct RPC state capture
- Multiple precision levels (decimal, raw, hex)
- USD valuations included

## 03 / Precision
### The right format for every use case.

Every balance record ships in multiple formats. Dashboards, reconciliation, downstream models — pick the one you need.

- `BALANCE`: Decimal-adjusted, human-readable amount. What most queries need.
- `BALANCE_RAW`: Raw onchain value in wei or lamports. For exact onchain reconciliation.
- `BALANCE_PRECISE`: String-formatted for maximum decimal precision. No floating-point rounding.
- `BALANCE_HEX`: Hex value direct from the RPC call. For debugging and low-level verification.

## 04 / Chain highlights
### Built for each chain's strengths.

- **20+ Chains covered**
- **12 EVM chains + crosschain**
- **Daily Snapshot frequency**
- **80+ Curated Solana tables**

### EVM chains (12 + crosschain)

Separate tables for ERC20 tokens and native assets. Snapshots from direct `balanceOf` and `eth_getBalance` RPC calls.
- Ethereum
- Polygon
- Arbitrum
- Optimism
- Base
- BSC
- Avalanche
- Gnosis
- Ink
- Monad
- Somnia

### Solana: complete time series

Forward-filled daily balances with no gaps between active days. A `BALANCE_CHANGED_ON_DATE` flag tells you whether each row is fresh or carried forward. 80+ curated tables across 7 schemas.

### Aptos: unified + compliance-ready

Single table covering all verified fungible assets. Includes a `FROZEN` status flag for compliance queries and `TOKEN_IS_VERIFIED` for price reliability filtering.

### NEAR

Daily native balances broken down by liquid, staked, lockup, and storage components.

### Ethereum Beacon Chain

Validator balances per slot. See how individual validator stakes change over time.

### More chains

- Axelar: Staked + liquid balances by currency
- THORChain: Pool balances with RUNE/asset amounts
- Sui: Token balance change events per tx
- Flow: Point-in-time reward account balances
- Canton: Balance changes from transfers
- Monad: Delegator, staking, and validator balances

## 05 / Joins
### Joins directly into Flipside's data model.

Balance tables connect directly to labels, contracts, transfers, and stablecoin supply data.

- `dim_labels`: Identify addresses — exchanges, protocols, whales, funds
- `dim_contracts`: Get full token metadata from contract addresses
- `ez_token_transfers`: Compare snapshot balances against transfer activity
- `ez_stablecoins_supply`: Layer on stablecoin supply and market cap data

## 06 / Use cases
### Who uses this data.

### Stablecoin intelligence

Track stablecoin holder distribution, concentration risk, and flow patterns across chains. See where capital is moving and who's accumulating.

### Portfolio and wallet analytics

Build wallet-level portfolio views across tokens and chains. Power wallet trackers, portfolio dashboards, and address profiling tools.

### Token holder analysis

Who holds a token, how holdings are distributed, and how that changes over time. Segment by whale, retail, protocol, and exchange.

### DeFi position monitoring

Monitor token balances for protocol treasuries, DAO wallets, and smart contract holdings. Track capital allocation decisions as they happen.

### Compliance and risk

Identify frozen accounts on Aptos, track validator balances on Beacon Chain and Monad, and monitor staking positions for compliance reporting.

### Crosschain flow analysis

Combine balance snapshots with transfer data to track how assets move between chains, bridges, and protocols over time.

## 07 / Data access
### Query it your way.

### Table naming

- EVM ERC20 (per chain): `{chain}.balances.ez_balances_erc20_daily`
- EVM native (per chain): `{chain}.balances.ez_balances_native_daily`
- Crosschain ERC20: `crosschain.balances.ez_balances_erc20_daily`
- Crosschain native: `crosschain.balances.ez_balances_native_daily`
- Solana SOL: `solana.core.fact_sol_daily_balances`
- Solana SPL tokens: `solana.core.fact_token_daily_balances`
- Aptos: `aptos.balances.ez_balances`

### Key columns (EVM)
- `DATE`: Snapshot date (end of day)
- `ADDRESS`: Wallet address
- `CONTRACT_ADDRESS`: Token contract (ERC20 tables)
- `SYMBOL`: Token symbol
- `BALANCE`: Decimal-adjusted amount
- `BALANCE_USD`: USD value at end-of-day prices
- `BLOCKCHAIN`: Chain name (crosschain tables)

### Access methods
- **Flipspace**: SQL editor, AI chat, dashboards, and automations in one workspace. Free tier available.
- **Snowflake Data Share**: Pro customers get a dedicated Snowflake sub-account with 1 TB storage for production pipelines and BI tools.
- **CLI / MCP**: Programmatic access for pipelines, bots, and downstream systems.
- **AI Agents**: Ask questions in natural language. Agents query the data for you via chat, Slack, or CLI.

## 08 / Why Flipside
### What makes this different.

- **Onchain verified, not inferred**: Balances come from direct contract calls, not reverse-engineered from transfer logs. What you query is what the chain reports.
- **Curated, not raw**: Every table passes through thousands of automated quality checks. Token symbols, decimals, and USD prices are pre-joined.
- **Queryable instantly**: No warehouse setup, no ETL to maintain. Available via Flipspace, CLI/MCP, Snowflake, or AI agents that query it for you.
- **Crosschain by default**: The `crosschain.balances` schema covers every supported EVM chain in one table. No chain-by-chain queries needed.

## Get started
### See what every wallet holds. Across every chain.

Daily balance snapshots for 20+ blockchains with USD valuations, crosschain rollups, and multiple precision formats. Query in SQL or let AI do it for you.