date_trunc(week, BLOCK_TIMESTAMP) as date,

Count(distinct TX_hash) as "# NFT Sales",

avg("# NFT Sales") Over(order by date rows between 6 preceding and current row) as "MA-7",

avg("# NFT Sales") Over(order by date rows between 13 preceding and current row) as "MA-14",

avg("# NFT Sales") Over(order by date rows between 49 preceding and current row) as "MA-50",

avg("# NFT Sales") Over(order by date rows between 99 preceding and current row) as "MA-100"

from ethereum.core.ez_nft_sales

where 1=1

and PRICE_USD is not NULL

and PRICE_USD > 0

and PLATFORM_NAME is not NULL

and event_type in ('sale', 'bid_won')

group by 1