flipside

    IN-CLASS CODE
    somkeneIN-CLASS CODE
    Updated 2024-02-15
    SELECT
    s.symbol_in,
    SUM(s.amount_in_usd) total_amount

    FROM ethereum.defi.ez_dex_swaps s
    JOIN ethereum.core.dim_labels l ON s.contract_address=l.address

    WHERE platform LIKE 'uniswap%' AND s.amount_in_usd IS NOT NULL

    GROUP BY s.symbol_in

    ORDER BY total_amount DESC

    LIMIT 10
    Last run: about 1 year ago
    SYMBOL_IN
    TOTAL_AMOUNT
    1
    		WETH626976152031.11
    2
    		USDC377323574063.65
    3
    		USDT134151629330.31
    4
    		WBTC57924848579.14
    5
    		DAI47965848910.4
    6
    		FEI10893858283.88
    7
    		UNI6954787969.03
    8
    		LINK6672159217.93
    9
    		SHIB6488659844.36
    10
    		FRAX6193786825.85
    10
    236B
    13s