adambalamin155
    Updated 2022-12-09
    with a as

    (SELECT
    sum(PRICE_usd) as volume ,avg (PRICE_usd) as prices ,BLOCK_TIMESTAMP::date as date
    FROM ethereum.core.ez_nft_sales
    WHERE EVENT_TYPE = 'sale' and CURRENCY_SYMBOL = 'ETH' and NFT_ADDRESS=lower('0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d')
    group by date)

    select
    avg(prices) over(
    order by date
    rows between 199 preceding and current row ) moving_avg200,
    avg(prices) over(
    order by date
    rows between 49 preceding and current row ) moving_avg50,
    avg(prices) over(
    order by date
    rows between 19 preceding and current row ) moving_avg20,
    prices,
    date,volume
    from a
    Run a query to Download Data