Enriched Transactions
Chain
WorldchainDataset name
worldchain.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_0xa08d8ea9efa0d2d72cd0c35e98b1eac33be3668204b1cf3231aae698a7ae423e_0 | 0x96e5009328f61769f77a52aa4bcd00bbecf09c088d1cd3e7cfb97625febd9676 | 3 | 0xa08d8ea9efa0d2d72cd0c35e98b1eac33be3668204b1cf3231aae698a7ae423e | 3 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0x440a5e20000a6fe000000000000000000000000300000000667afad7000000000133c586000000000000000000000000000000000000000000000000000000023bd762df0000000000000000000000000000000000000000000000000000000000000002793daed4743301e00143be5533cd1dce0a741519e9e9c96588a9ad7dbb4d8db4000000000000000000000000dbbe3d8c2d2b22a2611c5a94a9a12c2fcd49eb29 | null | null | 126 | 1719335645 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | ||||||
| enriched_transaction_v2_0xac6a1ea5e3bdb6c3a6cc3129799af2420f4aecf9b8f3c7184470ade33bacb309_0 | 0x845caf1b31eb376b547f960e510b86de54264d6b5be21bea537b77765febe463 | 6 | 0xac6a1ea5e3bdb6c3a6cc3129799af2420f4aecf9b8f3c7184470ade33bacb309 | 6 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000a6fe000000000000000000000000000000000667afae3000000000133c58700000000000000000000000000000000000000000000000000000002453d5dd0000000000000000000000000000000000000000000000000000000000000000129d231f7f333b1db7cf7c8845f359276193784d4f1675a3eb67bc532f82df4d4000000000000000000000000dbbe3d8c2d2b22a2611c5a94a9a12c2fcd49eb29 | null | null | 126 | 1719335651 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0xcbaaf02789acda5e8227c735b7fe47651a9e5e0138f79a450958c8f5c137b9c7_0 | 0x4e6e9f07b273f29f98690f42f8abcde002b925082722031d86c94c83d545b12b | 13 | 0xcbaaf02789acda5e8227c735b7fe47651a9e5e0138f79a450958c8f5c137b9c7 | 13 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000a6fe000000000000000000000000100000000667afaef000000000133c588000000000000000000000000000000000000000000000000000000022c890925000000000000000000000000000000000000000000000000000000000000000181db29135717f7617f30a056be4a19fdd93d9076a849116f106b61c5c30a3319000000000000000000000000dbbe3d8c2d2b22a2611c5a94a9a12c2fcd49eb29 | null | null | 126 | 1719335665 | null | 1 | 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_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 |