Enriched Transactions
Chain
Sanko SepoliaDataset name
sanko_sepolia.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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| enriched_transaction_0xc68c6b849681599335340ef93d4bc6ab5e5784da7018c3771237a3da1b4f4491_1 | 0x8ee59123fee2379c81c6fed5fa4310d24b0e40027b3bb04684bde87f0e3caaf1 | 0 | 0xc68c6b849681599335340ef93d4bc6ab5e5784da7018c3771237a3da1b4f4491 | 6 | 1 | 0x4c8d290a1b368ac4728d83a9e8321fc3af2b39b1 | null | 100000 | 1500000 | 0x601f80600e600039806000f350fe60003681823780368234f58015156014578182fd5b80825250506014600cf3 | null | null | 0 | 1705711149 | 0x7a0d94f55792c434d74a40883c6ed8545e406d12 | 1 | 400000 | null | null | null | null | null | ||||
| enriched_transaction_0x7b02b169e1456c51cf176a9a8e70730fc4cf4abb0d26a27970c57ac5ea6d41d0_2 | 0x3385c76a27187627c720ea784f948ee7fc50a7a1e78c69818922b398779750c1 | 0 | 0x7b02b169e1456c51cf176a9a8e70730fc4cf4abb0d26a27970c57ac5ea6d41d0 | 13 | 2 | 0x2bce4cd0d337a55589134c3c9202eff2271e343d | 0x297bffa7fceeb4eb94fec0cfccdbde1455d19fe4 | 0 | 400000 | 0x1cff79cd00000000000000000000000084847521786e9b6fc2cc222fe8d3a37ef97334dd0000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000006430570b9400000000000000000000000056f29cfe0d78d14d0bc88c5b0ec945e08024d9d2000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000f424000000000000000000000000000000000000000000000000000000000 | 400000 | null | 104 | 1705711169 | 1050000 | null | 1 | 400000 | null | null | null | null | null | |||
| enriched_transaction_0x67f6448637ad1e2251a05d17edfe20a2b0a555e46b31581db59ce2a2569fcd07_0 | 0x3db1084d1cd6875acc91e08c83863e745717e7b738e5d8dce0812df3e02f0762 | 0 | 0x67f6448637ad1e2251a05d17edfe20a2b0a555e46b31581db59ce2a2569fcd07 | 79 | 0 | 0x00000000000000000000000000000000000a4b05 | 0x00000000000000000000000000000000000a4b05 | 0x6bf6a42d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004ed72d000000000000000000000000000000000000000000000000000000000000004f0000000000000000000000000000000000000000000000000000000000000001 | null | null | 106 | 1706396149 | null | 1 | 0 | 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 |