betswirl_v1_arbitrum

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	in_dividend	in_treasury	block_number	block_timestamp	transaction_hash
0x61523749e6fb1ef538f2d57db13a62ad33a55449	134328358208955	22388059701492	false	0x0000000000000000000000000000000000000000	44776119402985	22388059701492	142386860	2023-10-20T18:57:13.000Z	0x5cf89aecfb62ed3e67ea0cd36b83ddc486ba7b302ac029f139436d5ce759666c
0x61523749e6fb1ef538f2d57db13a62ad33a55449	163636363636363	27272727272727	false	0x0000000000000000000000000000000000000000	54545454545454	27272727272727	142387353	2023-10-20T18:59:43.000Z	0xd2c90a2466ccc0e79540992e6d9d7d63e5aaebcada7750042dddd6084a422712
0x61523749e6fb1ef538f2d57db13a62ad33a55449	339622641509433	56603773584905	false	0x0000000000000000000000000000000000000000	113207547169811	56603773584905	142352532	2023-10-20T16:05:11.000Z	0x6a0d891c9a30bc65080021109419d84e2cac782387ccecab0c6e00d407aa60dd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v1_arbitrum.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
89640722418515843059381613165911338007160721593590709038464826379047076612492	0xf4c6ba9dd0d26a8e2de4bdab046df61afc3952eb	false	0x45cdc4594d27432256d3669be370fb85b25aafb8	false	0x0000000000000000000000000000000000000000	2500000000000000	0	true	9	84259579	2023-04-25T20:26:36.000Z	0xb8a61d10fda0b21b47b019520ae78cca1dbd35f7384a746fde846c8e4d1f32dd
89148622473183983592821069162345703517999444383218886188571848311616611692707	0xf4c6ba9dd0d26a8e2de4bdab046df61afc3952eb	false	0x45cdc4594d27432256d3669be370fb85b25aafb8	false	0x0000000000000000000000000000000000000000	2500000000000000	0	false	1	84259664	2023-04-25T20:26:58.000Z	0x10ebf732f397e0869cc271d9b2239256fe2682ca409006f3924f7b16a5e155a2
798543735178141458545668852873668875806339156791559445033291641755593881531	0xf4c6ba9dd0d26a8e2de4bdab046df61afc3952eb	true	0x2c305888a456e7004663bc12a74395e637eabcbc	false	0x0000000000000000000000000000000000000000	1000000000000000	1940000000000000	true	7	83797075	2023-04-24T12:05:19.000Z	0x919608c9f6c46d6a7263826aaa886c7647d35079d9f5f3cfd449d1619d9a55b9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v1_arbitrum.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
32720506959357050168847921801847457158172113470485494534695065378048664664244	71	0x6f3b387fb817a9128386d01debb90ce428f6a07d	0x42838970285c5fef7e2f408a059eb6410bc60518	false	0x0000000000000000000000000000000000000000	769933707639460	26	1	133934410	2023-09-23T20:17:05.000Z	0x1af6651cd10bf3a81c78ce221d9ba1d3e3adc8bbebefef51a2b638f9a476163e
4474940023283703812542030985066432931283035754197794031060458145391346874072	50	0x6f3b387fb817a9128386d01debb90ce428f6a07d	0x42838970285c5fef7e2f408a059eb6410bc60518	false	0x0000000000000000000000000000000000000000	1284300000000000	15	1	133967308	2023-09-23T23:07:48.000Z	0x2fe97590ea23136c46ef3fb1448f672a859795b4de0f91e0e0652bfc7408c462
105890778972759835756094252983259715269128985984595580558318752594649626797736	24	0x6f3b387fb817a9128386d01debb90ce428f6a07d	0x42838970285c5fef7e2f408a059eb6410bc60518	false	0x0000000000000000000000000000000000000000	908955721429370	3	1	133951299	2023-09-23T21:43:17.000Z	0x7ea43d87f2e61d85cb687c28794ac949382eb23b088fee6ced4583413f4eb2da

Example Query

Query with partition filter

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

Keno_Roll_event

Keno game roll events from BetSwirl decentralized casino on Arbitrum, tracking player bets with wagered amounts, selected numbers, rolled results, and payout outcomes. Enables analysis of player behavior, game fairness verification, and house edge calculations.

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
91186066238305689696998094060271075470369917767596200433593324434183743631740	0x08f28c744be07a1b7eb5ca30e298b799364cfb34	0x5d7753194ec7605c7ba785f4d1fa8c2612e5bf9d	false	0x0000000000000000000000000000000000000000	919578981857239	371960502371434	8394	2	8788	107270689	2023-07-02T23:20:03.000Z	0x5e053bae405785692ea82d4754ad7076ab047723a0359118f3b93c7191531425
102541510626506475208977165210102193656505496563020032509640634866333580744270	0x08f28c744be07a1b7eb5ca30e298b799364cfb34	0x5d7753194ec7605c7ba785f4d1fa8c2612e5bf9d	false	0x0000000000000000000000000000000000000000	919578981857239	371960502371434	24632	2	8788	107270840	2023-07-02T23:20:43.000Z	0x31d04785fd58a936eff78ec38feadc3134db866943d44f2e5ee5ea31f1a23854
60783089777620188781704647071978161777011145189784764292550493833400048873599	0x08f28c744be07a1b7eb5ca30e298b799364cfb34	0x5d7753194ec7605c7ba785f4d1fa8c2612e5bf9d	false	0x0000000000000000000000000000000000000000	919578981857239	371960502371434	1476	9	8788	107270757	2023-07-02T23:20:20.000Z	0x817bbe5cad23473358f37418bc8da2a5602edcda1fb541d7d76babcc76b296e7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v1_arbitrum.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_payout	in_rolled	log_index	in_numbers	block_number	block_timestamp	transaction_hash
49941760710802584206198692077175485273212646981737866359904357788062289179759	0x6d8fcfc4c166835ffa3baf978d1d871b9dc05141	0x6eb4e1b2e08a91e691775b81e9b3cb61147f10df	false	0x0000000000000000000000000000000000000000	20000000000000000	25715000000000000	20	2	46170550270	198587644	2024-04-07T16:31:35.000Z	0x02cbdf75e9b9d1e3d7fd9212746282f008b3e9d3732ab2421eaa861dd67a7d38
50980514634491086540383175615069244581775219954140972574626000550810076744373	0x6d8fcfc4c166835ffa3baf978d1d871b9dc05141	0x6eb4e1b2e08a91e691775b81e9b3cb61147f10df	false	0x0000000000000000000000000000000000000000	20000000000000000	0	18	1	46170550270	198587587	2024-04-07T16:31:21.000Z	0xe8adb1cf109c3778c425660900050dab533e4f6aced3bca85c292532d2b6306a
71289509149292334525867330668299695391624762528072081150390883745813636701078	0x6d8fcfc4c166835ffa3baf978d1d871b9dc05141	0xdc75d95bc46fafed33304c470b4810a4ad2b70e9	false	0x0000000000000000000000000000000000000000	1100000000000000	0	1	14	4194432	262454758	2024-10-10T19:51:03.000Z	0x9247d98d53c58d841986964f9ac7d85018b25428206c007b17d2c4fc805b1c53

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v1_arbitrum.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
0x73a3b27cae6b416ea739536d38407baeaf63e5a5	7000000000000000000	false	0xe26ae3d881f3d5def58d795f611753804e7a6b26	11	17500000000000000000	10500000000000000000	83967111	35000000000000000000	2023-04-25T00:03:26.000Z	0x108dd184a93fc8271b0285bfcf03a9952e5621f188425890b9f8d55b0833de91
0x73a3b27cae6b416ea739536d38407baeaf63e5a5	210000	false	0x4cfa50b7ce747e2d61724fcac57f24b748ff2b2a	3	525000	315000	178347569	1050000	2024-02-07T12:55:23.000Z	0x9e26e0130032cf1118ab675e963c67100d119030fad93692aeafc8f6ee2464e0
0x73a3b27cae6b416ea739536d38407baeaf63e5a5	210000	false	0x4cfa50b7ce747e2d61724fcac57f24b748ff2b2a	0	525000	315000	178346031	1050000	2024-02-07T12:48:55.000Z	0x28034aee407e726669ddd2e1777a54db34b7abc2839654c6c77524f71f186b8b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v1_arbitrum.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
33	0x73a3b27cae6b416ea739536d38407baeaf63e5a5	false	[“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0xc0c5b3dbab356dd0b7bbf4a68392b472ed4f3ca7”,“0x08a05ed11367c38d8a8e0400ca527b836fade4c0”,“0x7f8dda85d44a6f225257375546fec2f96c3b95ee”,“0x0ada191ebd33c22dd76e48fc490cf2eafad2a90b”,“0xbbfd9988ea52ee8c88f7ba28d1db827e73955ae8”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”]	0x4cfa50b7ce747e2d61724fcac57f24b748ff2b2a	14880000	3	[“0x0ada191ebd33c22dd76e48fc490cf2eafad2a90b”]	174140228	1000000	[“0xc0c5b3dbab356dd0b7bbf4a68392b472ed4f3ca7”,“0xbbfd9988ea52ee8c88f7ba28d1db827e73955ae8”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0x7f8dda85d44a6f225257375546fec2f96c3b95ee”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”,“0x08a05ed11367c38d8a8e0400ca527b836fade4c0”,“0xf0ee42aa7a347a2d1e9dbdf5cfc42b66843ab33d”]	2024-01-25T20:01:38.000Z	0x009facb1a7ea836423a381fc79d05df42bf5991e8d0008c3ed17d4eb6f08aac2
7	0x73a3b27cae6b416ea739536d38407baeaf63e5a5	false	[“0x6eb4e1b2e08a91e691775b81e9b3cb61147f10df”,“0x6eb4e1b2e08a91e691775b81e9b3cb61147f10df”]	0x0000000000000000000000000000000000000000	65100000000000000	1	[“0x6eb4e1b2e08a91e691775b81e9b3cb61147f10df”]	92260799	35000000000000000	[“0x6eb4e1b2e08a91e691775b81e9b3cb61147f10df”]	2023-05-19T11:36:18.000Z	0xb86d9e085596a981e3ca1f90d07169ad1ca399fbb010e53a092e4389f71c0883
45	0x73a3b27cae6b416ea739536d38407baeaf63e5a5	false	[“0xeb6b882a295d316ac62c8cfcc81c3e37c084b7c5”,“0xe890380af2b1fe0aab440e6ea07e9aad5048cf62”,“0x7a6f38594496617f61f8358912f4ea69fe33d02f”,“0x7a6f38594496617f61f8358912f4ea69fe33d02f”,“0xcdd2d2fcc80c209b6d33ad94ed3e01166a1fe623”,“0x75964ac8cc1676eb51451f25faaaefd40ccde602”,“0xfae62c9056f9e9c3cf555311ade26a2eab01a8e3”,“0xfae62c9056f9e9c3cf555311ade26a2eab01a8e3”,“0x5823327ae76c52bf1cdccb5df83d84f8dac7ba07”,“0xaaea16cdc55e5edd8a3906471a83787391c72afa”,“0xec10935cef44e63ebd02166f092eb78b59db6ba0”,“0x50ae8da158e03e76400d53ee263b6eaff3c21cf0”,“0xaec109dcd8521d4e12a7ec04532cbf9ecaffcc52”,“0xaec109dcd8521d4e12a7ec04532cbf9ecaffcc52”,“0xaec109dcd8521d4e12a7ec04532cbf9ecaffcc52”,“0xaec109dcd8521d4e12a7ec04532cbf9ecaffcc52”,“0xaec109dcd8521d4e12a7ec04532cbf9ecaffcc52”,“0x7f8dda85d44a6f225257375546fec2f96c3b95ee”,“0x9cd8993e6c4adad9db8ddc3a1b2904a86f3f0165”,“0x11b0030ac9906bb242dd2bfbe11a3ba3394e089f”]	0x4cfa50b7ce747e2d61724fcac57f24b748ff2b2a	18600000	6	[“0x7a6f38594496617f61f8358912f4ea69fe33d02f”]	180673894	1000000	[“0x50ae8da158e03e76400d53ee263b6eaff3c21cf0”,“0x7a6f38594496617f61f8358912f4ea69fe33d02f”,“0x5823327ae76c52bf1cdccb5df83d84f8dac7ba07”,“0x7f8dda85d44a6f225257375546fec2f96c3b95ee”,“0xaec109dcd8521d4e12a7ec04532cbf9ecaffcc52”,“0x75964ac8cc1676eb51451f25faaaefd40ccde602”,“0xaec109dcd8521d4e12a7ec04532cbf9ecaffcc52”,“0xaec109dcd8521d4e12a7ec04532cbf9ecaffcc52”,“0xcdd2d2fcc80c209b6d33ad94ed3e01166a1fe623”,“0x11b0030ac9906bb242dd2bfbe11a3ba3394e089f”,“0xaec109dcd8521d4e12a7ec04532cbf9ecaffcc52”,“0xe890380af2b1fe0aab440e6ea07e9aad5048cf62”,“0x9cd8993e6c4adad9db8ddc3a1b2904a86f3f0165”,“0xec10935cef44e63ebd02166f092eb78b59db6ba0”,“0xaaea16cdc55e5edd8a3906471a83787391c72afa”,“0xaec109dcd8521d4e12a7ec04532cbf9ecaffcc52”,“0xfae62c9056f9e9c3cf555311ade26a2eab01a8e3”,“0xeb6b882a295d316ac62c8cfcc81c3e37c084b7c5”,“0xfae62c9056f9e9c3cf555311ade26a2eab01a8e3”]	2024-02-14T13:10:17.000Z	0xbc0b7a9060e489ef0b1d6e3e5f33180df8316aeeb5d8d22874ba0490d21ecb23

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.betswirl_v1_arbitrum.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
0xd4bfb259d8785228e5d2c19115d5db342e2ee064	0x855f76f69826b41d663da8587c199e5ff4c55325	false	4582465116560714	23	115411251	2023-07-27T09:22:48.000Z	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x6314d2e829a9a51d67d02f4defce85d85c9d90ca19b8f91289ad5a15a69507ae
0xd4bfb259d8785228e5d2c19115d5db342e2ee064	0x2152b333edcdfe906635e78761d7b93d62740106	false	35455212773374481	1	115594670	2023-07-27T22:40:47.000Z	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x074efd4e0b154c00f79b20404179099390440a4e5651e6101bd45e954292fb93
0xd4bfb259d8785228e5d2c19115d5db342e2ee064	0xe0674496f64965bc8cd376cf87b4c6c434c85065	false	13959647362278008	3	115513793	2023-07-27T16:35:18.000Z	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x6f263ace782ab1d07d560805dc2e3fb0c4c960bd41d4b2ce7370626f405c5823

Example Query

Query with partition filter

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