Enriched Transactions
Chain
Proof of Play BossDataset name
pop_boss.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_0x7451c79e92555fe65e5005caf66504c90da52391273ad2c777c7509dcae7fa86_0 | 0x74823a118640b0cceb6f5f5cf660770c6ba4e31a3a2d5ad8e5105bd0881c8f3e | 0 | 0x7451c79e92555fe65e5005caf66504c90da52391273ad2c777c7509dcae7fa86 | 24 | 0 | 0x00000000000000000000000000000000000a4b05 | 0x00000000000000000000000000000000000a4b05 | 0x6bf6a42d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000136d8ee00000000000000000000000000000000000000000000000000000000000000180000000000000000000000000000000000000000000000000000000000000030 | null | null | 106 | 1721767377 | null | 1 | null | null | null | null | null | null | null | null | 20371694 | null | null | null | null | |||||||
| enriched_transaction_v2_0xa125208adada43d22f709d4d59e59bff2d323dc14ebb90396bdc14a39c10f0f5_0 | 0x1f99b9aae4fbc2547c222377b48270697c200717b92b9a2fbec234be25397cc6 | 0 | 0xa125208adada43d22f709d4d59e59bff2d323dc14ebb90396bdc14a39c10f0f5 | 43 | 0 | 0x00000000000000000000000000000000000a4b05 | 0x00000000000000000000000000000000000a4b05 | 0x6bf6a42d0000000000000000000000000000000000000000000000000000000000989680000000000000000000000000000000000000000000000000000000000136e5db000000000000000000000000000000000000000000000000000000000000002b0000000000000000000000000000000000000000000000000000000000008782 | null | null | 106 | 1721807288 | null | 1 | null | null | null | null | null | null | null | null | 20375003 | null | null | null | null | |||||||
| enriched_transaction_v2_0x0e657ab26ece478fe01482e9b72578e9aa1316d5a8f5037378ef556852c5ef7d_0 | 0x4e1a0273dade5cacd008ba1025395817235aa335e4646993ec6964d4bd513be7 | 0 | 0x0e657ab26ece478fe01482e9b72578e9aa1316d5a8f5037378ef556852c5ef7d | 47 | 0 | 0x00000000000000000000000000000000000a4b05 | 0x00000000000000000000000000000000000a4b05 | 0x6bf6a42d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000136f3be000000000000000000000000000000000000000000000000000000000000002f000000000000000000000000000000000000000000000000000000000000004b | null | null | 106 | 1721850171 | null | 1 | null | null | null | null | null | null | null | null | 20378558 | 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 |