flipside

    misouser3.8
    sarathmisouser3.8
    Updated 2022-09-20
    SELECT DISTINCT COUNT (ORIGIN_FROM_ADDRESS) AS number_user_opt,
    date_trunc('day', BLOCK_TIMESTAMP) AS date
    --BLOCK_TIMESTAMP
    FROM optimism.sushi.ez_swaps a
    WHERE BLOCK_TIMESTAMP >= CURRENT_DATE -7
    GROUP BY 2
    ORDER BY 2 ASC
    Run a query to Download Data