Enriched Transactions
Chain
SonicDataset name
sonic.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_0x2ff7f6afc4964d64982a4f01c72ca5dc921650e0f322a382f86dfba19002ce9a_4 | 0x49e7ae5e8d07905db00e3cff5e1a6004da4f91520adc909b7bf061a24c7bd0b8 | 4 | 0x2ff7f6afc4964d64982a4f01c72ca5dc921650e0f322a382f86dfba19002ce9a | 1 | 4 | 0x0000000000000000000000000000000000000000 | 0xd100a01e00000000000000000000000000000000 | -ÆÀ | 0xa8ab09ba00000000000000000000000090039b2b26bbcba645c0a2f89982813e12c618fe00000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000422ca8b0a00a425000000 | null | null | 0 | 1733011200 | 0 | 0 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||
| enriched_transaction_v2_0xda34494ea576e8f240a3a76e250b2e0acfd5d64af314781f38a498e87621c49d_0 | 0x3aea8fd24d5b5f5b880b9db12e626a75d110b501594f4bc81d897e41461f2ce7 | 2 | 0xda34494ea576e8f240a3a76e250b2e0acfd5d64af314781f38a498e87621c49d | 73 | 0 | 0x597fa3ad161b16f450e257ed71be8404bdefcdc9 | 0x3fab184622dc19b6109349b94811493bf2a45362 | 0 | 0 | 0 | 0x | null | null | 0 | 1733072859 | 0 | 0 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null |
| enriched_transaction_v2_0x5b6a489af3e4f20083fbf30b018634566d775d88dd2b813d211910e0bc045012_1 | 0xc6844bd12f010ea0d3ee58af96057df31dab0c6f8d4c1333b5f833d1681726ca | 34 | 0x5b6a489af3e4f20083fbf30b018634566d775d88dd2b813d211910e0bc045012 | 969 | 1 | 0x0000000000000000000000000000000000000000 | 0xd100a01e00000000000000000000000000000000 | 0 | 0xe08d7e660000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000003000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000700000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000009000000000000000000000000000000000000000000000000000000000000000a | null | null | 0 | 1733075650 | 0 | 0 | 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 |