Enriched Transactions
Chain
KatanaDataset name
katana.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_0x52ca531a2e350c254f3bafac02cc77a1cebcae3ad0b9b38bc63346981245383d_0 | 0x2992c52953a5751213cc4b1685687aa21fe2a5c3a1e6eecb23f5e5c82e2dd8fe | 17 | 0x52ca531a2e350c254f3bafac02cc77a1cebcae3ad0b9b38bc63346981245383d | 18 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000000558000c5fc5000000000000000600000000681d2e270000000001566f000000000000000000000000000000000000000000000000000000000187b7271800000000000000000000000000000000000000000000000000000000000000013aac6c19fe303d4799b5d029b41f597e5adf2b3da241b9bbf97117d9ed0218610000000000000000000000001ffda89c755f6d4af069897d77ccabb580fd412a | null | null | 126 | 1746742829 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0xb920479aa87629ddb495e17c34d9c482fb6a4c376a3b36d7190d6d3140af0dba_0 | 0x089770aff94b28981664fe2c925b3cab6a61e7cb4479ab9cf0268b6363d0fcb5 | 67 | 0xb920479aa87629ddb495e17c34d9c482fb6a4c376a3b36d7190d6d3140af0dba | 68 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000000558000c5fc5000000000000000800000000681d2e570000000001566f0400000000000000000000000000000000000000000000000000000001b288cd560000000000000000000000000000000000000000000000000000000000000001f1fe99bb3d76e76b1534cc3d4553367c5781927b87185ee542b2553ae23629da0000000000000000000000001ffda89c755f6d4af069897d77ccabb580fd412a | null | null | 126 | 1746742879 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0xfdaae7c10c14f6e4b557f3e7948c575b8faf706faa3709e5bb007571cc12442b_0 | 0x9c6491eaaf06cd2ffa9502e1aa6196167a824f0bfd6bc69ad6e4c2ec87c802aa | 78 | 0xfdaae7c10c14f6e4b557f3e7948c575b8faf706faa3709e5bb007571cc12442b | 79 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000000558000c5fc5000000000000000700000000681d2e630000000001566f05000000000000000000000000000000000000000000000000000000019fa84279000000000000000000000000000000000000000000000000000000000000000133aa4b9e6f908354021af38d1322cb01ab4efbce6c58cf23bfbb66ecccb1c8000000000000000000000000001ffda89c755f6d4af069897d77ccabb580fd412a | null | null | 126 | 1746742890 | 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 |