betswirl_v1_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_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
0xc7130b9d454243be816b7f5ab09e7ef292b0c465	130000000000000	false	0x0000000000000000000000000000000000000000	166	280000000000000	190000000000000	16946307	2022-04-14T18:48:38.000Z	0xa084e1040b81bb6d2ea56b6353169d134ab1b4201fb0c964dccada29de36dcd3
0xc7130b9d454243be816b7f5ab09e7ef292b0c465	24999999999999	false	0x0000000000000000000000000000000000000000	204	53846153846153	36538461538460	16946159	2022-04-14T18:41:14.000Z	0x679819255d675a5c76b7787e94c8a43bd9150db3d54a95644f95e133e63140ed
0xc7130b9d454243be816b7f5ab09e7ef292b0c465	18055555555554	false	0x0000000000000000000000000000000000000000	286	38888888888888	26388888888888	16947861	2022-04-14T20:06:20.000Z	0x320e809dc8cf852573465e6e825b4c481bf6eb146179641b5f64a25a2cef3cf7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v1_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_payout	in_rolled	log_index	block_number	block_timestamp	transaction_hash
11716936637563813815034488915095296175738132368404856778733149245826610991089	0x76739d9693aa2bb62c44ae1b9084d6937edb91aa	true	0xa34fc5faae47923218958c1c8f2fdd4f71be7b1f	false	0x0000000000000000000000000000000000000000	80000000000000000	155200000000000000	true	596	18192619	2022-05-28T10:30:34.000Z	0xb7d6b330c3eec8ae68c5296e8dd78926c006320e6d5e5e7908dc64f4b97ac70c
42558319503179463052652182509610469708372534182008325943839448234825190677206	0x76739d9693aa2bb62c44ae1b9084d6937edb91aa	false	0x4bf83bacb97969b7387207c294763bad1aec25c9	false	0x0000000000000000000000000000000000000000	200000000000000	0	true	167	17922103	2022-05-18T23:51:03.000Z	0x48d6ef39a50190b2321e9fd68999b98f7c6e6c923d0f2531fc779945e261f11c
80342116827777184633631930127599107135483417465878201323265554698003677070098	0x76739d9693aa2bb62c44ae1b9084d6937edb91aa	false	0x075b048bfe7e83a014152877d74506c8988431eb	false	0x0000000000000000000000000000000000000000	200000000000000	0	true	220	17918192	2022-05-18T20:32:37.000Z	0xc40675e8bc935919a32f425780df074d8db41d278e055129180c733a6a9a4c48

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v1_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_rolled	log_index	block_number	block_timestamp	transaction_hash
73984877654469345897367832404488239817872140416433290046706965230363338498338	84	0xd73812a2e5d57bbea5ef7a142d78da1c383a345f	0x2c305888a456e7004663bc12a74395e637eabcbc	false	0x3e0a7c7db7bb21bda290a80c9811de6d47781671	100000000000000000000	19	185	16835432	2022-04-10T22:12:20.000Z	0xcbd728f8559fc5c28800f12a5d06eb2e1a786bdc9327fd12b78a41c0230f9de2
79153484022333436236889058968573060844044350022512538460991108267093609563713	50	0xd73812a2e5d57bbea5ef7a142d78da1c383a345f	0xe793abff0eeda8b24403f680edc16bf973ae5c96	false	0x0000000000000000000000000000000000000000	200000000000000	38	251	16835006	2022-04-10T21:51:00.000Z	0x6780bb958e7bd9fef670d4780f1495b2106d90b09f16eb7ce9b6bcbb4090d219
103639342125526596880266996241018137311226400756858808486014539502103645483073	18	0xd73812a2e5d57bbea5ef7a142d78da1c383a345f	0xe793abff0eeda8b24403f680edc16bf973ae5c96	false	0x0000000000000000000000000000000000000000	200000000000000	15	108	16835433	2022-04-10T22:12:23.000Z	0x9e6074b6436566d0714195cfb6e3b02a603c84ffc39c1bf1c1576c4d8b64887e

Example Query

Query with partition filter

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

Keno_Roll_event

Keno game roll outcomes from BetSwirl gambling protocol on BSC (Binance Smart Chain), recording player selections, results, wager amounts, and payouts for each game round. Used for analyzing keno gameplay patterns, payout ratios, and player betting behavior.

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
85763813556434932220189037380041004486562991520599686378420339321818211362627	0x144021ad08c37588fbbf49627a24310d0d961979	0x70dc6a4fed8a24c6580d3542c7b3774b328ac62a	false	0x0000000000000000000000000000000000000000	10000000000000000	5884020000000000	3457	414	2338	29260608	2023-06-20T07:37:50.000Z	0xdf73b8afe1141aa6407526780e1f31f6b7d570e6611240845927b8a62c96fc26
5669610481425502314892804623182863001821352597304802626474573578956092455941	0x144021ad08c37588fbbf49627a24310d0d961979	0x5ae330abc5708e66696b30034b0d22eb0d240d0e	false	0x0000000000000000000000000000000000000000	36398796869377646	21417124875535546	18240	69	325	31480388	2023-09-05T15:31:24.000Z	0x07ab2b2023045cacd7f48cd7b59eff73185981e31ae27f7e483f18f9f0366375
51950184817986197717492900671797740370068070019585898763900811708415039468684	0x144021ad08c37588fbbf49627a24310d0d961979	0x5ae330abc5708e66696b30034b0d22eb0d240d0e	false	0x0000000000000000000000000000000000000000	36398796869377646	21417124875535546	220	202	449	31480416	2023-09-05T15:32:49.000Z	0x735cb29e2d0558ad514d19e54f483fe18d39156dd401f701b73543e782436cd8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v1_bsc.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
6034774821674576379216169764774418703804089303348064295254655829475503371202	0x073b8573bc82dd35bfab4e7e23ccb9df78e183f8	0xba18b22d325641b872dbb3b7e0bfe055e913040f	false	0x4e3cabd3ad77420ff9031d19899594041c420aee	1000000000000000000000	2	258	91447186090	21301853	2022-09-13T16:49:32.000Z	0x8c776ad55d0cc1389b8e81986eb107d215609ecdf31e6114ccca488892b7c132
57592803284970950015533461277034817773809361972259903037790304169315470191420	0x073b8573bc82dd35bfab4e7e23ccb9df78e183f8	0xba18b22d325641b872dbb3b7e0bfe055e913040f	false	0x4e3cabd3ad77420ff9031d19899594041c420aee	1000000000000000000000	24	260	91447186090	21301455	2022-09-13T16:29:38.000Z	0xeeb9a854a490256ca0aab21c595ce8466ea63c69ccaebeca5e7d1209445a60a3
92846851058850288852032190452993660126567464823017965833528837317046808654762	0x073b8573bc82dd35bfab4e7e23ccb9df78e183f8	0xba18b22d325641b872dbb3b7e0bfe055e913040f	false	0x4e3cabd3ad77420ff9031d19899594041c420aee	1000000000000000000000	35	85	91447186090	21301601	2022-09-13T16:36:56.000Z	0x7857699d9708bc168b7f174f2200b265f93fc6bc3eb74069482ad2b6adcfa758

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v1_bsc.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
0xb1c4b33030ca6ecae14f3803481f06c8e254218f	350000000000000	false	0x0000000000000000000000000000000000000000	373	875000000000000	525000000000000	27367068	1750000000000000	2023-04-15T10:25:22.000Z	0x7787f830cd65172b29c3486dacebdafff965f4b0cdcc022cd1ff56942e43bae9
0xb1c4b33030ca6ecae14f3803481f06c8e254218f	420000000000000	false	0x0000000000000000000000000000000000000000	133	1050000000000000	630000000000000	27640418	2100000000000000	2023-04-24T22:51:26.000Z	0xc490d73f4de4786ad8a2675629ff4b6ab0b9189d36d2b4f35b4cfd7874195e9b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v1_bsc.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
2	0xb1c4b33030ca6ecae14f3803481f06c8e254218f	false	[“0x341e6ae1c1a0e2a45875f2dcca0a9d494b3c9f3e”,“0x92a2819bbfc94d992368a4087ecbb71842f9003a”]	0x0000000000000000000000000000000000000000	55800000000000000	134	[“0x341e6ae1c1a0e2a45875f2dcca0a9d494b3c9f3e”]	27640418	30000000000000000	[“0x92a2819bbfc94d992368a4087ecbb71842f9003a”]	2023-04-24T22:51:26.000Z	0xc490d73f4de4786ad8a2675629ff4b6ab0b9189d36d2b4f35b4cfd7874195e9b
1	0xb1c4b33030ca6ecae14f3803481f06c8e254218f	false	[“0x2c305888a456e7004663bc12a74395e637eabcbc”,“0x2c305888a456e7004663bc12a74395e637eabcbc”,“0x341e6ae1c1a0e2a45875f2dcca0a9d494b3c9f3e”,“0x08c487012496949da1b8db346d6caab38d103efa”,“0x08c487012496949da1b8db346d6caab38d103efa”]	0x0000000000000000000000000000000000000000	46500000000000000	374	[“0x341e6ae1c1a0e2a45875f2dcca0a9d494b3c9f3e”]	27367068	10000000000000000	[“0x2c305888a456e7004663bc12a74395e637eabcbc”,“0x08c487012496949da1b8db346d6caab38d103efa”,“0x08c487012496949da1b8db346d6caab38d103efa”,“0x2c305888a456e7004663bc12a74395e637eabcbc”]	2023-04-15T10:25:22.000Z	0x7787f830cd65172b29c3486dacebdafff965f4b0cdcc022cd1ff56942e43bae9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v1_bsc.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
0xeb5f6571861eaa6de9f827519b48efe979d4d913	0x365e9edf596f411c502c153255372b9bfe2a3755	false	1214889107619574	96	29552246	2023-06-30T11:19:28.000Z	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0xce48921c232b3e02b54781a7c815a2c36339eab94504f62e6988d50ec4d88850
0xeb5f6571861eaa6de9f827519b48efe979d4d913	0xde9939e9c22c084f9d0d1d58b7640d6aa9503340	false	41043475293581873	122	30443893	2023-07-31T12:35:42.000Z	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0xffd500b3603ff11cc0b3e4c8f832b01df45a79b869128b16afd6d1834c207438
0xeb5f6571861eaa6de9f827519b48efe979d4d913	0x2a3e6b983cb7e1331865d3fe0ca14baf56b4be01	false	48387409816808441	87	30457521	2023-07-31T23:58:58.000Z	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0x8c9f90d652ee64caac6aa463c88f5a1fc1895777b2882e8d483ff69c331b9dfa

Example Query

Query with partition filter

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

Keno_Roll_event

Roulette_Roll_event

RussianRoulette_AllocateHouseEdgeAmount_event

RussianRoulette_Roll_event

StakingV1_RewardPaid_event

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