> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# 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

## 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    |

\*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        | Realtime 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                   |
