betswirl_v5_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
70337361945138283134311591932716431385530195904052013152264199198081040391175	0xf4cc8b8520cbb57829379eca18b1911cc401c97d	false	0x0f6d13bbe42d09265cd3f594f3bada7081ebf433	false	0x0000000000000000000000000000000000000000	100000000000000000000	194000000000000000000	false	92	38763209	2023-02-01T00:23:40.000Z	0xf78694c0422cb963d8fff2b7774578d7116bbf46bce07491469daca63457e02a
77546968057730198355248865573153000166388321361608433576103870291248565906205	0xf4cc8b8520cbb57829379eca18b1911cc401c97d	true	0x0f6d13bbe42d09265cd3f594f3bada7081ebf433	false	0x0000000000000000000000000000000000000000	100000000000000000000	0	false	57	38763237	2023-02-01T00:24:40.000Z	0x51895d57e39531e842dc3a141de9cdc84c24fe93e785e68443889f2fbc30ee6c
86933631695282916784064215821583609632198370224856511098973484270486838652137	0xf4cc8b8520cbb57829379eca18b1911cc401c97d	false	0x0f6d13bbe42d09265cd3f594f3bada7081ebf433	false	0x0000000000000000000000000000000000000000	56185948066517020000	109000739249043018800	false	70	38763162	2023-02-01T00:21:28.000Z	0xa3ae03d83a5e040e783a9db03adca98b5798329c0b91d3be9b12a6a212a786ab

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v5_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
17881189897241448527035827288433891226592589282108558825671229204036689742534	25	0x31edcd915e695adaf782c482b9816613b347ac8c	0x8d95f8739fb8f4ab75d6bedebdedb8238f63704e	false	0x0000000000000000000000000000000000000000	100000000000000000	129333333333333334	49	73	53449818	2024-02-12T23:09:34.000Z	0x094239416c5bb24f224d980f75f311aafeea0c97af8dc1b55d0adc0aa321a97c
56564249490393766219099530895406123099069473579907714323003817803298416189629	56	0x31edcd915e695adaf782c482b9816613b347ac8c	0xb839bc576d4873310827b2e9feba613d65710e99	false	0x0000000000000000000000000000000000000000	100000000000000000	0	15	90	53442045	2024-02-12T18:33:13.000Z	0xda62d0e066e466c7e85db3445c32fcaaa746854108f8f31ee1ee6d0e38980916
38462483520139265235043279044068984294413004468957532458329961978057710324176	13	0x31edcd915e695adaf782c482b9816613b347ac8c	0xb839bc576d4873310827b2e9feba613d65710e99	false	0x0000000000000000000000000000000000000000	1000000000000000000	0	12	226	53441929	2024-02-12T18:29:07.000Z	0x735e7abce1acf43f4a0243edb5d7065c0bfa00cbf1b60bea86b9f494ce6b88c4

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

CoinToss_Roll_event

Dice_Roll_event

​Tables

​CoinToss_Roll_event

​Dice_Roll_event

Tables

CoinToss_Roll_event

Dice_Roll_event