betswirl_v3_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
0x2528401607cc0590d31c2fca129a75dc13b1dbb7	4122846950062539171	1030711737515634792	false	0x0000000000000000000000000000000000000000	68	3092135212546904378	2061423475031269585	33509792	2022-09-24T13:59:49.000Z	0xb3e5c5263c5dc6de18b1f14374c97633ff43cb6bc5e25046dd0735465145696c
0x2528401607cc0590d31c2fca129a75dc13b1dbb7	41280000000000000	10320000000000000	false	0x0000000000000000000000000000000000000000	53	30960000000000000	20640000000000000	33514615	2022-09-24T16:47:48.000Z	0x4c0ad883ebe3399aa33c1b3e9d697ac50e6dd6614d91f6ea3da9d3b77a22b276
0x2528401607cc0590d31c2fca129a75dc13b1dbb7	4128388800000000000	1032097200000000000	false	0x0000000000000000000000000000000000000000	84	3096291600000000000	2064194400000000000	33510705	2022-09-24T14:33:19.000Z	0xdcd59eea16fa408bab4c00052b8c6b0772b5715ffbe068dc80911feceaac7d15

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v3_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_payout	in_rolled	log_index	block_number	block_timestamp	transaction_hash
59139641678548640942180340046034173030473349473440645564755328981326474913728	0x5e312882767e3b0efa6bfbbcbbe74d1475fdc939	false	0xc770c9e0f0c6e91a924dc6975bcffde89c476e3e	false	0x62f594339830b90ae4c084ae7d223ffafd9658a7	900000000000000000000	1737000000000000000000	false	184	49293999	2023-10-29T12:30:42.000Z	0x5d6368ce9fed6024f2bdcc8967659f0aa66fafee3643acde37e563ecfbca9689
52708576488582478822430394035305702386117890225275532099381108912193311851377	0x5e312882767e3b0efa6bfbbcbbe74d1475fdc939	false	0xc770c9e0f0c6e91a924dc6975bcffde89c476e3e	false	0x62f594339830b90ae4c084ae7d223ffafd9658a7	200000000000000000000	386000000000000000000	false	145	49294069	2023-10-29T12:33:12.000Z	0x697cca3aaf0a029205458deeccc1479a16d9df6ad416dc5a716f321cdc246109
80499071371351925156941245282196577266985168757964115345413733319530973927028	0x5e312882767e3b0efa6bfbbcbbe74d1475fdc939	false	0x9062a5e6c63360f4fc6739bda0dce438b622da8c	false	0x62f594339830b90ae4c084ae7d223ffafd9658a7	5000000000000000000000	9650000000000000000000	false	99	49298071	2023-10-29T15:03:17.000Z	0xd7aacb38a34152e45db0bb8b27a27168fc3915424ddb61a0d030c3bc8008edd9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v3_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_payout	in_rolled	log_index	block_number	block_timestamp	transaction_hash
84252797793852597335890135600153401548988056451107784629982987186225757044453	12	0x54003260bd79b252483ac6e07dc8a5e0aceb3895	0x089da352d9b9c929f2e41bd85769fafc31b67376	false	0x62f594339830b90ae4c084ae7d223ffafd9658a7	20088051800000000000000	22028374985227272727272	73	117	33817328	2022-10-02T01:07:09.000Z	0x690702ca6e163149713d88f40d21e2f10ff3dce5750ad2b5094dd3b271e1aba9
92741370951709576751041229696705453598348385451620332943876536210034683600723	30	0x54003260bd79b252483ac6e07dc8a5e0aceb3895	0x200155d850c9afe5e04cbf95a3ff8162504ea14b	false	0x62f594339830b90ae4c084ae7d223ffafd9658a7	898000000000000000000	1237957142857142857143	41	79	33851249	2022-10-02T20:43:55.000Z	0x3d39b62ce38a0b1583340e496ee30edc0760a7ec973ee32e5766e5e7d2ee2a99
59924200666576386682547136865792762847171656220284206617082770874898234791437	49	0x54003260bd79b252483ac6e07dc8a5e0aceb3895	0x200155d850c9afe5e04cbf95a3ff8162504ea14b	false	0x62f594339830b90ae4c084ae7d223ffafd9658a7	4500000000000000000000	8514705882352941176470	66	156	33851291	2022-10-02T20:45:23.000Z	0x6cc9317331a459b8615c18575ae521fd96d79e3149cd63589e6026c609f5ab7f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v3_polygon.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_payout	in_rolled	log_index	in_numbers	block_number	block_timestamp	transaction_hash
66830412018915320871560206972044952318865073641996228775939038854043016351231	0xc518fbe02c4125e8e7e63b05cd9ddddbee6b9d49	0x806346b423ddb4727c1f5dc718886430aa7ce9cf	false	0x4e3decbb3645551b8a19f0ea1678079fcb33fb4c	4501853137595659000	40517803701645329915	11	92	1082132736	36716910	2022-12-11T22:59:52.000Z	0x9714b081949e1d636001718e05ae7fc08af85e4ebc4afacc9d631e7f3dbd8b2c
89342721041234004784993680714065305388380357429486130727229061938346307395504	0xc518fbe02c4125e8e7e63b05cd9ddddbee6b9d49	0x36b3560b03e67325732bde47e345f8a28d202116	false	0x0000000000000000000000000000000000000000	500000000000000000	0	27	89	45991767380	36705919	2022-12-11T16:19:27.000Z	0x31c16fba3a708a8d6514cad357319ea6865a642249c7770734dcb65e6ac2fb34
2502070445926411798871928020190225801104402288908702828778400896322967387936	0xc518fbe02c4125e8e7e63b05cd9ddddbee6b9d49	0x36b3560b03e67325732bde47e345f8a28d202116	false	0x0000000000000000000000000000000000000000	330000000000000000	660018333333333334	2	138	45991767380	36705938	2022-12-11T16:20:09.000Z	0x16765d457f607c917d507d30f9ce66f65f01427f03de3af2bb4bfda92eb34d53

Example Query

Query with partition filter

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

Overview

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

Tables

Bank_AllocateHouseEdgeAmount_event

CoinToss_Roll_event

Dice_Roll_event

Roulette_Roll_event