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.
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.
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.
EVM chains (12 + crosschain)
Separate tables for ERC20 tokens and native assets. Snapshots from direct balanceOf and eth_getBalance RPC calls.
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
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.
Explore stablecoin data →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.
Explore labels & tags →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.
See KYC & compliance labels →Crosschain flow analysis
Combine balance snapshots with transfer data to track how assets move between chains, bridges, and protocols over time.
Explore crosschain data →07 / Data access
Query it your way.
Table naming
{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 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.
Explore agents →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.