Enriched Transactions
Chain
Lyra MainnetDataset name
lyra_mainnet.transaction_receiptsVersion
1.3.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_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_0x898544a62b75523f96b72a01a07b9a64d78462005ed2a119d535f4b3f129da81_0 | 0xb8168d741d874d626a2708fa7bd012ce943c968e9614d8f618ad5847f639bd6a | 2211345 | 0x898544a62b75523f96b72a01a07b9a64d78462005ed2a119d535f4b3f129da81 | 2211346 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 10000 | 0x015d8eb90000000000000000000000000000000000000000000000000000000001210043000000000000000000000000000000000000000000000000000000006597c14f00000000000000000000000000000000000000000000000000000002d0c7070df75f4ebafe178ab249b8eecff8bcb9a201586e533e77508ebae0d68207fed28f000000000000000000000000000000000000000000000000000000000000000200000000000000000000000014e4e97bdc195d399ad8e7fc14451c279fe04c8e00000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0 | null | null | 126 | 1704444307 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x761e96a382d22f364692f417c0c10151d3d2b8db3b16696bd6ee6e9444b6bf4f_0 | 0x9691438e8699ea2da1ba1fd916f7e61678b1fef13c915ccd3b90b9214a94d150 | 2211346 | 0x761e96a382d22f364692f417c0c10151d3d2b8db3b16696bd6ee6e9444b6bf4f | 2211347 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 10000 | 0x015d8eb90000000000000000000000000000000000000000000000000000000001210043000000000000000000000000000000000000000000000000000000006597c14f00000000000000000000000000000000000000000000000000000002d0c7070df75f4ebafe178ab249b8eecff8bcb9a201586e533e77508ebae0d68207fed28f000000000000000000000000000000000000000000000000000000000000000300000000000000000000000014e4e97bdc195d399ad8e7fc14451c279fe04c8e00000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0 | null | null | 126 | 1704444309 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0xc24081a8c41ac3b0533ec0e26f4471f1014fa7d77362e61d53c476283ac37034_0 | 0x5c6cb8d4db97e695d3d50de027fa284fda5d94af5c0016900993436b21ebef14 | 2211352 | 0xc24081a8c41ac3b0533ec0e26f4471f1014fa7d77362e61d53c476283ac37034 | 2211353 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 10000 | 0x015d8eb90000000000000000000000000000000000000000000000000000000001210044000000000000000000000000000000000000000000000000000000006597c15b00000000000000000000000000000000000000000000000000000002b5b3e5723e437d69e3c20b578159bf99adf7a46ee7e069753d32ada6e9c39dc3836e2bb2000000000000000000000000000000000000000000000000000000000000000300000000000000000000000014e4e97bdc195d399ad8e7fc14451c279fe04c8e00000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0 | null | null | 126 | 1704444321 | 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 |