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
.