Enriched Transactions
Chain
PlasmaDataset name
plasma.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_0xe540c975d924087164ec4dc3a3eef57b341a903e2fd47e11ac49674af6f8e0b5_0 | 0x7f23519c82601a78a1852275ed4ffb3ff95ec1ca7fcd2dc9c163778caa720d59 | 0 | 0xe540c975d924087164ec4dc3a3eef57b341a903e2fd47e11ac49674af6f8e0b5 | 224593 | 0 | 0xbd828f7679656f8f830b89611c933017442f2ebf | 0xe7ce761950249434e651b0e04645ee01fea34c99 | R | ;Ê | 0x | ;Ê | ;Ê | 2 | 1748520583 | R | R | null | 1 | ;Ê | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0x8367a19225cb40e5354ebfb18966f7fc3fe0c379810ca0631d29fbc84971d0b8_0 | 0x8245ee1cc74fdcf679e70d8b10dff59a502e5ea2da55007ba95974ef0267b4aa | 0 | 0x8367a19225cb40e5354ebfb18966f7fc3fe0c379810ca0631d29fbc84971d0b8 | 252544 | 0 | 0xf895f7d6a8ef09c49c1f0d7127869b689304a1a0 | 0x5fa107f6859eaf33d33031b79c0965480b455428 | EcDô | R | ;Ê | 0x | ;Ê | ;Ê | 2 | 1748550590 | R | R | null | 1 | ;Ê | null | null | null | null | null | null | null | null | null | null | null | null | null | null |
| enriched_transaction_v2_0xff7f48d56cbcfa006cd447e201796f9ead2cff103285de0ae838ecd38a7236d4_0 | 0x9e4a0dc754b28f886001d19adc3ef9d2864e9836c37efd92e60ee894fd4d5ca7 | 1 | 0xff7f48d56cbcfa006cd447e201796f9ead2cff103285de0ae838ecd38a7236d4 | 253131 | 0 | 0xf895f7d6a8ef09c49c1f0d7127869b689304a1a0 | null | ü) | ;Ê | 0x608060405234801561001057600080fd5b50336040518060400160405280600581526020017f55534454300000000000000000000000000000000000000000000000000000008152506040518060400160405280600581526020017f5553445430000000000000000000000000000000000000000000000000000000815250816003908161008d919061072b565b50806004908161009d919061072b565b505050600073ffffffffffffffffffffffffffffffffffffffff168173ffffffffffffffffffffffffffffffffffffffff16036101125760006040517f1e4fbdf7000000000000000000000000000000000000000000000000000000008152600401610109919061083e565b60405180910390fd5b6101218161015f60201b60201c565b5061015a3361013461022560201b60201c565b600a61014091906109c8565b6305f5e10061014f9190610a13565b61022e60201b60201c565b610aea565b6000600560009054906101000a900473ffffffffffffffffffffffffffffffffffffffff16905081600560006101000a81548173ffffffffffffffffffffffffffffffffffffffff021916908373ffffffffffffffffffffffffffffffffffffffff1602179055508173ffffffffffffffffffffffffffffffffffffffff168173ffffffffffffffffffffffffffffffffffffffff167f8be0079c531659141344cd1fd0a4f28419497f9722a3daafe3b4186f6b6457e060405160405180910390a35050565b60006006905090565b600073ffffffffffffffffffffffffffffffffffffffff168273ffffffffffffffffffffffffffffffffffffffff16036102a05760006040517fec442f05000000000000000000000000000000000000000000000000000000008152600401610297919061083e565b60405180910390fd5b6102b2600083836102b660201b60201c565b5050565b600073ffffffffffffffffffffffffffffffffffffffff168373ffffffffffffffffffffffffffffffffffffffff16036103085780600260008282546102fc9190610a55565b925050819055506103db565b60008060008573ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff16815260200190815260200160002054905081811015610394578381836040517fe450d38c00000000000000000000000000000000000000000000000000000000815260040161038b93929190610a98565b60405180910390fd5b8181036000808673ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff16815260200190815260200160002081905550505b600073ffffffffffffffffffffffffffffffffffffffff168273ffffffffffffffffffffffffffffffffffffffff16036104245780600260008282540392505081905550610471565b806000808473ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff168152602001908152602001600020600082825401925050819055505b8173ffffffffffffffffffffffffffffffffffffffff168373ffffffffffffffffffffffffffffffffffffffff167fddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef836040516104ce9190610acf565b60405180910390a3505050565b600081519050919050565b7f4e487b7100000000000000000000000000000000000000000000000000000000600052604160045260246000fd5b7f4e487b7100000000000000000000000000000000000000000000000000000000600052602260045260246000fd5b6000600282049050600182168061055c57607f821691505b60208210810361056f5761056e610515565b5b50919050565b60008190508160005260206000209050919050565b60006020601f8301049050919050565b600082821b905092915050565b6000600883026105d77fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff8261059a565b6105e1868361059a565b95508019841693508086168417925050509392505050565b6000819050919050565b6000819050919050565b600061062861062361061e846105f9565b610603565b6105f9565b9050919050565b6000819050919050565b6106428361060d565b61065661064e8261062f565b8484546105a7565b825550505050565b600090565b61066b61065e565b610676818484610639565b505050565b5b8181101561069a5761068f600082610663565b60018101905061067c565b5050565b601f8211156106df576106b081610575565b6106b98461058a565b810160208510156106c8578190505b6106dc6106d48561058a565b83018261067b565b50505b505050565b600082821c905092915050565b6000610702600019846008026106e4565b1980831691505092915050565b600061071b83836106f1565b9150826002028217905092915050565b610734826104db565b67ffffffffffffffff81111561074d5761074c6104e6565b5b6107578254610544565b61076282828561069e565b600060209050601f8311600181146107955760008415610783578287015190505b61078d858261070f565b8655506107f5565b601f1984166107a386610575565b60005b828110156107cb578489015182556001820191506020850194506020810190506107a6565b868310156107e857848901516107e4601f8916826106f1565b8355505b6001600288020188555050505b505050505050565b600073ffffffffffffffffffffffffffffffffffffffff82169050919050565b6000610828826107fd565b9050919050565b6108388161081d565b82525050565b6000602082019050610853600083018461082f565b92915050565b7f4e487b7100000000000000000000000000000000000000000000000000000000600052601160045260246000fd5b60008160011c9050919050565b6000808291508390505b60018511156108df578086048111156108bb576108ba610859565b5b60018516156108ca5780820291505b80810290506108d885610888565b945061089f565b94509492505050565b6000826108f857600190506109b4565b8161090657600090506109b4565b816001811461091c576002811461092657610955565b60019150506109b4565b60ff84111561093857610937610859565b5b8360020a91508482111561094f5761094e610859565b5b506109b4565b5060208310610133831016604e8410600b841016171561098a5782820a90508381111561098557610984610859565b5b6109b4565b6109978484846001610895565b925090508184048111156109ae576109ad610859565b5b81810290505b9392505050565b600060ff82169050919050565b60006109d3826105f9565b91506109de836109bb565b9250610a0b7fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff84846108e8565b905092915050565b6000610a1e826105f9565b9150610a29836105f9565b9250828202610a37816105f9565b91508282048414831517610a4e57610a4d610859565b5b5092915050565b6000610a60826105f9565b9150610a6b836105f9565b9250828201905080821115610a8357610a82610859565b5b92915050565b610a92816105f9565b82525050565b6000606082019050610aad600083018661082f565b610aba6020830185610a89565b610ac76040830184610a89565b949350505050565b6000602082019050610ae46000830184610a89565b92915050565b61128e80610af96000396000f3fe608060405234801561001057600080fd5b50600436106100ea5760003560e01c806370a082311161008c57806395d89b411161006657806395d89b4114610239578063a9059cbb14610257578063dd62ed3e14610287578063f2fde38b146102b7576100ea565b806370a08231146101e1578063715018a6146102115780638da5cb5b1461021b576100ea565b806323b872dd116100c857806323b872dd1461015b578063313ce5671461018b57806340c10f19146101a957806342966c68146101c5576100ea565b806306fdde03146100ef578063095ea7b31461010d57806318160ddd1461013d575b600080fd5b6100f76102d3565b6040516101049190610eb5565b60405180910390f35b61012760048036038101906101229190610f70565b610365565b6040516101349190610fcb565b60405180910390f35b610145610388565b6040516101529190610ff5565b60405180910390f35b61017560048036038101906101709190611010565b610392565b6040516101829190610fcb565b60405180910390f35b6101936103c1565b6040516101a0919061107f565b60405180910390f35b6101c360048036038101906101be9190610f70565b6103ca565b005b6101df60048036038101906101da919061109a565b6103e0565b005b6101fb60048036038101906101f691906110c7565b6103ed565b6040516102089190610ff5565b60405180910390f35b610219610435565b005b610223610449565b6040516102309190611103565b60405180910390f35b610241610473565b60405161024e9190610eb5565b60405180910390f35b610271600480360381019061026c9190610f70565b610505565b60405161027e9190610fcb565b60405180910390f35b6102a1600480360381019061029c919061111e565b610528565b6040516102ae9190610ff5565b60405180910390f35b6102d160048036038101906102cc91906110c7565b6105af565b005b6060600380546102e29061118d565b80601f016020809104026020016040519081016040528092919081815260200182805461030e9061118d565b801561035b5780601f106103305761010080835404028352916020019161035b565b820191906000526020600020905b81548152906001019060200180831161033e57829003601f168201915b5050505050905090565b600080610370610635565b905061037d81858561063d565b600191505092915050565b6000600254905090565b60008061039d610635565b90506103aa85828561064f565b6103b58585856106e4565b60019150509392505050565b60006006905090565b6103d26107d8565b6103dc828261085f565b5050565b6103ea33826108e1565b50565b60008060008373ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff168152602001908152602001600020549050919050565b61043d6107d8565b6104476000610963565b565b6000600560009054906101000a900473ffffffffffffffffffffffffffffffffffffffff16905090565b6060600480546104829061118d565b80601f01602080910402602001604051908101604052809291908181526020018280546104ae9061118d565b80156104fb5780601f106104d0576101008083540402835291602001916104fb565b820191906000526020600020905b8154815290600101906020018083116104de57829003601f168201915b5050505050905090565b600080610510610635565b905061051d8185856106e4565b600191505092915050565b6000600160008473ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff16815260200190815260200160002060008373ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff16815260200190815260200160002054905092915050565b6105b76107d8565b600073ffffffffffffffffffffffffffffffffffffffff168173ffffffffffffffffffffffffffffffffffffffff16036106295760006040517f1e4fbdf70000000000000000000000000000000000000000000000000000000081526004016106209190611103565b60405180910390fd5b61063281610963565b50565b600033905090565b61064a8383836001610a29565b505050565b600061065b8484610528565b90507fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff8110156106de57818110156106ce578281836040517ffb8f41b20000000000000000000000000000000000000000000000000000000081526004016106c5939291906111be565b60405180910390fd5b6106dd84848484036000610a29565b5b50505050565b600073ffffffffffffffffffffffffffffffffffffffff168373ffffffffffffffffffffffffffffffffffffffff16036107565760006040517f96c6fd1e00000000000000000000000000000000000000000000000000000000815260040161074d9190611103565b60405180910390fd5b600073ffffffffffffffffffffffffffffffffffffffff168273ffffffffffffffffffffffffffffffffffffffff16036107c85760006040517fec442f050000000000000000000000000000000000000000000000000000000081526004016107bf9190611103565b60405180910390fd5b6107d3838383610c00565b505050565b6107e0610635565b73ffffffffffffffffffffffffffffffffffffffff166107fe610449565b73ffffffffffffffffffffffffffffffffffffffff161461085d57610821610635565b6040517f118cdaa70000000000000000000000000000000000000000000000000000000081526004016108549190611103565b60405180910390fd5b565b600073ffffffffffffffffffffffffffffffffffffffff168273ffffffffffffffffffffffffffffffffffffffff16036108d15760006040517fec442f050000000000000000000000000000000000000000000000000000000081526004016108c89190611103565b60405180910390fd5b6108dd60008383610c00565b5050565b600073ffffffffffffffffffffffffffffffffffffffff168273ffffffffffffffffffffffffffffffffffffffff16036109535760006040517f96c6fd1e00000000000000000000000000000000000000000000000000000000815260040161094a9190611103565b60405180910390fd5b61095f82600083610c00565b5050565b6000600560009054906101000a900473ffffffffffffffffffffffffffffffffffffffff16905081600560006101000a81548173ffffffffffffffffffffffffffffffffffffffff021916908373ffffffffffffffffffffffffffffffffffffffff1602179055508173ffffffffffffffffffffffffffffffffffffffff168173ffffffffffffffffffffffffffffffffffffffff167f8be0079c531659141344cd1fd0a4f28419497f9722a3daafe3b4186f6b6457e060405160405180910390a35050565b600073ffffffffffffffffffffffffffffffffffffffff168473ffffffffffffffffffffffffffffffffffffffff1603610a9b5760006040517fe602df05000000000000000000000000000000000000000000000000000000008152600401610a929190611103565b60405180910390fd5b600073ffffffffffffffffffffffffffffffffffffffff168373ffffffffffffffffffffffffffffffffffffffff1603610b0d5760006040517f94280d62000000000000000000000000000000000000000000000000000000008152600401610b049190611103565b60405180910390fd5b81600160008673ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff16815260200190815260200160002060008573ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff168152602001908152602001600020819055508015610bfa578273ffffffffffffffffffffffffffffffffffffffff168473ffffffffffffffffffffffffffffffffffffffff167f8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b92584604051610bf19190610ff5565b60405180910390a35b50505050565b600073ffffffffffffffffffffffffffffffffffffffff168373ffffffffffffffffffffffffffffffffffffffff1603610c52578060026000828254610c469190611224565b92505081905550610d25565b60008060008573ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff16815260200190815260200160002054905081811015610cde578381836040517fe450d38c000000000000000000000000000000000000000000000000000000008152600401610cd5939291906111be565b60405180910390fd5b8181036000808673ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff16815260200190815260200160002081905550505b600073ffffffffffffffffffffffffffffffffffffffff168273ffffffffffffffffffffffffffffffffffffffff1603610d6e5780600260008282540392505081905550610dbb565b806000808473ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff168152602001908152602001600020600082825401925050819055505b8173ffffffffffffffffffffffffffffffffffffffff168373ffffffffffffffffffffffffffffffffffffffff167fddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef83604051610e189190610ff5565b60405180910390a3505050565b600081519050919050565b600082825260208201905092915050565b60005b83811015610e5f578082015181840152602081019050610e44565b60008484015250505050565b6000601f19601f8301169050919050565b6000610e8782610e25565b610e918185610e30565b9350610ea1818560208601610e41565b610eaa81610e6b565b840191505092915050565b60006020820190508181036000830152610ecf8184610e7c565b905092915050565b600080fd5b600073ffffffffffffffffffffffffffffffffffffffff82169050919050565b6000610f0782610edc565b9050919050565b610f1781610efc565b8114610f2257600080fd5b50565b600081359050610f3481610f0e565b92915050565b6000819050919050565b610f4d81610f3a565b8114610f5857600080fd5b50565b600081359050610f6a81610f44565b92915050565b60008060408385031215610f8757610f86610ed7565b5b6000610f9585828601610f25565b9250506020610fa685828601610f5b565b9150509250929050565b60008115159050919050565b610fc581610fb0565b82525050565b6000602082019050610fe06000830184610fbc565b92915050565b610fef81610f3a565b82525050565b600060208201905061100a6000830184610fe6565b92915050565b60008060006060848603121561102957611028610ed7565b5b600061103786828701610f25565b935050602061104886828701610f25565b925050604061105986828701610f5b565b9150509250925092565b600060ff82169050919050565b61107981611063565b82525050565b60006020820190506110946000830184611070565b92915050565b6000602082840312156110b0576110af610ed7565b5b60006110be84828501610f5b565b91505092915050565b6000602082840312156110dd576110dc610ed7565b5b60006110eb84828501610f25565b91505092915050565b6110fd81610efc565b82525050565b600060208201905061111860008301846110f4565b92915050565b6000806040838503121561113557611134610ed7565b5b600061114385828601610f25565b925050602061115485828601610f25565b9150509250929050565b7f4e487b7100000000000000000000000000000000000000000000000000000000600052602260045260246000fd5b600060028204905060018216806111a557607f821691505b6020821081036111b8576111b761115e565b5b50919050565b60006060820190506111d360008301866110f4565b6111e06020830185610fe6565b6111ed6040830184610fe6565b949350505050565b7f4e487b7100000000000000000000000000000000000000000000000000000000600052601160045260246000fd5b600061122f82610f3a565b915061123a83610f3a565b9250828201905080821115611252576112516111f5565b5b9291505056fea264697066735822122006083fa6b0da5a2891b35f2efbf772aca530bee49944d78f889401a7c5cbe6a164736f6c634300081c0033 | ;Ê | ;Ê | 2 | 1748551221 | Ñ^ | Ñ^ | 0x3ed69e5354ae6e0965cfda9287ccbf2c980ea48d | 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 |