betswirl_v5_bsc

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
28690659557276692090088326531870554593887155587496191937346396393384587153499	0xaed16fb2203621bcf4c3894e7941b1c195075e6a	false	0xdc75d95bc46fafed33304c470b4810a4ad2b70e9	false	0x0000000000000000000000000000000000000000	42000000000000000	0	true	191	30700692	2023-08-09T11:20:54.000Z	0xa09287e8c500eca43e4dbdcf0f7172303a215d45a56714bf62da1613106609a3
98719505566385039796776097794892995873765041381509079616838634243241897015400	0xaed16fb2203621bcf4c3894e7941b1c195075e6a	false	0xd975ff1f1035f7b58f2d5347c986c5301addb54a	false	0x0000000000000000000000000000000000000000	23023786976506744	44666146734423084	false	127	31024031	2023-08-20T17:33:00.000Z	0x3cc93038d2ed7185578e353bcec615abed51aa60f77332d888ec1c696cb6e9ae
36265363529978314776464210057247275771074446275757721542781214931468516546625	0xaed16fb2203621bcf4c3894e7941b1c195075e6a	true	0xd975ff1f1035f7b58f2d5347c986c5301addb54a	false	0x0000000000000000000000000000000000000000	4500000000000000	0	false	56	31024138	2023-08-20T17:38:21.000Z	0xd5862905ee6e2f055137282712dfccf5bdcaa6d99c6c054bb1f9304a7801ae7c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v5_bsc.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
110228984564777074325019753570674917795207075356640711140944511025875757882067	99	0x56b112c906e2d78b24bb53fcf534bb774732b540	0x60c20a6614abb57f7a304c382bbc5a1067a98d61	false	0x0557a288a93ed0df218785f2787dac1cd077f8f3	586262184597688800000	0	35	195	27731449	2023-04-28T02:50:31.000Z	0xe99dd9b52a9b9f77a95fde58a9abd14175ca7975da51620c5ab53312e3b87507
389495837126289793240966830598696503264514852897705441939015127239312751266	7	0x56b112c906e2d78b24bb53fcf534bb774732b540	0xbcbf9adee33316dc7cf14d967edb68a56a33f1cf	false	0x3e0a7c7db7bb21bda290a80c9811de6d47781671	1000000000000000000	1048387096774193549	53	266	26261048	2023-03-07T14:51:00.000Z	0xa21a4cb1289218d744968e7cfe0862784f48de46cfcba6c17b3f668c8223bbe7
52616915256293743710300270746183491916303559052344632237086800357273483821573	16	0x56b112c906e2d78b24bb53fcf534bb774732b540	0xce6dd2b6557b274ba6cb14a909b5aae9b9be1bcc	false	0x0557a288a93ed0df218785f2787dac1cd077f8f3	10000000000000000000000	11488095238095238095238	71	103	26262718	2023-03-07T16:15:18.000Z	0xf496db361be2d9f1a079cb33fdb52d4e75bb6cd30c57981f591994cf6528efeb

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

CoinToss_Roll_event

Dice_Roll_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​CoinToss_Roll_event

​Dice_Roll_event

Tables

CoinToss_Roll_event

Dice_Roll_event