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

812.68 MB
2003000 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

53.23 GB
629646877 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

144.31 GB
2859305114 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

49.58 GB
60639276 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
);