Enriched Transactions
Chain
ZoraDataset name
zora.receipt_transactionsVersion
1.2.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_0xccb615d77269c7d5c443ff951fe18a628fe50ed5c6936ba65bcaefa5a3b80d2d_5 | 0x8e9ce6c02141a93475299af9cdf4f6d04f8faceafde2764d2da3e86d2ad9b597 | 20 | 0xccb615d77269c7d5c443ff951fe18a628fe50ed5c6936ba65bcaefa5a3b80d2d | 15455943 | 5 | 0xb6f1c140c3413a95edd4629575785d28f6dff799 | 0x92bea47df99061a4bd62c024e2a35741edb82288 | 0 | 141076 | 1000252 | 0xef9dd06900000000000000000000000071b0f07308b68bf0276efa3ccc5955ed3eadf59c00000000000000000000000000000000000000000000000000000000000000240000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000410635c5119aa488be35597d3bb086b97e2ae260694ce80dfacdefa87a2f838a3717d8f79761c85c61bb529adea0ceb8f277b988cd8f5381f7f2de42d89ada5bcf1b00000000000000000000000000000000000000000000000000000000000000 | null | null | 0 | 1717605725 | 555549 | 111947 | null | 1 | 1000252 | null | 1552906562349 | 3852 | 20157146442 | null | null | null | null | null | null | null | null | null | null |
| enriched_transaction_v2_0x42eb2e5ddedb798f685a1104749389ed72d04e22de30b6830cf3f552d741879a_2 | 0xccc5eb190491e4839c93368606c3369ee49e4f36df6dde7e20502fe0d3f27aba | 156316 | 0x42eb2e5ddedb798f685a1104749389ed72d04e22de30b6830cf3f552d741879a | 15455944 | 2 | 0xc523cdb7a367147479e7f4188b1b544f1ffff1cf | 0x915704306eec00e1963b26013007f6d20655de83 | 0 | 25000000 | 254 | 0x00 | 100000000 | 2 | 2 | 1717605727 | 3352804 | 3172193 | null | 1 | 254 | null | 714369270115 | 1772 | 20157146442 | 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 |