Enriched Transactions
Chain
BasecampDataset name
basecamp.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_0xba4e9223a4ceac4d356e183518788ec2921e56bd9666a6c33949428e6f078301_0 | 0x211e07c5595ade3dc66abd99428d756b011e569399e4fb44693fc2053ab0b2fe | 1 | 0xba4e9223a4ceac4d356e183518788ec2921e56bd9666a6c33949428e6f078301 | 202832 | 0 | 0xd1f240f1188f78195a23a3e5a69697235a5ca75e | 0x071a42ffda69d5de326d9cdf1b664dfa43edb83a | 0 | 0 | 0x | 0 | 0 | 2 | 1738961553 | 0 | 0 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0xea00b7aaa70e01768bfbfed043d9aeaa5408214e2e85f4fc4ad7ecbe6fcfb4a3_0 | 0x9b28a6bed2e0e06902aa9567f3d9198f3169829347bcb6fb1b977ca778b27e9f | 1 | 0xea00b7aaa70e01768bfbfed043d9aeaa5408214e2e85f4fc4ad7ecbe6fcfb4a3 | 204222 | 0 | 0x071a42ffda69d5de326d9cdf1b664dfa43edb83a | 0x0d41fad9751b207fa8f2594f42401d34905db77f | 0 | 0 | 0 | 0x | 0 | 0 | 2 | 1738962943 | 0 | 0 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null |
| enriched_transaction_v2_0xdf9b0ca1f68793805c267829de6ffd98de9431de8f67d9a347445569fab791b0_0 | 0x8b13b34d8d4c3b699971f8356a282b80074514d990115b229092c21dcc28cebf | 2 | 0xdf9b0ca1f68793805c267829de6ffd98de9431de8f67d9a347445569fab791b0 | 211930 | 0 | 0x071a42ffda69d5de326d9cdf1b664dfa43edb83a | null | 0 | 0 | 0x608060405234801561001057600080fd5b506040518060400160405280600781526020016610d85b5c13999d60ca1b8152506040518060400160405280600781526020016610d0535413919560ca1b8152508160009081610060919061011b565b50600161006d828261011b565b50506000600655506101da565b634e487b7160e01b600052604160045260246000fd5b600181811c908216806100a457607f821691505b6020821081036100c457634e487b7160e01b600052602260045260246000fd5b50919050565b601f821115610116576000816000526020600020601f850160051c810160208610156100f35750805b601f850160051c820191505b81811015610112578281556001016100ff565b5050505b505050565b81516001600160401b038111156101345761013461007a565b610148816101428454610090565b846100ca565b602080601f83116001811461017d57600084156101655750858301515b600019600386901b1c1916600185901b178555610112565b600085815260208120601f198616915b828110156101ac5788860151825594840194600190910190840161018d565b50858210156101ca5787850151600019600388901b60f8161c191681555b5050505050600190811b01905550565b611004806101e96000396000f3fe608060405234801561001057600080fd5b50600436106100f55760003560e01c80636a62784211610097578063b88d4fde11610066578063b88d4fde146101ff578063c87b56dd14610212578063d082e38114610225578063e985e9c51461022e57600080fd5b80636a627842146101b057806370a08231146101c357806395d89b41146101e4578063a22cb465146101ec57600080fd5b8063095ea7b3116100d3578063095ea7b31461016257806323b872dd1461017757806342842e0e1461018a5780636352211e1461019d57600080fd5b806301ffc9a7146100fa57806306fdde0314610122578063081812fc14610137575b600080fd5b61010d610108366004610c4d565b610241565b60405190151581526020015b60405180910390f35b61012a610293565b6040516101199190610cba565b61014a610145366004610ccd565b610325565b6040516001600160a01b039091168152602001610119565b610175610170366004610d02565b61034e565b005b610175610185366004610d2c565b61035d565b610175610198366004610d2c565b6103ed565b61014a6101ab366004610ccd565b61040d565b6101756101be366004610d68565b610418565b6101d66101d1366004610d68565b61043c565b604051908152602001610119565b61012a610484565b6101756101fa366004610d83565b610493565b61017561020d366004610dd5565b61049e565b61012a610220366004610ccd565b6104b6565b6101d660065481565b61010d61023c366004610eb1565b61052b565b60006001600160e01b031982166380ac58cd60e01b148061027257506001600160e01b03198216635b5e139f60e01b145b8061028d57506301ffc9a760e01b6001600160e01b03198316145b92915050565b6060600080546102a290610ee4565b80601f01602080910402602001604051908101604052809291908181526020018280546102ce90610ee4565b801561031b5780601f106102f05761010080835404028352916020019161031b565b820191906000526020600020905b8154815290600101906020018083116102fe57829003601f168201915b5050505050905090565b600061033082610559565b506000828152600460205260409020546001600160a01b031661028d565b610359828233610592565b5050565b6001600160a01b03821661038c57604051633250574960e11b8152600060048201526024015b60405180910390fd5b600061039983833361059f565b9050836001600160a01b0316816001600160a01b0316146103e7576040516364283d7b60e01b81526001600160a01b0380861660048301526024820184905282166044820152606401610383565b50505050565b6104088383836040518060200160405280600081525061049e565b505050565b600061028d82610559565b61042481600654610698565b6006805490600061043483610f1e565b919050555050565b60006001600160a01b038216610468576040516322718ad960e21b815260006004820152602401610383565b506001600160a01b031660009081526003602052604090205490565b6060600180546102a290610ee4565b6103593383836106b2565b6104a984848461035d565b6103e73385858585610751565b60606104c182610559565b5060006104d960408051602081019091526000815290565b905060008151116104f95760405180602001604052806000815250610524565b806105038461087c565b604051602001610514929190610f45565b6040516020818303038152906040525b9392505050565b6001600160a01b03918216600090815260056020908152604080832093909416825291909152205460ff1690565b6000818152600260205260408120546001600160a01b03168061028d57604051637e27328960e01b815260048101849052602401610383565b610408838383600161090f565b6000828152600260205260408120546001600160a01b03908116908316156105cc576105cc818486610a15565b6001600160a01b0381161561060a576105e960008560008061090f565b6001600160a01b038116600090815260036020526040902080546000190190555b6001600160a01b03851615610639576001600160a01b0385166000908152600360205260409020805460010190555b60008481526002602052604080822080546001600160a01b0319166001600160a01b0389811691821790925591518793918516917fddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef91a4949350505050565b610359828260405180602001604052806000815250610a79565b6001600160a01b0382166106e457604051630b61174360e31b81526001600160a01b0383166004820152602401610383565b6001600160a01b03838116600081815260056020908152604080832094871680845294825291829020805460ff191686151590811790915591519182527f17307eab39ab6107e8899845ad3d59bd9653f200f220920489ca2b5937696c31910160405180910390a3505050565b6001600160a01b0383163b1561087557604051630a85bd0160e11b81526001600160a01b0384169063150b7a0290610793908890889087908790600401610f74565b6020604051808303816000875af19250505080156107ce575060408051601f3d908101601f191682019092526107cb91810190610fb1565b60015b610837573d8080156107fc576040519150601f19603f3d011682016040523d82523d6000602084013e610801565b606091505b50805160000361082f57604051633250574960e11b81526001600160a01b0385166004820152602401610383565b805181602001fd5b6001600160e01b03198116630a85bd0160e11b1461087357604051633250574960e11b81526001600160a01b0385166004820152602401610383565b505b5050505050565b6060600061088983610a91565b600101905060008167ffffffffffffffff8111156108a9576108a9610dbf565b6040519080825280601f01601f1916602001820160405280156108d3576020820181803683370190505b5090508181016020015b600019016f181899199a1a9b1b9c1cb0b131b232b360811b600a86061a8153600a85049450846108dd57509392505050565b808061092357506001600160a01b03821615155b156109e557600061093384610559565b90506001600160a01b0383161580159061095f5750826001600160a01b0316816001600160a01b031614155b80156109725750610970818461052b565b155b1561099b5760405163a9fbf51f60e01b81526001600160a01b0384166004820152602401610383565b81156109e35783856001600160a01b0316826001600160a01b03167f8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b92560405160405180910390a45b505b5050600090815260046020526040902080546001600160a01b0319166001600160a01b0392909216919091179055565b610a20838383610b69565b610408576001600160a01b038316610a4e57604051637e27328960e01b815260048101829052602401610383565b60405163177e802f60e01b81526001600160a01b038316600482015260248101829052604401610383565b610a838383610bcf565b610408336000858585610751565b60008072184f03e93ff9f4daa797ed6e38ed64bf6a1f0160401b8310610ad05772184f03e93ff9f4daa797ed6e38ed64bf6a1f0160401b830492506040015b6d04ee2d6d415b85acef81000000008310610afc576d04ee2d6d415b85acef8100000000830492506020015b662386f26fc100008310610b1a57662386f26fc10000830492506010015b6305f5e1008310610b32576305f5e100830492506008015b6127108310610b4657612710830492506004015b60648310610b58576064830492506002015b600a831061028d5760010192915050565b60006001600160a01b03831615801590610bc75750826001600160a01b0316846001600160a01b03161480610ba35750610ba3848461052b565b80610bc757506000828152600460205260409020546001600160a01b038481169116145b949350505050565b6001600160a01b038216610bf957604051633250574960e11b815260006004820152602401610383565b6000610c078383600061059f565b90506001600160a01b03811615610408576040516339e3563760e11b815260006004820152602401610383565b6001600160e01b031981168114610c4a57600080fd5b50565b600060208284031215610c5f57600080fd5b813561052481610c34565b60005b83811015610c85578181015183820152602001610c6d565b50506000910152565b60008151808452610ca6816020860160208601610c6a565b601f01601f19169290920160200192915050565b6020815260006105246020830184610c8e565b600060208284031215610cdf57600080fd5b5035919050565b80356001600160a01b0381168114610cfd57600080fd5b919050565b60008060408385031215610d1557600080fd5b610d1e83610ce6565b946020939093013593505050565b600080600060608486031215610d4157600080fd5b610d4a84610ce6565b9250610d5860208501610ce6565b9150604084013590509250925092565b600060208284031215610d7a57600080fd5b61052482610ce6565b60008060408385031215610d9657600080fd5b610d9f83610ce6565b915060208301358015158114610db457600080fd5b809150509250929050565b634e487b7160e01b600052604160045260246000fd5b60008060008060808587031215610deb57600080fd5b610df485610ce6565b9350610e0260208601610ce6565b925060408501359150606085013567ffffffffffffffff80821115610e2657600080fd5b818701915087601f830112610e3a57600080fd5b813581811115610e4c57610e4c610dbf565b604051601f8201601f19908116603f01168101908382118183101715610e7457610e74610dbf565b816040528281528a6020848701011115610e8d57600080fd5b82602086016020830137600060208483010152809550505050505092959194509250565b60008060408385031215610ec457600080fd5b610ecd83610ce6565b9150610edb60208401610ce6565b90509250929050565b600181811c90821680610ef857607f821691505b602082108103610f1857634e487b7160e01b600052602260045260246000fd5b50919050565b600060018201610f3e57634e487b7160e01b600052601160045260246000fd5b5060010190565b60008351610f57818460208801610c6a565b835190830190610f6b818360208801610c6a565b01949350505050565b6001600160a01b0385811682528416602082015260408101839052608060608201819052600090610fa790830184610c8e565b9695505050505050565b600060208284031215610fc357600080fd5b815161052481610c3456fea264697066735822122084822ea5426a3cb5cf55deb28aff9f82e4f4a066754dcdc343048785a6a8eba364736f6c63430008190033 | null | null | 0 | 1738970651 | 0 | 0 | 0xa0f248a19c6e236f7b2bf76f77d4e25b459dbcdd | 1 | 0 | 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 |