Popex404Daily volume of NFTs in Polygon
    Updated 2022-07-17
    Select DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS DAYS, COUNT(TX_ID), SUCCESS, to_label
    from flipside_prod_db.polygon.transactions
    where FROM_ADDRESS IN
    (select ADDRESS
    from flipside_prod_db.polygon.labels
    where label_type = 'nft') OR
    TO_LABEL_TYPE ILIKE '%NFT%' OR
    TO_LABEL_SUBTYPE ILIKE 'marketplace' OR
    FUNCTION_NAME ILIKE '%NFT%'
    Group by 1,4,3
    Run a query to Download Data