Enriched Transactions
Chain
Dataset name
moca_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_0x098c25d93ad0f11f47c70677b36cb9e96f5ea18e7fa66b225cce9f8fa2cae310_8 | 0xfbea6b567879c2edbcaee39d9b7b0d933b74e8478ccc6719c1a8747d73b4c127 | 14 | 0x098c25d93ad0f11f47c70677b36cb9e96f5ea18e7fa66b225cce9f8fa2cae310 | 530264 | 8 | 0xbe84ca9daa0ef52c16d8682f243316eec37cd61c | 0x00000be6819f41400225702d32d3dd23663dd690 | #òoÁ | R | ;Ê | 0x | A« | 2 | 1756871361 | âH | R | null | 1 | ;Ê | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0x7f038e4969d1243ecd40fbeef0836f9e6aa24ced34fc1192485a522719426a98_1 | 0x4863dc3ee3c9498728fefd566dda16253ffd7ccc767faf616fd2165b62ac6046 | 19 | 0x7f038e4969d1243ecd40fbeef0836f9e6aa24ced34fc1192485a522719426a98 | 530265 | 1 | 0xbe84ca9daa0ef52c16d8682f243316eec37cd61c | 0x00000be6819f41400225702d32d3dd23663dd690 | #òoÁ | R | ;Ê | 0x | A« | 2 | 1756871362 | R | null | 1 | ;Ê | null | null | null | null | null | null | null | null | null | null | null | null | null | null | ||
| enriched_transaction_v2_0x7f038e4969d1243ecd40fbeef0836f9e6aa24ced34fc1192485a522719426a98_10 | 0xa6a76453996a7a1536a36f480d8e97e56d3f3fcee1fb9fef829ef8bb8719754f | 28 | 0x7f038e4969d1243ecd40fbeef0836f9e6aa24ced34fc1192485a522719426a98 | 530265 | 10 | 0xbe84ca9daa0ef52c16d8682f243316eec37cd61c | 0x00000be6819f41400225702d32d3dd23663dd690 | #òoÁ | R | ;Ê | 0x | A« | 2 | 1756871362 | X | R | 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 |