Skip to main content

​
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.
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_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_bankSTRINGAmount allocated to the bank from house edge distribution. Numeric string representation of token wei or smallest unit amount.
in_dividendSTRINGAmount allocated to dividends from house edge distribution. Numeric string representation of token wei or smallest unit amount.
in_partnerSTRINGAddress of the partner or referral entity associated with the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_treasurySTRINGContract address of the Aave protocol treasury. Hex-encoded, 0x-prefixed, 42-character string.
in_teamSTRINGAmount allocated to the team from house edge distribution. Numeric string representation of token wei or smallest unit amount.
addressin_bankin_teamremovedin_tokenlog_indexin_partnerin_dividendin_treasuryblock_numberblock_timestamptransaction_hash
0x61523749e6fb1ef538f2d57db13a62ad33a55449193846153846153230769230769false0x000000000000000000000000000000000000000000646153846153832307692307691455109862023-10-30T20:07:02.000Z0xd4e0c1befe7711877352b2c1c711d0352e2cbc9df0f6bafe69f6330a47e04348
0x61523749e6fb1ef538f2d57db13a62ad33a5544912631578947368321052631578947false0x00000000000000000000000000000000000000000042105263157894210526315789471454739582023-10-30T17:05:31.000Z0x41ff11fc694f1b01fe52dd3f70fcfca65a75cd19d123c20966369c16de9aede1
0x61523749e6fb1ef538f2d57db13a62ad33a55449225000000000003750000000000false0x000000000000000000000000000000000000000000750000000000037500000000001454746652023-10-30T17:08:55.000Z0x6e64d8622a41fd29e837623bf33d0099af6ebfebcbc23c3277eedce37ea83fe9
Query with partition filter
SELECT *
FROM `tt-contracts.betswirl_v4_arbitrum.Bank_AllocateHouseEdgeAmount_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100