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