GAME | UNIQUE_PLAYERS | TOTAL_WAGERED | TOTAL_PLAYS | TOTAL_GAME_STARTS | |
|---|---|---|---|---|---|
1 | Blub Flip | 285 | 2090818.57148828 | 8993 | 26829 |
2 | Blub Wheel | 243 | 1709693.8779737 | 3791 | 7662 |
3 | Blub Plinko | 183 | 1023683.20102267 | 3073 | 5630 |
permaryMost played blub game
Updated 2025-02-26
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 between timestamp '2025-02-22 21:20'
and timestamp '2025-02-25 06:40'
group by 1
),
blub_games as (
select
date_trunc('day', a.block_timestamp) as date,
a.origin_from_address as player,
count(distinct a.tx_hash) as play_count,
sum(a.amount * b.price) as total_wagered,
case
when lower(a.origin_to_address) = '0x7d812a58dd63eb3a7b3b84f9290bd84db148893f' then 'blub flip'
when lower(a.origin_to_address) = '0x0382df14b587c51052ffcca53db8697849ca1b2e' then 'blub plinko'
when lower(a.origin_to_address) = '0x3d74cbac40e2f23a795c665056613e3f3a83d160' then 'blub wheel'
end as game
from avalanche.core.ez_native_transfers a
join avax_price b
on date_trunc('day', a.block_timestamp) = b.day
where lower(a.origin_to_address) in (
'0x7d812a58dd63eb3a7b3b84f9290bd84db148893f',
'0x0382df14b587c51052ffcca53db8697849ca1b2e',
'0x3d74cbac40e2f23a795c665056613e3f3a83d160'
)
and a.origin_function_signature in ('0x53ccbeea', '0xe427275b', '0x11af445d')
and a.block_timestamp between timestamp '2025-02-22 21:20' and timestamp '2025-02-25 06:40'
group by 1, 2, 5
)
select
Last run: about 2 months ago
3
139B
3s