betswirl_v3_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_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
0x908a71b19b25f3c7cdc7597136d8f4ac068d4971	13920000000000	3480000000000	false	0x0000000000000000000000000000000000000000	1	10440000000000	6960000000000	26292546	2023-02-15T14:38:20.000Z	0xc3adb27c87b0b9569d16afbafda645d61d11226657c51b339628595c582898d2
0x908a71b19b25f3c7cdc7597136d8f4ac068d4971	23976000000000	5994000000000	false	0x0000000000000000000000000000000000000000	3	17982000000000	11988000000000	26294947	2023-02-15T15:59:42.000Z	0xde3fc2a47f612f13018c67b4a67004d3ab845f1b6f4e081e444d7b8182270632
0x908a71b19b25f3c7cdc7597136d8f4ac068d4971	45597600000000	11399400000000	false	0x0000000000000000000000000000000000000000	10	34198200000000	22798800000000	26301681	2023-02-15T19:46:01.000Z	0xd5690c9636466d6dc052f8ded1306eb172e985e7acd51e55ee9b4bfd9129b977

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v3_avalanche.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
19063824585151681286666656685702981207051213227700905279488254568605811718353	0x6d47cb207ee241ce67b2750402de44bd1ba45482	true	0xce4c48957bf7ef684dd23fa1ee276d2957c2854f	false	0x0000000000000000000000000000000000000000	270000000000000000	523800000000000000	true	24	18935107	2022-08-21T15:09:03.000Z	0xb18e66e9b2dda7b6ad07e1898be67b72b5026df73f62f5966413a41c405cb67b
18771027115873076965901520666028729543506838902083240222872858198318454369301	0x6d47cb207ee241ce67b2750402de44bd1ba45482	true	0xce4c48957bf7ef684dd23fa1ee276d2957c2854f	false	0x0000000000000000000000000000000000000000	120000000000000000	0	false	11	18935091	2022-08-21T15:08:30.000Z	0xcb31f24332c380a1c2493f5b4a8ccbff06a484d2660c1b002ba22256717583b3
110785965767611638845138328372022747100616191217239531094527973244344226232765	0x6d47cb207ee241ce67b2750402de44bd1ba45482	true	0x2c305888a456e7004663bc12a74395e637eabcbc	false	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	1000000	0	false	3	16357880	2022-06-22T06:26:29.000Z	0x6a514e9c3ab4be3f077640dcccf55512594cefff8c2f8f034cf2b3d4724804ec

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v3_avalanche.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
65503484370645788839620661268601406125779174398356847295903940679809016867967	40	0xa149c31657584a40f449780392312973c097f900	0x241dd49319a9c692a81ff24623f0d8536ee91a07	false	0x0000000000000000000000000000000000000000	100000000000000000	15	53	18369349	2022-08-08T09:22:09.000Z	0x3d5123d35fa6e9ae2dcafbf141e29630793a247504470fa8754d3b0190f29bef
49736340470411240712926906901389031989137326457670020540861341636063253427766	20	0xa149c31657584a40f449780392312973c097f900	0x19af8ee9aff0d9909c918af7e3c5e75d45eed518	false	0x0000000000000000000000000000000000000000	300000000000000000	16	1	16330373	2022-06-21T15:09:33.000Z	0x6ca23640c84568b19379eb02f08015d51a18c1a24474136a8c0b3832c4ce4ad0
64100612527789336249283193852974598045557601190202841946064570320810889336191	30	0xa149c31657584a40f449780392312973c097f900	0x19af8ee9aff0d9909c918af7e3c5e75d45eed518	false	0x0000000000000000000000000000000000000000	624189798265255300	8	1	16330403	2022-06-21T15:10:33.000Z	0xc0d2326afac7f11da685fe7e2781d35c75946004d04a47fbc189641a2cf5d87b

Example Query

Query with partition filter

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