Schema

blocks.csv

Column	Type
number	bigint
hash	hex_string
parent_hash	hex_string
nonce	hex_string
sha3_uncles	hex_string
logs_bloom	hex_string
transactions_root	hex_string
state_root	hex_string
receipts_root	hex_string
miner	address
difficulty	numeric
total_difficulty	numeric
size	bigint
extra_data	hex_string
gas_limit	bigint
gas_used	bigint
timestamp	bigint
transaction_count	bigint
base_fee_per_gas	bigint
withdrawals_root	string
withdrawals	string
blob_gas_used	bigint
excess_blob_gas	bigint

---

transactions.csv

Column	Type
hash	hex_string
nonce	bigint
block_hash	hex_string
block_number	bigint
transaction_index	bigint
from_address	address
to_address	address
value	numeric
gas	bigint
gas_price	bigint
input	hex_string
block_timestamp	bigint
max_fee_per_gas	bigint
max_priority_fee_per_gas	bigint
transaction_type	bigint
max_fee_per_blob_gas	bigint
blob_versioned_hashes	string

---

token_transfers.csv

Column	Type
token_address	address
from_address	address
to_address	address
value	numeric
transaction_hash	hex_string
log_index	bigint
block_number	bigint

---

receipts.csv

Column	Type
transaction_hash	hex_string
transaction_index	bigint
block_hash	hex_string
block_number	bigint
cumulative_gas_used	bigint
gas_used	bigint
contract_address	address
root	hex_string
status	bigint
effective_gas_price	bigint
blob_gas_price	bigint
blob_gas_used	bigint

---

logs.csv

Column	Type
log_index	bigint
transaction_hash	hex_string
transaction_index	bigint
block_hash	hex_string
block_number	bigint
address	address
data	hex_string
topics	string

---

contracts.csv

Column	Type
address	address
bytecode	hex_string
function_sighashes	string
is_erc20	boolean
is_erc721	boolean
block_number	bigint

---

tokens.csv

Column	Type
address	address
symbol	string
name	string
decimals	bigint
total_supply	numeric
block_number	bigint

---

traces.csv

Column	Type
block_number	bigint
transaction_hash	hex_string
transaction_index	bigint
from_address	address
to_address	address
value	numeric
input	hex_string
output	hex_string
trace_type	string
call_type	string
reward_type	string
gas	bigint
gas_used	bigint
subtraces	bigint
trace_address	string
error	string
status	bigint
trace_id	string

Differences between geth and parity traces.csv

• to_address field differs for callcode trace (geth seems to return correct value, as parity value of to_address is same as to_address of parent call);
• geth output doesn't have reward traces;
• geth output doesn't have to_address, from_address, value for suicide traces;
• error field contains human readable error message, which might differ in geth/parity output;
• geth output doesn't have transaction_hash;
• gas_used is 0 on traces with error in geth, empty in parity;
• zero output of subcalls is 0x000... in geth, 0x in parity;

You can find column descriptions in https://github.com/medvedev1088/ethereum-etl-airflow

Note: for the address type all hex characters are lower-cased. boolean type can have 2 values: True or False.