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
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
Sample Data
| address | in_bank | in_team | removed | in_token | log_index | in_partner | in_dividend | in_treasury | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x61523749e6fb1ef538f2d57db13a62ad33a55449 | 19384615384615 | 3230769230769 | false | 0x0000000000000000000000000000000000000000 | 0 | 0 | 6461538461538 | 3230769230769 | 145510986 | 2023-10-30T20:07:02.000Z | 0xd4e0c1befe7711877352b2c1c711d0352e2cbc9df0f6bafe69f6330a47e04348 |
| 0x61523749e6fb1ef538f2d57db13a62ad33a55449 | 126315789473683 | 21052631578947 | false | 0x0000000000000000000000000000000000000000 | 0 | 0 | 42105263157894 | 21052631578947 | 145473958 | 2023-10-30T17:05:31.000Z | 0x41ff11fc694f1b01fe52dd3f70fcfca65a75cd19d123c20966369c16de9aede1 |
| 0x61523749e6fb1ef538f2d57db13a62ad33a55449 | 22500000000000 | 3750000000000 | false | 0x0000000000000000000000000000000000000000 | 0 | 0 | 7500000000000 | 3750000000000 | 145474665 | 2023-10-30T17:08:55.000Z | 0x6e64d8622a41fd29e837623bf33d0099af6ebfebcbc23c3277eedce37ea83fe9 |
Example Query
Example Query
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