aycgmonthly sales
    Updated 2024-04-21
    SELECT
    DATE_TRUNC('month', BLOCK_TIMESTAMP) as Date,
    COUNT(*) as Total_Sales,
    t.project_name,
    t.NFT_ADDRESS
    FROM
    ethereum.nft.ez_nft_sales t
    WHERE
    t.NFT_ADDRESS = lower('0xBd3531dA5CF5857e7CfAA92426877b022e612cf8') OR
    t.NFT_ADDRESS = lower('0xBC4CA0EdA7647A8aB7C2061c2E118A18a936f13D')
    GROUP BY
    t.NFT_ADDRESS, t.project_name, Date;


    QueryRunArchived: QueryRun has been archived