Skip to main content

​
Tables

​
PostageStamp_BatchCreated_event

Postage stamp batch creation events from Swarm’s decentralized storage protocol on Gnosis Chain, recording batch purchases that enable users to upload and store data. Contains batch identifiers, owner addresses, payment amounts, depth parameters for storage capacity allocation, and immutability flags for analyzing storage provisioning patterns.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_batchIdSTRINGUnique identifier for the postage stamp batch created in this event. Hex-encoded, 0x-prefixed 64-character string serving as the batch reference in the Swarm network.
in_totalAmountSTRINGTotal amount involved in the transaction or operation. String-encoded integer representing the amount in the token’s smallest unit.
in_normalisedBalanceSTRINGPostage batch balance normalized to a standard unit, representing the batch’s payment capacity for storage. String-encoded integer value that may be very large, typically in the tens of millions to billions range.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_depthINT64Storage depth of the postage batch, determining the maximum number of chunks (2^depth) that can be stored. Higher values allow more data storage but require proportionally higher stake amounts.
in_bucketDepthINT64Defines the bucket subdivision depth for the postage batch, controlling storage collision resolution granularity. Value ranges from 16 in samples, representing the number of subdivision levels within the batch.
in_immutableFlagBOOLFlag indicating whether the postage batch is immutable and cannot be topped up after creation. Typically false for flexible batches that can be refilled, true for one-time permanent batches.
addressremovedin_depthin_ownerlog_indexin_batchIdblock_numberin_bucketDepthin_totalAmountblock_timestampin_immutableFlagtransaction_hashin_normalisedBalance
0x30d155478ef27ab32a1d578be7b84bc5988af381false190xdaf753621a975e34acaaf3373f336ffef8e6097f20x795895824e2b2cdd85fddc303cd3b931cc8796737ea88ac4130b005852da6f062602701316524288000000002023-01-18T13:18:35.000Zfalse0x6bc0a95b42b572f91030e4c69ca2bb8b8a8babad301609b0131996fdecf66d9d101933540
0x30d155478ef27ab32a1d578be7b84bc5988af381false270xdaf753621a975e34acaaf3373f336ffef8e6097f20x3d9eb2b5d6629d74429f6ed2c660e695448211a14ffbba2fd94a91ae95650eaf260276661633554432000000002023-01-18T14:15:35.000Zfalse0x2fe3596e3004c607413b11c6e3cd46de41d58c6cd2b64387f73a9f421832d41926936152
0x30d155478ef27ab32a1d578be7b84bc5988af381false250xc4b200967f24a53856b447e9087a46f97338d59330xaca2c681910317648c8770f21450e64feed406cc5e07a56f0947a3ec82316ecc260335141633554432000000002023-01-18T22:47:45.000Zfalse0x0167dbee611390e1859e0859953ad62cdef66832a1190806c4aabb940029b861101959544
Query with partition filter
SELECT *
FROM `tt-contracts.swarm_v1_gnosis.PostageStamp_BatchCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
PostageStamp_BatchTopUp_event

Batch top-up events from the Swarm PostageStamp contract on Gnosis Chain, recording when users add funds to extend storage batch validity periods. Used for analyzing Swarm network storage economics and batch management patterns.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_batchIdSTRINGUnique identifier for a postage batch in the Swarm network that is being topped up with additional postage. Hex-encoded, 0x-prefixed 64-character string representing the batch identifier.
in_topupAmountSTRINGAmount of tokens added to increase the batch balance in the Swarm PostageStamp contract, denominated in the smallest unit (wei-equivalent). Values typically range from millions to quadrillions, representing incremental storage capacity purchases.
in_normalisedBalanceSTRINGNormalized balance of the postage batch after the top-up transaction, denominated in Swarm’s smallest unit. Represents the updated storage credit available for the batch on the Swarm network.
addressremovedlog_indexin_batchIdblock_numberin_topupAmountblock_timestamptransaction_hashin_normalisedBalance
0x30d155478ef27ab32a1d578be7b84bc5988af381false280x71d81776d3db5fa8b0c952bfa56295723ebc0b2d00901fb767217542951f016e3010214616307453952000002023-09-22T18:24:55.000Z0x67abf928835598f3f0dfe44c1bc63d1ebb0d70dff875ca8fc935df06214e1435137594508689
0x30d155478ef27ab32a1d578be7b84bc5988af381false20x3b3ac9fff8284c96dc1532d2493cbada4b61c2180a257370c331547595f2d01c277010114369066659676162023-04-30T03:10:00.000Z0xcf45de5cc18b206f0a0102648cbf3a31941e33f2595590f2f28f73979515edb527850415572
0x30d155478ef27ab32a1d578be7b84bc5988af381false20x3b3ac9fff8284c96dc1532d2493cbada4b61c2180a257370c331547595f2d01c277011564369066659676162023-04-30T03:22:35.000Z0xdcceaf6ffa090a475eff4bd06b79c90461f95fca7f648a0b52f2dc79e1911f5632850415564
Query with partition filter
SELECT *
FROM `tt-contracts.swarm_v1_gnosis.PostageStamp_BatchTopUp_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
Redistribution_WinnerSelected_event

Winner selection events from Swarm’s redistribution contract on Gnosis Chain. Records staking node winners with their overlay addresses, stake amounts (0.1 xBZZ), and stake density for analyzing network reward distribution.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_winnerSTRUCT<owner STRING, overlay STRING, stake STRING, stakeDensity STRING, hash STRING, depth INT64>Nested record containing details about the selected winner in Swarm’s redistribution lottery, including their node overlay address, stake amount, and network depth. All winner records show consistent stake of 0.1 tokens (100000000000000000 wei) and depth 8, with unique overlay and owner addresses per event.
addressremovedin_winnerlog_indexblock_numberblock_timestamptransaction_hash
0x8c26b7ca61a6608b011cba43d8ca4476b6d8da17false{“hash”:“0x33fb0a61c885a4664b77e9473b5ec6f60b694d4265c4232db8d8e195d2189ce0”,“depth”:8,“owner”:“0x02776882c51698bb6ba858a28024c14460178cfb”,“stake”:“100000000000000000”,“overlay”:“0x0b1a26486df6f84c185294ae8c8e3ce79317c3ffd9affc726cdc166626cd25c8”,“stakeDensity”:“25600000000000000000”}3265587382023-02-19T14:59:55.000Z0xf4e1803baa5bee0b719f1a04ca0989feb2390f248b6eeb3df9fe70c066f33a64
0x8c26b7ca61a6608b011cba43d8ca4476b6d8da17false{“hash”:“0x1440e235ffddcc5bc0922cc37fbfc0292b500fa5f67e5f4a7b7d7df201da849a”,“depth”:8,“owner”:“0x032a5b2ead5f4ee41b03b2b86011830dec3fa1d1”,“stake”:“100000000000000000”,“overlay”:“0x308d49a4aee4aef7bb0165d6c25261801bd57115787f7fc1511191729a1533ef”,“stakeDensity”:“25600000000000000000”}3265535782023-02-19T07:32:45.000Z0x87f15aeb13615c3d794744b827b633ce73877c0b96f35617b12d399b890d548e
0x8c26b7ca61a6608b011cba43d8ca4476b6d8da17false{“hash”:“0xfffd2b0305eb2a0a3886601c3f62820df72f102b9756605fd85326aa6778730d”,“depth”:8,“owner”:“0x03ccb25213951e81dd4f2cfeb5a848df6e9346ab”,“stake”:“100000000000000000”,“overlay”:“0x1a98bf2dac473629957ee5957a793618088420931951c1dc30616091fc92bd70”,“stakeDensity”:“25600000000000000000”}3265497662023-02-19T02:02:50.000Z0xd49ee2e59918e86559fe3219716ed4dfcaee2826ee3caf0d5ad13f18a2467cad
Query with partition filter
SELECT *
FROM `tt-contracts.swarm_v1_gnosis.Redistribution_WinnerSelected_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100