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

About this Dataset

Ethereum Blockchain

Part of Baselight’s unified blockchain collection, this dataset provides two complementary layers of chain data:

Optimized tables (recommended): cleaned, enriched, and indexed for fast analytics and LLMs (e.g., Asset Transfers, Decoded Events/Calls, Swaps).
Raw tables (advanced): full ledger data as produced on-chain (e.g., Blocks, Transactions, Receipts, Logs, Traces).

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

Start with Optimized tables for most use cases. Use Raw only when you need low-level fields or custom decoding.

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

Tables

Blocks (Raw)

@blt.ethereum.blocks

5.29 GB
5,205,000 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
);

Asset Transfers (Optimized)

@blt.ethereum.fact_asset_transfers

272.13 GB
4,518,471,297 rows
21 columns

CREATE TABLE fact_asset_transfers (
  "chain_id" INTEGER,
  "block_timestamp" TIMESTAMP,
  "block_number" BIGINT,
  "tx_hash" VARCHAR,
  "tx_index" INTEGER,
  "event_index" INTEGER,
  "source_type" VARCHAR,
  "transfer_standard" VARCHAR,
  "token_address" VARCHAR,
  "token_symbol" VARCHAR,
  "token_decimals" INTEGER,
  "from_address" VARCHAR,
  "to_address" VARCHAR,
  "token_id" DECIMAL,
  "operator_address" VARCHAR,
  "amount_raw" DECIMAL,
  "amount_adj" DOUBLE,
  "is_mint" BOOLEAN,
  "is_burn" BOOLEAN,
  "is_internal" BOOLEAN,
  "created_at" TIMESTAMP
);

Decoded Calls (Optimized)

@blt.ethereum.fact_decoded_calls

272.47 GB
5,107,902,075 rows
22 columns

CREATE TABLE fact_decoded_calls (
  "chain_id" INTEGER,
  "block_number" BIGINT,
  "tx_index" INTEGER,
  "call_id" VARCHAR,
  "parent_call_id" VARCHAR,
  "tx_hash" VARCHAR,
  "call_type" VARCHAR,
  "from_address" VARCHAR,
  "to_address" VARCHAR,
  "impl_address" VARCHAR,
  "selector" VARCHAR,
  "contract_name" VARCHAR,
  "function_name" VARCHAR,
  "success" BOOLEAN,
  "value_wei" DECIMAL,
  "gas_used" BIGINT,
  "input_size" INTEGER,
  "output_size" INTEGER,
  "args" VARCHAR,
  "return_values" VARCHAR,
  "block_timestamp" TIMESTAMP,
  "created_at" TIMESTAMP
);

Decoded Events (Optimized)

@blt.ethereum.fact_decoded_events

503.64 GB
3,513,418,439 rows
17 columns

CREATE TABLE fact_decoded_events (
  "chain_id" INTEGER,
  "block_number" BIGINT,
  "tx_index" INTEGER,
  "log_index" INTEGER,
  "tx_hash" VARCHAR,
  "emitter_address" VARCHAR,
  "topic0" BLOB,
  "topic1" BLOB,
  "topic2" BLOB,
  "topic3" BLOB,
  "contract_name" VARCHAR,
  "event_name" VARCHAR,
  "decoded_ok" BOOLEAN,
  "args" VARCHAR,
  "data" BLOB,
  "block_timestamp" TIMESTAMP,
  "created_at" TIMESTAMP
);

Swaps (Optimized)

@blt.ethereum.fact_swaps

21.33 GB
271,805,036 rows
21 columns

CREATE TABLE fact_swaps (
  "chain_id" INTEGER,
  "block_number" BIGINT,
  "tx_index" INTEGER,
  "swap_seq" INTEGER,
  "log_index" INTEGER,
  "tx_hash" VARCHAR,
  "router_address" VARCHAR,
  "pool_address" VARCHAR,
  "trader_address" VARCHAR,
  "token_in_address" VARCHAR,
  "token_out_address" VARCHAR,
  "token_in_symbol" VARCHAR,
  "token_out_symbol" VARCHAR,
  "amount_in_raw" DECIMAL,
  "amount_out_raw" DECIMAL,
  "amount_in_norm" DOUBLE,
  "amount_out_norm" DOUBLE,
  "price_quote" DOUBLE,
  "source" VARCHAR,
  "block_timestamp" TIMESTAMP,
  "created_at" TIMESTAMP
);

Transactions & Receipts (Optimized)

@blt.ethereum.fact_transactions

451.22 GB
3,064,072,726 rows
25 columns

CREATE TABLE fact_transactions (
  "tx_hash" VARCHAR,
  "nonce" BIGINT,
  "block_number" BIGINT,
  "block_hash" VARCHAR,
  "block_timestamp" TIMESTAMP,
  "tx_index" INTEGER,
  "from_address" VARCHAR,
  "to_address" VARCHAR,
  "function_selector" VARCHAR,
  "value_wei" DECIMAL,
  "gas_price_wei" DECIMAL,
  "gas_limit_wei" BIGINT,
  "max_fee_per_gas_wei" DECIMAL,
  "max_priority_fee_per_gas_wei" DECIMAL,
  "transaction_type" INTEGER,
  "chain_id" INTEGER,
  "cumulative_gas_used" BIGINT,
  "gas_used" BIGINT,
  "created_contract_address" VARCHAR,
  "status" INTEGER,
  "effective_gas_price_wei" DECIMAL,
  "max_fee_per_blob_gas_wei" DECIMAL,
  "access_list" VARCHAR,
  "authorization_list" VARCHAR,
  "created_at" TIMESTAMP
);

Logs (Raw)

@blt.ethereum.logs

860.48 GB
5,843,936,799 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
);

Receipts (Raw)

@blt.ethereum.receipts

406.35 GB
3,128,328,669 rows
20 columns

CREATE TABLE receipts (
  "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" DOUBLE,
  "tx_index_hex" VARCHAR,
  "contract_address" VARCHAR,
  "status" DOUBLE,
  "status_hex" VARCHAR,
  "type" DOUBLE,
  "type_hex" VARCHAR,
  "block_timestamp" TIMESTAMP
);

Traces (Raw)

@blt.ethereum.traces

2.14 TB
14,071,401,030 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 (Raw)

@blt.ethereum.transactions

572.14 GB
938,720,921 rows
34 columns

CREATE TABLE transactions (
  "block_hash" VARCHAR,
  "block_number" DOUBLE,
  "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" DOUBLE,
  "nonce_hex" VARCHAR,
  "to" VARCHAR,
  "index" DOUBLE,
  "index_hex" VARCHAR,
  "value" DOUBLE,
  "value_hex" VARCHAR,
  "type" DOUBLE,
  "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
);