Enriched Transactions
Chain
Mode TestnetDataset name
mode_testnet.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_0xe9ab04bb18bce3033ed5727a918147ec72a2c5151df1b5ed8f8d12dc62e76e62_0 | 0x7e572c151f9b96f8daba5aab67e865362ff0b14ec7499aa7b8ff6d9b84456fb6 | 12846986 | 0xe9ab04bb18bce3033ed5727a918147ec72a2c5151df1b5ed8f8d12dc62e76e62 | 12846986 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 1000000 | 0 | 0x440a5e20000003d10008ee870000000000000003000000006622e0f00000000000577f7e000000000000000000000000000000000000000000000000000000003cdac33600000000000000000000000000000000000000000000000000000004a1bd32183f7998410b9593c1ae4db09dda86bd4a54b017bcc65617727ae37b1730c35af20000000000000000000000004e6bd53883107b063c502ddd49f9600dc51b3ddc | null | null | 126 | 1713561904 | 43875 | 43875 | null | 1 | 0 | null | null | null | null | null | null |
| enriched_transaction_0xd65bf0d340186614791d4e5cbad3f7bbac99f888710e679da668841f65c3b58d_0 | 0xd9c0b48feec78437c038146e6d142e1ad5fc6f763258102f5ef26385cf622790 | 12846987 | 0xd65bf0d340186614791d4e5cbad3f7bbac99f888710e679da668841f65c3b58d | 12846987 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 1000000 | 0 | 0x440a5e20000003d10008ee870000000000000004000000006622e0f00000000000577f7e000000000000000000000000000000000000000000000000000000003cdac33600000000000000000000000000000000000000000000000000000004a1bd32183f7998410b9593c1ae4db09dda86bd4a54b017bcc65617727ae37b1730c35af20000000000000000000000004e6bd53883107b063c502ddd49f9600dc51b3ddc | null | null | 126 | 1713561906 | 43875 | 43875 | 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 |