nits3- Art Gobbler BAYC Comparison Past 30 days
    Updated 2023-04-13
    SELECT date(block_timestamp) as day, min(price_usd) as floor_price, avg(price_usd) as avg_sale_price, max(price_usd) as max_sale_price,
    count(DISTINCT tx_hash) as total_txs, sum(price_usd) as sale_usd, sum(sale_usd) over (order by day) as cumulative_sale_usd,
    min(floor_price) over (order by day rows between 6 preceding and CURRENT row) as moving_avg_min_floor,
    avg(avg_sale_price) over (order by day rows between 6 preceding and CURRENT row) as moving_avg_price,
    max(max_sale_price) over (order by day rows between 6 preceding and CURRENT row) as moving_avg_max_price
    from ethereum.core.ez_nft_sales
    where nft_address = lower('0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d')
    GROUP by 1
    order by 1 desc
    LIMIT 30
    Run a query to Download Data