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 TOKEN_ID

,sum(VALUE) as volume

from tab1

left join tab2

on tab1.TX_HASH=tab2.TX_HASH

where VALUE>0

group by 1

order by 2 desc