Enriched Transactions
Chain
Proof of Play CloudDataset name
pop_cloud.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_0xbf0390edd63bed210a2e81c16794823ebb0b7da83315ae2f9fe46cfb07b456a1_1 | 0xffb836044a6901c7877f3ae92bd93b187782aff650d96608577f4927bf8de02c | 0 | 0xbf0390edd63bed210a2e81c16794823ebb0b7da83315ae2f9fe46cfb07b456a1 | 4 | 1 | 0xf0476f0d77dfc7de4cb3a4dad592a87dac643ad8 | 0x0000000000000000000000000000000000000070 | 0x2b352fae0000000000000000000000000000000000000000000000000000000000000000 | 2 | 1718701165 | null | 1 | null | null | null | null | null | null | null | null | 6132588 | null | null | null | null | |||||||||
| enriched_transaction_v2_0xec44525d6f80a55fc617c5c7227219f2a7fe88038b8166aecb91832d33d06d04_1 | 0xb0a647f6a4fba274900cc3310ff99c9affaab16e8c035410aa30f5f80de06bfd | 1 | 0xec44525d6f80a55fc617c5c7227219f2a7fe88038b8166aecb91832d33d06d04 | 5 | 1 | 0xf0476f0d77dfc7de4cb3a4dad592a87dac643ad8 | 0x0000000000000000000000000000000000000070 | 0xa0188cdb0000000000000000000000000000000000000000000000000000000000989680 | 2 | 1718701165 | null | 1 | null | null | null | null | null | null | null | null | 6132588 | null | null | null | null | |||||||||
| enriched_transaction_v2_0x456e0fab1ae23d0cfb3cc2692ababbf63e4d6aabe23f3bdb05afc33fcce7eef9_1 | 0x73878b1d1e5e9c77f2fc0207cf20fdba710e7ae6d44428b0701b15602c388f5c | 0 | 0x456e0fab1ae23d0cfb3cc2692ababbf63e4d6aabe23f3bdb05afc33fcce7eef9 | 12 | 1 | 0x761551fc0cbaf95061e45dec45cbafd8ab169686 | 0x000000000000000000000000000000000000006e | 0xc9f95d3200000000000000000000000000000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000005f5e100000000000000000000000000000000000000000000000000016352ad10fb3000000000000000000000000000000000000000000000000000016345785d8a00000000000000000000000000000000000000000000000000000000000000c96a8000000000000000000000000000000000000000000000000000000000000493e00000000000000000000000000000000000000000000000000000099ab10c8000000000000000000000000000650451fc0cbaf95061e45dec45cbafd8ab168575000000000000000000000000650451fc0cbaf95061e45dec45cbafd8ab168575000000000000000000000000650451fc0cbaf95061e45dec45cbafd8ab16857500000000000000000000000000000000000000000000000000000000000001600000000000000000000000000000000000000000000000000000000000000000 | null | 105 | 1719276227 | null | 1 | null | null | null | null | null | null | null | null | 6179972 | 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 |