mitchperion2023-05-30 12:22 PM
    Updated 2023-09-16
    SELECT
    block_timestamp::date AS day,
    AVG(price) as average_price
    FROM
    ethereum.core.ez_nft_sales
    WHERE
    nft_address = '0x4a537f61ef574153664c0dbc8c8f4b900cacbe5d'
    AND block_timestamp::date BETWEEN CURRENT_DATE - INTERVAL '1 year' AND CURRENT_DATE
    GROUP BY
    block_timestamp::date
    ORDER BY
    day DESC;
    Run a query to Download Data