Enriched Transactions
Chain
Proof of Play ApexDataset name
apex.transaction_receiptsVersion
1.1.0Description
Enriched transaction data including input, value, from and to address, and metadata for the block, gas and receipt.
Example data
| block_hash | block_number | block_timestamp | from_address | gas | gas_price | hash | id | input | max_fee_per_gas | max_priority_fee_per_gas | nonce | receipt_contract_address | receipt_cumulative_gas_used | receipt_effective_gas_price | receipt_gas_used | receipt_l1_fee | receipt_l1_fee_scalar | receipt_l1_gas_price | receipt_l1_gas_used | receipt_root | receipt_root_hash | receipt_status | to_address | transaction_index | transaction_type | value |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0xca27251ded03376accce60f61926aa459c2a7e5b76c1e1b7c0d61ce8bd8aec73 | 562852 | 1701293287 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 1000000 | 0 | 0xef2fa7092d0cf892d568c0c9ac044a1b92ea199e74f8b3060f90a75d0d95c9fe | enriched_transaction_0xca27251ded03376accce60f61926aa459c2a7e5b76c1e1b7c0d61ce8bd8aec73_0 | 0x015d8eb900000000000000000000000000000000000000000000000000000000011d0887000000000000000000000000000000000000000000000000000000006567aca300000000000000000000000000000000000000000000000000000009551cf082448c4c58fb9c5de7cf8f5a2779cec8ff21c51d853c103284dad9395a86fc0e84000000000000000000000000000000000000000000000000000000000000000200000000000000000000000099199a22125034c808ff20f377d91187e8050f2e00000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0 | 562851 | 46913 | 0 | 46913 | 1 | 0x4200000000000000000000000000000000000015 | 0 | 126 | 0 | |||||||||
| 0x54cc9f474adabdb72d2d379e8b05e809109d29fea48dc3b06f5ab1f99a677011 | 562839 | 1701293261 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 1000000 | 0 | 0x95f1ca1172da0c57924ec0a4e76eb8df104bb0feceef16ac7b4da607a9f7f3d3 | enriched_transaction_0x54cc9f474adabdb72d2d379e8b05e809109d29fea48dc3b06f5ab1f99a677011_0 | 0x015d8eb900000000000000000000000000000000000000000000000000000000011d0885000000000000000000000000000000000000000000000000000000006567ac8b000000000000000000000000000000000000000000000000000000096ac873b9e3cfea4cdd80b9207a42b0bba8dc7d581e0b1f44aa77d66136691821a5d01c1d000000000000000000000000000000000000000000000000000000000000000100000000000000000000000099199a22125034c808ff20f377d91187e8050f2e00000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0 | 562838 | 64013 | 0 | 64013 | 1 | 0x4200000000000000000000000000000000000015 | 0 | 126 | 0 | |||||||||
| 0x503e231ac665a77e85a8865387e39ddfd4eade149dcd9f24c9e51107ba273a8b | 562807 | 1701293197 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 1000000 | 0 | 0x7382985f3a52c85abac75d52f7a3a5590ba5656ea019773a2f830be14e7cc08d | enriched_transaction_0x503e231ac665a77e85a8865387e39ddfd4eade149dcd9f24c9e51107ba273a8b_0 | 0x015d8eb900000000000000000000000000000000000000000000000000000000011d087f000000000000000000000000000000000000000000000000000000006567ac43000000000000000000000000000000000000000000000000000000090f92707716a29d27c9d4d241029669464a6fbcc5ad5a50248987807db81ecf00fe7cce03000000000000000000000000000000000000000000000000000000000000000500000000000000000000000099199a22125034c808ff20f377d91187e8050f2e00000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0 | 562806 | 46901 | 0 | 46901 | 1 | 0x4200000000000000000000000000000000000015 | 0 | 126 | 0 |
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 |