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

block_timestamp::date >= '2023-01-01'

and

platform_name = 'looksrare'

group by 1, 2, 3