betswirl_v4_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	in_team	removed	in_token	log_index	in_dividend	in_treasury	block_number	block_timestamp	transaction_hash
0xa475f643aa480a3df3e9872b6e80e75ae99b19db	3811266372301349	952816593075337	false	0x0000000000000000000000000000000000000000	148	2858449779226012	1905633186150674	31914700	2023-09-20T18:43:18.000Z	0xf1e8f7fedb56e4a63e12a7b32a663cb564231430cf2e6e9c79b4b5af6e4d9bf1
0xa475f643aa480a3df3e9872b6e80e75ae99b19db	3360000000000000	840000000000000	false	0x0000000000000000000000000000000000000000	102	2520000000000000	1680000000000000	31911988	2023-09-20T16:26:01.000Z	0x52a529c0427213f153dd76d6194df261bc07d582d2c1dba753c91ed51320ecb2
0xa475f643aa480a3df3e9872b6e80e75ae99b19db	5040000000000000	1260000000000000	false	0x0000000000000000000000000000000000000000	68	3780000000000000	2520000000000000	31914300	2023-09-20T18:22:24.000Z	0x046547f65a26b8c797de50291fb3fb0461a223dd2629e8044f33f3219e99f8f4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v4_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_rolled	log_index	block_number	block_timestamp	transaction_hash
57661585835524273778036361135230402827070674002311078889339067536660957999032	0xa923837812865a279d4a5d92779092bdb9e8884c	true	0xc6be8f56e4f86de185ec9ececf3835440c28b1c5	false	0x0000000000000000000000000000000000000000	20000000000000000	false	288	21647074	2022-09-25T18:37:15.000Z	0x2104f6b92fc6076f859848933162b201d19b62a2f0fb0a12eccc2febae1b45c7
80338650745566962564108058570429486411376824217559124020770832322399226964796	0xa923837812865a279d4a5d92779092bdb9e8884c	true	0xc6be8f56e4f86de185ec9ececf3835440c28b1c5	false	0x0000000000000000000000000000000000000000	270000000000000000	false	297	21645931	2022-09-25T17:39:36.000Z	0xd2b857554d808d8c1d0d8f631f2e3edefcbecfaedc82b55e9da16b83d2fc482f
7440183418314565660323002482475922486329931435357941558313759375531098923199	0xa923837812865a279d4a5d92779092bdb9e8884c	true	0xc6be8f56e4f86de185ec9ececf3835440c28b1c5	false	0x4e3cabd3ad77420ff9031d19899594041c420aee	1000000000000000000000	false	69	21644780	2022-09-25T16:41:27.000Z	0x818f7c1ba42f67dcdcbec8404a537f6bd3ac6067eafcbc250609984005aa0f7e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v4_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
107353792595797257247508392691626698134014918547682468332849069052897669361122	50	0xf85b42ec9ab660dffb5490476f1db4edd3967486	0x8b25e6e458c4184889d96ad7f59074f917ddbe12	false	0x4e3cabd3ad77420ff9031d19899594041c420aee	100000000000000000000000	193000000000000000000000	81	574	23806521	2022-12-11T07:11:02.000Z	0xc9c4b9f7e3648d2299c59d86d4a78825b23937e3dc2a871d0ba7098e05eacec9
42325150812472572523929282241697462198576722214221115743339384055287649916654	50	0xf85b42ec9ab660dffb5490476f1db4edd3967486	0x8b25e6e458c4184889d96ad7f59074f917ddbe12	false	0x4e3cabd3ad77420ff9031d19899594041c420aee	50000000000000000000000	96500000000000000000000	52	105	23820032	2022-12-11T18:43:04.000Z	0x8196dbfdd07c8c64510bdaafe9328a1085a697ff9b93f2865fbae639cebc292e
85520078519243097448763157801436305687162679670373681756892402131619190100362	73	0xf85b42ec9ab660dffb5490476f1db4edd3967486	0x953eedccaa39919fd1df567310c2d3a7c034d390	false	0x4e3cabd3ad77420ff9031d19899594041c420aee	76736747321287510000	274262819129786841296	82	285	23801645	2022-12-11T03:00:20.000Z	0xdacd047e03ee870337a36711f277d6a531972fdb31ba9bd0536c43dcbbc406c1

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​Bank_AllocateHouseEdgeAmount_event

​CoinToss_Roll_event

​Dice_Roll_event

Tables

Bank_AllocateHouseEdgeAmount_event

CoinToss_Roll_event

Dice_Roll_event