Enriched Transactions
Chain
Orderly SepoliaDataset name
orderly_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_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_0xa0ba1c41f2b5611ce08bdaf8d20b17c684c1f6f72e3c40dbc5c6636c2d3bfc91_0 | 0x04d4c5aadbed26125bb72779adc4157c1743a6118d6da178c8b9e70950c930a0 | 15493725 | 0xa0ba1c41f2b5611ce08bdaf8d20b17c684c1f6f72e3c40dbc5c6636c2d3bfc91 | 15493724 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000000d5c0000000000000000000000050000000066ab90c0000000000061e8c7000000000000000000000000000000000000000000000000000000014644319c0000000000000000000000000000000000000000000000000000022d1fc72345c79cd3cb43873fc25f5b1e9ead8e9790c0563577df55876adf762c95560a5de400000000000000000000000085e5551a01a3eebf34df650c0062cb80abd1661c | null | null | 126 | 1722519820 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0xa11b81ddc94e103081fe91dce18b8a44a4f57db1b042d89808ad1ab1f57d5a2b_0 | 0xcc29d1b19a168263182191edfcb8b397429cdd2cdd70616cde5b2d35df36e35a | 15493731 | 0xa11b81ddc94e103081fe91dce18b8a44a4f57db1b042d89808ad1ab1f57d5a2b | 15493730 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000000d5c00000000000000000000000b0000000066ab90c0000000000061e8c7000000000000000000000000000000000000000000000000000000014644319c0000000000000000000000000000000000000000000000000000022d1fc72345c79cd3cb43873fc25f5b1e9ead8e9790c0563577df55876adf762c95560a5de400000000000000000000000085e5551a01a3eebf34df650c0062cb80abd1661c | null | null | 126 | 1722519832 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0xa032a7f3387cf975c6ce80e1e98e04caa55cab272d8b635cce798345f4ca0781_0 | 0x937f21f092f87227984e1148b8f0cd6efedb782eb4b5c612607a599b870a1cce | 15493733 | 0xa032a7f3387cf975c6ce80e1e98e04caa55cab272d8b635cce798345f4ca0781 | 15493732 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000000d5c00000000000000000000000d0000000066ab90c0000000000061e8c7000000000000000000000000000000000000000000000000000000014644319c0000000000000000000000000000000000000000000000000000022d1fc72345c79cd3cb43873fc25f5b1e9ead8e9790c0563577df55876adf762c95560a5de400000000000000000000000085e5551a01a3eebf34df650c0062cb80abd1661c | null | null | 126 | 1722519836 | 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 |