Enriched Transactions
Chain
MetalDataset name
metal.receipt_transactionsVersion
1.1.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_0x937a0f095e51fd9b2876ee990625e436123312417dfb5f2207d16062a7bffbdb_0 | 0x2f31b74d533e94f560f6257e4f315ae9d71aeb136328fe2311d03872cac8c6c0 | 3017406 | 0x937a0f095e51fd9b2876ee990625e436123312417dfb5f2207d16062a7bffbdb | 3017406 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 1000000 | 0 | 0x440a5e20000a6fe0000000000000000000000004000000006660782f000000000131939f00000000000000000000000000000000000000000000000000000005562478ed0000000000000000000000000000000000000000000000000000000000000002d8434431ef41377119ca4973d5d4eb69333a266a97494275387b9b99ef962cdd000000000000000000000000c94c243f8fb37223f3eb2f7961f7072602a51b8b | null | null | 126 | 1717598327 | 43827 | 43827 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null |
| enriched_transaction_v2_0x055aef77d96f49df91bc1f6109b3c58d49afb5ca7581299fe10e2224624350c3_0 | 0x155e54b6d5a4bea4d239e3a62489e77f9b37ccc2d465e1a1e08bca174e040bbe | 3017409 | 0x055aef77d96f49df91bc1f6109b3c58d49afb5ca7581299fe10e2224624350c3 | 3017409 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 1000000 | 0 | 0x440a5e20000a6fe0000000000000000000000001000000006660783b00000000013193a0000000000000000000000000000000000000000000000000000000054a7781d20000000000000000000000000000000000000000000000000000000000000002ff341b62efb2ee5074ee98d724879ab64f6de82e0dc42f646fc80c28811ae26f000000000000000000000000c94c243f8fb37223f3eb2f7961f7072602a51b8b | null | null | 126 | 1717598333 | 43827 | 43827 | null | 1 | 0 | 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 |