tx_hash, nft_address, project_name, nft_from_address, nft_to_address,

tokenid

from ethereum.core.ez_nft_transfers),

tab2 as (select date_trunc('day',block_timestamp) as day, tx_hash, from_address, tx_fee, eth_value

from ethereum.core.fact_transactions

where to_address='0x74312363e45dcaba76c59ec49a7aa8a65a67eed3' --X2Y2: Exchange

and eth_value<>0)

select tab1.day as date, tab1.tx_hash as tx_id, nft_address, project_name, nft_from_address as nft_seller,

from_address as nft_purchaser,

tokenid, tx_fee, eth_value

from tab1 left join tab2 on tab1.tx_hash=tab2.tx_hash and tab1.nft_to_address=tab2.from_address

order by 1)

select project_name , sum(eth_value) as volume, count(distinct nft_seller) as seller,

count(distinct nft_purchaser) as purchaser, count(distinct tx_id) as sales_count, sum(tx_fee) as tx_fee_vol

from table1

where eth_value is not null and project_name is not null

group by 1

order by 3 DESC

limit 10