Enriched Transactions
Chain
Dataset name
ethernity_testnet.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_0x01ebe1c7f127bd1d87d33635a0fd9825cdf67187197873e1f6e8cba54c9e1f4e_0 | 0x4ff1b589154b253b7aab4fb4aca7758a553518b960af65a1e0e312275b46ebb1 | 16 | 0x01ebe1c7f127bd1d87d33635a0fd9825cdf67187197873e1f6e8cba54c9e1f4e | 17 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000f424000000000000000000000000500000000665ef57800000000005c1fdc00000000000000000000000000000000000000000000000000000011abc2c7bc0000000000000000000000000000000000000000000000000000000000000001f1eb0a6aca66856387b35d0b65980694ecf3961ceaf6e25ce4a71d6b6a2ad90e000000000000000000000000973a9e30d6d11355a459a69e7cbfba61c7627736 | null | null | 126 | 1717499266 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x9e5d9ecd366d2066d25bf5f47b77def24fa77b1cb4fc041c995bb1beedc5cd98_0 | 0xe4bcd0f927a8b3d823017d8b47e7a6915e04906dfcfc42925d2af99deb0d729c | 33 | 0x9e5d9ecd366d2066d25bf5f47b77def24fa77b1cb4fc041c995bb1beedc5cd98 | 34 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000f424000000000000000000000000400000000665ef59c00000000005c1fde00000000000000000000000000000000000000000000000000000011a865194900000000000000000000000000000000000000000000000000000000000000015c0710363628dfec66eefa57b0e4ea7e5d7a8184ed931c5a525cbaf6678b86c4000000000000000000000000973a9e30d6d11355a459a69e7cbfba61c7627736 | null | null | 126 | 1717499300 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0xe4ffeed1f4016e085ffff2423a6747b7d515406a5df51ad6f8cee36017ec519a_0 | 0x78438b75722b566338e3352a1fa8ee34f0d4c85c897d5a2ce2c09ba3096a91c0 | 47 | 0xe4ffeed1f4016e085ffff2423a6747b7d515406a5df51ad6f8cee36017ec519a | 48 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000f424000000000000000000000000000000000665ef5c000000000005c1fe100000000000000000000000000000000000000000000000000000011226c96920000000000000000000000000000000000000000000000000000000000000001990de73d9b6006fd93383e0499d1a619cfa5e0947180089bcf1f2dd11e997ac9000000000000000000000000973a9e30d6d11355a459a69e7cbfba61c7627736 | null | null | 126 | 1717499328 | 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 |