betswirl_v1_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_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_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	removed	in_token	log_index	in_treasury	block_number	block_timestamp	transaction_hash
0x72a5b0295eaacc8c005ec6a800cb9beced73da0e	false	0x0000000000000000000000000000000000000000	106	6000000000000000	27208375	2022-04-16T14:32:26.000Z	0x3494443ff0dddffdd3432cee2254df4097f71dcb77510cc19a8cc415a638218b
0x72a5b0295eaacc8c005ec6a800cb9beced73da0e	false	0x0000000000000000000000000000000000000000	29	135000000000000000	27223796	2022-04-16T23:47:01.000Z	0x90d7b800d9540df9afe2598510a3717d80ee57c8b9cc9c68f91b49738a96df8c
0x72a5b0295eaacc8c005ec6a800cb9beced73da0e	false	0x0000000000000000000000000000000000000000	119	1500000000000000	27208360	2022-04-16T14:31:56.000Z	0x0783ca35dee57f33724dc150b3d294f798534d47b05727f192c050a947e7c035

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v1_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_rolled	log_index	block_number	block_timestamp	transaction_hash
89824595436658824179832524801227170053888281073396636117893695689668801023237	0x67cf8c56c09d747db83a94d5828c4dbcb13487f9	true	0x22eef082c1f80758d092a802f77d665480dfb835	false	0x0000000000000000000000000000000000000000	1000000000000000000	false	494	25442752	2022-03-01T03:03:08.000Z	0xcebae71d4e71e236399da7796ab6e4d5c87ed70c695324e06fe7fc820e287d01
97159008431316024474340071710271808634154024001092393866001949947461810922340	0x67cf8c56c09d747db83a94d5828c4dbcb13487f9	true	0x22eef082c1f80758d092a802f77d665480dfb835	false	0x0000000000000000000000000000000000000000	1000000000000000000	false	87	25456078	2022-03-01T11:47:38.000Z	0x62f6e65f443ee3b4c32ca22ed304e17f28013e207910cd6aed3e790df78685ff
29575564786112991159253338117115314777115262006753351507408226626330455044475	0x67cf8c56c09d747db83a94d5828c4dbcb13487f9	true	0x22eef082c1f80758d092a802f77d665480dfb835	false	0x0000000000000000000000000000000000000000	1000000000000000000	false	235	25457019	2022-03-01T12:21:10.000Z	0xc526446a49cfc05deb374897ff6e96c17f5b2f91765ae3aefcf93fc3227ffc30

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v1_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_rolled	log_index	block_number	block_timestamp	transaction_hash
45163987509750309154950906901790623016386117636072247902646534330280372451542	60	0xc38842415049f265f6714154bd3fc120c554b54c	0x35288cdc877f90b575abc70f5d02560f6d7e868e	false	0x0000000000000000000000000000000000000000	1000000000000000000	13	81	25729443	2022-03-08T14:59:00.000Z	0xe0c5d9d2c31b295475632900aade0e63d5e52fce56f45c3525f51b14e95da1ae
79429219029834366068302447418880396630056240085838340823507072402903511225864	60	0xc38842415049f265f6714154bd3fc120c554b54c	0x35288cdc877f90b575abc70f5d02560f6d7e868e	false	0x0000000000000000000000000000000000000000	1000000000000000000	36	71	25729468	2022-03-08T14:59:50.000Z	0x8b866777c18b8ea0999164c5d0a7947101dedfff792cb20da1ebe97c5ba20a2d
8524066028730857733883514952478482964976727268164734367976747832213870468008	50	0xc38842415049f265f6714154bd3fc120c554b54c	0x50b13f2f79fa06ab33f5eaf7ddea666499c36de2	false	0x0000000000000000000000000000000000000000	10000000000000000	49	108	25741198	2022-03-08T22:06:38.000Z	0x4baa26be31bf96aa9441f1c8b1968b898484758d7370adac4da5f098d908f422

Example Query

Query with partition filter

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

Keno_Roll_event

Keno game roll outcome events from BetSwirl casino protocol on Polygon, recording bet amounts, selected numbers, random roll results, and payouts for each wager. Used for analyzing game outcomes, player betting patterns, and house edge performance.

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`	`STRING`	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
101552624908252017468547739571321952427061451346460093157181251436261257406115	0x85965f322e8da9ecb1f3abf75b0144042f6f8873	0x0e6621085de7b28c5a84adeaec7790b7f8efc57b	false	0x0000000000000000000000000000000000000000	2000000000000000000	1604768000000000000	105	103	1136	43986116	2023-06-16T18:22:25.000Z	0xfe75af16237628e0e3c9b049649c7ad95e3077c9958b90c967c32658515b9ae1
67796596372813001176650149179363084417096817654970170648300149196922945139529	0x85965f322e8da9ecb1f3abf75b0144042f6f8873	0x0e6621085de7b28c5a84adeaec7790b7f8efc57b	false	0x0000000000000000000000000000000000000000	2000000000000000000	802384000000000000	9225	78	1136	43986135	2023-06-16T18:23:05.000Z	0x704588f5fd8fd08e1c6ff48c4e6a7f73eee6e9ed5f5417abc14bc16d9e0716bd
44177490627011838976832313825664206289195371078241876416476132396144369994265	0x85965f322e8da9ecb1f3abf75b0144042f6f8873	0x2c305888a456e7004663bc12a74395e637eabcbc	false	0x0000000000000000000000000000000000000000	10000000000000000	6686210000000000	14352	71	44	43985242	2023-06-16T17:48:07.000Z	0x256a118f5d9cd32ae6b9483f335f520e850f302ccf5e8070fc27ebe56c9bf72b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v1_polygon.Keno_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
103575289952936055846541133286481883616799829433012459674624974920617324900218	0xc63cf4c40864186a942a3762d4eaccb9645a66b2	0xcde2f94112479ce21097367b273d55975bcfc6e1	false	0x0000000000000000000000000000000000000000	1000000000000000000	35	70	520874	32094884	2022-08-20T02:31:20.000Z	0x6e6eedcf1582bbf913bc7bf8fb6dc4dc39c32610481389d65431d08d09690749
37301420486030678687531399663898139940196916307029256401412730455125932798238	0xc63cf4c40864186a942a3762d4eaccb9645a66b2	0xcde2f94112479ce21097367b273d55975bcfc6e1	false	0x0000000000000000000000000000000000000000	1000000000000000000	8	44	1048576	32093906	2022-08-20T01:51:20.000Z	0xf26a924f86b4703c625172a1a7c0402993b5e8f593f95a92a66bf961759555f9
48455958029734982287884915895723237952629060356481402226059498756695463341897	0xc63cf4c40864186a942a3762d4eaccb9645a66b2	0xdac4d5e4f69e58e66b178fb98101b78a95706816	false	0x9246a5f10a79a5a939b0c2a75a3ad196aafdb43b	15000000000000000000000	2	102	91447186090	32111185	2022-08-20T12:30:01.000Z	0xf733f865e00bacf08e5acabb2669b5250ae1cc95220c4b42ffe35c6b93df93cc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v1_polygon.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
0x58645a4488b9e7a05a3ec5dc874bfa5abbd62cfc	49000000000000000	false	0x0000000000000000000000000000000000000000	120	122500000000000000	73500000000000000	46795995	245000000000000000	2023-08-27T00:08:28.000Z	0x80fe329ccb4b14a723182b9105cdca5e0d72327be1ea7d4d32504c3194e75d20
0x58645a4488b9e7a05a3ec5dc874bfa5abbd62cfc	42000000000000000	false	0x0000000000000000000000000000000000000000	66	105000000000000000	63000000000000000	46795948	210000000000000000	2023-08-27T00:06:48.000Z	0xcf920625e2da68d8afe96b56cc987f00153408f5fe12b959fc88e0bf549ce8dc
0x58645a4488b9e7a05a3ec5dc874bfa5abbd62cfc	350000000000000000	false	0x0000000000000000000000000000000000000000	76	875000000000000000	525000000000000000	46796212	1750000000000000000	2023-08-27T00:16:42.000Z	0x8079d60a04192857a93041892258167a1a8441a19b83813b32605650101079fc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v1_polygon.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
28	0x58645a4488b9e7a05a3ec5dc874bfa5abbd62cfc	false	[“0x303eff4eb381e966052d4d9ad5560e9fd778db39”,“0x303eff4eb381e966052d4d9ad5560e9fd778db39”]	0x0000000000000000000000000000000000000000	1860000000000000000	78	[“0x303eff4eb381e966052d4d9ad5560e9fd778db39”]	45121199	1000000000000000000	[“0x303eff4eb381e966052d4d9ad5560e9fd778db39”]	2023-07-15T20:35:46.000Z	0x01455f887ee1a5c82bdd01d669371869553ab684627b0dda3e4d77b50a1a6060
36	0x58645a4488b9e7a05a3ec5dc874bfa5abbd62cfc	false	[“0xed684079af754343484a7cd29db21d3a6d1dbdf7”,“0x21724584c0e2bd499c0dd273d616cf27afe9b3d0”]	0x0000000000000000000000000000000000000000	5580000000000000000	137	[“0x21724584c0e2bd499c0dd273d616cf27afe9b3d0”]	53014384	3000000000000000000	[“0xed684079af754343484a7cd29db21d3a6d1dbdf7”]	2024-02-01T21:55:58.000Z	0xfb2da0e9b8582d259359108f2f2638e8f980020e1b69733651f1891642297dc1
33	0x58645a4488b9e7a05a3ec5dc874bfa5abbd62cfc	false	[“0x82585832c33ce8812b2933a6cab0da9eb1ec05bd”,“0x82585832c33ce8812b2933a6cab0da9eb1ec05bd”,“0x30b766cccf3b89cdfe5c8e8c632c4e38b9adc6ae”,“0x30b766cccf3b89cdfe5c8e8c632c4e38b9adc6ae”,“0x30b766cccf3b89cdfe5c8e8c632c4e38b9adc6ae”]	0x0000000000000000000000000000000000000000	4650000000000000000	69	[“0x30b766cccf3b89cdfe5c8e8c632c4e38b9adc6ae”]	47403160	1000000000000000000	[“0x82585832c33ce8812b2933a6cab0da9eb1ec05bd”,“0x82585832c33ce8812b2933a6cab0da9eb1ec05bd”,“0x30b766cccf3b89cdfe5c8e8c632c4e38b9adc6ae”,“0x30b766cccf3b89cdfe5c8e8c632c4e38b9adc6ae”]	2023-09-11T06:50:29.000Z	0xdf00cc772288b22eb79480c0254365ac47ae93f64b5514d9d0a0619e8e4129fb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v1_polygon.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
0xa184468972c71209bc31a5ef39b7321d2a839225	0x057532933627b16d7ded57921f58a0c1ecf8d63c	false	4312044208940000000	95	44372443	2023-06-26T20:25:07.000Z	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x6677f2c3fc4bdb46e2dadca4259f17c361492ed3fe100ccf3a11ffd389bfb042
0xa184468972c71209bc31a5ef39b7321d2a839225	0x1523b038ecba1629c4018caa15f39f27f9ecb4d5	false	193116294593657304727	227	44628671	2023-07-03T09:36:32.000Z	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x338b08328643bfdf1affd4ee749d6a98fc8316d29433d6c98195d70f7871a912
0xa184468972c71209bc31a5ef39b7321d2a839225	0x252da81d73f596bdc8a122a5e8d553dfe6c7d361	false	46424372918821903541	486	44640691	2023-07-03T16:59:39.000Z	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x0d8d5ca3c84163275c2cd10d980772e59db2e2e0bbbbd6918eb63ee97c3afb90

Example Query

Query with partition filter

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

Keno_Roll_event

Roulette_Roll_event

RussianRoulette_AllocateHouseEdgeAmount_event

RussianRoulette_Roll_event

StakingV1_RewardPaid_event

​Tables

​Bank_AllocateHouseEdgeAmount_event

​CoinToss_Roll_event

​Dice_Roll_event

​Keno_Roll_event

​Roulette_Roll_event

​RussianRoulette_AllocateHouseEdgeAmount_event

​RussianRoulette_Roll_event

​StakingV1_RewardPaid_event

Tables

Bank_AllocateHouseEdgeAmount_event

CoinToss_Roll_event

Dice_Roll_event

Keno_Roll_event

Roulette_Roll_event

RussianRoulette_AllocateHouseEdgeAmount_event

RussianRoulette_Roll_event

StakingV1_RewardPaid_event