Overview
- Dataset ID:
0102 - Table:
blockdb_evm.b0102_transactions_v1 - Description: Transactions included in blocks
- Primary Key:
tx_hash - API: POST /evm/raw/transactions
- Sample: Hugging Face Sample
Columns
| Column | Type | Description |
|---|---|---|
chain_id | BIGINT | EVM chain identifier; see Chain. |
tx_hash | BYTEA | Keccak-256 hash of the transaction (32 bytes) |
from_address | BYTEA | Sender address (20 bytes) |
to_address | BYTEA | Recipient address (null for contract creation, 20 bytes if present) |
block_number | BIGINT | Block height containing this transaction. |
block_time | TIMESTAMPTZ | UTC timestamp of the block. |
tx_index | INTEGER | Zero-based index of the transaction within the block; directly verified by RLP. |
created_contract_address | BYTEA | Contract address created by this transaction (20 bytes); null for non-creation. |
gas_used | NUMERIC(78) | Gas consumed by this transaction. |
effective_gas_price_wei | NUMERIC(78) | Effective gas price paid in wei. |
status_success | BOOLEAN | Execution status: TRUE if successful, FALSE if reverted. |
root | BYTEA | Pre-Byzantium: state root (32 bytes) after tx execution; NULL for Byzantium+. |
tx_type | SMALLINT | Type of transaction (e.g., 2=EIP-1559, 1=legacy). |
trace_failed | BOOLEAN | TRUE if trace failed, FALSE if succeeded, NULL if trace not available. |
value_wei | NUMERIC | Value transferred in wei. |
input | BYTEA | Calldata sent with the transaction. |
nonce | BIGINT | Sender nonce. |
gas_limit | NUMERIC | Gas limit provided by the sender. |
gas_price_wei | NUMERIC | Gas price in wei (legacy). |
max_fee_per_gas_wei | NUMERIC | Max fee per gas (EIP-1559). |
max_priority_fee_per_gas_wei | NUMERIC | Max priority fee per gas (EIP-1559). |
_tracing_id | BYTEA | Tracing ID of the genesis tx record. |
_created_at | TIMESTAMPTZ | Record creation timestamp. |
_updated_at | TIMESTAMPTZ | Record last update timestamp. |
Use Cases
- Transaction flow analysis and wallet tracking
- Gas fee analytics and EIP-1559 impact studies
- Contract deployment and creation tracking
- Failed transaction analysis and debugging
- MEV and arbitrage transaction identification
- Cross-chain transaction pattern analysis
Related Datasets
Blocks
Block headers that contain these transactions.
Logs
Smart contract events emitted by transactions.
Internal Transactions
Nested calls spawned within each transaction.