Enriched Transactions
Chain
B3 SepoliaDataset name
b3_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_0xf1c7cbfc5e70163810e7fc80e574cecb62bedde023cf5c4347431bb42cce4d2b_0 | 0x213cd2d659db51f4b0420eee67ead7f1f7782333280951e12ee60625ab296fb4 | 5 | 0xf1c7cbfc5e70163810e7fc80e574cecb62bedde023cf5c4347431bb42cce4d2b | 5 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000f424000000000000000000000000100000000662c382400000000008c6ca200000000000000000000000000000000000000000000000000000000000003c80000000000000000000000000000000000000000000000000000000000000001138633b0328b194e2ed2cda1674f32fa495eb370467f31abeb8e649f5cc1c62c0000000000000000000000006f9e9dd73cc45e22f4df49a7441da9e998a955b0 | null | null | 126 | 1714173989 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0xe05381de1db31554160f92f3455cd32256222774c073cc5441081c5e2d2ff494_0 | 0xb8fee022192ab64c40c3ef4221b724f60f3f9a8f313550c114130724522d0d69 | 15 | 0xe05381de1db31554160f92f3455cd32256222774c073cc5441081c5e2d2ff494 | 15 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000f424000000000000000000000000100000000662c382e00000000008c6ca700000000000000000000000000000000000000000000000000000000000003cd000000000000000000000000000000000000000000000000000000000000000190f6eb428f798d00bedce832632bd9c0774861cc7b4fabd65441e5ea49a3f3e30000000000000000000000006f9e9dd73cc45e22f4df49a7441da9e998a955b0 | null | null | 126 | 1714173999 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x9b8efe6664cfc421532fd384b7e5cd92f15a8803ce97601120deb5e79cdb0083_0 | 0x48779d3e1209734a18cd3973b0cba11fbe060d22db4f2206b195a6b851e9f35f | 34 | 0x9b8efe6664cfc421532fd384b7e5cd92f15a8803ce97601120deb5e79cdb0083 | 34 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000f424000000000000000000000000000000000662c384200000000008c6cb100000000000000000000000000000000000000000000000000000000000003cf0000000000000000000000000000000000000000000000000000000000000001a94ad2c7e34fa0b4ad0c7088ecb4570729bb70b74f130dfd4b26062324b2ac780000000000000000000000006f9e9dd73cc45e22f4df49a7441da9e998a955b0 | null | null | 126 | 1714174018 | 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 |