senecaBasepaint total volume copy
    Updated 2024-02-21
    SELECT
    EXTRACT(YEAR FROM BLOCK_TIMESTAMP) AS year,
    EXTRACT(WEEK FROM BLOCK_TIMESTAMP) AS week,
    COUNT(*) AS num_rows
    FROM
    base.nft.ez_nft_sales
    WHERE
    NFT_ADDRESS = '0xba5e05cb26b78eda3a2f8e3b3814726305dcac83'
    GROUP BY
    year, week
    ORDER BY
    year, week;