(select el.block_timestamp as dte,

origin_from_address,

el.contract_address as nft_address,

nft.project_name,

el.tx_hash

from base.core.fact_event_logs el

inner join base.core.ez_nft_transfers nft

on el.contract_address = nft.nft_address

and el.tx_hash=nft.tx_hash

where 1=1

and el.origin_to_address='0x00000000000000adc04c56bf30ac9d3c0aaf14dc'

and el.origin_to_address!=contract_address

), t2 as

select t.*, eth_value from temp t inner join base.core.fact_transactions ft

on t.tx_hash=ft.tx_hash

),

t3 as

select dte

, tx_hash

, origin_from_address

, nft_address

, project_name

, avg(eth_value) as price

from t2

group by 1,2,3,4,5

select date_trunc('hour',dte) as date,

project_name,

sum(price) as volume

from t3

group by 1 , 2