DATE | GAME | UNIQUE_PLAYERS | TOTAL_GAMES | TOTAL_WINNERS | WIN_RATE | TOTAL_PAYOUTS | USD_PAYOUTS | |
|---|---|---|---|---|---|---|---|---|
1 | 2025-02-25 00:00:00.000 | Blub Flip | 66 | 4131 | 4131 | 100 | 2.656579e-14 | 5.702568205e-13 |
2 | 2025-02-25 00:00:00.000 | Blub Plinko | 65 | 927 | 927 | 100 | 8.385598958e-15 | 1.800038696e-13 |
3 | 2025-02-25 00:00:00.000 | Blub Wheel | 52 | 491 | 492 | 100.2 | 5.0448e-15 | 1.08290836e-13 |
4 | 2025-02-24 00:00:00.000 | Blub Flip | 95 | 2888 | 2889 | 100.03 | 9.795784e-15 | 2.331233329e-13 |
5 | 2025-02-24 00:00:00.000 | Blub Plinko | 108 | 1838 | 1838 | 100 | 1.23016512e-14 | 2.927587958e-13 |
6 | 2025-02-24 00:00:00.000 | Blub Wheel | 88 | 692 | 691 | 99.86 | 3.908943e-15 | 9.302632849e-14 |
7 | 2025-02-23 00:00:00.000 | Blub Plinko | 82 | 743 | 743 | 100 | 3.509014e-15 | 8.860114141e-14 |
8 | 2025-02-23 00:00:00.000 | Blub Flip | 166 | 3865 | 3858 | 99.82 | 2.309544316e-14 | 5.831503166e-13 |
9 | 2025-02-23 00:00:00.000 | Blub Wheel | 153 | 2770 | 2770 | 100 | 2.6430728e-14 | 6.673648692e-13 |
10 | 2025-02-22 00:00:00.000 | Blub Wheel | 95 | 370 | 370 | 100 | 9.707e-16 | 2.460117813e-14 |
11 | 2025-02-22 00:00:00.000 | Blub Plinko | 66 | 597 | 597 | 100 | 9.2898847e-15 | 2.354405154e-13 |
12 | 2025-02-22 00:00:00.000 | Blub Flip | 142 | 1270 | 1265 | 99.61 | 9.357249158e-15 | 2.371477833e-13 |
13 | 2025-02-21 00:00:00.000 | Blub Flip | 30 | 284 | 284 | 100 | 8.45714e-16 | 2.126301186e-14 |
14 | 2025-02-21 00:00:00.000 | Blub Plinko | 31 | 229 | 229 | 100 | 1.5113084e-15 | 3.799744174e-14 |
15 | 2025-02-21 00:00:00.000 | Blub Wheel | 11 | 38 | 38 | 100 | 4.11e-17 | 1.033339625e-15 |
16 | 2025-02-20 00:00:00.000 | Blub Flip | 21 | 47 | 47 | 100 | 1.1266e-16 | 2.745852792e-15 |
17 | 2025-02-20 00:00:00.000 | Blub Plinko | 27 | 343 | 343 | 100 | 1.412481e-15 | 3.442628171e-14 |
18 | 2025-02-20 00:00:00.000 | Blub Wheel | 8 | 56 | 56 | 100 | 1.464e-16 | 3.568195e-15 |
19 | 2025-02-19 00:00:00.000 | Blub Flip | 24 | 87 | 87 | 100 | 2.2747e-16 | 5.367249429e-15 |
20 | 2025-02-19 00:00:00.000 | Blub Wheel | 8 | 59 | 59 | 100 | 3.275e-17 | 7.727498958e-16 |
permaryintegrated-moccasin
Updated 2025-02-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH avax_price AS (
SELECT
DATE_TRUNC('day', hour) AS day,
AVG(price) AS price
FROM avalanche.price.ez_prices_hourly
WHERE symbol = 'AVAX'
AND hour >= DATEADD('day', -30, CURRENT_DATE)
GROUP BY 1
),
game_events AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS date,
tx_hash,
origin_from_address AS player,
contract_address,
event_name,
CASE
WHEN LOWER(contract_address) = '0x7d812a58dd63eb3a7b3b84f9290bd84db148893f' THEN 'Blub Flip'
WHEN LOWER(contract_address) = '0x0382df14b587c51052ffcca53db8697849ca1b2e' THEN 'Blub Plinko'
WHEN LOWER(contract_address) = '0x3d74cbac40e2f23a795c665056613e3f3a83d160' THEN 'Blub Wheel'
END AS game
FROM avalanche.core.ez_decoded_event_logs
WHERE LOWER(contract_address) IN (
'0x7d812a58dd63eb3a7b3b84f9290bd84db148893f',
'0x0382df14b587c51052ffcca53db8697849ca1b2e',
'0x3d74cbac40e2f23a795c665056613e3f3a83d160'
)
AND event_name IN ('WinnerPicked', 'GameStarted')
AND block_timestamp >= DATEADD('day', -30, CURRENT_DATE)
),
winnings AS (
SELECT
t.tx_hash,
t.block_timestamp,
Last run: about 2 months ago
90
7KB
56s