DATE_TRUNC('{{Time_frame}}', block_timestamp) AS DATE,

PLATFORM_NAME,

AVG(price_usd) AS "Total trading volume (USD)",

AVG(price) AS "Total trading volume (ETH)",

AVG(AVG(price_usd)) OVER (

ORDER BY

DATE ROWS BETWEEN 50 PRECEDING

AND CURRENT ROW

) AS MA50,

AVG(AVG(price_usd)) OVER (

ORDER BY

DATE ROWS BETWEEN 100 PRECEDING

AND CURRENT ROW

) AS MA100

base.nft.ez_nft_sales

nft_address = LOWER('0xA449b4f43D9A33FcdCF397b9cC7Aa909012709fD')

AND price <= '10'

AND price <> '0'

GROUP BY

1, 2

ORDER BY

1 DESC;