Enriched Transactions
Chain
ModeDataset name
mode.receipt_transactionsVersion
1.1.0Description
Transaction data including input, value, from and to address, and metadata for the block, gas, and receipts.
Example data
| id | hash | nonce | block_hash | block_number | transaction_index | from_address | to_address | value | gas | gas_price | input | max_fee_per_gas | max_priority_fee_per_gas | transaction_type | block_timestamp | receipt_cumulative_gas_used | receipt_gas_used | receipt_contract_address | receipt_status | receipt_effective_gas_price | receipt_root_hash | receipt_l1_fee | receipt_l1_gas_used | receipt_l1_gas_price | receipt_l1_fee_scalar | receipt_l1_blob_base_fee | receipt_l1_blob_base_fee_scalar | blob_versioned_hashes | max_fee_per_blob_gas | receipt_l1_block_number | receipt_l1_base_fee_scalar | gateway_fee | fee_currency | gateway_fee_recipient |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| enriched_transaction_v2_0x784db8b9e2318b944632eb83cd61c450aea3ec6529c59fa51dadd0dd870eb909_0 | 0x20a5b068f9d796cf7d00783eae881d24f6a8f1762a39f2cd3f856d80fccdd801 | 8718952 | 0x784db8b9e2318b944632eb83cd61c450aea3ec6529c59fa51dadd0dd870eb909 | 8718952 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 1000000 | 0 | 0x440a5e2000004e20000955060000000000000004000000006660942b00000000013195f1000000000000000000000000000000000000000000000000000000047ab8ff3400000000000000000000000000000000000000000000000000000000000000041415ad4f6748ee5706791ac68672927414688913faee515edbca4bbfc36197ee00000000000000000000000099199a22125034c808ff20f377d91187e8050f2e | null | null | 126 | 1717605487 | 43851 | 43851 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null |
| enriched_transaction_v2_0xadd702994169bca096f8fcc0d2e67a969482b5b526179bed0a88b6e41d1905be_4 | 0xc1536ded2fa2eda7ab0c0faef744fce24d39e44e707483286f673d4f42eaa077 | 378814 | 0xadd702994169bca096f8fcc0d2e67a969482b5b526179bed0a88b6e41d1905be | 8718954 | 4 | 0x58c0179d43d2ccb0459eb151f35ceb7eedbb7fa4 | 0xfde78a663b0df013a793d8951cafe7240eb5d5f2 | 0 | 20000000 | 5032 | 0x00000000 | 1500000 | 15 | 2 | 1717605491 | 2830166 | 967687 | null | 1 | 5032 | null | 668670490215 | 1780 | 18782878931 | null | null | null | null | null | null | null | null | null | null |
Schema
| Column | Type |
|---|---|
| id | string |
| hash | string |
| nonce | long |
| block_hash | string |
| block_number | long |
| transaction_index | long |
| from_address | string |
| to_address | string |
| value | decimal |
| gas | decimal |
| gas_price | decimal |
| input | string |
| max_fee_per_gas | decimal |
| max_priority_fee_per_gas | decimal |
| transaction_type | long |
| block_timestamp | long |
| receipt_cumulative_gas_used | decimal |
| receipt_gas_used | decimal |
| receipt_contract_address | string |
| receipt_status | long |
| receipt_effective_gas_price | decimal |
| receipt_root_hash | string |
| receipt_l1_fee | decimal |
| receipt_l1_gas_used | decimal |
| receipt_l1_gas_price | decimal |
| receipt_l1_fee_scalar | double |
| receipt_l1_blob_base_fee | decimal |
| receipt_l1_blob_base_fee_scalar | long |
| blob_versioned_hashes | array |
| max_fee_per_blob_gas | decimal |
| receipt_l1_block_number | long |
| receipt_l1_base_fee_scalar | long |
| gateway_fee | long |
| fee_currency | string |
| gateway_fee_recipient | string |