Core Schemas
Overview
Core Ethereum Virtual Machine (EVM) Compatible Schemas on Allium.
Ethereum Virtual Machine (EVM) schemas share similar data structures across all EVM-compatible blockchains indexed by Allium.
We support the following data verticals
*only applicable for Arbitrum Orbit blockchains
Verticals
Raw Data
Raw blockchain data in its most fundamental form, providing the foundation for all derived analytics.| Schema | Description | Tables |
|---|---|---|
| Raw | Primary blockchain data directly from nodes | blocks, transactions, logs, traces, traces_evm_transfers* |
| Raw+ | Enhanced data about deployed smart contracts and tokens | contracts, erc20_tokens, erc721_tokens, erc1155_tokens |
Decoded Data
Human-readable versions of blockchain interactions, with parameters decoded into structured formats.| Models | Description |
|---|---|
| Decoded logs | Event logs with parameters decoded into JSON format for easy querying |
| Decoded traces | Contract interactions with input/output parameters decoded into JSON format |
Metrics
Pre-computed blockchain analytics that enable efficient cross-chain comparison and time-series analysis.| Models | Description |
|---|---|
| Metrics Overview | Daily metrics grouped by chain, covering transactions, users, fees, token transfers, DEX activity, NFTs, stablecoins, and more. Not all metrics are available for every chain. |
Assets
Comprehensive tracking of digital asset movements and holdings across the blockchain.| Models | Description |
|---|---|
| Balances | Real-time tracking of asset balance changes at the block level |
| Balances Latest | Current snapshot of all asset holdings per address |
| Transfers | Detailed record of asset movements between addresses |
| Credit Debit | Aggregated inflow/outflow analysis of assets per address |
Decentralized Exchanges (DEX)
Complete coverage of on-chain trading activity and liquidity provision.| Models | Description |
|---|---|
| DEX Trades | Individual swap transactions across all DEX protocols |
| DEX Pools | Comprehensive registry of active liquidity pools |
| DEX Aggregator Trades | Trades routed through DEX aggregator services |
| DEX Events | Protocol-specific events (Uniswap V2-V4) for detailed analysis |
| DEX OrderFlow | Aggregated trading flow data for frontend analysis |
| DEX Token Prices Hourly | Historical token pricing derived from on-chain trades |
Lending
Complete coverage of on-chain lending activity, total locked value and interest rates.| Models | Description |
|---|---|
| TVL Daily | Delivers daily snapshots of Total Value Locked in lending markets with token-level breakdowns for market size and utilization analysis |
| Interest Rates | Provides detailed interest rate data including supply APY, borrow rates, and market conditions from Aave, Compound, and Morpho Blue for yield analysis |
| Deposits | Tracks deposit events across major lending protocols including Aave and Compound, capturing deposit amounts, token details, and participant addresses |
| Withdrawals | Monitors withdrawal events from lending protocols with complete data on withdrawn amounts, tokens, and user addresses for liquidity analysis |
| Loans | Records borrowing activity from leading lending platforms, with comprehensive data on loan amounts, terms, borrower addresses, and collateralization |
| Repayments | Documents loan repayment transactions with detailed information on repaid amounts, outstanding balances, and borrower activity |
| Liquidations | Captures liquidation events with data on liquidated collateral, repaid debt, liquidators, and borrowers across all major lending protocols |
Non-Fungible Tokens (NFTs)
Detailed tracking of NFT activity and ownership changes.| Models | Description |
|---|---|
| NFT Mints | Detailed records of new NFT creation events |
| NFT Trades | Comprehensive marketplace and peer-to-peer trading activity |
| NFT With Flags | Enhanced trading data with wash trading detection |
| NFT Transfers | Complete history of NFT ownership changes |