count(distinct tx_hash) as transactions,

count(distinct nft_address) as collections,

count(distinct tokenid) as nfts,

count(distinct buyer_address) as buyers,

count(distinct seller_address) as sellers,

sum(price_usd)/pow(10,2) as volume,

avg(price_usd)/pow(10,2) as price

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