Enriched Transactions
Chain
Dataset name
megaeth_testnet_v2.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_0x74bd3e4162303d3982cbef8a19e664ef52c51be127c1d13c15f112d1974102d1_2 | 0x88827c65c0c5eb9c3469de5acbb6321879ebb285beb059ec1fe1ae61512c4c8d | 913031 | 0x74bd3e4162303d3982cbef8a19e664ef52c51be127c1d13c15f112d1974102d1 | 2013386 | 2 | 0x20bae013686a00535508c89326fe08853522660b | 0x9f0b0ae7a3b6671129633121149b7059d004eda4 | 5¤é | | 0x9aec351f000000000000000000000000000000000000000000000000000642474bbc98ae00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000009534f4c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000048d1be0ca45544800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005d9ef17470425443000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a4dc7b49b9055534454000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005f6004055534443000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005f58ef55852500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000faf465a424e42000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000019fd62dfdd444f4745000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001282a9141444100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003d711ca | | 2 | 1761723842 | ÖÛ | öÝ | null | 1 | | null | Ñ | null | 810949 | null | null | null | 1368 | null | null | null | |||||
| enriched_transaction_v2_0x74bd3e4162303d3982cbef8a19e664ef52c51be127c1d13c15f112d1974102d1_16 | 0x8987589e4d9ed94415ccd10b656b4810d3a6cab50b06c7e4a89b262be5a11721 | 913038 | 0x74bd3e4162303d3982cbef8a19e664ef52c51be127c1d13c15f112d1974102d1 | 2013386 | 16 | 0x20bae013686a00535508c89326fe08853522660b | 0x9f0b0ae7a3b6671129633121149b7059d004eda4 | 5¤é | | 0x9aec351f000000000000000000000000000000000000000000000000000642474bc747210000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000955534454000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005f6004055534443000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005f58ef5534f4c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000048d13df8a45544800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005d9eeb16205852500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000faf1f49424e42000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000019fd5b3e95444f4745000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001282a9141444100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003d711ca425443000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a4dc7b49b90 | | 2 | 1761723842 | PPô | öÝ | null | 1 | | null | null | 810949 | null | null | null | 1368 | null | null | null | ||||||
| enriched_transaction_v2_0x3f9eeed332d865da6a2d29f1f4464e575b1e2e192fcd72e725bdc03daa343127_0 | 0x393ad8c8d6044c59346957299a6d7ab9a120ade542d7554c333d8f96003ba226 | null | 0x3f9eeed332d865da6a2d29f1f4464e575b1e2e192fcd72e725bdc03daa343127 | 2013387 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x098999be00000558000c5fc5000000000000003f000000006901c2600000000000912cbc000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000001b2ed74130e7ec083e8c871987c5f037dead391d611bcb86812e13f4f05a9d4010000000000000000000000008b3cbae2ceff7930aa69be81b1f8977db1f53cf8000000000000000000000000 | null | null | 126 | 1761723843 | null | 1 | null | ¿ | null | 810949 | null | null | null | 1368 | 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 |