date | player | play count | wagered | |
|---|---|---|---|---|
1 | 2025-02-25 00:00:00.000 | 157 | 7112 | 2680745.4418875 |
2 | 2025-02-24 00:00:00.000 | 181 | 5876 | 1527061.63197919 |
3 | 2025-02-23 00:00:00.000 | 249 | 8357 | 3183976.06908208 |
4 | 2025-02-22 00:00:00.000 | 207 | 4798 | 2282332.08703433 |
5 | 2025-02-21 00:00:00.000 | 57 | 1070 | 207177.498505188 |
6 | 2025-02-20 00:00:00.000 | 52 | 1464 | 295429.041775875 |
7 | 2025-02-19 00:00:00.000 | 45 | 1013 | 38733.981991562 |
8 | 2025-02-18 00:00:00.000 | 44 | 890 | 55297.671410729 |
9 | 2025-02-17 00:00:00.000 | 49 | 1171 | 56135.668077125 |
10 | 2025-02-16 00:00:00.000 | 42 | 883 | 31307.750457521 |
11 | 2025-02-15 00:00:00.000 | 51 | 1048 | 95765.906998125 |
12 | 2025-02-14 00:00:00.000 | 22 | 249 | 14796.522802667 |
13 | 2025-02-13 00:00:00.000 | 10 | 29 | 3685.348121042 |
14 | 2025-02-12 00:00:00.000 | 11 | 111 | 11109.051986542 |
15 | 2025-02-11 00:00:00.000 | 9 | 377 | 11229.357765 |
16 | 2025-02-10 00:00:00.000 | 17 | 171 | 5734.370215625 |
17 | 2025-02-09 00:00:00.000 | 13 | 289 | 17127.266082292 |
18 | 2025-02-08 00:00:00.000 | 10 | 293 | 9425.604333083 |
19 | 2025-02-07 00:00:00.000 | 10 | 280 | 8930.595475625 |
20 | 2025-02-06 00:00:00.000 | 14 | 310 | 12900.878026667 |
permarydaily-blue
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"
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'),
lower('0x8a06D417df79e271B99C42dfB55158de3594f963'),
lower('0x3d74Cbac40E2F23a795C665056613e3f3a83d160')
)
and a.origin_function_signature in (
'0x53ccbeea',
'0x2426b72b',
'0x53ccbeea',
'0xe427275b',
'0x14ea3539',
'0x51ea0b03',
Last run: about 2 months ago
...
193
9KB
7s