swarm_v1_gnosis

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_batchId`	`STRING`	Unique 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_totalAmount`	`STRING`	Total amount involved in the transaction or operation. String-encoded integer representing the amount in the token’s smallest unit.
`in_normalisedBalance`	`STRING`	Postage 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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_depth`	`INT64`	Storage 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_bucketDepth`	`INT64`	Defines 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_immutableFlag`	`BOOL`	Flag 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.

Sample Data

address	removed	in_depth	in_owner	log_index	in_batchId	block_number	in_bucketDepth	in_totalAmount	block_timestamp	in_immutableFlag	transaction_hash	in_normalisedBalance
0x30d155478ef27ab32a1d578be7b84bc5988af381	false	19	0xdaf753621a975e34acaaf3373f336ffef8e6097f	2	0x795895824e2b2cdd85fddc303cd3b931cc8796737ea88ac4130b005852da6f06	26027013	16	52428800000000	2023-01-18T13:18:35.000Z	false	0x6bc0a95b42b572f91030e4c69ca2bb8b8a8babad301609b0131996fdecf66d9d	101933540
0x30d155478ef27ab32a1d578be7b84bc5988af381	false	27	0xdaf753621a975e34acaaf3373f336ffef8e6097f	2	0x3d9eb2b5d6629d74429f6ed2c660e695448211a14ffbba2fd94a91ae95650eaf	26027666	16	3355443200000000	2023-01-18T14:15:35.000Z	false	0x2fe3596e3004c607413b11c6e3cd46de41d58c6cd2b64387f73a9f421832d419	26936152
0x30d155478ef27ab32a1d578be7b84bc5988af381	false	25	0xc4b200967f24a53856b447e9087a46f97338d593	3	0xaca2c681910317648c8770f21450e64feed406cc5e07a56f0947a3ec82316ecc	26033514	16	3355443200000000	2023-01-18T22:47:45.000Z	false	0x0167dbee611390e1859e0859953ad62cdef66832a1190806c4aabb940029b861	101959544

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_batchId`	`STRING`	Unique 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_topupAmount`	`STRING`	Amount 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_normalisedBalance`	`STRING`	Normalized 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.

Sample Data

address	removed	log_index	in_batchId	block_number	in_topupAmount	block_timestamp	transaction_hash	in_normalisedBalance
0x30d155478ef27ab32a1d578be7b84bc5988af381	false	28	0x71d81776d3db5fa8b0c952bfa56295723ebc0b2d00901fb767217542951f016e	30102146	1630745395200000	2023-09-22T18:24:55.000Z	0x67abf928835598f3f0dfe44c1bc63d1ebb0d70dff875ca8fc935df06214e1435	137594508689
0x30d155478ef27ab32a1d578be7b84bc5988af381	false	2	0x3b3ac9fff8284c96dc1532d2493cbada4b61c2180a257370c331547595f2d01c	27701011	436906665967616	2023-04-30T03:10:00.000Z	0xcf45de5cc18b206f0a0102648cbf3a31941e33f2595590f2f28f73979515edb5	27850415572
0x30d155478ef27ab32a1d578be7b84bc5988af381	false	2	0x3b3ac9fff8284c96dc1532d2493cbada4b61c2180a257370c331547595f2d01c	27701156	436906665967616	2023-04-30T03:22:35.000Z	0xdcceaf6ffa090a475eff4bd06b79c90461f95fca7f648a0b52f2dc79e1911f56	32850415564

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_winner`	`STRUCT<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.

Sample Data

address	removed	in_winner	log_index	block_number	block_timestamp	transaction_hash
0x8c26b7ca61a6608b011cba43d8ca4476b6d8da17	false	{“hash”:“0x33fb0a61c885a4664b77e9473b5ec6f60b694d4265c4232db8d8e195d2189ce0”,“depth”:8,“owner”:“0x02776882c51698bb6ba858a28024c14460178cfb”,“stake”:“100000000000000000”,“overlay”:“0x0b1a26486df6f84c185294ae8c8e3ce79317c3ffd9affc726cdc166626cd25c8”,“stakeDensity”:“25600000000000000000”}	3	26558738	2023-02-19T14:59:55.000Z	0xf4e1803baa5bee0b719f1a04ca0989feb2390f248b6eeb3df9fe70c066f33a64
0x8c26b7ca61a6608b011cba43d8ca4476b6d8da17	false	{“hash”:“0x1440e235ffddcc5bc0922cc37fbfc0292b500fa5f67e5f4a7b7d7df201da849a”,“depth”:8,“owner”:“0x032a5b2ead5f4ee41b03b2b86011830dec3fa1d1”,“stake”:“100000000000000000”,“overlay”:“0x308d49a4aee4aef7bb0165d6c25261801bd57115787f7fc1511191729a1533ef”,“stakeDensity”:“25600000000000000000”}	3	26553578	2023-02-19T07:32:45.000Z	0x87f15aeb13615c3d794744b827b633ce73877c0b96f35617b12d399b890d548e
0x8c26b7ca61a6608b011cba43d8ca4476b6d8da17	false	{“hash”:“0xfffd2b0305eb2a0a3886601c3f62820df72f102b9756605fd85326aa6778730d”,“depth”:8,“owner”:“0x03ccb25213951e81dd4f2cfeb5a848df6e9346ab”,“stake”:“100000000000000000”,“overlay”:“0x1a98bf2dac473629957ee5957a793618088420931951c1dc30616091fc92bd70”,“stakeDensity”:“25600000000000000000”}	3	26549766	2023-02-19T02:02:50.000Z	0xd49ee2e59918e86559fe3219716ed4dfcaee2826ee3caf0d5ad13f18a2467cad

Example Query

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

PostageStamp_BatchCreated_event

PostageStamp_BatchTopUp_event

Redistribution_WinnerSelected_event

​Tables

​PostageStamp_BatchCreated_event

​PostageStamp_BatchTopUp_event

​Redistribution_WinnerSelected_event

Tables

PostageStamp_BatchCreated_event

PostageStamp_BatchTopUp_event

Redistribution_WinnerSelected_event