select date_trunc('day', BLOCK_TIMESTAMP) as day, platform_name, tb2.PROJECT_NAME,
count(distinct tx_hash) as transactions,
count(distinct tokenid) as nfts,
count(distinct buyer_address) as buyers,
count(distinct seller_address) as sellers,
sum(price_usd)/pow(10,3) as volume
from
ethereum.core.ez_nft_sales tb1 join ethereum.core.dim_nft_metadata tb2 on tb1.nft_address = tb2.CONTRACT_ADDRESS
where
platform_name = 'looksrare'
group by 1, 2, 3