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
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.
Balances come from RPC calls to the chain itself. What you query is what the blockchain reports — no reverse-engineering from transfer history.
Every EVM balance record includes BALANCE_USD at end-of-day prices. No price feed joins or valuation logic to build yourself.
The crosschain.balances schema rolls up every supported EVM chain. One query, standardized schemas, no multi-chain stitching.
02 / Coverage
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.
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.
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.
03 / Precision
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
Separate tables for ERC20 tokens and native assets. Snapshots from direct balanceOf and eth_getBalance RPC calls.
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.
Single table covering all verified fungible assets. Includes a FROZEN status flag for compliance queries and TOKEN_IS_VERIFIED for price reliability filtering.
Daily native balances broken down by liquid, staked, lockup, and storage components.
Validator balances per slot. See how individual validator stakes change over time.
05 / Joins
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
Track stablecoin holder distribution, concentration risk, and flow patterns across chains. See where capital is moving and who's accumulating.
Explore stablecoin data →Build wallet-level portfolio views across tokens and chains. Power wallet trackers, portfolio dashboards, and address profiling tools.
Who holds a token, how holdings are distributed, and how that changes over time. Segment by whale, retail, protocol, and exchange.
Explore labels & tags →Monitor token balances for protocol treasuries, DAO wallets, and smart contract holdings. Track capital allocation decisions as they happen.
Identify frozen accounts on Aptos, track validator balances on Beacon Chain and Monad, and monitor staking positions for compliance reporting.
See KYC & compliance labels →Combine balance snapshots with transfer data to track how assets move between chains, bridges, and protocols over time.
Explore crosschain data →07 / Data access
{chain}.balances.ez_balances_erc20_daily {chain}.balances.ez_balances_native_daily crosschain.balances.ez_balances_erc20_daily crosschain.balances.ez_balances_native_daily solana.core.fact_sol_daily_balances solana.core.fact_token_daily_balances aptos.balances.ez_balances 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) SQL editor, AI chat, dashboards, and automations in one workspace. Free tier available.
Pro customers get a dedicated Snowflake sub-account with 1 TB storage for production pipelines and BI tools.
Programmatic access for pipelines, bots, and downstream systems.
Ask questions in natural language. Agents query the data for you via chat, Slack, or CLI.
Explore agents →08 / Why Flipside
Balances come from direct contract calls, not reverse-engineered from transfer logs. What you query is what the chain reports.
Every table passes through thousands of automated quality checks. Token symbols, decimals, and USD prices are pre-joined.
No warehouse setup, no ETL to maintain. Available via Flipspace, CLI/MCP, Snowflake, or AI agents that query it for you.
The crosschain.balances schema covers every supported EVM chain in one table. No chain-by-chain queries needed.
Get started
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.