kasadeghPolygon NFT daily volume over the past month
    Updated 2022-07-16

    select events.block_timestamp::date as day,
    count(distinct events.TX_ID) as daily_nft_transfer_count, sum(amount_usd) as daily_volume
    from flipside_prod_db.polygon.udm_events as events
    join polygon.core.dim_labels as label
    on events.contract_address = label.address
    where LABEL_TYPE like '%nft%' and lower(event_name) like '%transfer%' and day>= DATEADD(DAY,-30,CURRENT_DATE())
    group by 1
    order by 1


    Run a query to Download Data