2844Polygon NFT 1
    Updated 2022-07-14
    select BLOCK_TIMESTAMP::date as "DATE" , count (DISTINCT TX_ID) as "DAILY VOLUME",
    CASE
    WHEN BLOCK_TIMESTAMP::date >='2022-06-15' THEN 'PAST MONTH'
    WHEN BLOCK_TIMESTAMP::date >'2021-06-15' AND BLOCK_TIMESTAMP::date <'2022-06-15' THEN 'PAST YEAR'
    END AS "PERIOD"
    from flipside_prod_db.polygon.udm_events
    where TO_LABEL_TYPE = 'nft'
    GROUP BY 1

    Run a query to Download Data