Enriched Transactions
Chain
Plume MainnetDataset name
plume_mainnet.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_0x718e1d77b65b0f185d80b79c0228d04852719e374b5078f2fcb3477761c3d038_1 | 0x72ea2b1a3d8fe6c7290c21921d9b5bd2e43ba640285cd4ff1332dbd290d63f3d | 7 | 0x718e1d77b65b0f185d80b79c0228d04852719e374b5078f2fcb3477761c3d038 | 13 | 1 | 0x5ec32984332eab190ca431545664320259d755d8 | 0xbec4e65d9337b6eb5a135044f351f742da8c68c4 | 0 | 0x36568abed8aa0f3194971a2a116679f7c2090f6939c8d4e01a2a8d7e41d55e5351469e630000000000000000000000005ec32984332eab190ca431545664320259d755d8 | 0 | 0 | 2 | 1740050172 | 0 | 0 | null | 1 | null | null | null | null | null | null | null | null | 21887212 | null | null | null | null | ||||
| enriched_transaction_v2_0x5d94e7c21a412c96c58eb3864598ec6b719a51a4c26782ea6b044a4b98335037_0 | 0x676954f3a5d68038008ff446ca317919d749dda94bf4177cd0a328bb52bba614 | 0 | 0x5d94e7c21a412c96c58eb3864598ec6b719a51a4c26782ea6b044a4b98335037 | 19 | 0 | 0x00000000000000000000000000000000000a4b05 | 0x00000000000000000000000000000000000a4b05 | 0x6bf6a42d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014e7ddf0000000000000000000000000000000000000000000000000000000000000013000000000000000000000000000000000000000000000000000000000000017a | null | null | 106 | 1740461223 | null | 1 | null | null | null | null | null | null | null | null | 21921247 | null | null | null | null | |||||||
| enriched_transaction_v2_0x664323a4f6259556029cc8384a13842ee9afbd33b21eafc5ea034466adb7c9ab_1 | 0x71af33ed78f128a244b4a49ce71a532e1bc465d20a30bab12583375fde5db7df | 6 | 0x664323a4f6259556029cc8384a13842ee9afbd33b21eafc5ea034466adb7c9ab | 23 | 1 | 0x9f403140bc0574d7d36ea472b82daa1bbd4ef327 | null | 0 | 0x608060405234801561001057600080fd5b50610d32806100206000396000f3fe608060405234801561001057600080fd5b506004361061007d5760003560e01c8063861e1ca51161005b578063861e1ca514610127578063c4d66de81461014a578063cb5026b91461015f578063e1e3a7df1461016757600080fd5b80632baf0be7146100825780634b4b2efb146100bc5780635e280f11146100dc575b600080fd5b6100a97fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff81565b6040519081526020015b60405180910390f35b6100cf6100ca366004610bc1565b61017a565b6040516100b39190610bf5565b6000546101029062010000900473ffffffffffffffffffffffffffffffffffffffff1681565b60405173ffffffffffffffffffffffffffffffffffffffff90911681526020016100b3565b61013a610135366004610bc1565b610487565b60405190151581526020016100b3565b61015d610158366004610c36565b610577565b005b6100a9600081565b61013a610175366004610c58565b6107b6565b600080548351602085015160408087015190517fc9fc7bcd00000000000000000000000000000000000000000000000000000000815273ffffffffffffffffffffffffffffffffffffffff878116600483015263ffffffff9094166024820152604481019290925267ffffffffffffffff16606482015283926201000090049091169063c9fc7bcd90608401602060405180830381865afa158015610223573d6000803e3d6000fd5b505050506040513d601f19601f820116820180604052508101906102479190610ca4565b9050801580156103235750600054845160208601516040517f5b17bb7000000000000000000000000000000000000000000000000000000000815273ffffffffffffffffffffffffffffffffffffffff878116600483015263ffffffff90931660248201526044810191909152620100009092041690635b17bb7090606401602060405180830381865afa1580156102e3573d6000803e3d6000fd5b505050506040513d601f19601f820116820180604052508101906103079190610cbd565b67ffffffffffffffff16846040015167ffffffffffffffff1611155b15610332576003915050610481565b7fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff811480159061042e5750600054845160208601516040517fa0dd43fc00000000000000000000000000000000000000000000000000000000815273ffffffffffffffffffffffffffffffffffffffff878116600483015263ffffffff9093166024820152604481019190915262010000909204169063a0dd43fc90606401602060405180830381865afa1580156103ee573d6000803e3d6000fd5b505050506040513d601f19601f820116820180604052508101906104129190610cbd565b67ffffffffffffffff16846040015167ffffffffffffffff1611155b1561043d576002915050610481565b801580159061046c57507fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff8114155b1561047b576001915050610481565b60009150505b92915050565b60008054604080517f861e1ca5000000000000000000000000000000000000000000000000000000008152855163ffffffff166004820152602086015160248201529085015167ffffffffffffffff16604482015273ffffffffffffffffffffffffffffffffffffffff8481166064830152620100009092049091169063861e1ca590608401602060405180830381865afa925050508015610564575060408051601f3d9081017fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe016820190925261056191810190610cda565b60015b61057057506000610481565b9050610481565b60006105a17fb53127684a568b3173ae13b9f8a6016e243e63b6e8ee1178d6a717850b5d61035490565b905073ffffffffffffffffffffffffffffffffffffffff81166105fa5773ffffffffffffffffffffffffffffffffffffffff7fb53127684a568b3173ae13b9f8a6016e243e63b6e8ee1178d6a717850b5d61035561061c565b3373ffffffffffffffffffffffffffffffffffffffff82161461061c57600080fd5b600054610100900460ff161580801561063c5750600054600160ff909116105b806106565750303b158015610656575060005460ff166001145b6106e7576040517f08c379a000000000000000000000000000000000000000000000000000000000815260206004820152602e60248201527f496e697469616c697a61626c653a20636f6e747261637420697320616c72656160448201527f647920696e697469616c697a656400000000000000000000000000000000000060648201526084015b60405180910390fd5b600080547fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00166001179055801561074557600080547fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00ff166101001790555b61074e8361095e565b80156107b157600080547fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00ff169055604051600181527f7f26b83ff96e1f2b6a682f133852f6798a09c465da95921460cefb38474024989060200160405180910390a15b505050565b6000805485516040517f9d7f977500000000000000000000000000000000000000000000000000000000815273ffffffffffffffffffffffffffffffffffffffff878116600483015263ffffffff90921660248201528582166044820152620100009092041690639d7f977590606401602060405180830381865afa158015610843573d6000803e3d6000fd5b505050506040513d601f19601f820116820180604052508101906108679190610cda565b61087357506000610956565b600054604080517fc9a54a99000000000000000000000000000000000000000000000000000000008152875163ffffffff166004820152602088015160248201529087015167ffffffffffffffff16604482015273ffffffffffffffffffffffffffffffffffffffff8681166064830152620100009092049091169063c9a54a9990608401602060405180830381865afa158015610915573d6000803e3d6000fd5b505050506040513d601f19601f820116820180604052508101906109399190610cda565b61094557506000610956565b8161095257506000610956565b5060015b949350505050565b600054610100900460ff166109f5576040517f08c379a000000000000000000000000000000000000000000000000000000000815260206004820152602b60248201527f496e697469616c697a61626c653a20636f6e7472616374206973206e6f74206960448201527f6e697469616c697a696e6700000000000000000000000000000000000000000060648201526084016106de565b6109fe81610a01565b50565b600054610100900460ff16610a98576040517f08c379a000000000000000000000000000000000000000000000000000000000815260206004820152602b60248201527f496e697469616c697a61626c653a20636f6e7472616374206973206e6f74206960448201527f6e697469616c697a696e6700000000000000000000000000000000000000000060648201526084016106de565b6000805473ffffffffffffffffffffffffffffffffffffffff90921662010000027fffffffffffffffffffff0000000000000000000000000000000000000000ffff909216919091179055565b67ffffffffffffffff811681146109fe57600080fd5b600060608284031215610b0d57600080fd5b6040516060810181811067ffffffffffffffff82111715610b57577f4e487b7100000000000000000000000000000000000000000000000000000000600052604160045260246000fd5b604052905080823563ffffffff81168114610b7157600080fd5b8152602083810135908201526040830135610b8b81610ae5565b6040919091015292915050565b803573ffffffffffffffffffffffffffffffffffffffff81168114610bbc57600080fd5b919050565b60008060808385031215610bd457600080fd5b610bde8484610afb565b9150610bec60608401610b98565b90509250929050565b6020810160048310610c30577f4e487b7100000000000000000000000000000000000000000000000000000000600052602160045260246000fd5b91905290565b600060208284031215610c4857600080fd5b610c5182610b98565b9392505050565b60008060008060c08587031215610c6e57600080fd5b610c788686610afb565b9350610c8660608601610b98565b9250610c9460808601610b98565b9396929550929360a00135925050565b600060208284031215610cb657600080fd5b5051919050565b600060208284031215610ccf57600080fd5b8151610c5181610ae5565b600060208284031215610cec57600080fd5b81518015158114610c5157600080fdfea2646970667358221220163f262373e2299f486fa9bb3ba79263b6ce79b9d48696b15a23967fc426e57064736f6c63430008160033 | 0 | 2 | 1740461773 | 0 | 0 | 0x66a71dcef29a0ffbdbe3c6a460a3b5bc225cd675 | 1 | null | null | null | null | null | null | null | null | 21921292 | 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 |