Enriched Transactions
Chain
SankoDataset name
sanko.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_0x8ad510ef5a9d67c2135e8e048b982646a0c21b3b367ea60e23ddd357d1c8a5a2_1 | 0xbd1eb3dc8c4a291fe31e90cde8db79674e324db53ee346578106818be700fb04 | 0 | 0x8ad510ef5a9d67c2135e8e048b982646a0c21b3b367ea60e23ddd357d1c8a5a2 | 16 | 1 | 0x02867114b27d686f3565e2060424e985a1e565f5 | 0x0000000000000000000000000000000000000064 | 5000000 | 67000 | 1000000 | 0x25e1606300000000000000000000000002867114b27d686f3565e2060424e985a1e565f5 | 25000 | 23000 | 2 | 1713061152 | 67000 | 67000 | null | 1 | 400000 | null | null | null | null | null | null | null | null | 19650753 | null | null | null | null | |
| enriched_transaction_v2_0x5f6591b739078250e3f10af389a0df64ceca891d60bfef25c0f680d3bcbd4399_0 | 0xcd13f5681950e293a5c3e9ecfc58edbf142be8c29c7380247a12f1c9960f7c5c | 0 | 0x5f6591b739078250e3f10af389a0df64ceca891d60bfef25c0f680d3bcbd4399 | 21 | 0 | 0x00000000000000000000000000000000000a4b05 | 0x00000000000000000000000000000000000a4b05 | 0x6bf6a42d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012bef820000000000000000000000000000000000000000000000000000000000000015000000 | null | null | 106 | 1713131626 | null | 1 | 400000 | null | null | null | null | null | null | null | null | 19656578 | null | null | null | null | ||||||
| enriched_transaction_v2_0xcc92207fc8a63bc3e09823816be23cf12f3131787186e0909f9fd03211adb610_1 | 0xb502f0254418f5cdf67c92f0d7b5ad22ec65411a3854ab6ce7b187ea75e618c6 | 0 | 0xcc92207fc8a63bc3e09823816be23cf12f3131787186e0909f9fd03211adb610 | 31 | 1 | 0x9f21b7aaa954e4fdb1f609a27a8c6d456dcfa4bf | null | 3200 | 0x60806040523480156200001157600080fd5b5060405162001063380380620010638339810160408190526200003491620001fc565b604051806040016040528060068152602001657374616e6b6f60d01b815250604051806040016040528060068152602001655354414e4b4f60d01b8152508160039081620000839190620002bc565b506004620000928282620002bc565b505050620000af620000a9620000db60201b60201c565b620000df565b620000d433620000c26012600a6200049d565b620000ce9084620004b2565b62000131565b50620004e2565b3390565b600580546001600160a01b038381166001600160a01b0319831681179093556040519116919082907f8be0079c531659141344cd1fd0a4f28419497f9722a3daafe3b4186f6b6457e090600090a35050565b6001600160a01b0382166200018c5760405162461bcd60e51b815260206004820152601f60248201527f45524332303a206d696e7420746f20746865207a65726f206164647265737300604482015260640160405180910390fd5b8060026000828254620001a09190620004cc565b90915550506001600160a01b038216600081815260208181526040808320805486019055518481527fddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef910160405180910390a35050565b505050565b6000602082840312156200020f57600080fd5b5051919050565b634e487b7160e01b600052604160045260246000fd5b600181811c908216806200024157607f821691505b6020821081036200026257634e487b7160e01b600052602260045260246000fd5b50919050565b601f821115620001f7576000816000526020600020601f850160051c81016020861015620002935750805b601f850160051c820191505b81811015620002b4578281556001016200029f565b505050505050565b81516001600160401b03811115620002d857620002d862000216565b620002f081620002e984546200022c565b8462000268565b602080601f8311600181146200032857600084156200030f5750858301515b600019600386901b1c1916600185901b178555620002b4565b600085815260208120601f198616915b82811015620003595788860151825594840194600190910190840162000338565b5085821015620003785787850151600019600388901b60f8161c191681555b5050505050600190811b01905550565b634e487b7160e01b600052601160045260246000fd5b600181815b80851115620003df578160001904821115620003c357620003c362000388565b80851615620003d157918102915b93841c9390800290620003a3565b509250929050565b600082620003f85750600162000497565b81620004075750600062000497565b81600181146200042057600281146200042b576200044b565b600191505062000497565b60ff8411156200043f576200043f62000388565b50506001821b62000497565b5060208310610133831016604e8410600b841016171562000470575081810a62000497565b6200047c83836200039e565b806000190482111562000493576200049362000388565b0290505b92915050565b6000620004ab8383620003e7565b9392505050565b808202811582820484141762000497576200049762000388565b8082018082111562000497576200049762000388565b610b7180620004f26000396000f3fe608060405234801561001057600080fd5b50600436106100f55760003560e01c806370a0823111610097578063a457c2d711610066578063a457c2d7146101eb578063a9059cbb146101fe578063dd62ed3e14610211578063f2fde38b1461022457600080fd5b806370a0823114610197578063715018a6146101c05780638da5cb5b146101c857806395d89b41146101e357600080fd5b806323b872dd116100d357806323b872dd1461014d578063313ce56714610160578063395093511461016f57806342966c681461018257600080fd5b806306fdde03146100fa578063095ea7b31461011857806318160ddd1461013b575b600080fd5b610102610237565b60405161010f91906109a1565b60405180910390f35b61012b610126366004610a0c565b6102c9565b604051901515815260200161010f565b6002545b60405190815260200161010f565b61012b61015b366004610a36565b6102e3565b6040516012815260200161010f565b61012b61017d366004610a0c565b610307565b610195610190366004610a72565b610329565b005b61013f6101a5366004610a8b565b6001600160a01b031660009081526020819052604090205490565b610195610336565b6005546040516001600160a01b03909116815260200161010f565b61010261034a565b61012b6101f9366004610a0c565b610359565b61012b61020c366004610a0c565b6103d9565b61013f61021f366004610aad565b6103e7565b610195610232366004610a8b565b610412565b60606003805461024690610ae0565b80601f016020809104026020016040519081016040528092919081815260200182805461027290610ae0565b80156102bf5780601f10610294576101008083540402835291602001916102bf565b820191906000526020600020905b8154815290600101906020018083116102a257829003601f168201915b5050505050905090565b6000336102d7818585610488565b60019150505b92915050565b6000336102f18582856105ad565b6102fc858585610627565b506001949350505050565b6000336102d781858561031a83836103e7565b6103249190610b1a565b610488565b61033333826107cb565b50565b61033e6108f5565b610348600061094f565b565b60606004805461024690610ae0565b6000338161036782866103e7565b9050838110156103cc5760405162461bcd60e51b815260206004820152602560248201527f45524332303a2064656372656173656420616c6c6f77616e63652062656c6f77604482015264207a65726f60d81b60648201526084015b60405180910390fd5b6102fc8286868403610488565b6000336102d7818585610627565b6001600160a01b03918216600090815260016020908152604080832093909416825291909152205490565b61041a6108f5565b6001600160a01b03811661047f5760405162461bcd60e51b815260206004820152602660248201527f4f776e61626c653a206e6577206f776e657220697320746865207a65726f206160448201526564647265737360d01b60648201526084016103c3565b6103338161094f565b6001600160a01b0383166104ea5760405162461bcd60e51b8152602060048201526024808201527f45524332303a20617070726f76652066726f6d20746865207a65726f206164646044820152637265737360e01b60648201526084016103c3565b6001600160a01b03821661054b5760405162461bcd60e51b815260206004820152602260248201527f45524332303a20617070726f766520746f20746865207a65726f206164647265604482015261737360f01b60648201526084016103c3565b6001600160a01b0383811660008181526001602090815260408083209487168084529482529182902085905590518481527f8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b92591015b60405180910390a3505050565b60006105b984846103e7565b9050600019811461062157818110156106145760405162461bcd60e51b815260206004820152601d60248201527f45524332303a20696e73756666696369656e7420616c6c6f77616e6365000000 | 2 | 1713169786 | 3200 | 3200 | 0x9c2730ea529c70e901fbdaf3e15e110ca8701c61 | 1 | 400000 | null | null | 1200 | null | null | null | null | null | null | 19659729 | 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 |