Enriched Transactions
Chain
SoneiumDataset name
soneium.receipt_transactionsVersion
1.0.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_0xf0bab24f40f50e08f742802396759a656b33eb02dd69d16723bcdf440d2d8928_0 | 0x5af97b1631d673c143dafc72ffe02cbd2085bc722cc88d29e3c5aa3b3a16d010 | 27 | 0xf0bab24f40f50e08f742802396759a656b33eb02dd69d16723bcdf440d2d8928 | 28 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000000558000c5fc5000000000000000400000000674d89cf0000000001453a8d00000000000000000000000000000000000000000000000000000002d7e644870000000000000000000000000000000000000000000000000000000039afbecf21ff5545bca523e1bd4af48564b6b19ab035851fcdd95ac3e67be6adc9f9150e0000000000000000000000006776be80dbada6a02b5f2095cf13734ac303b8d1 | null | null | 126 | 1733134807 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0xe459e19089f3691a8295c751b63021ab680709973064d618d1086a26b68f837b_0 | 0x91a87c064e1a7c1d7791cd3333443c7c72ce5f79679e1f49f810e8f25b9d6aff | 38 | 0xe459e19089f3691a8295c751b63021ab680709973064d618d1086a26b68f837b | 39 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000000558000c5fc5000000000000000300000000674d89e70000000001453a8f00000000000000000000000000000000000000000000000000000002d336551b0000000000000000000000000000000000000000000000000000000049026da0f96de2232b5f345cada77a17964c4868e99bfafc111c943ea48fe53d364b356b0000000000000000000000006776be80dbada6a02b5f2095cf13734ac303b8d1 | null | null | 126 | 1733134829 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x0f5a08be1d1f9718fe5b3566c697d67fbfe98cb73213ba0acf792cbe1f59143f_0 | 0xb60611146e602f815b6e266822f55bbdececc1be835a260e32743cee92594fd6 | 87 | 0x0f5a08be1d1f9718fe5b3566c697d67fbfe98cb73213ba0acf792cbe1f59143f | 88 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000000558000c5fc5000000000000000400000000674d8a470000000001453a9700000000000000000000000000000000000000000000000000000002b1c3fe7800000000000000000000000000000000000000000000000000000000437ef56d456272a4d40903bb4b265cef1bf4b90deb3a70e4575a615725b4d0f1dd5d46a90000000000000000000000006776be80dbada6a02b5f2095cf13734ac303b8d1 | null | null | 126 | 1733134927 | null | 1 | null | null | null | null | 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 |