betswirl_v5_arbitrum

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
36831706269315114689734728316847769142092721314465418387441562327181635106241	0x0620f8324531894d9f75da76dd5e382c4c4fa274	true	0x77b19f5a7080b0c1887dcacbe63a141e9317a0f0	false	0x0000000000000000000000000000000000000000	10000000000000000	19400000000000000	true	2	93036739	2023-05-21T19:45:35.000Z	0x2d1deb0e130a7dd049543968ce9f14cf778e7c3cfbfe414cf8ad2da20c218878
63301382445916070184300720972785279744101143141087539069654141481560956793448	0x0620f8324531894d9f75da76dd5e382c4c4fa274	true	0x77b19f5a7080b0c1887dcacbe63a141e9317a0f0	false	0x0000000000000000000000000000000000000000	10000000000000000	19400000000000000	true	2	93036548	2023-05-21T19:44:44.000Z	0x2b76fdeb48fcfb6288d2f814d4a15a2e676f5ff6f389e7d93e628859f89dab97
67878438304666614536051748358217908904597621167161225877817284568022230319435	0x0620f8324531894d9f75da76dd5e382c4c4fa274	true	0x77b19f5a7080b0c1887dcacbe63a141e9317a0f0	false	0x0000000000000000000000000000000000000000	10000000000000000	19400000000000000	true	2	93036996	2023-05-21T19:46:41.000Z	0x7958b1eed4d8789a7a4e26ee0a6c460474ab442ae0e92580a3d2dd7b38df290a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v5_arbitrum.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
75699001781757439391225103663727091081940452433316720242440086855652064011063	46	0x6f3b387fb817a9128386d01debb90ce428f6a07d	0x3048181b1ed56ce97ea4cfe2993c06b488d11fa6	false	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	1000000	0	20	2	159911029	2023-12-14T03:50:19.000Z	0xd7a5845f31af225629e65a6979231fec992b16b9c67d380a0e96df1c4e445997
30281292639446317633072427958380318257763499884373732108910013049539265823191	20	0x6f3b387fb817a9128386d01debb90ce428f6a07d	0x3048181b1ed56ce97ea4cfe2993c06b488d11fa6	false	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	1000000	1206250	80	5	159910905	2023-12-14T03:49:43.000Z	0x1fce102af443a2411ed32e90b3ce50b9dbfc5b5f04f65fca26a5986f22d2e898
103199512352820994126671539794943713832917542341698349510464047077198421843238	77	0x6f3b387fb817a9128386d01debb90ce428f6a07d	0x3048181b1ed56ce97ea4cfe2993c06b488d11fa6	false	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	1000000	4195653	91	5	159910700	2023-12-14T03:48:45.000Z	0x30166a691de556ae663f83c9595f4771e52b2a3312408fed594bc7a2f7659122

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v5_arbitrum.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