Updated 2022-07-16
    with polygon_nft_address as (select address,label from flipside_prod_db.polygon.labels where label_type like '%nft%')

    , popular_nft as (select sum(EVENT_INPUTS:value/1e18) as volume, label from polygon.core.fact_event_logs inner join polygon_nft_address
    on polygon_nft_address.address=polygon.core.fact_event_logs.contract_address
    where EVENT_INPUTS:value/1e18 < 10000000000
    group by label
    having sum(EVENT_INPUTS:value/1e18) > 0
    order by volume desc)

    ,daily_volume as (select sum(EVENT_INPUTS:value/1e18) as volume, block_timestamp::date as nft_date from polygon.core.fact_event_logs inner join polygon_nft_address
    on polygon_nft_address.address=polygon.core.fact_event_logs.contract_address
    where EVENT_INPUTS:value/1e18 < 10000000000
    group by nft_date
    having sum(EVENT_INPUTS:value/1e18) > 0
    order by volume desc)

    , nft_users as (select min(block_timestamp::date) as nft_date, ORIGIN_TO_ADDRESS from polygon.core.fact_event_logs inner join polygon_nft_address
    on polygon_nft_address.address=polygon.core.fact_event_logs.contract_address
    group by ORIGIN_TO_ADDRESS
    )
    , polygon_users as (select min(block_timestamp::date) as transaction_date, TO_ADDRESS from polygon.core.fact_transactions
    group by TO_ADDRESS)


    , profit as (select sum(EVENT_INPUTS:value/1e18) as volume, ORIGIN_FROM_ADDRESS from polygon.core.fact_event_logs inner join polygon_nft_address
    on polygon_nft_address.address=polygon.core.fact_event_logs.contract_address
    where EVENT_INPUTS:value/1e18 < 10000000000
    group by ORIGIN_FROM_ADDRESS
    having sum(EVENT_INPUTS:value/1e18) > 0
    order by volume desc
    limit 10)


    select * from profit
    Run a query to Download Data