OwentellETH Merge: Selling Event? (6)
    Updated 2022-09-29
    WITH eth_from AS (
    SELECT symbol_out, COUNT(*) as num_swaps,
    COUNT(DISTINCT sender) as num_distinct_swappers,
    SUM(amount_in_usd) as swap_vol_usd
    FROM ethereum.core.ez_dex_swaps
    WHERE token_in = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
    AND block_timestamp BETWEEN '2022-09-15' AND current_date - 2
    GROUP BY symbol_out
    )

    SELECT *
    FROM eth_from
    WHERE swap_vol_usd IS NOT NULL
    AND symbol_out IS NOT NULL
    ORDER BY num_distinct_swappers DESC
    LIMIT 5

    Run a query to Download Data