Enriched Transactions
Chain
Dataset name
hyperevm.receipt_transactionsVersion
1.1.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_0x792da8cdc9fadbcb0dc81206a16b3dfbe406ba56b4f80d601c5ccb5f8286345d_0 | 0x3145addb8b3b22c78abc31d2fb340b1585bf6048194c264c774c6a97997768f8 | 0 | 0x792da8cdc9fadbcb0dc81206a16b3dfbe406ba56b4f80d601c5ccb5f8286345d | 4755 | 0 | 0xf569e5fea87cb45da33ab8246080c73c50ccd950 | 0x6169d055a1602c5f673b58029a501d41d8b2287b | 0 | 0 | 0 | 0x | 0 | 0 | 2 | 1739858980 | 0 | 0 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null |
| enriched_transaction_v2_0x70bea91b4d3eea5c8aed953292a822789092cb362abcd2449d8d830eb15d1f21_0 | 0x5e51bc989f0ef1b4066aac62dd8b54871622de35c825160c34a7adde49d57ccc | 1 | 0x70bea91b4d3eea5c8aed953292a822789092cb362abcd2449d8d830eb15d1f21 | 5720 | 0 | 0x18cf159e1776ca6bdbe6719dace450121b4603b4 | 0x18cf159e1776ca6bdbe6719dace450121b4603b4 | 0 | 0 | 0 | 0x | null | null | 0 | 1739860848 | 0 | 0 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null |
| enriched_transaction_v2_0xec34dfb21e31db368cb61b39eaf03ebd0a605506ac8bd9b578c1ad9df23facb8_0 | 0xc05421e418b14e0e14eb457dc01f4b406aea21bae215464f1df650aa4142927b | 0 | 0xec34dfb21e31db368cb61b39eaf03ebd0a605506ac8bd9b578c1ad9df23facb8 | 6518 | 0 | 0x64c00ffeb4e6e2dd93233bade3e59a0a4e4899af | 0x323d2c850b454e0d1c8e5beaa829064fe8a91dcc | 0 | G | 0x45b2b004de69b6e00c2785518b2753145ae8fe6a57a7b2206d8ff15324aea4666080604052348015600f57600080fd5b506108468061001f6000396000f3fe608060405234801561001057600080fd5b50600436106100365760003560e01c806311b804ab1461003b578063d057c8b114610077575b600080fd5b61004e610049366004610637565b61008a565b60405173ffffffffffffffffffffffffffffffffffffffff909116815260200160405180910390f35b61004e61008536600461068f565b6101f0565b6040517fffffffffffffffffffffffffffffffffffffffff0000000000000000000000003360601b1660208201526034810182905260009081906054016040516020818303038152906040528051906020012090506100e98582610341565b60405173ffffffffffffffffffffffffffffffffffffffff808316825291935033918716907f9e0862c4ebff2150fbbfd3f8547483f55bdec0c34fd977d3fccaa55d6c4ce7849060200160405180910390a38351156101e85760008273ffffffffffffffffffffffffffffffffffffffff16856040516101699190610736565b6000604051808303816000865af19150503d80600081146101a6576040519150601f19603f3d011682016040523d82523d6000602084013e6101ab565b606091505b50509050806101e6576040517fd853e20800000000000000000000000000000000000000000000000000000000815260040160405180910390fd5b505b509392505050565b6000806101fd8486610356565b90506102098682610341565b91503373ffffffffffffffffffffffffffffffffffffffff168273ffffffffffffffffffffffffffffffffffffffff168773ffffffffffffffffffffffffffffffffffffffff167fce771ab142d4dae572f01bd7e3eb77c8241179ce1a8128451099727badfba64e8789886040516102839392919061079c565b60405180910390a48451156103385760008273ffffffffffffffffffffffffffffffffffffffff16866040516102b99190610736565b6000604051808303816000865af19150503d80600081146102f6576040519150601f19603f3d011682016040523d82523d6000602084013e6102fb565b606091505b5050905080610336576040517fd853e20800000000000000000000000000000000000000000000000000000000815260040160405180910390fd5b505b50949350505050565b600061034f600084846104bc565b9392505050565b600082811a60f81b7f01000000000000000000000000000000000000000000000000000000000000008116158015917f020000000000000000000000000000000000000000000000000000000000000081161515917f0400000000000000000000000000000000000000000000000000000000000000909116151590849084906103dd5750825b156104125786866040516020016103f59291906107c7565b60405160208183030381529060405280519060200120905061048d565b83801561041d575082155b15610433576040805160208101899052016103f5565b8315801561043e5750825b15610458578646876040516020016103f5939291906107e8565b8646604051602001610474929190918252602082015260400190565b6040516020818303038152906040528051906020012090505b81156104b2576040805160208101839052338183015281518082038301905260600190525b9695505050505050565b60006c5af43d3d93803e602a57fd5bf36021528260145273602c3d8160093d39f33d3d3d3d363d3d37363d73600052816035600c86f59050806105075763301164256000526004601cfd5b60006021529392505050565b803573ffffffffffffffffffffffffffffffffffffffff8116811461053757600080fd5b919050565b7f4e487b7100000000000000000000000000000000000000000000000000000000600052604160045260246000fd5b600082601f83011261057c57600080fd5b813567ffffffffffffffff8111156105965761059661053c565b6040517fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe0603f7fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe0601f8501160116810181811067ffffffffffffffff821117156106025761060261053c565b60405281815283820160200185101561061a57600080fd5b816020850160208301376000918101602001919091529392505050565b60008060006060848603121561064c57600080fd5b61065584610513565b9250602084013567ffffffffffffffff81111561067157600080fd5b61067d8682870161056b565b93969395505050506040919091013590565b600080600080608085870312156106a557600080fd5b6106ae85610513565b9350602085013567ffffffffffffffff8111156106ca57600080fd5b6106d68782880161056b565b93505060408501359150606085013567ffffffffffffffff8111156106fa57600080fd5b6107068782880161056b565b91505092959194509250565b60005b8381101561072d578181015183820152602001610715565b50506000910152565b60008251610748818460208701610712565b9190910192915050565b6000815180845261076a816020860160208601610712565b601f017fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe0169290920160200192915050565b8381526060602082015260006107b56060830185610752565b82810360408401526104b28185610752565b8281526040602082015260006107e06040830184610752565b949350505050565b8381528260208201526060604082015260006108076060830184610752565b9594505050505056fea264697066735822122068c6b08fce7a18b0f21aa2cfd72d2af098db55aa005d9b14a61840e9fa4b629a64736f6c634300081a0033 | A« | 2 | 1739862392 | null | 1 | G | 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 |