flipside

    By Event Nmae
    datavortexBy Event Nmae
    Updated 2025-04-18
    SELECT symbol_in,
    event_name,
    COUNT(DISTINCT tx_hash) AS total_transactions,
    COUNT(DISTINCT origin_from_address) AS total_swappers,
    SUM(amount_in_usd) AS volume_swapped
    FROM polygon.defi.ez_dex_swaps
    WHERE symbol_in IN ('USDT', 'USDC', 'EURS', 'DAI', 'UST', 'BUSD', 'TUSD')
    AND block_timestamp >= '{{start_date}}'
    AND block_timestamp < '{{end_date}}'
    GROUP BY symbol_in, event_name;

    Last run: about 1 month ago
    SYMBOL_IN
    EVENT_NAME
    TOTAL_TRANSACTIONS
    TOTAL_SWAPPERS
    VOLUME_SWAPPED
    1
    		EURSTokenExchange4337879350.83
    2
    		USDCStatic Swap14330434.44
    3
    		USDTTokenExchangeUnderlying5063312805838.06
    4
    		USDTElastic Swap6372143019.5
    5
    		USDCTokenExchange1194363238.25
    6
    		TUSDSwap1811111396.72
    7
    		USDTStatic Swap1054.66
    8
    		USDCElastic Swap152822929608.37
    9
    		USDTDodoSwap7822433529.92
    10
    		USDCWooRouterSwap26105792487001.76
    11
    		USDTTrade503216544286.9
    12
    		DAIStatic Swap743.88
    13
    		BUSDSwap7963698599.41
    14
    		USDCTokenExchangeUnderlying4102641298376.08
    15
    		DAITokenExchangeUnderlying4032881964528.72
    16
    		USDTBuyBaseToken931939343687163.53
    17
    		USDCSwap14746701158261394624126.59
    18
    		USTSwap206943314237.63
    19
    		DAIDodoSwap440.69
    20
    		USDCDynamic Swap76712194382813.43
    42
    2KB
    3s