date_trunc('day', block_timestamp) as date,

COUNT(DISTINCT tx_hash) AS transaction_count,

COUNT(DISTINCT buyer_address) AS unique_buyer_count,

COUNT(DISTINCT seller_address) AS unique_seller_count,

SUM(price_usd) AS transaction_volume,

-- sum(platform_fee_usd) as protocol_fee,

avg(price_usd) AS avg_nft_price,

max(price_usd) AS max_nft_price,

min(price_usd) AS min_nft_price,

median(price_usd) AS median_nft_price,

AVG(transaction_count) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS MA_7_transactions,

AVG(transaction_count) OVER (ORDER BY date ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) AS MA_30_transactions,

AVG(transaction_volume) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS MA_7_volume,

AVG(transaction_volume) OVER (ORDER BY date ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) AS MA_30_volume,

AVG(unique_buyer_count) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS MA_7_buyers,

AVG(unique_seller_count) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS MA_7_seller,

SUM(transaction_count) OVER (ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_tx_count,

SUM(transaction_volume) OVER (ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_tx_volume

-- SUM(protocol_fee) OVER (ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_protocol_fee

FROM

near.nft.ez_nft_sales

where

platform_name = 'Mitte'

group by date