betswirl_v3_bsc

Tables

Bank_AllocateHouseEdgeAmount_event

Event logs recording the distribution of house edge revenue across multiple recipients including bank reserves, dividends, team allocations, treasury, and partner/referral shares. Used for tracking revenue allocation flows in decentralized gaming protocols.

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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_bank`	`STRING`	Amount allocated to the bank from house edge distribution. Numeric string representation of token wei or smallest unit amount.
`in_dividend`	`STRING`	Amount allocated to dividends from house edge distribution. Numeric string representation of token wei or smallest unit amount.
`in_partner`	`STRING`	Address of the partner or referral entity associated with the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_treasury`	`STRING`	Contract address of the Aave protocol treasury. Hex-encoded, 0x-prefixed, 42-character string.
`in_team`	`STRING`	Amount allocated to the team from house edge distribution. Numeric string representation of token wei or smallest unit amount.

Sample Data

address	in_bank	removed	in_token	log_index	in_dividend	block_number	block_timestamp	transaction_hash
0x2a555e3ad89571b931ff6c7b8b7e655d62dbc9f8	6176712144109	false	0x0000000000000000000000000000000000000000	352	2647162347475	21973350	2022-10-07T15:38:55.000Z	0xf4dbb58befe944f6bd84402be8eaac0303af921d92ed280a90cffaa39129a8a8
0x2a555e3ad89571b931ff6c7b8b7e655d62dbc9f8	72327346756195	false	0x0000000000000000000000000000000000000000	269	30997434324083	21973305	2022-10-07T15:36:40.000Z	0xb2a71befd39f5fde31b5e3cec0c932c2892574d1c1f6e817d4caf4b49932b539
0x2a555e3ad89571b931ff6c7b8b7e655d62dbc9f8	103599999999999	false	0x0000000000000000000000000000000000000000	118	44399999999999	21981652	2022-10-07T22:36:34.000Z	0x16765d348d6d4c56a02a936de01ddf33ba0e8dd19b4204f9864d7b8bef0d0395

Example Query

Query with partition filter

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

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
81647841194783582390858484332750388657887517702551574212262162988212212654919	0x8bae4264c83b2dcc58c5aca33e4414a0cbad2ebf	false	0x04aaba24543006976da65646f234686833109a1d	false	0x4e3cabd3ad77420ff9031d19899594041c420aee	1000000000000000000000	1930000000000000000000	false	202	20674991	2022-08-22T21:31:34.000Z	0x833accd1dcdd2cf2c090c3ec720362514ce16bf15fe870c3d0ae5594202b145d
61885583106366243698335459508379814072910074310557167960429876896013946040577	0x8bae4264c83b2dcc58c5aca33e4414a0cbad2ebf	true	0x06b57ce8f126b4224757be5c782b2f7af99684b8	false	0x0000000000000000000000000000000000000000	55000000000000000	0	false	101	20659618	2022-08-22T08:42:44.000Z	0x91e5d2398654ddbd75aa9059a7e9bbe659e91e2525c7af01a78f2f64ee6b57c1
67254297994892044309451371088394495196308490872188599149720623751913454159077	0x8bae4264c83b2dcc58c5aca33e4414a0cbad2ebf	false	0x06b57ce8f126b4224757be5c782b2f7af99684b8	false	0x0000000000000000000000000000000000000000	120000000000000000	0	true	101	20659635	2022-08-22T08:43:35.000Z	0xdef62767189de98c60c072fe34190d29feea4b0cc0ade52fbddbd52ab47eb86c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v3_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
21308176147799215946614529600398389326862593321230845176355735085052454200142	8	0xcfe6e9c9452381d68186a511bb78450fdb43a75d	0x5396771db5f28317cf96fd04f39e9c5d6e8bd627	false	0x0000000000000000000000000000000000000000	200000000000000000	210869565217391304	26	350	19546874	2022-07-14T15:22:42.000Z	0x65f967f6202aa48b7c8249dd154a395dfee324da49e3d5e5aca0f94e972b0d6b
17909904478978218108381914651934721336655954630120403265155787888104093365710	10	0xcfe6e9c9452381d68186a511bb78450fdb43a75d	0x5396771db5f28317cf96fd04f39e9c5d6e8bd627	false	0x0000000000000000000000000000000000000000	200000000000000000	215555555555555556	76	316	19546849	2022-07-14T15:21:27.000Z	0x5926af9d5a93139fb07197f37ddd36a178ac50689532febd9a68d66bc2a0dd89
86068119771397685166893902954093496919696880606498620631388722026761084891419	11	0xcfe6e9c9452381d68186a511bb78450fdb43a75d	0x1d9a2b7beedfd3955e2e3b5da1a4fd91847ecdde	false	0x4e3cabd3ad77420ff9031d19899594041c420aee	23891614371153442000000	25904952660857383741573	42	200	19535549	2022-07-14T05:55:27.000Z	0x8f1b7236a47b63cdf9bf5802b43eb3c2d65676100ca95cfdb92d5b03deadaa05

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v3_bsc.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_rolled	log_index	in_numbers	block_number	block_timestamp	transaction_hash
37673678930162639873516626364816014656053048076705533312690656566488446827514	0x6a3b4c2812e91ec6f3b72b2a04d517770e57dbb2	0x56e8fbfd3ba418726cfe0d0a6304876be8b8628e	false	0x0000000000000000000000000000000000000000	10000000000000000	20	159	91447186090	25134756	2023-01-27T00:29:39.000Z	0x6b8f1b5ce8751e70bb8ac06b70494a70c151d2fdd87485db764a6cc2a97f109a
86280666139351056194834654158979136408699010237640286933227889207740433379060	0x6a3b4c2812e91ec6f3b72b2a04d517770e57dbb2	0x56e8fbfd3ba418726cfe0d0a6304876be8b8628e	false	0x0000000000000000000000000000000000000000	10000000000000000	31	109	91447186090	25134858	2023-01-27T00:34:58.000Z	0xb3b25a6ec45333719da0edc0654bb290f59bf6f974a1cc217eeeaf4a295efebd
6527077886381317148511254756355995741998315584915790117540513113763916083465	0x6a3b4c2812e91ec6f3b72b2a04d517770e57dbb2	0x56e8fbfd3ba418726cfe0d0a6304876be8b8628e	false	0x0000000000000000000000000000000000000000	10000000000000000	2	177	91447186090	25134839	2023-01-27T00:34:00.000Z	0xbee44efe546262e0d3cd941116c9817f1032508aef24c0bb4a04e1242407301e

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Bank_AllocateHouseEdgeAmount_event

CoinToss_Roll_event

Dice_Roll_event

Roulette_Roll_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Bank_AllocateHouseEdgeAmount_event

​CoinToss_Roll_event

​Dice_Roll_event

​Roulette_Roll_event

Tables

Bank_AllocateHouseEdgeAmount_event

CoinToss_Roll_event

Dice_Roll_event

Roulette_Roll_event