strawbettySwap volume on Uniswap
    Updated 2022-04-23
    SELECT
    date_trunc('day', block_timestamp) as day,
    SUM(amount_usd) as uni_amount_usd,
    COUNT(DISTINCT tx_id) as uni_num_tx,
    COUNT(DISTINCT from_address) as uni_users,
    case WHEN (day >= '2022-02-24') then 'Ukraine war'
    else 'other days' end as specific_time
    FROM ethereum.dex_swaps
    WHERE platform LIKE '%uni%'
    AND day >= '2022-01-01'
    AND day < '2022-04-20'
    GROUP BY 1
    ORDER BY 1
    Run a query to Download Data