DATE | unique_players | daily_wagered | daily_plays | |
|---|---|---|---|---|
1 | 2025-02-24 00:00:00.000 | 174 | 1339776.96349317 | 5418 |
2 | 2025-02-23 00:00:00.000 | 238 | 2866786.42743762 | 7378 |
3 | 2025-02-22 00:00:00.000 | 190 | 1060638.26532344 | 2237 |
4 | 2025-02-21 00:00:00.000 | 44 | 135834.391933542 | 551 |
5 | 2025-02-20 00:00:00.000 | 38 | 91723.483247188 | 446 |
6 | 2025-02-19 00:00:00.000 | 27 | 16966.443623229 | 201 |
7 | 2025-02-18 00:00:00.000 | 36 | 32208.06774375 | 257 |
8 | 2025-02-17 00:00:00.000 | 36 | 33859.9154205 | 315 |
9 | 2025-02-16 00:00:00.000 | 24 | 10941.428475 | 130 |
10 | 2025-02-15 00:00:00.000 | 41 | 72622.212740125 | 423 |
11 | 2025-02-14 00:00:00.000 | 17 | 10811.295940104 | 66 |
12 | 2025-02-13 00:00:00.000 | 8 | 2511.4112375 | 18 |
13 | 2025-02-12 00:00:00.000 | 9 | 8259.205564 | 27 |
14 | 2025-02-11 00:00:00.000 | 7 | 1747.11424125 | 42 |
15 | 2025-02-10 00:00:00.000 | 9 | 1999.566045313 | 16 |
16 | 2025-02-09 00:00:00.000 | 9 | 13240.958529375 | 88 |
17 | 2025-02-08 00:00:00.000 | 7 | 5096.1416675 | 98 |
18 | 2025-02-07 00:00:00.000 | 6 | 4229.532271875 | 47 |
19 | 2025-02-06 00:00:00.000 | 8 | 795.698539063 | 27 |
20 | 2025-02-05 00:00:00.000 | 9 | 1485.417172917 | 39 |
permaryDaily Xblub ferdy
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
),
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 >= dateadd('day', -30, current_date)
and a.block_timestamp < current_date
group by 1, 2, 5
)
-- 5️⃣ DAILY TRENDS: How the Game is Growing Over Time
select
Last run: about 2 months ago
30
1KB
4s