Enriched Transactions
Chain
Immutable zkEVM TestnetDataset name
immutable_testnet.transaction_receiptsVersion
1.0.0Description
Enriched transaction data including input, value, from and to address, and metadata for the block, gas and receipt.
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_l1_fee | receipt_l1_fee_scalar | receipt_l1_gas_price | receipt_l1_gas_used | receipt_root | receipt_root_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| enriched_transaction_0x5a86843613c135e55fe21c5246aa50966c3c24e5abcf9a8377984d11ba034c10_0 | 0x12a058d413945619e030294350490e1e681591c5b0652fc2d235d300c2c67640 | 0 | 0x5a86843613c135e55fe21c5246aa50966c3c24e5abcf9a8377984d11ba034c10 | 4299900 | 0 | 0xfffffffffffffffffffffffffffffffffffffffe | 0x0000000000000000000000000000000000000101 | 0 | 1000000 | 0 | 0x0f50287c00000000000000000000000000000000000000000000000000000000000037fd0000000000000000000000000000000000000000000000000000000000419b510000000000000000000000000000000000000000000000000000000000419c7c0000000000000000000000000000000000000000000000000000000000000000 | 127 | 1700421121 | 99167 | 99167 | 1 | 0x0000000000000000000000000000000000000000000000000000000000000000 | |||||||||
| enriched_transaction_0x82a280bab29e525e3cdc1f58550424d4376f5cca1e41b846f0f45fcbf03a400d_1 | 0xfdeec529016a09b27b2bccf0979dd7471684820ae57a975827c5ef962332e57b | 0 | 0x82a280bab29e525e3cdc1f58550424d4376f5cca1e41b846f0f45fcbf03a400d | 4305300 | 1 | 0xfffffffffffffffffffffffffffffffffffffffe | 0x0000000000000000000000000000000000000105 | 0 | 1000000 | 0 | 0x8a9cd82d000000000000000000000000000000000000000000000000000000000000380f00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000004000000000000000000000000fe38f710075cc92f0100bd3abdbd4310beed56b20000000000000000000000000000000000000000000000000000000000000012000000000000000000000000fbe2bd3ca896981940796b0ed76b6762a604fc350000000000000000000000000000000000000000000000000000000000000123000000000000000000000000c73f0f44fa20555d8e4f008385136bd71e9d5041000000000000000000000000000000000000000000000000000000000000012a0000000000000000000000003525257def83a1d80d030a4f0e5b1d59c18d65ad0000000000000000000000000000000000000000000000000000000000000128 | 127 | 1700432073 | 208228 | 109061 | 1 | 0x0000000000000000000000000000000000000000000000000000000000000000 | |||||||||
| enriched_transaction_0xcfb6208ac5c77e14ffd7620372780324b09361bb957d80e621821282ddd461d5_0 | 0x3a2de6ba7fa61a151d0351c22c65ac860be7ae690ca416d0dc21e09b634d0c8c | 0 | 0xcfb6208ac5c77e14ffd7620372780324b09361bb957d80e621821282ddd461d5 | 4302300 | 0 | 0xfffffffffffffffffffffffffffffffffffffffe | 0x0000000000000000000000000000000000000101 | 0 | 1000000 | 0 | 0x0f50287c0000000000000000000000000000000000000000000000000000000000003805000000000000000000000000000000000000000000000000000000000041a4b1000000000000000000000000000000000000000000000000000000000041a5dc0000000000000000000000000000000000000000000000000000000000000000 | 127 | 1700425988 | 99167 | 99167 | 1 | 0x0000000000000000000000000000000000000000000000000000000000000000 |
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 |