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 the 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.
