Enriched Transactions
Chain
XplaDataset name
xpla.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_0x486d3360edc4122b8a4c73cf91608f11096e5e06c326d5314f3423997acdd880_0 | 0xd3c9dce3d31c72b29b709e961fa10340b9062cbc301dc111b3ee16f4df59e494 | 3 | 0x486d3360edc4122b8a4c73cf91608f11096e5e06c326d5314f3423997acdd880 | 2588214 | 0 | 0x28cbd1ffbae887ec904c69a458d5e59d4fc16338 | 0x399f21d7aacd3c1a3de5be67e3ea59a79e22cc18 | 0 | 0 | 0 | 0x2f2ff15d9f2df0fed2c77648de5860a4cc508cd0818c85b8b8a1ab4ceeef8d981c8956a600000000000000000000000028cbd1ffbae887ec904c69a458d5e59d4fc16338 | null | null | 0 | 1676727816 | 5 | 5 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null |
| enriched_transaction_v2_0xf2dff5b8c1db2abc12aeebb46d9e5bc27e42752557c5a60b3c45f79bf74cc85b_0 | 0xef63929dbb260115d73ef5b861b4eca1afe4b7bf20dd7479cd08cc663baa4f1d | 4 | 0xf2dff5b8c1db2abc12aeebb46d9e5bc27e42752557c5a60b3c45f79bf74cc85b | 2588236 | 0 | 0x28cbd1ffbae887ec904c69a458d5e59d4fc16338 | 0x399f21d7aacd3c1a3de5be67e3ea59a79e22cc18 | 0 | 0 | 0 | 0x40c10f1900000000000000000000000028cbd1ffbae887ec904c69a458d5e59d4fc163380000000000000000000000000000000000000000204fce5e3e25026110000000 | null | null | 0 | 1676727951 | 0 | 0 | null | 1 | null | null | null | 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 |