betswirl_v4_avalanche

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
106307242729927038933920425864548728512237752966876445794596757752658612702758	0x272b4dd8e842be1012c9ccbb89b636996f9bae98	true	0x8157b9805e2c984774374740c569f58211e6f8ee	false	0x0000000000000000000000000000000000000000	100000000000000000	194000000000000000	true	24	33482773	2023-08-04T12:34:01.000Z	0x04c15e230efc523631c987f85817853278695e28e7040aee27f84fe43f2a7d84
24349623708286335648902994531507181515028737656732310330791797685429245098605	0x272b4dd8e842be1012c9ccbb89b636996f9bae98	true	0x8157b9805e2c984774374740c569f58211e6f8ee	false	0x8f47416cae600bccf9530e9f3aeaa06bdd1caa79	10000000000000000000	19300000000000000000	true	32	33482979	2023-08-04T12:40:51.000Z	0xc297bcc6a7597abaffd82725589ebe75c48208bfc0193ceabba00967d63cac1f
30610326208155431120105050159577603488106294352782697345081677352420333035484	0x272b4dd8e842be1012c9ccbb89b636996f9bae98	true	0x0fdf52317361121b869cc4b415cecc15ab480cec	false	0x0000000000000000000000000000000000000000	999999999000000000	0	false	1	33497511	2023-08-04T20:49:07.000Z	0x0893edac97880d56b595def61e689aad3030a7bcda18086386b85480dddcaff3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v4_avalanche.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
97323417950659057538076161152170556808160898697432299776632263635910454202538	8	0x8d940a4859570754d364b86ccc05052ea5068ea6	0xb78aa826f41d126d9f99022a282c9f5b9f704f1b	false	0x0000000000000000000000000000000000000000	500000000000000000	527173913043478261	39	10	33248416	2023-07-30T00:16:52.000Z	0xcd8ed6a721d80055b97b959ce1f776b082a8ea8d409812a17c3451854390f886
90627775300546080527957492349796766717788559685505700114334322429279728662762	8	0x8d940a4859570754d364b86ccc05052ea5068ea6	0xb78aa826f41d126d9f99022a282c9f5b9f704f1b	false	0x0000000000000000000000000000000000000000	500000000000000000	527173913043478261	26	16	33248714	2023-07-30T00:27:02.000Z	0x606c1a72f466b8b17eb1c7983068478085de8c88a2566e4e7aad682b7a95c4e1
55083224629318984345366014498667332813032702952037301218708991161852040870628	9	0x8d940a4859570754d364b86ccc05052ea5068ea6	0xb78aa826f41d126d9f99022a282c9f5b9f704f1b	false	0x0000000000000000000000000000000000000000	500000000000000000	532967032967032967	65	18	33248224	2023-07-30T00:10:06.000Z	0xa8d3e3eab38f672d9d74ab0bfc2f69f5bbf0b3f2a3e6200f03dd50c2f08cb123

Example Query

Query with partition filter

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