Skip to main content

​
Tables

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_idSTRINGUnique identifier for the position, record, or entity within the protocol. Numeric string representation.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_numbersSTRINGPlayer’s selected numbers or positions for the wager. Numeric string representation encoding the chosen bet configuration in the gaming protocol.
in_rolledINT64Randomly generated outcome value from the gaming protocol’s verifiable randomness system.
in_payoutSTRINGPayout amount awarded to the player or winner. Numeric string representation of token quantity in smallest denomination.
in_idaddressin_userremovedin_tokenin_amountin_payoutin_rolledlog_indexin_numbersblock_numberblock_timestamptransaction_hash
550962597418102253794555490244267511276036557374717109551681057569943797773560x6d8fcfc4c166835ffa3baf978d1d871b9dc051410x2ba83118c82db3f8bc1ab4bdcfbdb241e91729b2false0x00000000000000000000000000000000000000002100000000000000420011666666666710375242862738982812024-11-13T02:54:35.000Z0xeddad0e92b6f8b4d835d05ae2a7797188471fad79b93fd7e853b72924a92bfe4
1069691101828455624033393014114170495318708898960309477862790946231708888801930x6d8fcfc4c166835ffa3baf978d1d871b9dc051410x2ba83118c82db3f8bc1ab4bdcfbdb241e91729b2false0x0000000000000000000000000000000000000000100000000000000002965242862738972622024-11-13T02:50:19.000Z0xcf05bc88d1bdd9b9f0c4c7ad5c7a3bd09f7b90c7bcf7fa0304eddb91cec96bf6
279029279710946151078872766891779277350752163808511855698017479052385722769950x6d8fcfc4c166835ffa3baf978d1d871b9dc051410x2ba83118c82db3f8bc1ab4bdcfbdb241e91729b2false0x0000000000000000000000000000000000000000210000000000000003218366435779842738984422024-11-13T02:55:15.000Z0x0030b290dee3ece049788f34fd6011d0d620760f217bd4577c408cbcec691f00
Query with partition filter
SELECT *
FROM `tt-contracts.betswirl_v3_arbitrum.Roulette_Roll_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100