mattkstewOptimism DEXs 2.5
    Updated 2022-08-07
    select
    --date_trunc('day', block_timestamp),
    project_name,
    count(distinct from_address)


    from optimism.core.fact_token_transfers left outer join optimism.core.dim_labels
    on contract_address = address
    where label_type like 'dex'
    group by 1

    Run a query to Download Data