Enriched Transactions
Chain
MegaETHDataset name
megaeth_mainnet.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_0x32c60dce67256cb9695888bf1706a95455451d3d5ab3bb13c47f301019f6deae_0 | 0x7b578f90813e9c5f8e058624468964baba9a55b32db32979d3f3c9b8b421ce2f | 3 | 0x32c60dce67256cb9695888bf1706a95455451d3d5ab3bb13c47f301019f6deae | 4 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | õá | 0x098999be00000558000c5fc5000000000000000400000000691225d300000000016ab55a0000000000000000000000000000000000000000000000000000000022ba611d0000000000000000000000000000000000000000000000000000000000000007f4f264684772ae0ceaa504953a3984d84a1b797de953c9ee49342a4f51ca53a6000000000000000000000000b98c6b1a805b96707a43e1f1acfa163b68098fa6000000000000000000000000 | null | null | 126 | 1762797015 | null | 1 | null | ç | "ºa | null | 810949 | null | null | null | 1368 | null | null | null | |||||||
| enriched_transaction_v2_0xa19afa00344d71302afe5c8867bb5bc28e67fda2b217501a49872cd106beb6af_0 | 0x26f27afba81da418a1c6dfb5fe1b6272e9dfd4bc0a3e343e3ef921b3fe0f8e23 | 16 | 0xa19afa00344d71302afe5c8867bb5bc28e67fda2b217501a49872cd106beb6af | 17 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | õá | 0x098999be00000558000c5fc5000000000000000500000000691225df00000000016ab55b0000000000000000000000000000000000000000000000000000000022643d170000000000000000000000000000000000000000000000000000000000000008bce47ebcb51cf0da0342584a0611c4c42125b19472ef7096b77c65d5389322f1000000000000000000000000b98c6b1a805b96707a43e1f1acfa163b68098fa6000000000000000000000000 | null | null | 126 | 1762797028 | null | 1 | null | ç | "d= | null | 810949 | null | null | null | 1368 | null | null | null | |||||||
| enriched_transaction_v2_0x2f31961daa41e4ce0233cad373195cebfe76fdc283d5e00e7437c1f132bfc598_0 | 0x57a51e2e314cf58de4b5442523379edbad387ef380a9eed647e4c0c49ccecf29 | 20 | 0x2f31961daa41e4ce0233cad373195cebfe76fdc283d5e00e7437c1f132bfc598 | 21 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | õá | 0x098999be00000558000c5fc5000000000000000900000000691225df00000000016ab55b0000000000000000000000000000000000000000000000000000000022643d170000000000000000000000000000000000000000000000000000000000000008bce47ebcb51cf0da0342584a0611c4c42125b19472ef7096b77c65d5389322f1000000000000000000000000b98c6b1a805b96707a43e1f1acfa163b68098fa6000000000000000000000000 | null | null | 126 | 1762797032 | null | 1 | null | 0 | 1 | null | 1 | 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 |