sarathsushi_uni 1
    Updated 2022-10-17
    SELECT
    date_trunc('day', block_timestamp) as day,
    case WHEN project_name LIKE '%sushiswap%' THEN 'SushiSwap'
    WHEN project_name LIKE '%uniswap%' THEN 'UniSwap' end as dex,
    count(DISTINCT tx_hash) as swaps,
    count(DISTINCT origin_from_address) as users FROM arbitrum.core.fact_event_logs
    LEFT outer JOIN arbitrum.core.dim_labels
    ON contract_address = address
    where not address is NULL
    --AND event_name like 'Swap'
    AND( project_name LIKE '%sushiswap%'
    OR project_name LIKE '%uniswap%' )
    GROUP BY 1,2
    Run a query to Download Data