Raw Datasets

Datasets form the backbone of Big Data Analytics. Ethereum, as a blockchain platform, provides an abundance of raw data. There are few tables which can be , where general analyses are conducted, and reports are generated based on the available data and formulas.

Datasets
Columns

ethereum_blocks

timestamp, number, hash, parent_hash, nonce, sha3_uncles, logs_bloom, transactions_root, state_root, receipts_root, miner, difficulty, total_difficulty, size, extra_data, gas_limit, gas_used, transaction_count, base_fee_per_gas

ethereum_transactions

hash, nonce, transaction_index, from_address, to_address, value, gas, gas_price, input, receipt_cumulative_gas_used, receipt_gas_used, receipt_contract_address, receipt_status, block_timestamp, block_number, block_hash, max_fee_per_gas, max_priority_fee_per_gas, transaction_type, receipt_effective_gas_price

ethereum_logs

log_index, transaction_hash, transaction_index, address, data, topics, block_timestamp, block_number, block_hash

ethereum_traces

transaction_hash, transaction_index, from_address, to_address, value, input, output, trace_type, call_type, reward_type, gas, gas_used, subtraces, trace_address, error, status, block_timestamp, block_number, block_hash, trace_id

ethereum_genesis

block_id, timestamp, genesis, recipiant, failed, call_count, alloc_in_wei, alloc_in_eth, internal_value

Last updated