Enriched Transactions
Chain
Lyra TestnetDataset name
lyra_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_0xe78643cb500501c37299ff3b95e601f75feff556924504b9ca5245fa58fce945_0 | 0x911a54acef9a1608c65c34be649fcc877336263367868356b519f6eaa3943271 | 148 | 0xe78643cb500501c37299ff3b95e601f75feff556924504b9ca5245fa58fce945 | 149 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x015d8eb900000000000000000000000000000000000000000000000000000000003d5a9a0000000000000000000000000000000000000000000000000000000064cc3494000000000000000000000000000000000000000000000000000000000b0a6de95df65d228c5e514b9d97eb6f1069c054ffc038e69fb1c96b82927c683b260eb20000000000000000000000000000000000000000000000000000000000000002000000000000000000000000d1a823bf5c7db22a2da0cb9cef9330930805a47200000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0 | null | null | 126 | 1691104462 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x50ec1bc26d239aeec77d107c60c212725b63761ce59c01b599cdfe05f1686c71_0 | 0xec3701b5276fe7f93b038e7c290db2b148ebf4684cf3670f75dfe131af8a99a1 | 209 | 0x50ec1bc26d239aeec77d107c60c212725b63761ce59c01b599cdfe05f1686c71 | 210 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x015d8eb900000000000000000000000000000000000000000000000000000000003d5aa30000000000000000000000000000000000000000000000000000000064cc3500000000000000000000000000000000000000000000000000000000000c11edac4566a309fb39c21ecf8b42310499cd25caf1231836268fb2d916bbc9a307e20c0000000000000000000000000000000000000000000000000000000000000003000000000000000000000000d1a823bf5c7db22a2da0cb9cef9330930805a47200000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0 | null | null | 126 | 1691104584 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x61b5436adc86e5b9e7e56b713b48d35c3cdafa4f181643c450e8c56cfbc49137_0 | 0x707153c29b39ef386b14c647217546f87726b6a1f53a5481795591225e42568d | 11 | 0x61b5436adc86e5b9e7e56b713b48d35c3cdafa4f181643c450e8c56cfbc49137 | 12 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x015d8eb900000000000000000000000000000000000000000000000000000000003d5a8a0000000000000000000000000000000000000000000000000000000064cc33bc000000000000000000000000000000000000000000000000000000000c7279a73339c68aaf12dac7ac24ff010023c3bff148ec3c4f3b5a90d69962cae49831590000000000000000000000000000000000000000000000000000000000000000000000000000000000000000d1a823bf5c7db22a2da0cb9cef9330930805a47200000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0 | null | null | 126 | 1691104188 | 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 |