betswirl_v2_avalanche

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
0x187de399100aa962f209aa78621f5138aca6111f	11666	false	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	5	19166	19166	16312711	2022-06-21T05:18:05.000Z	0xce2a3a0decb8382c83b437206e1fe3caf302a1385efdc599a6f3c5116959efd1
0x187de399100aa962f209aa78621f5138aca6111f	11666	false	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	4	19166	19166	16307523	2022-06-21T02:24:57.000Z	0x33e97e99773f0bd71a554a52fe0d2544c14dc73e53acfc205a7c915694b34512
0x187de399100aa962f209aa78621f5138aca6111f	11666	false	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	11	19166	19166	16307636	2022-06-21T02:28:43.000Z	0xd758b1b5bfbe280f3856362635fcca1caf60b3cd32a628e53a6dd81f385a2f39

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v2_avalanche.Bank_AllocateHouseEdgeAmount_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
95991177802350761550933669352548807914347647180912517778249389053065612497574	0x556bc2bbe113cec48fc3b2c45afb708fb09dda63	0x4ca11ba147210542a0acc519fbb8ef82c051db8c	false	0x0000000000000000000000000000000000000000	10000000000000000	18	5	1	19889090	2022-09-15T05:39:55.000Z	0x36f9ee91f8875bb8f6ecc1de2877555d1b729a9bf8ab0af1df75eded2630727a
111293384270617304380142352401078866982921490611903461372623607616651657526327	0x556bc2bbe113cec48fc3b2c45afb708fb09dda63	0x4ca11ba147210542a0acc519fbb8ef82c051db8c	false	0x0000000000000000000000000000000000000000	20000000000000000	28	2	1	19889113	2022-09-15T05:40:53.000Z	0x3ce63cc2f033ad91249e6a38b974f57c39df7ebb4bda1a4c221b045ffe8d474f
73855330743945606192568479760099395596419888961936516566658102002627333265998	0x556bc2bbe113cec48fc3b2c45afb708fb09dda63	0x4ca11ba147210542a0acc519fbb8ef82c051db8c	false	0x0000000000000000000000000000000000000000	20000000000000000	23	49	1	19889104	2022-09-15T05:40:31.000Z	0xbbf11eed5a269d6c43f9b261b4a8ad57cbe23a9a1cec39a59f5ea0c768d9d3a0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v2_avalanche.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
0x9913effa744b72385e537e092710072d21f8bc98	0x0ec9efc8c5305978cb957c74b228d4949f5e9dd0	false	449025211385896365	33	34864956	2023-09-07T03:22:56.000Z	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0xb11975dadd4b2b577de7a4fd6f35f81276c99032a07b6a60d063c64c34dad013
0x9913effa744b72385e537e092710072d21f8bc98	0x671675805456d04165f6e03f71ab2b92f63e01b8	false	488089123605342845	12	34883948	2023-09-07T14:41:26.000Z	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0x7a77969ce98d21a49252ec3e0353f728083390afd933bbbf6d494260b339f922
0x9913effa744b72385e537e092710072d21f8bc98	0x671675805456d04165f6e03f71ab2b92f63e01b8	false	290945444313139007	10	34866954	2023-09-07T04:34:27.000Z	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0x6a99b2f445a4572ccae8737923457fc8975ba782970e8cd10fc958075eae1dab

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Bank_AllocateHouseEdgeAmount_event

Roulette_Roll_event

StakingV2_RewardPaid_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Bank_AllocateHouseEdgeAmount_event

​Roulette_Roll_event

​StakingV2_RewardPaid_event

Tables

Bank_AllocateHouseEdgeAmount_event

Roulette_Roll_event

StakingV2_RewardPaid_event