Enriched Transactions
Chain
zkSyncDataset name
zksync.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 | 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_0x2092bc76fca8d88f719dccedcb449577b185fa3c6e54ae52ae892147e2a7749b_2 | 0xbf850a0f88a00904a11f45b916e474d0782e0f0525973457af6143ffcb9245cc | 7 | 0x2092bc76fca8d88f719dccedcb449577b185fa3c6e54ae52ae892147e2a7749b | 11319095 | 2 | 0x5a2d4aec97718fd89d3b96e486227d54291b5a3c | 0x2da10a1e27bf85cedd8ffb1abbe97e53391c0295 | 10000000000000 | 3074962 | 250000000 | 0x2cc4081e00000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000050457b5b37c9980000000000000000000000000000000000000000000000000000000064dbe7820000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000600000000000000000000000003355df6d4c9c3035724fd0e3914de96a5a83aaf400000000000000000000000000000000000000000000000000000000029cf4f50000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002000000000000000000000000080115c708e12edd42e504c1cd52aea96c547c05c00000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000600000000000000000000000003355df6d4c9c3035724fd0e3914de96a5a83aaf40000000000000000000000005a2d4aec97718fd89d3b96e486227d54291b5a3c00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000 | 250000000 | 250000000 | 0 | 1692122451 | 0 | 833782 | null | 1 | 250000000 | null | 0x2092bc76fca8d88f719dccedcb449577b185fa3c6e54ae52ae892147e2a7749b | null | null | null | null | null | null | null | null | null | null | null | null | null |
| enriched_transaction_v2_0x6fbba9cda871f4daa1da991c6bfd77fc6c0d6873cc0eee9a91c271eddde67228_0 | 0x5350c0e4fdb1561a7a4faebd0179b52f15c4b1efd35f3433997afaa76622b1eb | 41 | 0x6fbba9cda871f4daa1da991c6bfd77fc6c0d6873cc0eee9a91c271eddde67228 | 11319113 | 0 | 0x8da44d3977685bdf8cac156198681406b6d93c59 | 0x9606ec131eec0f84c95d82c9a63959f2331cf2ac | 29940000000000000 | 2979984 | 250000000 | 0xac9650d800000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001a0000000000000000000000000000000000000000000000000000000000000012475ceafe6000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000008da44d3977685bdf8cac156198681406b6d93c59000000000000000000000000000000000000000000000000006a5e457893400000000000000000000000000000000000000000000000000000000000033846d80000000000000000000000000000000000000000000000000000000064dbc468000000000000000000000000000000000000000000000000000000000000002b5aea5775959fbc2557cc8789bc1bf90a239d9a910007d03355df6d4c9c3035724fd0e3914de96a5a83aaf400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000412210e8a00000000000000000000000000000000000000000000000000000000 | 279500000 | 279500000 | 0 | 1692122469 | 0 | 834958 | null | 1 | 250000000 | null | 0x6fbba9cda871f4daa1da991c6bfd77fc6c0d6873cc0eee9a91c271eddde67228 | 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 | long |
| 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 |