date | player | play count | wagered | game | |
|---|---|---|---|---|---|
1 | 2025-02-25 00:00:00.000 | 6 | 12 | 369.648825 | PVP Flip |
2 | 2025-02-25 00:00:00.000 | 84 | 1159 | 462154.771143813 | Blub Plinko |
3 | 2025-02-25 00:00:00.000 | 64 | 685 | 568784.208932875 | Blub Wheel |
4 | 2025-02-25 00:00:00.000 | 86 | 4517 | 1287075.36234225 | Blub Flip |
5 | 2025-02-25 00:00:00.000 | 3 | 87 | 235352.047409375 | Dice |
6 | 2025-02-25 00:00:00.000 | 17 | 60 | 10015.0789375 | Roulette |
7 | 2025-02-25 00:00:00.000 | 7 | 106 | 7195.16500625 | Keno |
8 | 2025-02-25 00:00:00.000 | 22 | 483 | 109705.866967938 | Range and Limbo |
9 | 2025-02-25 00:00:00.000 | 3 | 3 | 93.2923225 | RPS |
10 | 2025-02-24 00:00:00.000 | 4 | 8 | 497.8409625 | RPS |
11 | 2025-02-24 00:00:00.000 | 22 | 299 | 173058.267090188 | Range and Limbo |
12 | 2025-02-24 00:00:00.000 | 7 | 17 | 2872.972101563 | Dice |
13 | 2025-02-24 00:00:00.000 | 4 | 8 | 1099.96425 | PVP Flip |
14 | 2025-02-24 00:00:00.000 | 22 | 62 | 3537.14694375 | Roulette |
15 | 2025-02-24 00:00:00.000 | 85 | 692 | 218651.732873438 | Blub Wheel |
16 | 2025-02-24 00:00:00.000 | 105 | 1838 | 618406.10591025 | Blub Plinko |
17 | 2025-02-24 00:00:00.000 | 8 | 64 | 5632.049095313 | Keno |
18 | 2025-02-24 00:00:00.000 | 92 | 2888 | 503305.552752187 | Blub Flip |
19 | 2025-02-23 00:00:00.000 | 8 | 28 | 1359.264579167 | Keno |
20 | 2025-02-23 00:00:00.000 | 11 | 20 | 140.322670833 | RPS |
permaryFerdy flip analysis
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 a
where symbol = 'WAVAX'
group by 1
order by 1 desc
)
select
date_trunc('day', a.block_timestamp) as "date",
count(distinct a.origin_from_address) as "player",
count(distinct a.tx_hash) as "play count",
sum(a.amount * b.price) as "wagered",
case when lower(a.origin_to_address) = lower('0x7D812a58DD63Eb3A7b3b84f9290BD84dB148893F') then 'Blub Flip'
when lower(a.origin_to_address) = lower('0x08E1e965b485Ed4f8F4E4b32bc65bBbE5F302D72') then 'Range and Limbo'
when lower(a.origin_to_address) = lower('0x5035fC7a8b92C21e5146a4F00ccE543Df4B35A3e') then 'RPS'
when lower(a.origin_to_address) = lower('0x0382DF14B587c51052FFcCA53DB8697849Ca1B2e') then 'Blub Plinko'
when lower(a.origin_to_address) = lower('0x50e50B4076817b10C341CaB216C28012069eC3Ed') then 'Dice'
when lower(a.origin_to_address) = lower('0x8425E43C147329BF5B12b17Aba180bb5834e3Bbf') then 'Keno'
when lower(a.origin_to_address) = lower('0x02C1eDfbA909Dafd1ECf6aA9182FC69ee4c10e11') then 'Roulette'
when lower(a.origin_to_address) = lower('0x8a06D417df79e271B99C42dfB55158de3594f963') then 'PVP Flip'
when lower(a.origin_to_address) = lower('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 (
lower('0x7D812a58DD63Eb3A7b3b84f9290BD84dB148893F'),
lower('0x08E1e965b485Ed4f8F4E4b32bc65bBbE5F302D72'),
lower('0x5035fC7a8b92C21e5146a4F00ccE543Df4B35A3e'),
lower('0x0382DF14B587c51052FFcCA53DB8697849Ca1B2e'),
lower('0x50e50B4076817b10C341CaB216C28012069eC3Ed'),
lower('0x8425E43C147329BF5B12b17Aba180bb5834e3Bbf'),
lower('0x02C1eDfbA909Dafd1ECf6aA9182FC69ee4c10e11'),
Last run: about 2 months ago
...
1035
58KB
6s