betswirl_v2_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_dividend`	`STRING`	Amount allocated to dividends from house edge distribution. Numeric string representation of token wei or smallest unit amount.
`in_referral`	`STRING`	Referral code identifier associated with the transaction. Numeric string representation, often ‘0’ when no referral is present.
`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_team	removed	in_token	log_index	in_dividend	in_treasury	block_number	block_timestamp	transaction_hash
0xf26e41e3714efe1ff03b423f45dcc31a98c21867	101562500000000	false	0x0000000000000000000000000000000000000000	247	218750000000000	148437500000000	20458589	2022-08-15T08:59:44.000Z	0x50643eb4c44ab4b56b83411bd9c19d0c0ae757d9a9c1ff42c1a31883bd8bac96
0xf26e41e3714efe1ff03b423f45dcc31a98c21867	101562500000000	false	0x0000000000000000000000000000000000000000	289	218750000000000	148437500000000	20458567	2022-08-15T08:58:38.000Z	0x0a531e4c6f191ab9e94bca663f2cda0ff15567f4f66b12c3e1bd0faf5cf28709
0xf26e41e3714efe1ff03b423f45dcc31a98c21867	166666666666666	false	0x0000000000000000000000000000000000000000	301	358974358974358	243589743589743	20456272	2022-08-15T07:00:04.000Z	0xe07624f49083eccc5ff57ab0ac65a96dfb5be12c4744987f2eee49197e19873e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v2_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
72978298002197673662609314889820222290558254501496102905256601642199077448043	0xa6d00859fa870620b8b79294cd9c6b02fcf982f4	true	0x2ae6471264de2c283b14ac874d689ae62c0850a9	false	0x0000000000000000000000000000000000000000	50000000000000000	false	141	18659725	2022-06-13T18:28:46.000Z	0x5524359c84b45eb7099a32445d86accdc4cd525cdbe5df026dbdeacef2f589c9
68169002166622783871958718863837332799474354355932870328080651176577120464666	0xa6d00859fa870620b8b79294cd9c6b02fcf982f4	true	0x2ae6471264de2c283b14ac874d689ae62c0850a9	false	0x0000000000000000000000000000000000000000	50000000000000000	false	189	18662927	2022-06-13T21:09:52.000Z	0x9233e88d65b2c8026273dc0eddd08a2698f73495420f117cea33b925dfd566a3
64438663345554677230834168436683842534844843370047013182734162161189695977541	0xa6d00859fa870620b8b79294cd9c6b02fcf982f4	true	0x4417de67fbb1c2c77718e4733c07e19976a7eaf7	false	0x0000000000000000000000000000000000000000	50000000000000000	false	132	18661643	2022-06-13T20:05:40.000Z	0x162de1c41989f3dc0e83c323337530982381219d436b2e44df50fe7b4a136ce0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v2_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
72219693720078818737881774508278270547322246830740602529391229188089678786241	4	0xebe9f31b4f276bd42ff45946514710babc48ce5f	0xa9fb562ccbdefa02138acbe8acf8253f3e62a8ba	false	0x4e3cabd3ad77420ff9031d19899594041c420aee	5000000000000000000000	5026041666666666666667	10	323	18574854	2022-06-10T19:15:42.000Z	0x83a7bdebb97f74a62ba1480444816f5a94885ebba58116967003e7925804dd96
82229678548400283223255931458522351559917835441644041532358662447462354290291	4	0xebe9f31b4f276bd42ff45946514710babc48ce5f	0xecae1f4e41c3a45f14fc78c4a2ab17421004bde8	false	0x4e3cabd3ad77420ff9031d19899594041c420aee	5000000000000000000000	5026041666666666666667	8	109	18554193	2022-06-10T01:56:45.000Z	0x0b1fa158099c5105f7200affa15c9cba718ea36bddbfc880604ccef849d9c2a5
84265022178202163003770427351013149168392182438744766396011738763396375323078	4	0xebe9f31b4f276bd42ff45946514710babc48ce5f	0x4f80ef22ba5f4221162f9a5d6ea237b3f416ebc7	false	0x4e3cabd3ad77420ff9031d19899594041c420aee	5000000000000000000000	5026041666666666666667	16	319	18566962	2022-06-10T12:37:09.000Z	0xd80ca3086c7946d22c83bed0f03189270ba72d1a589d06e35e9988e0eb5cb6f4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v2_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
56810841011810948718955504530492944895756275034677327598848845704303507750554	0x105ad8cce099d051b6320d645671a3532b6159f7	0x6991c1b476d580167cfdff0cf87bf77b6ad48398	false	0x0000000000000000000000000000000000000000	5000000000000000	12	191	45812984490	22114561	2022-10-12T15:03:06.000Z	0x858bd0574bf59ddf0815df15c26267127a198fdfb1be819f1db88e7387cc9339
103863009562242131095108150303883271487827102224521076450278906638102474089582	0x105ad8cce099d051b6320d645671a3532b6159f7	0x6991c1b476d580167cfdff0cf87bf77b6ad48398	false	0x0000000000000000000000000000000000000000	5000000000000000	30	278	45812984490	22114537	2022-10-12T15:01:54.000Z	0xa77ef98d4dda1db482abff3b46b0cb54a5562927a0f61d6793b813aacd2762e3
108857055916429420373593825360246144122985509600117323302195774173196897663853	0x105ad8cce099d051b6320d645671a3532b6159f7	0x9f9672eb14d26d2cfe289396d41fc71154bf1d12	false	0x4e3cabd3ad77420ff9031d19899594041c420aee	1000000000000000000000	28	241	128	22103678	2022-10-12T05:45:10.000Z	0xe1e20318f519f422d972fa34d260521179c9b2acb1b449dbb9bae55bce959205

Example Query

Query with partition filter

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

StakingV2_RewardPaid_event

Staking reward distribution events emitted when users claim accrued rewards from staking contracts. Records the recipient address, reward token contract, and reward amount paid out.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewardsToken`	`STRING`	Contract address of the reward token being distributed. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	in_rewardsToken	transaction_hash
0x20df34ebe5dcb1082297a18ba8d387b55fb975a0	0xfc4848605c2201091a3df1b64b9c40cf730b7569	false	126054497917218551	151	32496260	2023-10-11T00:58:39.000Z	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0x73d468cadc03fc20e52b46427ad97e14c4cbfce02922d3a47e51c385e40155ae
0x20df34ebe5dcb1082297a18ba8d387b55fb975a0	0x69e24369bfeda80348bd5104df01c4d8b33ecff9	false	14163775118732707	137	32522933	2023-10-11T23:18:35.000Z	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0xbcf7b3d4ab08c648f4987021ff6af00aceab953662215406894ebc1ebf46da58
0x20df34ebe5dcb1082297a18ba8d387b55fb975a0	0x523d0cd051e272856a2c925c08a5fba8425c4944	false	908304618100000	670	30561940	2023-08-04T15:18:10.000Z	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0x8c45a4624ee15f41bd307afc6982a8dcbfd6e379ef1623474b0354d98e4ed687

Example Query

Query with partition filter

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

StakingV2_RewardPaid_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Bank_AllocateHouseEdgeAmount_event

​CoinToss_Roll_event

​Dice_Roll_event

​Roulette_Roll_event

​StakingV2_RewardPaid_event

Tables

Bank_AllocateHouseEdgeAmount_event

CoinToss_Roll_event

Dice_Roll_event

Roulette_Roll_event

StakingV2_RewardPaid_event