trunc(block_timestamp,'{{granularity}}') as date,

count(*) as sales,

sum(sales) over (order by date) as cum_sales,

count(TOKENID)as num_of_nft,

count(DISTINCT TX_HASH ) as tx,

sum(tx) over (order by date) as cum_tx,

count(DISTINCT SELLER_ADDRESS ) as sellers,

count (DISTINCT BUYER_ADDRESS) as buyers,

count (DISTINCT ORIGIN_FROM_ADDRESS) as users,

sum(users) over (order by date) as cum_users,

sum(PRICE_USD) as sales_volume_usd,

avg(PRICE_USD) as avg_sale_price_usd,

max(PRICE_USD) as max_sale_price_usd,

min(PRICE_USD) min_sale_price_usd,

sum(PRICE) as sales_volume_pol,

avg(PRICE) as avg_sale_price_pol,

max(PRICE) as max_sale_price_pol,

min(PRICE) as min_sale_price_pol,

sum(CREATOR_FEE) as creator_fee_pol,

sum(creator_fee_pol) over (order by date) as cum_creator_fee_pol,

sum(TOTAL_FEES) as total_fee_pol,

sum(TX_FEE) as tx_fee_pol,

sum(tx_fee_pol) over (order by date) as cum_tx_fee_pol,

FROM polygon.nft.ez_nft_sales

WHERE PROJECT_NAME = '{{collection_name}}'

and date >= '2022-01-01'

group by 1

order by 1