0-MIDTrade price-before
    Updated 2025-02-19

    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: 28 days ago
    COLLECTION
    MAX
    AVG
    USERS
    TXS
    1
    WF252113.30541112
    1
    27B
    2s