adambalaApetimism 11
    Updated 2022-09-02
    select
    count (distinct tx_hash) as vSwap,
    count (distinct origin_from_address) as vSwappers ,
    ADDRESS ,
    PROJECT_NAME,
    LABEL_TYPE
    from OPTIMISM.core.fact_event_logs inner join OPTIMISM.core.dim_labels
    on origin_to_address =ADDRESS where LABEL_TYPE ilike '%nft%'

    group by 3,4,5
    Run a query to Download Data