aycgaverage/max sales price
    Updated 2024-04-21
    SELECT
    t.NFT_ADDRESS,
    t.project_name,
    AVG(PRICE_USD) AS AVG_SALES_USD,
    MAX(PRICE_USD) AS MAX_SALES_USD
    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;

    QueryRunArchived: QueryRun has been archived