Enriched Transactions
Chain
AbstractDataset name
abstract.receipt_transactionsVersion
1.1.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_0xba67fef0adc166979cfbfef1d23f6ffe2f0f44e9f3c9f40ce94d7875b90e34fb_0 | 0x9aef63bb4ab64a2a3d7a203b418f8780ebf976f478e657369ef59d4fef9b2a18 | 8 | 0xba67fef0adc166979cfbfef1d23f6ffe2f0f44e9f3c9f40ce94d7875b90e34fb | 17 | 0 | 0xe85b66fca403bc35bcae17ce7758e942aea65dc0 | 0xe85b66fca403bc35bcae17ce7758e942aea65dc0 | 0 | 0 | 0 | 0x | 0 | 0 | 0 | 1730311732 | 0 | null | 1 | 0 | 0xba67fef0adc166979cfbfef1d23f6ffe2f0f44e9f3c9f40ce94d7875b90e34fb | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0x4506e5aba95776bde67dec11473fa01862948782dcc06dc8f1e30efe1b790beb_0 | 0xe4aeff258926ad6e366fc26e87db9c2879e10ea86d377f061f79d58ec832de10 | 11 | 0x4506e5aba95776bde67dec11473fa01862948782dcc06dc8f1e30efe1b790beb | 20 | 0 | 0xe85b66fca403bc35bcae17ce7758e942aea65dc0 | 0xe85b66fca403bc35bcae17ce7758e942aea65dc0 | 0 | 0 | 0 | 0x | 0 | 0 | 0 | 1730312634 | 0 | null | 1 | 0 | 0x4506e5aba95776bde67dec11473fa01862948782dcc06dc8f1e30efe1b790beb | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0x0c18bd36eae77c55077b2719664277eb76e3b8e7a3a9f8582f306adb0d8a23e2_0 | 0xbb8920f440f84787ac1e3e3d8a64834f18c48cff68ca00f731318fb411365669 | 18 | 0x0c18bd36eae77c55077b2719664277eb76e3b8e7a3a9f8582f306adb0d8a23e2 | 27 | 0 | 0xe85b66fca403bc35bcae17ce7758e942aea65dc0 | 0xe85b66fca403bc35bcae17ce7758e942aea65dc0 | 0 | 0 | 0 | 0x | 0 | 0 | 0 | 1730314737 | 0 | null | 1 | 0 | 0x0c18bd36eae77c55077b2719664277eb76e3b8e7a3a9f8582f306adb0d8a23e2 | 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_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 |