Enriched Transactions
Chain
Optimism SepoliaDataset name
optimism_sepolia.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_root | receipt_root_hash | receipt_l1_fee | receipt_l1_gas_used | receipt_l1_gas_price | receipt_l1_fee_scalar |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| enriched_transaction_0x8f0f0a0e55ae5944d633061f73ccbf4ee53c99de76ca6f8c47372492d3efdfbb_0 | 0x55fdcd0b2c1bc627e3f511d8cc4eb43eaf767d2e8fb31a8add0546d917f4cb97 | 14 | 0x8f0f0a0e55ae5944d633061f73ccbf4ee53c99de76ca6f8c47372492d3efdfbb | 15 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 1000000 | 0 | 0x015d8eb900000000000000000000000000000000000000000000000000000000003e1ff20000000000000000000000000000000000000000000000000000000064d6dbc4000000000000000000000000000000000000000000000000000000000b85b83d7cbe0204bc063a04b7d962bc0b91178254734e3f2028aafa2caa1ba7a80d170400000000000000000000000000000000000000000000000000000000000000030000000000000000000000008f23bb38f531600e5d8fddaaec41f13fab46e98c00000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0 | null | null | 126 | 1691802570 | 46889 | 46889 | null | 1 | 0 | null | null | null | null | null | null |
| enriched_transaction_0xf6317b1dca647ad7832393f7ed9c50225b9b6bcad62be15f188382689da00b01_0 | 0xdc523a3634f632a0f106859f18a3e85ab0c3de6282989fd800cfe270f4dbf8fd | 33 | 0xf6317b1dca647ad7832393f7ed9c50225b9b6bcad62be15f188382689da00b01 | 34 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 1000000 | 0 | 0x015d8eb900000000000000000000000000000000000000000000000000000000003e1ff50000000000000000000000000000000000000000000000000000000064d6dbe8000000000000000000000000000000000000000000000000000000000bb81bdb0f917ca7fe6c49f292078a34bbc9f38aea30de6717c427f1f7e0affe1e60928500000000000000000000000000000000000000000000000000000000000000040000000000000000000000008f23bb38f531600e5d8fddaaec41f13fab46e98c00000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0 | null | null | 126 | 1691802608 | 46889 | 46889 | null | 1 | 0 | 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 | long |
| receipt_root_hash | string |
| receipt_l1_fee | decimal |
| receipt_l1_gas_used | decimal |
| receipt_l1_gas_price | decimal |
| receipt_l1_fee_scalar | double |