Enriched Transactions
Chain
SophonDataset name
sophon.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_0xfb28e46dfb847c0f35dcef47ea19f5950152ba81d1de39b43b5221aa08d7b0ba_0 | 0x5b8fe860c2b9c0af3fa6379e58cef7ebc4b17cd53b04eaf95c90b39fea59f20a | 19 | 0xfb28e46dfb847c0f35dcef47ea19f5950152ba81d1de39b43b5221aa08d7b0ba | 25 | 0 | 0xe6d3c3e13de46451c4d3dd6729b7b2ad4c2c37e9 | 0x0000000000000000000000000000000000008006 | 0 | 0 | 0x9c4d535b000000000000000000000000000000000000000000000000000000000000000001000167ad44aca0fb3d3dc1e360601b2865ba9b8fb9a41b4f7d5b1b23a0d5b500000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | 0 | 0 | 113 | 1729670923 | 0 | 0x13cf5444fba78ab4e15a6186ed94aa9a66d70453 | 1 | 0 | 0xfb28e46dfb847c0f35dcef47ea19f5950152ba81d1de39b43b5221aa08d7b0ba | null | null | null | null | null | null | null | null | null | null | null | null | null | ||
| enriched_transaction_v2_0x37254ca9014b095eb50e27d28bb3cb62e430676c7aaef829edb183e88da46c08_0 | 0x1e6e27000dbc246a3f8dd1360cb4ab8ce2222a141d29898ff88a9c3dca3a7b6f | 36 | 0x37254ca9014b095eb50e27d28bb3cb62e430676c7aaef829edb183e88da46c08 | 43 | 0 | 0xe6d3c3e13de46451c4d3dd6729b7b2ad4c2c37e9 | 0x8d7faba273cb3a62130807ddb7a1896facc59d4b | 0 | 0 | 0x5b5cef4e0000000000000000000000008d7faba273cb3a62130807ddb7a1896facc59d4b0000000000000000000000000000000000000000000000000000000000000001 | 0 | 0 | 0 | 1729677196 | 0 | null | 1 | 0 | 0x37254ca9014b095eb50e27d28bb3cb62e430676c7aaef829edb183e88da46c08 | null | null | null | null | null | null | null | null | null | null | null | null | null | ||
| enriched_transaction_v2_0x04b93ca04bfbdd0bec3ac15030ed8d455b35106909592d86e3a630b973cb8a23_0 | 0x550b8e10dc1b79e9fc6740cf90d9146e00ecdffd5cf3cd50133f14b3fc691a46 | 37 | 0x04b93ca04bfbdd0bec3ac15030ed8d455b35106909592d86e3a630b973cb8a23 | 45 | 0 | 0xe6d3c3e13de46451c4d3dd6729b7b2ad4c2c37e9 | 0x0000000000000000000000000000000000008006 | 0 | 0 | 0x9c4d535b0000000000000000000000000000000000000000000000000000000000000000010001553a480f72a7f06acb2e71580031ab0b5dddb21f160368c3c1003898dc000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000004555344430000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000045553444300000000000000000000000000000000000000000000000000000000 | 0 | 0 | 113 | 1729681874 | 0 | 0xae52a5bc3c64119a6d25c747e48f5452eb6536ee | 1 | 0 | 0x04b93ca04bfbdd0bec3ac15030ed8d455b35106909592d86e3a630b973cb8a23 | 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 |