Core Ethereum Virtual Machine (EVM) Compatible Schemas on Allium.
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 |
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 |
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. |
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 |
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 |
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 |
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 |