Enriched Transactions
Chain
Dataset name
automata_testnet.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_0x11262b44cc28a1decc09e16893523eae708e7a66b14d0f16a88cdbc3b5af39ab_0 | 0x45b22578dfb6c102d078cb644d839757f59ae4ec7b91670285e32d4cd2d23b6d | 2 | 0x11262b44cc28a1decc09e16893523eae708e7a66b14d0f16a88cdbc3b5af39ab | 3 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000000558000c5fc50000000000000003000000006673cfe000000000005dc7210000000000000000000000000000000000000000000000000000000000008f3e00000000000000000000000000000000000000000000000000000000000000019a08104a5d4c00b466a42d7094ad8771d1fcae172ee61aaf6d483f934df340200000000000000000000000003c06b2ed915058191d0b813b1d807bd7da743209 | null | null | 126 | 1718865894 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0xfd0ba344597fc946b3cb333b1b3cdd6010737c5bcca58d5d0dec91ca894a32f7_0 | 0x71e607c3410840a6b131d18a5e996bf70227a0991b6b3305485b57d67d486d96 | 32 | 0xfd0ba344597fc946b3cb333b1b3cdd6010737c5bcca58d5d0dec91ca894a32f7 | 33 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000000558000c5fc50000000000000003000000006673d01c00000000005dc726000000000000000000000000000000000000000000000000000000000000bab100000000000000000000000000000000000000000000000000000000000000012284ede1b3cc9d65f23f1aa42552b370a39ca854964a342f8c5eedb7a7ff943d0000000000000000000000003c06b2ed915058191d0b813b1d807bd7da743209 | null | null | 126 | 1718865954 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x9a36c46a6f4862563adc43e668edbbd67de028f43c436d8faaf0461eec55f009_0 | 0x34f0650ec09e4ebfa72d732149c5a1839b4e2a2bc83aa9206ef28cd1b5b2eaa4 | 42 | 0x9a36c46a6f4862563adc43e668edbbd67de028f43c436d8faaf0461eec55f009 | 43 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000000558000c5fc50000000000000001000000006673d03400000000005dc728000000000000000000000000000000000000000000000000000000000000b36400000000000000000000000000000000000000000000000000000000000000014f2f99d30ff4e26ede4c25342bd03726b1aae4bbc8cae5d027847c7db6b2095f0000000000000000000000003c06b2ed915058191d0b813b1d807bd7da743209 | null | null | 126 | 1718865974 | 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 |