with tab1 as (

select --BLOCK_TIMESTAMP::date as day

TX_HASH

,ORIGIN_FROM_ADDRESS

,TOKEN_ID

from ronin.nft.ez_nft_transfers

where ORIGIN_TO_ADDRESS='0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc'

and ORIGIN_FUNCTION_SIGNATURE='0x2beee4c7'

and NAME='Lumiterra Game Item'

and BLOCK_TIMESTAMP::date>='2024-11-11'

),

tab2 as (

select --BLOCK_TIMESTAMP::date as day

TX_HASH

,VALUE

from ronin.core.fact_transactions

select 'Lumiterra' as coll

,max(VALUE) as max_price

,median(VALUE) as med_price

,avg(VALUE) as avg_price

,min(VALUE) as min_price

from tab1

left join tab2

on tab1.TX_HASH=tab2.TX_HASH

where VALUE>0

group by 1