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

Last updated