flipside

    Assets Swapped to $KET by Volume [USD]
    SniperAssets Swapped to $KET by Volume [USD]
    Updated 2025-03-24
    select
    TOKEN_in,
    SYMBOL_in,
    count(DISTINCT ORIGIN_FROM_ADDRESS) as users,
    count(DISTINCT TX_HASH) as transactions,
    count(*) as swap,
    sum(AMOUNT_IN) as volume_avax,
    sum(AMOUNT_IN_USD) as volume_usd,
    avg(AMOUNT_IN_USD) as avg_volume_usd,
    from avalanche.defi.ez_dex_swaps
    where AMOUNT_IN_USD is NOT NULL
    and
    --TOKEN_in = lower('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7')
    --OR
    TOKEN_out = lower('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7')
    group by 1,2



    Last run: 21 days ago
    TOKEN_IN
    SYMBOL_IN
    USERS
    TRANSACTIONS
    SWAP
    VOLUME_AVAX
    VOLUME_USD
    AVG_VOLUME_USD
    1
    		0xd036414fa2bcbb802691491e323bff1348c5f4baMU105864136415478017.44239759133504.595.22285113
    2
    		0x7698a5311da174a95253ce86c21ca7272b9b05f8WINK9634234285416.5265059817685.8622.473274854
    3
    		0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6eUSDC1046376257421367780.3027531367632.08238.180438871
    4
    		0x24de8771bc5ddb3362db529fc3358f2df3a0e346avUSD375835832819.7534411352817.244.832315609
    5
    		0xacfb898cff266e53278cc0124fc2c7c94c8cb9a5NOCHILL101079047911105024543.01156334814.1242.322603969
    6
    		0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4besAVAX2907927973845.226335154111750.79140.214291092
    7
    		0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7WAVAX1925525896833772612407962.3124251302567552.53895.896533077
    8
    		0xaaab9d12a30504559b0c5a9a5977fee4a6081c6bPHAR3351214121444.73570125320908.6717.222957166
    9
    		0xfc6da929c031162841370af240dec19099861d3bDOMI7111132564.746542683319.5329.048181818
    10
    		0x4d6ec47118f807ace03d3b3a4ee6aa96cb2ab677BNZ43147794779261265664.53673839649.798.296670852
    10
    1KB
    23s