COLLECTION | MAX | AVG | USERS | TXS | |
|---|---|---|---|---|---|
1 | WF | 252 | 113.3054 | 11 | 12 |
0-MIDTrade price-before
Updated 2025-02-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with tab1 as (
select TX_HASH
from ronin.nft.ez_nft_transfers
where NAME in ('Wild Forest Lords')
)
select 'WF' as collection
,max(VALUE) as max
,avg(VALUE) as avg
,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-02-01'and BLOCK_TIMESTAMP::date<='2025-02-09'
and VALUE<>'0'
and VALUE is not null
group by 1
Last run: 27 days ago
1
27B
2s