Enriched Transactions
Chain
ShrapnelDataset name
shrapnel.transaction_receiptsVersion
1.0.0Description
Enriched transaction data including input, value, from and to address, and metadata for the block, gas and receipt.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| enriched_transaction_0x7e116ed3f38b9765da62299d5e7a5110b9e74abd5badc63187464bbf044b5921_0 | 0x516146af18ac5b92661e2f68f099ebbc26ad580dc599e94d90e7d14442290833 | 3 | 0x7e116ed3f38b9765da62299d5e7a5110b9e74abd5badc63187464bbf044b5921 | 1200291 | 0 | 0x05fa2678d124f997e3abba46e5099353ba85e8f3 | 0x9a970b8d84f299ce1dded3d06e2426243d79e33f | 0 | 0 | 0 | 0xa9059cbb00000000000000000000000039f9c7a652e691acb721f7c31006ccdec2d6b09a0000000000000000000000000000000000000000000000004fa8939692be0000 | null | null | 0 | 1712572531 | 0 | 0 | null | 1 | 0 | null | null | null | null | null | null |
| enriched_transaction_0xf41cb92959cdeb93ddb686280bfb95a15ff36f946422b1c03bd93268ef720897_0 | 0x130e3fede07ab6bfacd847f89acfb8004d03bd0a9cf2a48672d585ee2f38727a | 123424 | 0xf41cb92959cdeb93ddb686280bfb95a15ff36f946422b1c03bd93268ef720897 | 1200294 | 0 | 0x339d413ccefd986b1b3647a9cfa9cbbe70a30749 | 0x76111de813f83aaadbd62773bf41247634e2319a | 0 | 0 | 0 | 0x3161b7f6000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000101000000000000000000000000000000000000000000012dd4acb1fd8bd1b26430000000000000000000000000000000000000000000000000000000000839b6800000000000000000000000000000000000000000000000000000000000000010 | null | null | 0 | 1712572808 | 0 | 0 | null | 1 | 0 | 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 |