Enriched Transactions
Chain
BaseDataset name
base.receipt_transactionsVersion
1.2.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_0xc85d18b575468e4e869595e0620a4409dbb6b08773248c3961b540d664174430_5 | 0x02862c2799bc5455acfdbb3f4e4d2be53a43c583d693ba11b845eb740e2e364b | 6143 | 0xc85d18b575468e4e869595e0620a4409dbb6b08773248c3961b540d664174430 | 16971759 | 5 | 0xf501e496859e560308c9cc433465405239cd61e8 | 0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad | 99000000000000000 | 300000 | 11167072 | 0x24856bc30000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000020b080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000015fb7f9b8c380000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000f501e496859e560308c9cc433465405239cd61e8000000000000000000000000000000000000000000000000015fb7f9b8c380000000000000000000000000000000000000000000000f2421cad2b03ff88c869400000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000000000000000000000042000000000000000000000000000000000000060000000000000000000000001cefcc04858fc03f2c806e37f03ea02f4d276fb0 | 11167072 | 11167072 | 2 | 1720732865 | 919492 | 156762 | null | 1 | 11167072 | null | 22708239520 | 2932 | 3413021516 | null | 1 | 1055762 | null | null | null | 2269 | null | null | null |
| enriched_transaction_v2_0xc85d18b575468e4e869595e0620a4409dbb6b08773248c3961b540d664174430_12 | 0x9f9e18eb23a8fee25d49e5a54676832caf68aceff499ebf15771a3b481b29944 | 1578 | 0xc85d18b575468e4e869595e0620a4409dbb6b08773248c3961b540d664174430 | 16971759 | 12 | 0x09ca6926f0a1fa30ddc04710db2d89ec0d73b608 | 0xba5e05cb26b78eda3a2f8e3b3814726305dcac83 | 0 | 83711 | 10611080 | 0x8abe099100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000013e000000000000000000000000000000000000000000000000000000000000014e | null | null | 0 | 1720732865 | 1491377 | 65436 | null | 1 | 10611080 | null | 12390633417 | 1600 | 3413021516 | null | 1 | 1055762 | null | null | null | 2269 | 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 |