Enriched Transactions
Chain
Mezo TestnetDataset name
mezo_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_0x54e6757cae71528ef8eea16368d90d708ae84177075162ce93b45bb6efcd987c_0 | 0x68f73a2911e442b3acefe69c23f1f539a7c6e2f348382d118f50b14567909004 | 2 | 0x54e6757cae71528ef8eea16368d90d708ae84177075162ce93b45bb6efcd987c | 28607 | 0 | 0x0504d82efb7db7a8c05e8df8cea575d8c9f48bb2 | 0x7b7c000000000000000000000000000000000000 | cÐ | 0 | 0xa9059cbb000000000000000000000000b8ad2c6414fd3daac4308974f29999d199096c5a0000000000000000000000000000000000000000000000000de0b6b3a7640000 | 0 | 0 | 2 | 1730386094 | cÐ | cÐ | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0xc91fa77dfab5c629de7073350b3d90651a72a4f011d0b7294afb5d0cf8d90696_0 | 0x15d3e679f32a0dadee26266d6c650beb3a047ea812a457a025f4c9971a65bee4 | 0 | 0xc91fa77dfab5c629de7073350b3d90651a72a4f011d0b7294afb5d0cf8d90696 | 110907 | 0 | 0x3575ae68f99cb74c974f404cee5697d19f583466 | 0x7b7c000000000000000000000000000000000011 | 0 | 0x6a050f5ffc9119c454327c72cba275a6fff7d697213bfcdcb6483cebc490d7ed4942e881000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000001200000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000000b6a75737474657374696e670000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | 0 | 0 | 2 | 1730725939 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | ||||
| enriched_transaction_v2_0xdb1cb0e42cdb71650962d3703b98fe9f7ca36ccbcbbce06881464fe28b228e19_0 | 0x1bdded064c1c3a1a7e9658b7da833991a54d20efd8d377587ce0555e630c0155 | 8 | 0xdb1cb0e42cdb71650962d3703b98fe9f7ca36ccbcbbce06881464fe28b228e19 | 143353 | 0 | 0x0504d82efb7db7a8c05e8df8cea575d8c9f48bb2 | 0x7b7c000000000000000000000000000000000000 | cÐ | 0 | 0xa9059cbb0000000000000000000000009e0f855d302c633cf78f721a5c0a419d38ee949a0000000000000000000000000000000000000000000000000de0b6b3a7640000 | 0 | 0 | 2 | 1730900994 | cÐ | cÐ | null | 1 | 0 | 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 |