MLDZMNartg6
    Updated 2023-04-13
    select
    date_trunc('hour',BLOCK_TIMESTAMP) as hour,
    avg(price) as avg_sale,
    median(price) as med_price,
    min(price) as min_price,
    max(price) as max_price,
    max_price-min_price as bond_price,
    avg(price_usd) as avg_sale_usd,
    median(price_usd) as med_price_usd,
    min(price_usd) as min_price_usd,
    max(price_usd) as max_price_usd,
    max_price_usd-min_price_usd as bond_price_usd,
    avg(avg_sale) OVER (ORDER BY hour ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as MA_7_Days,
    avg(avg_sale_usd) OVER (ORDER BY hour ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as MA_7_Days_usd
    from ethereum.core.ez_nft_sales
    where NFT_ADDRESS=lower('0x60bb1e2AA1c9ACAfB4d34F71585D7e959f387769')
    group by 1

    Run a query to Download Data