TIME_PERIOD | VOLUME | USERS | TXS | |
|---|---|---|---|---|
1 | Before contest | 3018.3448 | 23 | 27 |
2 | After contest | 14744.556949 | 73 | 105 |
0-MIDtotal Stats
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
›
⌄
with tab1 as (
select TX_HASH
from ronin.nft.ez_nft_transfers
where NAME in ('Wild Forest Lords')
)
select --BLOCK_TIMESTAMP::date as day
case
when BLOCK_TIMESTAMP::date>='2025-01-24' and BLOCK_TIMESTAMP::date<='2025-02-09' then 'Before contest'
when BLOCK_TIMESTAMP::date>='2025-02-10' and BLOCK_TIMESTAMP::date<='2025-02-26' then 'After contest'
end as time_period
,sum(VALUE) as volume
,count(distinct FROM_ADDRESS) as users
,count(distinct TX_HASH) as txs
from ronin.core.fact_transactions
where TX_HASH in (select TX_HASH from tab1)
and BLOCK_TIMESTAMP::date>='2025-01-24'
and VALUE<>'0'
and VALUE is not null
group by 1
Last run: 19 days ago
2
74B
4s