@import url("https://fonts.googleapis.com/css2?family=Manrope:wght@200..800&display=swap");
body {
  font-family: "Manrope", sans-serif;
}

.relative.mt-8.prose.prose-gray a.card {
  text-decoration: none;
}


Optimism Data Schema

Overview

Optimism

Allium Documentation Hub

Allium is a blockchain data platform that empowers analytics, application development, and accounting.

Allium Overview

Allium delivers data via four core products: Explorer, Datashares, Developer, and Datastreams.

Feature Overview

Query, visualize, and analyze blockchain data with Explorer and Datashares.

Analytics

Build and scale blockchain applications with Developer and Datastreams

Applications

Power transaction monitoring, data reconciliation, and financial reporting with Explorer and Datashares.

Audit and Accounting

Blockchains and schemas supported by Allium.

Data Quality Verification

Data Caveats

FAQ on data freshness for Historical (Batch) Data.

Data Freshness

Query Optimizations

Precomputed metrics to analyze and compare onchain activity across chains

Chain Metrics

Get macro metrics to granular transaction details of Stablecoin movements on chain.

Stablecoins

Human-readable ethereum function signatures and log events.

Decoded

Token Transfers

Fetch block-level changes in the balances of assets across wallets.

Balances

Query DEX swaps volume across multiple blockchain in a single query.

DEX Trades

Identity

Utility

Daily staking metrics across multiple blockchain networks

Staking

Ethereum Virtual Machine-compatible blockchains

Hedera

A one-stop destination for all your blockchain analytics needs.

Query Runner

Data Upload CSV + API

Chart and present your data through our visualisation tools.

Visualisations

Prebuilt metrics dashboards to track key ecosystems, assets, and entities – designed for specific use cases.

Metrics Dashboards

Data delivery straight to your data lake for privacy and control.

Access to Allium data in your own Databricks Environment

Databricks Delta Shares

You can use our data through Snowflake Shares, our custom Rest API and App

Snowflake Shares

Access to Allium data in your own native GCP/BQ Environment

BigQuery Analytics Hub Datashares

Regular data delivery to file buckets across different regions and cloud providers, offering flexible and customizable data access solutions

Data Dumps - S3 & GCS

BI Visualization Tools

Getting Started

Data Tips

Real-Time Data Overview

Allium Developer provides access to blockchain data through Raw and Enriched Endpoints via SQL API, and also through real-time Data Streams

Real-Time Data Delivery Interfaces

Check endpoints available for specific chains and chains supported across endpoints here.

Chain & Endpoint Availability

Prices Overview

Get the latest price for the given token addresses and chains.

Token Latest Price

Get the price history for the given token and the given time granularity.

Token Price Historical

Get tokens price stats like volume, high and low, price and volume change.

Token Price Stats

Wallet Overview

Provides rich transaction activity data for a wallet(s).

Transactions

Get the latest balances for a list of wallets.

Latest Fungible Token Balances

Get the latest NFT balances for a list of wallets.

Latest NFT Balances

Get the latest NFT balances for a single Solana wallet.

Latest Solana NFT Balances

Get the historical balances for a list of wallets.

Historical Fungible Token Balances

Wallet Holdings API Overview

Get historical aggregated usd holdings for an address.

Holdings History

Get the PnL for a given wallet and token address.

Real-time and historical NFT Metadata and Market Data

NFT Data Overview

This API returns all NFT tokens that belong to a given contract.

NFT Tokens by Contract

This API returns NFT token metadata by contract and token ID. For Solana, pass in a token ID of 0.

NFT Token by Contract and Token ID

This API returns the NFT contract metadata associated with the contract address.

NFT Contract

Fetch multiple collections that match the given contract addresses.

NFT Collections

Get a list of NFT listings by contract address.

NFT Listings by Contract Address

NFT Listings by Token ID

Get a list of NFT Activities by token ID.

NFT Activities by Token ID

Fetch a list of NFT Activities by contract address.

NFT Activities by Contract Address

Read and perform data transformations on source streams, and have the transformed data written to destination streams.

Data Transformations Overview

Custom SQL API

Deep Dive: Building A Bitcoin Wallet

Real-time, low-latency data streaming to your data lake of choice.

Getting Started With Kafka

Getting Started With Google Pub/Sub

Getting Started With AWS SNS

Converts questions from plain English into ready-to-run SQL queries with explanations.

Allium AI Assistant

Use the Allium MCP server to run Explorer queries from agent workflows.

MCP Server

Follow along with updates across Allium's products and services.

See the latest chain and schema additions from Allium.

Prices

Wallets

NFT

Data Transformations

Direct Data Access

Deep Dives

Optimism

Optimism Data Schema

Raw

Prices

Wallets

NFT

Data Transformations

Direct Data Access

Deep Dives

​Optimism Data Schema

Raw

Optimism Data Schema