Enriched Transactions
Chain
Pharos MainnetDataset name
pharos.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_0xc3d3fab99faca02743dfa499f4e51c66baca4ac890d9b88aa35e2a38610a1a18_0 | 0x90cad20d06391c38875af1cf8569779d712eb2c4634a856612387f6467c50a5e | 0 | 0xc3d3fab99faca02743dfa499f4e51c66baca4ac890d9b88aa35e2a38610a1a18 | 3462 | 0 | 0x5f0975a92e4fb8005e7229fac96762fb3ca3d218 | 0xaf97594412c1b7f2d2dc5abc2f5aeaef4162d4c2 | EcDô | nì | T ä | 0x | T ä | T ä | 2 | 1765539538 | R | R | null | 1 | T ä | null | null | null | null | null | null | null | null | null | null | null | null | null | null |
| enriched_transaction_v2_0x6a80c5448b1aacbebb7736c2c8a3778699a86e5330e40fb272b6486b3d6de04e_0 | 0x4888377730c757e1401f954620c631db4c25b62c7ddfeab914a28330c668265b | 0 | 0x6a80c5448b1aacbebb7736c2c8a3778699a86e5330e40fb272b6486b3d6de04e | 4144 | 0 | 0xaf97594412c1b7f2d2dc5abc2f5aeaef4162d4c2 | null | ;¢ | T ä | 0x60806040526040518060400160405280600981526020017f54657374546f6b656e00000000000000000000000000000000000000000000008152505f908161004791906102f6565b506040518060400160405280600481526020017f54657374000000000000000000000000000000000000000000000000000000008152506001908161008c91906102f6565b50601260025f6101000a81548160ff021916908360ff1602179055503480156100b3575f5ffd5b506103c5565b5f81519050919050565b7f4e487b71000000000000000000000000000000000000000000000000000000005f52604160045260245ffd5b7f4e487b71000000000000000000000000000000000000000000000000000000005f52602260045260245ffd5b5f600282049050600182168061013457607f821691505b602082108103610147576101466100f0565b5b50919050565b5f819050815f5260205f209050919050565b5f6020601f8301049050919050565b5f82821b905092915050565b5f600883026101a97fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff8261016e565b6101b3868361016e565b95508019841693508086168417925050509392505050565b5f819050919050565b5f819050919050565b5f6101f76101f26101ed846101cb565b6101d4565b6101cb565b9050919050565b5f819050919050565b610210836101dd565b61022461021c826101fe565b84845461017a565b825550505050565b5f5f905090565b61023b61022c565b610246818484610207565b505050565b5b818110156102695761025e5f82610233565b60018101905061024c565b5050565b601f8211156102ae5761027f8161014d565b6102888461015f565b81016020851015610297578190505b6102ab6102a38561015f565b83018261024b565b50505b505050565b5f82821c905092915050565b5f6102ce5f19846008026102b3565b1980831691505092915050565b5f6102e683836102bf565b9150826002028217905092915050565b6102ff826100b9565b67ffffffffffffffff811115610318576103176100c3565b5b610322825461011d565b61032d82828561026d565b5f60209050601f83116001811461035e575f841561034c578287015190505b61035685826102db565b8655506103bd565b601f19841661036c8661014d565b5f5b828110156103935784890151825560018201915060208501945060208101905061036e565b868310156103b057848901516103ac601f8916826102bf565b8355505b6001600288020188555050505b505050505050565b610e2e806103d25f395ff3fe60806040526004361061009f575f3560e01c8063313ce56711610063578063313ce5671461019e57806370a08231146101c857806395d89b4114610204578063a9059cbb1461022e578063d0e30db01461026a578063dd62ed3e14610274576100a0565b806306fdde03146100aa578063095ea7b3146100d457806318160ddd1461011057806323b872dd1461013a5780632e1a7d4d14610176576100a0565b5b6100a86102b0565b005b3480156100b5575f5ffd5b506100be610353565b6040516100cb9190610aa6565b60405180910390f35b3480156100df575f5ffd5b506100fa60048036038101906100f59190610b57565b6103de565b6040516101079190610baf565b60405180910390f35b34801561011b575f5ffd5b506101246104cb565b6040516101319190610bd7565b60405180910390f35b348015610145575f5ffd5b50610160600480360381019061015b9190610bf0565b6104d2565b60405161016d9190610baf565b60405180910390f35b348015610181575f5ffd5b5061019c60048036038101906101979190610c40565b61081e565b005b3480156101a9575f5ffd5b506101b261094f565b6040516101bf9190610c86565b60405180910390f35b3480156101d3575f5ffd5b506101ee60048036038101906101e99190610c9f565b610961565b6040516101fb9190610bd7565b60405180910390f35b34801561020f575f5ffd5b50610218610976565b6040516102259190610aa6565b60405180910390f35b348015610239575f5ffd5b50610254600480360381019061024f9190610b57565b610a02565b6040516102619190610baf565b60405180910390f35b6102726102b0565b005b34801561027f575f5ffd5b5061029a60048036038101906102959190610cca565b610a16565b6040516102a79190610bd7565b60405180910390f35b3460035f3373ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff1681526020019081526020015f205f8282546102fc9190610d35565b925050819055503373ffffffffffffffffffffffffffffffffffffffff167fe1fffcc4923d04b559f4d29a8bfc6cda04eb5b0d3c460751c2402c5c5cc9109c346040516103499190610bd7565b60405180910390a2565b5f805461035f90610d95565b80601f016020809104026020016040519081016040528092919081815260200182805461038b90610d95565b80156103d65780601f106103ad576101008083540402835291602001916103d6565b820191905f5260205f20905b8154815290600101906020018083116103b957829003601f168201915b505050505081565b5f8160045f3373ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff1681526020019081526020015f205f8573ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff1681526020019081526020015f20819055508273ffffffffffffffffffffffffffffffffffffffff163373ffffffffffffffffffffffffffffffffffffffff167f8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925846040516104b99190610bd7565b60405180910390a36001905092915050565b5f47905090565b5f8160035f8673ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff1681526020019081526020015f2054101561051c575f5ffd5b3373ffffffffffffffffffffffffffffffffffffffff168473ffffffffffffffffffffffffffffffffffffffff16141580156105f057507fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff60045f8673ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff1681526020019081526020015f205f3373ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff1681526020019081526020015f205414155b15610708578160045f8673ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff1681526020019081526020015f205f3373ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff1681526020019081526020015f20541015610679575f5ffd5b8160045f8673ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff1681526020019081526020015f205f3373ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff1681526020019081526020015f205f8282546107009190610dc5565b925050819055505b8160035f8673ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff1681526020019081526020015f205f8282546107549190610dc5565b925050819055508160035f8573ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff1681526020019081526020015f205f8282546107a79190610d35565b925050819055508273ffffffffffffffffffffffffffffffffffffffff168473ffffffffffffffffffffffffffffffffffffffff167fddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef8460405161080b9190610bd7565b60405180910390a3600190509392505050565b8060035f3373ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff1681526020019081526020015f20541015610867575f5ffd5b8060035f3373ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff1681526020019081526020015f205f8282546108b39190610dc5565b925050819055503373ffffffffffffffffffffffffffffffffffffffff166108fc8290811502906040515f60405180830381858888f193505050501580156108fd573d5f5f3e3d5ffd5b503373ffffffffffffffffffffffffffffffffffffffff167f7fcf532c15f0a6db0bd6d0e038bea71d30d808c7d98cb3bf7268a95bf5081b65826040516109449190610bd7565b60405180910390a250565b60025f9054906101000a900460ff1681565b6003602052805f5260405f205f915090505481565b6001805461098390610d95565b80601f01602080910402602001604051908101604052809291908181526020018280546109af90610d95565b80156109fa5780601f106109d1576101008083540402835291602001916109fa565b820191905f5260205f20905b8154815290600101906020018083116109dd57829003601f168201915b505050505081565b5f610a0e3384846104d2565b905092915050565b6004602052815f5260405f20602052805f5260405f205f91509150505481565b5f81519050919050565b5f82825260208201905092915050565b8281835e5f83830152505050565b5f601f19601f8301169050919050565b5f610a7882610a36565b610a828185610a40565b9350610a92818560208601610a50565b610a9b81610a5e565b840191505092915050565b5f6020820190508181035f830152610abe8184610a6e565b905092915050565b5f5ffd5b5f73ffffffffffffffffffffffffffffffffffffffff82169050919050565b5f610af382610aca565b9050919050565b610b0381610ae9565b8114610b0d575f5ffd5b50565b5f81359050610b1e81610afa565b92915050565b5f819050919050565b610b3681610b24565b8114610b40575f5ffd5b50565b5f81359050610b5181610b2d565b92915050565b5f5f60408385031215610b6d57610b6c610ac6565b5b5f610b7a85828601610b10565b9250506020610b8b85828601610b43565b9150509250929050565b5f8115159050919050565b610ba981610b95565b82525050565b5f602082019050610bc25f830184610ba0565b92915050565b610bd181610b24565b82525050565b5f602082019050610bea5f830184610bc8565b92915050565b5f5f5f60608486031215610c0757610c06610ac6565b5b5f610c1486828701610b10565b9350506020610c2586828701610b10565b9250506040610c3686828701610b43565b9150509250925092565b5f60208284031215610c5557610c54610ac6565b5b5f610c6284828501610b43565b91505092915050565b5f60ff82169050919050565b610c8081610c6b565b82525050565b5f602082019050610c995f830184610c77565b92915050565b5f60208284031215610cb457610cb3610ac6565b5b5f610cc184828501610b10565b91505092915050565b5f5f60408385031215610ce057610cdf610ac6565b5b5f610ced85828601610b10565b9250506020610cfe85828601610b10565b9150509250929050565b7f4e487b71000000000000000000000000000000000000000000000000000000005f52601160045260245ffd5b5f610d3f82610b24565b9150610d4a83610b24565b9250828201905080821115610d6257610d61610d08565b5b92915050565b7f4e487b71000000000000000000000000000000000000000000000000000000005f52602260045260245ffd5b5f6002820490506001821680610dac57607f821691505b602082108103610dbf57610dbe610d68565b5b50919050565b5f610dcf82610b24565b9150610dda83610b24565b9250828203905081811115610df257610df1610d08565b5b9291505056fea26469706673582212203f97a196ddc37afb11932f200b313b0c7f3192231076f69a36adf1a05327eaf664736f6c634300081c0033 | ¨È | 2 | 1765540834 | } | } | 0x16806b014167d2f26ef1b08e6d4c4bab6580f569 | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||
| enriched_transaction_v2_0x818791a54586c839a33f0a8eb0ba9ef3cbffddc2b6774678bfa35a3e229f7c92_0 | 0x12633f3ba69fbe89f393702862727dec169765fe4b76306de5ded5522f218ea7 | 22 | 0x818791a54586c839a33f0a8eb0ba9ef3cbffddc2b6774678bfa35a3e229f7c92 | 170666 | 0 | 0x1111111111111111111111111111111111111111 | 0x4100000000000000000000000000000000000000 | X | 0x3cf80e6c | null | null | 0 | 1765860550 | Ø | Ø | 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 |