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

About this Dataset

Ethereum 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.ethereum.blocks

13.07 GB
22835000 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.ethereum.logs

729.83 GB
5257546058 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.ethereum.traces

1.81 TB
12622518789 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.ethereum.transactions

1.39 TB
2952702338 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" DOUBLE,
  "max_fee_per_blob_gas_hex" VARCHAR,
  "access_list" VARCHAR,
  "blob_versioned_hashes" VARCHAR,
  "authorization_list" VARCHAR,
  "block_timestamp" TIMESTAMP
);