Name: Optimism Blockchain
Creator: Baselight
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

Optimism Blockchain

This dataset is part of Baselight’s unified blockchain collection — a standardized, structured repository of raw and enriched data across multiple blockchains. It includes key tables such as blocks, transactions, logs, traces.

Designed for on-chain analytics, indexing, decentralized applications, and research, the data is continuously updated and normalized.

Whether you're exploring transaction trends, building DeFi dashboards, or training ML models on blockchain activity, this dataset provides a reliable foundation.

We welcome feedback and contributions to improve coverage, completeness, and usability.

Tables

Blocks

@blt.optimism.blocks

677.36 MB
1668000 rows
31 columns


CREATE TABLE blocks (
  "hash" VARCHAR,
  "number" BIGINT,
  "number_hex" VARCHAR,
  "gas_limit" DOUBLE,
  "gas_limit_hex" VARCHAR,
  "gas_used" DOUBLE,
  "gas_used_hex" VARCHAR,
  "base_fee_per_gas" DOUBLE,
  "base_fee_per_gas_hex" VARCHAR,
  "blob_gas_used" DOUBLE,
  "blob_gas_used_hex" VARCHAR,
  "excess_blob_gas" DOUBLE,
  "excess_blob_gas_hex" VARCHAR,
  "nonce" VARCHAR,
  "difficulty" BIGINT,
  "difficulty_hex" VARCHAR,
  "total_difficulty" VARCHAR,
  "size" BIGINT,
  "size_hex" VARCHAR,
  "parent_hash" VARCHAR,
  "requests_hash" VARCHAR,
  "miner" VARCHAR,
  "parent_beacon_block_root" VARCHAR,
  "withdrawals_root" VARCHAR,
  "receipts_root" VARCHAR,
  "state_root" VARCHAR,
  "transactions_root" VARCHAR,
  "extra_data" VARCHAR,
  "mix_hash" VARCHAR,
  "withdrawals" VARCHAR,
  "block_timestamp" TIMESTAMP
);

Logs

@blt.optimism.logs

47.02 GB
558162649 rows
27 columns


CREATE TABLE logs (
  "block_hash" VARCHAR,
  "block_number" BIGINT,
  "block_number_hex" VARCHAR,
  "tx_from" VARCHAR,
  "tx_to" VARCHAR,
  "gas_used" DOUBLE,
  "gas_used_hex" VARCHAR,
  "cumulative_gas_used" DOUBLE,
  "cumulative_gas_used_hex" VARCHAR,
  "effective_gas_price" DOUBLE,
  "effective_gas_price_hex" VARCHAR,
  "tx_hash" VARCHAR,
  "tx_index" BIGINT,
  "tx_index_hex" VARCHAR,
  "contract_address" VARCHAR,
  "topics" VARCHAR,
  "topic0" VARCHAR,
  "topic1" VARCHAR,
  "topic2" VARCHAR,
  "topic3" VARCHAR,
  "data" VARCHAR,
  "index" BIGINT,
  "index_hex" VARCHAR,
  "status" BIGINT,
  "status_hex" VARCHAR,
  "removed" BOOLEAN,
  "block_timestamp" TIMESTAMP
);

Traces

@blt.optimism.traces

120.96 GB
2398327738 rows
20 columns


CREATE TABLE traces (
  "block_hash" VARCHAR,
  "block_number" BIGINT,
  "from" VARCHAR,
  "to" VARCHAR,
  "gas_used" DOUBLE,
  "gas_used_hex" VARCHAR,
  "gas" DOUBLE,
  "gas_hex" VARCHAR,
  "tx_hash" VARCHAR,
  "tx_index" DOUBLE,
  "trace_address" VARCHAR,
  "value" VARCHAR,
  "value_hex" VARCHAR,
  "sub_traces" BIGINT,
  "type" VARCHAR,
  "call_type" VARCHAR,
  "input" VARCHAR,
  "output" VARCHAR,
  "error" VARCHAR,
  "block_timestamp" TIMESTAMP
);

Transactions

@blt.optimism.transactions

43.13 GB
51823294 rows
34 columns


CREATE TABLE transactions (
  "block_hash" VARCHAR,
  "block_number" BIGINT,
  "block_number_hex" VARCHAR,
  "from" VARCHAR,
  "gas" DOUBLE,
  "gas_hex" VARCHAR,
  "gas_price" DOUBLE,
  "gas_price_hex" VARCHAR,
  "max_fee_per_gas" DOUBLE,
  "max_fee_per_gas_hex" VARCHAR,
  "max_priority_fee_per_gas" DOUBLE,
  "max_priority_fee_per_gas_hex" VARCHAR,
  "hash" VARCHAR,
  "input" VARCHAR,
  "nonce" BIGINT,
  "nonce_hex" VARCHAR,
  "to" VARCHAR,
  "index" BIGINT,
  "index_hex" VARCHAR,
  "value" BIGINT,
  "value_hex" VARCHAR,
  "type" BIGINT,
  "type_hex" VARCHAR,
  "chain_id" VARCHAR,
  "v" VARCHAR,
  "r" VARCHAR,
  "s" VARCHAR,
  "y_parity" VARCHAR,
  "max_fee_per_blob_gas" VARCHAR,
  "max_fee_per_blob_gas_hex" VARCHAR,
  "access_list" VARCHAR,
  "blob_versioned_hashes" VARCHAR,
  "authorization_list" VARCHAR,
  "block_timestamp" TIMESTAMP
);