betswirl_v2_polygon

Tables

CoinToss_Roll_event

Coin toss game outcome events from BetSwirl protocol contracts. Records each roll with bet details (amount, chosen face, token address), result (actual face rolled), payout amount, and player address for gambling analytics and game settlement tracking.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_face`	`BOOL`	Player’s chosen coin face side for the coin toss game. Boolean value where true represents one side (heads) and false represents the other side (tails).
`in_rolled`	`BOOL`	Randomly generated outcome value from the gaming protocol’s verifiable randomness system.
`in_payout`	`STRING`	Payout amount awarded to the player or winner. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_id	address	in_face	in_user	removed	in_token	in_amount	in_payout	in_rolled	log_index	block_number	block_timestamp	transaction_hash
69499848909655956347635153342471634236182388797594709947331692100696688010543	0x1eafebd961d8bd7423a844077806013c0b5bd559	true	0x2ed4338ace0ab5aad29aa76547b122ad6b6a61b2	false	0x0000000000000000000000000000000000000000	400000000000000000	776000000000000000	true	84	29216510	2022-06-06T00:46:23.000Z	0xfb26a905624dc207c79dc5e63187d777a9b2fb7ac20e4e107fa2163f6d38f2a2
92537227090275402868400486189708890434935487000651182752563891285000133030144	0x1eafebd961d8bd7423a844077806013c0b5bd559	true	0xd76e3fa964d26e08b2bd64e04beaa44b1fe47865	false	0x0000000000000000000000000000000000000000	100000000000000000	0	false	90	29462610	2022-06-12T04:16:26.000Z	0x3aa3a52b8f34dfeda30bee1bf85aefd2985d6bafc9d106e9e48222923b749c97
93871108879005267341170247022116512095134843837022788729573808279562025551233	0x1eafebd961d8bd7423a844077806013c0b5bd559	false	0xd76e3fa964d26e08b2bd64e04beaa44b1fe47865	false	0x0000000000000000000000000000000000000000	100000000000000000	0	true	70	29462844	2022-06-12T04:24:26.000Z	0x4af64d3a18a18b7e1087a8549bf0f08cefc7ef2d54348682dacb2540be9c3609

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v2_polygon.CoinToss_Roll_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Dice_Roll_event

Dice game outcome events from BetSwirl protocol contracts containing bet parameters, rolled result, cap threshold, and payout amount. Used for tracking dice game activity and settlement across decentralized gambling platforms.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_cap`	`INT64`	Player’s chosen winning threshold value in the dice game. Integer representing the upper bound for a winning roll outcome.
`in_rolled`	`INT64`	Randomly generated outcome value from the gaming protocol’s verifiable randomness system.
`in_payout`	`STRING`	Payout amount awarded to the player or winner. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_id	in_cap	address	in_user	removed	in_token	in_amount	in_payout	in_rolled	log_index	block_number	block_timestamp	transaction_hash
5128888850992524376076024565925474759396895146327979872990357616981963931003	52	0x2812fd77f38f4ae484217a0f6deca49a269d3435	0x2ed4338ace0ab5aad29aa76547b122ad6b6a61b2	false	0x0000000000000000000000000000000000000000	100000000000000000	202083333333333334	71	101	29259514	2022-06-07T03:02:09.000Z	0x1cf7537a1dbb7b1fea1bc7fd0486685fb75bf978f954f52876afc45ab5afbe01
11918648597501235547163353072990404187168457656503178416135424390311884278899	52	0x2812fd77f38f4ae484217a0f6deca49a269d3435	0x2ed4338ace0ab5aad29aa76547b122ad6b6a61b2	false	0x0000000000000000000000000000000000000000	100000000000000000	202083333333333334	71	84	29259594	2022-06-07T03:04:57.000Z	0xc094f02d81583d776bd68ca09c46d5f6b7820beb50c232b832e6787a45e9ef40
44665056570715579245588189504905870563383598319602132565772293720789849190527	52	0x2812fd77f38f4ae484217a0f6deca49a269d3435	0x2ed4338ace0ab5aad29aa76547b122ad6b6a61b2	false	0x0000000000000000000000000000000000000000	100000000000000000	202083333333333334	86	83	29259768	2022-06-07T03:10:53.000Z	0xa2d1d83d37ed106faaa0d9d2313afd6dae9df53580490891359dcb4d123f9c2d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v2_polygon.Dice_Roll_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Roulette_Roll_event

Roulette game outcome event emitted when a player’s bet is resolved, containing the bet identifier, wagered amount, random result (0-36), selected numbers, payout awarded, player address, and token used. Primary source for analyzing roulette game outcomes and player winnings.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_numbers`	`STRING`	Player’s selected numbers or positions for the wager. Numeric string representation encoding the chosen bet configuration in the gaming protocol.
`in_rolled`	`INT64`	Randomly generated outcome value from the gaming protocol’s verifiable randomness system.
`in_payout`	`STRING`	Payout amount awarded to the player or winner. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_id	address	in_user	removed	in_token	in_amount	in_payout	in_rolled	log_index	in_numbers	block_number	block_timestamp	transaction_hash
25804081523906181898968720664927877502207885644446776386719483406633712917567	0xeca13c464584b0984ab2ac10f3505fc51db6a3b6	0x7ee4fa92915d88cfcd739eb4d680c5dc452bb39f	false	0x0000000000000000000000000000000000000000	1000000000000000000	0	26	82	19634136210	34908679	2022-10-28T15:13:42.000Z	0x76d72cd0981339afe1e6c02c6c4e5f76fb38faaa1ec66ceb66f9baf799d11e29
81238947532397778293744418275309397352868295285613822016475521293807279005189	0xeca13c464584b0984ab2ac10f3505fc51db6a3b6	0x7ee4fa92915d88cfcd739eb4d680c5dc452bb39f	false	0x0000000000000000000000000000000000000000	1000000000000000000	3000083333333333334	31	76	19634136210	34908873	2022-10-28T15:20:22.000Z	0x606809d1bff26f5e4f29df863d339c5e55ee9a6c4f47ff4c1aacb4e93eb71ac8
102832945545873423973221232296510218127610136446539296541795814716470764047008	0xeca13c464584b0984ab2ac10f3505fc51db6a3b6	0x7ee4fa92915d88cfcd739eb4d680c5dc452bb39f	false	0x0000000000000000000000000000000000000000	1000000000000000000	0	15	275	19634136210	34908632	2022-10-28T15:12:04.000Z	0x49d2c064f4d0098a694b9ed25247ff95d27cec2e11e76bcc8f64c85a9cb5697b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v2_polygon.Roulette_Roll_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StakingV2_RewardPaid_event

Staking reward distribution events emitted when users claim accrued rewards from staking contracts. Records the recipient address, reward token contract, and reward amount paid out.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewardsToken`	`STRING`	Contract address of the reward token being distributed. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	in_rewardsToken	transaction_hash
0xa0d5f23dc9131597975aff96d293e5a7d0516665	0xfb17d5cd85854b6bee89e714591de521f3169de5	false	22977501219063269008	145	48625437	2023-10-12T10:19:48.000Z	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0xfcfa355078a831300676c38117fec6dff940510522ee7364f6eaa472e0c1809f
0xa0d5f23dc9131597975aff96d293e5a7d0516665	0xd361de7a6d5d17e48dd5e12d66870d6238ac416b	false	147709554481200000000	2752	48634452	2023-10-12T15:47:40.000Z	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x51bd8be5fc982c98e121eb1f3aeae302daae5d80391225e336fea091302346f7
0xa0d5f23dc9131597975aff96d293e5a7d0516665	0x4a7d69c7a8533e14271308669e6a665df374489e	false	532087310026468088	132	48640573	2023-10-12T19:28:50.000Z	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0xfa5dabe16700f593863990d029ece6948332c4fd37205fe99e6be4ce9dfc4789

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v2_polygon.StakingV2_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

CoinToss_Roll_event

Dice_Roll_event

Roulette_Roll_event

StakingV2_RewardPaid_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​CoinToss_Roll_event

​Dice_Roll_event

​Roulette_Roll_event

​StakingV2_RewardPaid_event

Tables

CoinToss_Roll_event

Dice_Roll_event

Roulette_Roll_event

StakingV2_RewardPaid_event