Elprognerd08 top 10 pool net flow opt
    Updated 2022-10-27
    SELECT pool_name,
    --DISTINCT(ORIGIN_FROM_ADDRESS) AS user,
    COUNT(tx_hash) AS n_txs,
    sum(AMOUNT_IN_USD - AMOUNT_OUT_USD) AS tot_netflow
    FROM optimism.sushi.ez_swaps
    WHERE AMOUNT_OUT_USD IS NOT NULL AND AMOUNT_IN_USD IS NOT NULL
    GROUP BY 1
    ORDER BY 3 DESC
    LIMIT 10
    Run a query to Download Data