Enriched Transactions
Chain
CodexDataset name
codex.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_0x75ca15bf3d5f8f26b4f2fd16493a0cab2e18d352a621f5661ca4d45233b868bc_0 | 0x329a043fbb2c3ab92821c9924d859bf10a1e44c4f06effaaa808affb552d1749 | 3 | 0x75ca15bf3d5f8f26b4f2fd16493a0cab2e18d352a621f5661ca4d45233b868bc | 4 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000010b3000000000000000000000000400000000670ce41300000000013fde610000000000000000000000000000000000000000000000000000000292f1e18c00000000000000000000000000000000000000000000000000000000000000015886b0f50dbc175d21028cff8e2d6ef92b813eaff4dca617f1da80bf4bc62e50000000000000000000000000b5bd290ef8ef3840cb866c7a8b7cc9e45fde3ab9 | null | null | 126 | 1728898075 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x45796969d2b96bdc0589aac863d691dcc650d02dc3e4f91a9aae79c446f9ba23_0 | 0x9de0abe41911141b3e06d4bfc6d32723fa53b227ce97d5419d09032e870aaf36 | 13 | 0x45796969d2b96bdc0589aac863d691dcc650d02dc3e4f91a9aae79c446f9ba23 | 14 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000010b3000000000000000000000000200000000670ce42b00000000013fde630000000000000000000000000000000000000000000000000000000284eee90e0000000000000000000000000000000000000000000000000000000000000001d913ee8a2a4cc84a2a706a97d23e415b36a66f176000e06b9d0a47d86381a964000000000000000000000000b5bd290ef8ef3840cb866c7a8b7cc9e45fde3ab9 | null | null | 126 | 1728898095 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x463a560a4d0a8ce2be0e34a299e09f0cd2dc9ace730cd8ae3282590277a81cc6_0 | 0x7be123eba19f00a605387733e662da62d8f344a17c38548cb311994e40372859 | 31 | 0x463a560a4d0a8ce2be0e34a299e09f0cd2dc9ace730cd8ae3282590277a81cc6 | 32 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000010b3000000000000000000000000800000000670ce44300000000013fde650000000000000000000000000000000000000000000000000000000285b16a790000000000000000000000000000000000000000000000000000000000000001e770d369e11c8796c3a185ca86d244c3188cf5e31ba5832d311a1147f5298755000000000000000000000000b5bd290ef8ef3840cb866c7a8b7cc9e45fde3ab9 | null | null | 126 | 1728898131 | 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 |