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 avgprice,

min(price_usd)/pow(10,2) as minprice,

max(price_usd)/pow(10,2) as maxprice

from

ethereum.core.ez_nft_sales

where

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

and platform_name = 'rarible'

group by 1