DATE | PLATFORMS | ADDRESS | TRANSACTIONS | |
|---|---|---|---|---|
1 | 2025-01-19 00:00:00.000 | AXIE Infinity | 121440 | 187512 |
2 | 2025-02-05 00:00:00.000 | Others | 30947 | 190623 |
3 | 2025-01-06 00:00:00.000 | Apeiron | 54541 | 54771 |
4 | 2025-02-07 00:00:00.000 | Wild Forest | 20217 | 21413 |
5 | 2025-01-28 00:00:00.000 | Apeiron | 30974 | 31087 |
6 | 2025-02-11 00:00:00.000 | Lumiterra | 1446 | 1497 |
7 | 2025-04-06 00:00:00.000 | Pixels | 165636 | 168478 |
8 | 2025-01-29 00:00:00.000 | Pixels | 230115 | 235225 |
9 | 2025-02-07 00:00:00.000 | The Machines Arena | 119039 | 119552 |
10 | 2025-02-26 00:00:00.000 | Pixels | 261917 | 270317 |
11 | 2025-03-15 00:00:00.000 | Lumiterra | 1814 | 1839 |
12 | 2025-03-05 00:00:00.000 | Apeiron | 51553 | 51681 |
13 | 2025-03-10 00:00:00.000 | AXIE Infinity | 121893 | 198717 |
14 | 2025-03-09 00:00:00.000 | Kaidro Chronicle | 702 | 78822 |
15 | 2025-03-17 00:00:00.000 | Apeiron | 36988 | 37154 |
16 | 2025-03-20 00:00:00.000 | Kaidro Chronicle | 536 | 747 |
17 | 2025-01-11 00:00:00.000 | Wild Forest | 104799 | 107069 |
18 | 2025-01-14 00:00:00.000 | AXIE Infinity | 123182 | 200263 |
19 | 2025-01-21 00:00:00.000 | Kaidro Chronicle | 891 | 126516 |
20 | 2025-01-16 00:00:00.000 | Pixels | 283325 | 290853 |
hess5. Daily Share
Updated 2025-04-09
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
›
⌄
with games as ( select * from $query('798c2d2f-083d-45a4-90e3-262eb17af08f')
)
,
total as ( select label,
count(distinct tx_hash) as txns
from ronin.core.fact_transactions a join games b on a.to_address = b.address
group by 1
order by 2 desc
limit 7)
,
tops as (select address,
label as platform,
count(distinct tx_hash) as txns
from ronin.core.fact_transactions a join games b on a.to_address = b.address
where label in (select label from total)
group by 1,2)
select block_timestamp::date as date,
case when platform is null then 'Others' else platform end as platforms,
count(distinct FROM_ADDRESS) as address,
count(distinct tx_hash) as transactions
from ronin.core.fact_transactions a left outer join tops b on a.to_address = b.address
where block_timestamp::date >= '2025-01-01'
group by 1,2
Last run: 17 days ago
...
792
42KB
31s