betswirl_v4_polygon

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
0x999b6d28a9e78c4be13d51469c49585d6d25be5e	24000000000000000	6000000000000000	false	0x0000000000000000000000000000000000000000	93	18000000000000000	12000000000000000	50567322	2023-11-30T09:21:55.000Z	0x50179a467edf0ef19f0c81ef19cb04c0b77e146ead479e62b529a34be65ec3e8
0x999b6d28a9e78c4be13d51469c49585d6d25be5e	24000000000000000	6000000000000000	false	0x0000000000000000000000000000000000000000	127	18000000000000000	12000000000000000	50552285	2023-11-30T00:28:45.000Z	0xd1c62c3850329fcdabd78c0c6807a02090e5272f91d69ee330b059e283c8bc87
0x999b6d28a9e78c4be13d51469c49585d6d25be5e	24000000000000000	6000000000000000	false	0x0000000000000000000000000000000000000000	227	18000000000000000	12000000000000000	50557049	2023-11-30T03:17:35.000Z	0x3ce5fb6ee8552805178fc8e400e943100f89100d9010864ce00aee12f593c16a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v4_polygon.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
10767737774258262876922588214821105061661699295921646581682937037277940299014	0x060c4f055a3f7797405863518024a82ea1fcb82f	false	0x863c5bf79bb048958f35636cc3455cd61766c36a	false	0x0000000000000000000000000000000000000000	2546000000000000000	true	195	34244748	2022-10-12T08:55:03.000Z	0x208c920ef9c681f505791e286c66ded5a9709d01d8aacacefc3600c52d722401
37454780678461872159430625177111730069538327818467724775378936523943909035339	0x060c4f055a3f7797405863518024a82ea1fcb82f	false	0x863c5bf79bb048958f35636cc3455cd61766c36a	false	0x0000000000000000000000000000000000000000	960000000000000000	true	540	34243909	2022-10-12T08:25:50.000Z	0x29a93925bd80ae046f3555bb0dc7c9baf26807f69bd14923f7c917d34d548d80
73970496255410022463646255071903046016712356668316546649415992436361048669036	0x060c4f055a3f7797405863518024a82ea1fcb82f	false	0x863c5bf79bb048958f35636cc3455cd61766c36a	false	0x0000000000000000000000000000000000000000	755460000000000000	true	261	34244928	2022-10-12T09:01:15.000Z	0xa3a6b8fb75ff09fda883180a805b50ed3427476a574bf8bcecc65d745910996d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v4_polygon.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_rolled	log_index	block_number	block_timestamp	transaction_hash
114629754411239849487796732768433279373162133153750025537330341649397452753936	5	0x4fa6a722b8c8c75cf1863f5c722ce001c67c7095	0xd6a575231308c5df0b626883f83778b440f66289	false	0x0000000000000000000000000000000000000000	10000000000000000000	2	56	33362358	2022-09-20T23:58:40.000Z	0x1a2d61cafecaec6db1b9abdb6b3e5df17961c8d01ce074ffce1bba1309f32ea2
53435755433294094965883645103910374908352364589092431600952194478170328235949	12	0x4fa6a722b8c8c75cf1863f5c722ce001c67c7095	0x425173da2eba8e6d6a7fa9786657cac27850273f	false	0x0000000000000000000000000000000000000000	10000000000000000000	2	431	33359725	2022-09-20T22:26:02.000Z	0x09abb876e5cacb09ed90b6bb84f0700ad6ef7096632893f49f973ee442b19081
82124768215732748041413814265590724703258130315608849339732313602198246994057	18	0x4fa6a722b8c8c75cf1863f5c722ce001c67c7095	0x6ca1aa8e21db8f05dc961e07d6bb1fba66e2bd57	false	0x0000000000000000000000000000000000000000	1090730131993515000	16	136	33353119	2022-09-20T18:31:58.000Z	0xb71766352c64f8b6116a3271785ad57c4831af9147868905f427daf51f70a85b

Example Query

Query with partition filter

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