Enriched Transactions
Chain
Dataset name
moca.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_0x02bfa013f61eccee618d98e18c6c0957664e1c0004b7315c74e4c05425a79b59_1 | 0xcb099e7127744f330f04e02e0361083df446a2d63f3e29d4544b6e473a5e94c2 | 232639 | 0x02bfa013f61eccee618d98e18c6c0957664e1c0004b7315c74e4c05425a79b59 | 14530235 | 1 | 0x339d413ccefd986b1b3647a9cfa9cbbe70a30749 | 0x3c2269811836af69497e5f486a85d7316753cf62 | _0 | Pw] | 0x3161b7f600000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000016a00000000000000000000000000000000000000000000009632e6d8ad6737263200000000000000000000000000000000000000000000000000000000000056160000000000000000000000000000000000000000000000000000000000000010 | null | null | 0 | 1777975005 | _0 | ¯ | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0x9e5a41f683622cdd83cac084c2eb5d40014ccf1148041cde9f61294ada054e9b_0 | 0x4d44ce55687575ebfb6a09a603925130f107d6b86e99027662ca9412addec87f | 232658 | 0x9e5a41f683622cdd83cac084c2eb5d40014ccf1148041cde9f61294ada054e9b | 14530603 | 0 | 0x339d413ccefd986b1b3647a9cfa9cbbe70a30749 | 0x3c2269811836af69497e5f486a85d7316753cf62 | _0 | Pw] | 0x3161b7f600000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006a000000000000000000000000000000000000000000000e9a51c98ff96904655800000000000000000000000000000000000000000000000000000000004519860000000000000000000000000000000000000000000000000000000000000010 | null | null | 0 | 1777975309 | ¯ | ¯ | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0xf4241c3e108e816ea690d4d1ad0c0ba07d05239a1b0b64ef0b762987d4c0d282_0 | 0x18530586d57b483426e554072eb7ef3644c15a9133c82e78d1364216781b543b | 232667 | 0xf4241c3e108e816ea690d4d1ad0c0ba07d05239a1b0b64ef0b762987d4c0d282 | 14530966 | 0 | 0x339d413ccefd986b1b3647a9cfa9cbbe70a30749 | 0x3c2269811836af69497e5f486a85d7316753cf62 | _0 | Pw] | 0x3161b7f60000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000b70000000000000000000000000000000000000000000e756c3391779681d3302e0000000000000000000000000000000000000000000000000000000002c8ba180000000000000000000000000000000000000000000000000000000000000010 | null | null | 0 | 1777975607 | ¯ | ¯ | null | 1 | null | 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 |