betswirl_v1_avalanche

Tables

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
43539727802193839414234207002706726429564085758367201787747213058843500890725	0x06c737eb2539762fa5277f01aa54e84c6e9972f3	0xce4c48957bf7ef684dd23fa1ee276d2957c2854f	false	0x0000000000000000000000000000000000000000	130000000000000000	3	2	45991767380	18935512	2022-08-21T15:22:40.000Z	0x15d90598a612ec59bb60f257a18d08381c0db49dea9b8b7ce2a6941b34fab9de
1866368577229553945342169536746316786581492380875463184550205784768573821462	0x06c737eb2539762fa5277f01aa54e84c6e9972f3	0xce4c48957bf7ef684dd23fa1ee276d2957c2854f	false	0x0000000000000000000000000000000000000000	130000000000000000	14	1	45991767380	18935465	2022-08-21T15:21:06.000Z	0x4f93c73e43461bd9e33addf9ff6c68a2e8d991bbfb5fb53c3a9701b446d01d7a
12812958866897167431860158425543829690259230323426706353634775224039322859592	0x06c737eb2539762fa5277f01aa54e84c6e9972f3	0xce4c48957bf7ef684dd23fa1ee276d2957c2854f	false	0x0000000000000000000000000000000000000000	100000000000000000	33	7	58902408630	18917287	2022-08-21T05:09:07.000Z	0x692cec67f684a4ea270a122c9e4cdc2c77db41822110d64765d6187c62b2977d

Example Query

Query with partition filter

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

RussianRoulette_AllocateHouseEdgeAmount_event

Event logs recording house edge distribution from Russian Roulette game contracts, allocating gaming profits among initiator rewards, team allocation, dividend pool, and treasury. Contains token addresses and allocation amounts denominated in smallest token units.

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_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.
`in_initiator`	`STRING`	Address of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_team	removed	in_token	log_index	in_dividend	in_treasury	block_number	in_initiator	block_timestamp	transaction_hash
0x5883ee078531307c5a8057b593c0af7b76cb1ea0	560000000000000	false	0x0000000000000000000000000000000000000000	13	1400000000000000	840000000000000	31514778	2800000000000000	2023-06-19T03:19:22.000Z	0xd504c7c02fdda6784a4bb40acd6b1e103312378f054172c20d537f0fb68cba28
0x5883ee078531307c5a8057b593c0af7b76cb1ea0	8400000000000000	false	0x0000000000000000000000000000000000000000	1	21000000000000000	12600000000000000	28636080	42000000000000000	2023-04-12T05:05:50.000Z	0x3c6aac89887553078cbbe10f4fda8550758d9cf2839a127ea56105d7a860c62b
0x5883ee078531307c5a8057b593c0af7b76cb1ea0	28000000000000000	false	0x0000000000000000000000000000000000000000	0	70000000000000000	42000000000000000	28657395	140000000000000000	2023-04-12T16:59:17.000Z	0xb52ec26dc5597a0cf8b214a6509b3e973620742a0fd5a834bdb997394c599ad2

Example Query

Query with partition filter

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

RussianRoulette_Roll_event

Russian Roulette game resolution events emitted when a round completes, containing player addresses occupying seats, eliminated positions, winning participants, bet amounts, and payout distributions. Used for tracking game outcomes and player performance in the Betswirl gambling protocol.

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_seats`	`ARRAY<STRING>`	Array of player addresses occupying seats in the Russian Roulette game round. Hex-encoded, 0x-prefixed, 42-character strings representing all participants before elimination.
`in_winners`	`ARRAY<STRING>`	Array of player addresses that survived the Russian Roulette game round and received payouts. Hex-encoded, 0x-prefixed, 42-character strings.
`in_killedSeats`	`ARRAY<STRING>`	Array of player addresses eliminated in the Russian Roulette game round. Hex-encoded, 0x-prefixed, 42-character strings representing addresses that did not survive the round.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_betAmount`	`STRING`	Bet amount wagered by the player. Numeric string representation of token quantity in smallest denomination.
`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	removed	in_seats	in_token	in_payout	log_index	in_winners	block_number	in_betAmount	in_killedSeats	block_timestamp	transaction_hash
64	0x5883ee078531307c5a8057b593c0af7b76cb1ea0	false	[“0xdfceb6d502812116cc0b965284a08e6b9a526a49”,“0xd477423a220c232627b0cceecb66e9be86a69d27”,“0xd477423a220c232627b0cceecb66e9be86a69d27”,“0xe86695440896098446cec35d3ce318f609e3673a”,“0xe86695440896098446cec35d3ce318f609e3673a”,“0xe86695440896098446cec35d3ce318f609e3673a”,“0xe86695440896098446cec35d3ce318f609e3673a”,“0xe86695440896098446cec35d3ce318f609e3673a”,“0xe86695440896098446cec35d3ce318f609e3673a”,“0xe86695440896098446cec35d3ce318f609e3673a”]	0x0000000000000000000000000000000000000000	4650000000000000000	8	[“0xe86695440896098446cec35d3ce318f609e3673a”]	30078023	500000000000000000	[“0xdfceb6d502812116cc0b965284a08e6b9a526a49”,“0xd477423a220c232627b0cceecb66e9be86a69d27”,“0xd477423a220c232627b0cceecb66e9be86a69d27”,“0xe86695440896098446cec35d3ce318f609e3673a”,“0xe86695440896098446cec35d3ce318f609e3673a”,“0xe86695440896098446cec35d3ce318f609e3673a”,“0xe86695440896098446cec35d3ce318f609e3673a”,“0xe86695440896098446cec35d3ce318f609e3673a”,“0xe86695440896098446cec35d3ce318f609e3673a”]	2023-05-16T03:44:20.000Z	0x533aac7614fbfbbe448cef317ac239cda8e9d3593e6b547c2e3331f38497c44c
21	0x5883ee078531307c5a8057b593c0af7b76cb1ea0	false	[“0x77c9dc116f3092adda6ee040b02baaeb985ba061”,“0x77c9dc116f3092adda6ee040b02baaeb985ba061”,“0x77c9dc116f3092adda6ee040b02baaeb985ba061”,“0x595084b8802cb715ae8e376bf6825eb7c985983b”,“0x595084b8802cb715ae8e376bf6825eb7c985983b”]	0x0000000000000000000000000000000000000000	930000000000000000	8	[“0x595084b8802cb715ae8e376bf6825eb7c985983b”]	28382012	200000000000000000	[“0x77c9dc116f3092adda6ee040b02baaeb985ba061”,“0x77c9dc116f3092adda6ee040b02baaeb985ba061”,“0x595084b8802cb715ae8e376bf6825eb7c985983b”,“0x77c9dc116f3092adda6ee040b02baaeb985ba061”]	2023-04-06T06:42:26.000Z	0x2fc8d676a22c4bf0361cda49ff1333bfb64e5ba48d058e598cc1da246456cbb3
1	0x5883ee078531307c5a8057b593c0af7b76cb1ea0	false	[“0x2c305888a456e7004663bc12a74395e637eabcbc”,“0x2c305888a456e7004663bc12a74395e637eabcbc”]	0x0000000000000000000000000000000000000000	186000000000000000	11	[“0x2c305888a456e7004663bc12a74395e637eabcbc”]	28325231	100000000000000000	[“0x2c305888a456e7004663bc12a74395e637eabcbc”]	2023-04-04T22:53:01.000Z	0x2cb7aa4582bea778a22d3aa27478ff6ca6123b5152c68cabeedbff112dee3503

Example Query

Query with partition filter

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

StakingV1_RewardPaid_event

Staking reward distribution events emitted when users claim or receive earned rewards from protocol staking contracts. Contains user address, reward token contract address, and reward amount denominated in the smallest token unit.

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
0x31edcd915e695adaf782c482b9816613b347ac8c	0x4b3fa40c53d4149299a24af71e9d03d0f44bbe0a	false	288991086746629012	160	32798841	2023-07-19T09:20:10.000Z	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0x4cea211a78080e7565882c5cf658a4e136ed7471128b9c3d0592eebc82e8279e
0x31edcd915e695adaf782c482b9816613b347ac8c	0x51b1651d3aa5f802ab69527e3ce71437b212740d	false	3632513542688000000	8	32798810	2023-07-19T09:19:06.000Z	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0x28dfdd93616b6bd659d7231f2007aa14b27224f55c93568f046c7fe75bb95e3a
0x31edcd915e695adaf782c482b9816613b347ac8c	0x64362046cb1419a89ac39e20eeb64945298ea85d	false	322386755868522299	17	32822932	2023-07-19T22:54:44.000Z	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0xc14c44ae516e81ff780fe8d762453c8ce130eac81cbeb9ecd83f6cc790326f06

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Roulette_Roll_event

RussianRoulette_AllocateHouseEdgeAmount_event

RussianRoulette_Roll_event

StakingV1_RewardPaid_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Roulette_Roll_event

​RussianRoulette_AllocateHouseEdgeAmount_event

​RussianRoulette_Roll_event

​StakingV1_RewardPaid_event

Tables

Roulette_Roll_event

RussianRoulette_AllocateHouseEdgeAmount_event

RussianRoulette_Roll_event

StakingV1_RewardPaid_event