Enriched Transactions
Chain
Ethereum SepoliaDataset name
ethereum_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_0xa7484ccd992b5797f4f6d446db350c720f42e9914b2692ece8ab783c42df2248_1 | 0x42fbb409a54d1031e89a8c82b961c9278b7ce83a69ef97ccb399c3efbe526e99 | 238 | 0xa7484ccd992b5797f4f6d446db350c720f42e9914b2692ece8ab783c42df2248 | 2802059 | 1 | 0x43c92d390d3ed89716e4a0776d8aea1fb965d55d | 0x041eac26aab0d7afe408c3ad3c07ea3f749e7453 | 0 | 0xd45b6292000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000006f05b59d3b20000000000000000000000000000000000000000000000000000000000000000c3500000000000000000000000000000000000000000000000000000000000000001000000000000000000000000ed3e3065909d47fe1c51bd08be3d0caa33aecfa5 | null | null | 0 | 1675145892 | 0 | 0 | null | 1 | null | null | null | null | null | null | |||
| enriched_transaction_0xe586f60053ef981b54c5b55653357f18a3ff4ed46eef89924f1029ba55435ecb_6 | 0xcbe805af9c69a53259739b30e13de1e9868d594a76af74ab01b05694b9e04e74 | 324827 | 0xe586f60053ef981b54c5b55653357f18a3ff4ed46eef89924f1029ba55435ecb | 1867664 | 6 | 0xdc9d3015a4a391607a835b87a292bcf030af24e2 | 0xf549af21578cfe2385ffd3488b3039fd9e52f006 | 0 | 0 | 0xc9807539000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001a00000000000000000000000000000000000000000000000000000000000000200010100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000bf81fd87c427b46e97ad2f8d2ef9dd8b000538f303000102030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000292f67f040000000000000000000000000000000000000000000000000000000292f67f040000000000000000000000000000000000000000000000000000000292f67f040000000000000000000000000000000000000000000000000000000292f67f040000000000000000000000000000000000000000000000000000000000000000287bf8b9f3f169a9c7f4d3ccb63c8323175b8057177f47a6201075ee6807918196094a76317b7134b7ae2562773b121f1760f3130946c79f7102cd6f68a3872c500000000000000000000000000000000000000000000000000000000000000025c1de873f7fe3286a236fbeabeb705c90870d237a14dc98c646870b0d5b055f212d0b0bfcaa28c15ba9d563bb7b7c0fb063f05458e09c9bf04757692db175514 | 0 | 0 | 2 | 1662897924 | 0 | tm | null | 0 | 0 | null | null | null | null | null | null | |
| enriched_transaction_0x23fd93b4c0413550499ae79c2a5dd88a3b2fa3bc4a89ecb9294fdf3c7cc2bba4_1 | 0xf21c8eeda30eee0a1d8acf3f60f8d90b9eac32a67013c186818515aaa54cdaef | 325012 | 0x23fd93b4c0413550499ae79c2a5dd88a3b2fa3bc4a89ecb9294fdf3c7cc2bba4 | 1867911 | 1 | 0xdc9d3015a4a391607a835b87a292bcf030af24e2 | 0xf549af21578cfe2385ffd3488b3039fd9e52f006 | 0 | 0 | 0xc9807539000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001a00000000000000000000000000000000000000000000000000000000000000200010100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000bf81fd87c427b46e97ad2f8d2ef9dd8b0005399401000102030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000294bc7c228000000000000000000000000000000000000000000000000000000294bc7c228000000000000000000000000000000000000000000000000000000294bc7c228000000000000000000000000000000000000000000000000000000294bc7c22800000000000000000000000000000000000000000000000000000000000000029cf7adf35790acac0d0f0a94b5c9c7d13d4a3a91466a9851e753b0c1866192bad92ee3ff41b0c96ec69f0b2269168c40a934128596314a859311f56cad07fd3100000000000000000000000000000000000000000000000000000000000000025eaa49dea94d60330dc3975c4052259c96ce475507c2dc16207a0e4fe713787a4d653e6c142637067e4721bcaba2c82b24814a0ab8e1f6bd025c67221aa56c22 | 0 | 0 | 2 | 1662901068 | tm | null | 0 | 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 |