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

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

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

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.