Enriched Transactions
Chain
OptimismDataset name
optimism.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_0x92e56372d57142bb21006c1eb344945593dcc3dc581e094fa63e1428136b80b8_9 | 0x856f360210cde4cdc5235d587c6d63a2db64b5bd1402018bee6968a9c2f078e3 | 120 | 0x92e56372d57142bb21006c1eb344945593dcc3dc581e094fa63e1428136b80b8 | 120975112 | 9 | 0xccc44edeae2ef30cf7de80b0b43dfdf286f2178d | 0x111111125421ca6dc452d289314280a0f8842a65 | 0 | 454691 | 61703600 | 0x07ed2379000000000000000000000000b63aae6c353636d66df13b89ba4425cfe13d10ba0000000000000000000000004200000000000000000000000000000000000042000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000b63aae6c353636d66df13b89ba4425cfe13d10ba000000000000000000000000ccc44edeae2ef30cf7de80b0b43dfdf286f2178d000000000000000000000000000000000000000000000000016345785d8a000000000000000000000000000000000000000000000000000000003b295835c4730000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012000000000000000000000000000000000000000000000000000000000000001da0000000000000000000000000000000000000001bc0001a200018c0001505126a132dab612db5cb9fc9ac426a0cc215a3423f9c942000000000000000000000000000000000000420004f41766d8000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003aa0e668059000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000b63aae6c353636d66df13b89ba4425cfe13d10ba0000000000000000000000000000000000000000000000000000000066664f2c00000000000000000000000000000000000000000000000000000000000000010000000000000000000000004200000000000000000000000000000000000042000000000000000000000000420000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000004101420000000000000000000000000000000000000600042e1a7d4d0000000000000000000000000000000000000000000000000000000000000000c061111111125421ca6dc452d289314280a0f8842a6500206b4be0b9111111125421ca6dc452d289314280a0f8842a650000000000002a6f45f2 | null | null | 0 | 1717549001 | 1792089 | 318144 | null | 1 | 61703600 | null | 64172973056 | 7732 | 6067003070 | null | null | null | null | null | null | null | null | null | null |
| enriched_transaction_v2_0x525c168fd73c640b08fb9295d86942c773b15f9dd5e9be2168cd9f3e6c016832_1 | 0x3415b93c6f6d3f221a88a73be956c349c02469d6c69d3736c0bcf9bcf7dacbc3 | 113222 | 0x525c168fd73c640b08fb9295d86942c773b15f9dd5e9be2168cd9f3e6c016832 | 120975113 | 1 | 0x3f343211f0487eb43af2e0e773ba012015e6651a | 0x1111111254eeb25477b68fb85ed929f73a960582 | 0 | 248026 | 104962618 | 0x12aa3caf000000000000000000000000b63aae6c353636d66df13b89ba4425cfe13d10ba00000000000000000000000042000000000000000000000000000000000000060000000000000000000000000b2c639c533813f4aa9d7837caf62653d097ff85000000000000000000000000b63aae6c353636d66df13b89ba4425cfe13d10ba0000000000000000000000003f343211f0487eb43af2e0e773ba012015e6651a000000000000000000000000000000000000000000000000074358111a590700000000000000000000000000000000000000000000000000000000007737233200000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008100000000000000000000000000000000000000000000000000000000006302a000000000000000000000000000000000000000000000000000000000760a3618ee63c1e5803241738149b24c9164da14fa2040159ffc6dd23742000000000000000000000000000000000000061111111254eeb25477b68fb85ed929f73a96058200000000000000000000000000000000000000000000000000000000000000 | null | null | 0 | 1717549003 | 223087 | 179248 | null | 1 | 104962618 | null | 49133988682 | 5920 | 6067003070 | 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 |