🔹Core Schemas

EVM Core Schemas

EVM schemas share similar data structures across all EVM-compatible blockchains indexed by Allium. The following are the main categories of schemas.

Schema Categories

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

*only applicable for Arbitrum Orbit blockchains

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

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