ThatGuyOptimism - User Behavior 9. op swap top
    Updated 2022-10-26
    (SELECT
    POOL_NAME,
    'Optimsm' as blockchain,
    COUNT(DISTINCT TX_HASH) as tx_count,
    COUNT(DISTINCT ORIGIN_FROM_ADDRESS) as user_count,
    SUM(AMOUNT_IN_USD) as volume
    FROM optimism.sushi.ez_swaps
    WHERE BLOCK_TIMESTAMP >= '2022-06-01'
    GROUP BY 1
    HAVING volume > 0
    ORDER BY volume DESC
    LIMIT 10)

    Run a query to Download Data