Schema

blocks.csv

Column Type
number bigint
hash hex_string
parent_hash hex_string
logs_bloom hex_string
transactions_root hex_string
state_root hex_string
receipts_root hex_string
size bigint
extra_data hex_string
gas_used numeric
block_timestamp timestamp
block_unix_timestamp numeric
transaction_count bigint
block_score numeric
total_block_score numeric
governance_data hex_string
vote_data hex_string
committee struct
proposer hex_string
reward_address adresss
base_fee_per_gas numeric

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
fee_payer hex_string
fee_payer_signatures struct
fee_ratio bigint
sender_tx_hash hex_string
signatures struct
tx_type string
tx_type_int bigint
block_timestamp timestamp
block_unix_timestamp numeric
receipt_gas_used numeric
receipt_contract_address adresss
receipt_status bigint
max_priority_fee_per_gas numeric
max_fee_per_gas numeric
access_list struct

token_transfers.csv

Column Type
token_address address
from_address address
to_address address
value string
block_hash hex_string
block_number bigint
block_timestamp timestamp
block_unix_timestamp numeric
transaction_hash hex_string
transaction_receipt_status bigint
log_index bigint

receipts.csv

Column Type
transaction_hash hex_string
transaction_index bigint
block_hash hex_string
block_number bigint
gas numeric
gas_price numeric
gas_used numeric
effective_gas_price numeric
contract_address address
logs_bloom hex_string
nonce bigint
fee_payer hex_string
fee_payer_signatures struct
fee_ratio bigint
code_format string
human_readable boolean
tx_error string
key hex_string
input_data hex_string
from_address address
to_address address
type_name string
type_int bigint
sender_tx_hash hex_string
signatures struct
status bigint
value string
input_json struct
access_list struct
chain_id bigint
max_priority_fee_per_gas numeric
max_fee_per_gas numeric
block_timestamp timestamp
block_unix_timestamp numeric

logs.csv

Column Type
block_number bigint
block_hash hex_string
block_timestamp timestamp
block_unix_timestamp numeric
transaction_hash hex_string
transaction_index bigint
transaction_receipt_status bigint
log_index bigint
address address
data string
topics string

contracts.csv

Column Type
address address
bytecode hex_string
function_sighashes string
is_erc20 boolean
is_erc721 boolean
is_erc1155 boolean
block_number bigint
block_hash hex_string
block_timestamp timestamp
block_unix_timestamp numeric
transaction_hash hex_string
transaction_index bigint
transaction_receipt_status bigint
trace_index bigint
trace_status bigint
creator_address address

tokens.csv

Column Type
address address
symbol string
name string
decimals bigint
total_supply string
function_sighashes string
is_erc20 boolean
is_erc721 boolean
is_erc1155 boolean
block_number bigint
block_hash hex_string
block_timestamp timestamp
block_unix_timestamp numeric
transaction_hash hex_string
transaction_index bigint
transaction_receipt_status bigint
trace_index bigint
trace_status bigint
creator_address address

traces.csv

Column Type
block_number bigint
block_hash hex_string
block_timestamp timestamp
block_unix_timestamp numeric
transaction_hash hex_string
transaction_index bigint
transaction_receipt_status bigint
from_address address
to_address address
value numeric
input hex_string
output hex_string
trace_type string
call_type string
gas numeric
gas_used numeric
subtraces bigint
trace_address string
error string
status bigint
trace_index string

You can find column descriptions in https://github.com/klaytn/klaytn-etl

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