flipside

    KET Swap Pairs' Stats in Avalanche DEXs
    Ali3NKET Swap Pairs' Stats in Avalanche DEXs
    Updated 2025-03-17
    with pricet as (
    select date_trunc (day,block_timestamp) as day,
    '0xffff003a6bad9b743d658048742935fffe2b6ed7' as token_address,
    'KET' as symbol,
    '18' as decimals,
    avg (amount_in_usd/amount_out) as USDPrice
    from avalanche.defi.ez_dex_swaps
    where (symbol_in = 'WAVAX' or symbol_in ilike 'USDC')
    and (symbol_out = 'KET' or token_out = '0xffff003a6bad9b743d658048742935fffe2b6ed7')
    and block_timestamp >= '2025-02-05'
    group by 1,2,3,4 having USDPrice < 10

    union all

    select hour::date as day,
    token_address,
    'USDC' as symbol,
    decimals,
    avg (price) as usdprice
    from avalanche.price.ez_prices_hourly
    where token_address ilike '0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E'
    group by 1,2,3,4),

    SimpleSwap as (
    SELECT
    block_timestamp,
    tx_hash,
    decoded_log:maker as maker,
    decoded_log:makerAsset as makerAsset,
    decoded_log:makerAmountReceived as makerAmountReceived,
    decoded_log:taker as taker,
    decoded_log:takerAsset as takerAsset,
    decoded_log:takerAmountReceived as takerAmountReceived,
    decoded_log
    FROM
    avalanche.core.ez_decoded_event_logs
    Last run: 23 days agoAuto-refreshes every 24 hours
    TRADING_PAIR
    TX_COUNT
    TRADERS_COUNT
    TOTAL_TRADING_VOLUME
    TOTAL_USD_TRADING_VOLUME
    AVERAGE_TRADING_VOLUME
    AVERAGE_USD_TRADING_VOLUME
    1
    		KET => WAVAX31728369812163767149.73085258452971.415338.825257362637.700434529
    2
    		WAVAX => KET240735190592482528122.24256283985248.937868.726476475900.131695252
    3
    		KET => NOCHILL910512321725900.17682676345304.93189.4511719937.966457394
    4
    		NOCHILL => KET764110031847151.88964773334248.7241.52090607343.881935145
    5
    		KET => MU68211115170001.12178018233673.4824.9122394175.059876784
    6
    		MU => KET64971074175032.34297220233241.2926.932196185.275557848
    7
    		KET => BNZ5511418473549.8633670537807.4285.9125296387.384261719
    8
    		KET => USDC52907496175961.483278431007610.81850.214961905141.957003381
    9
    		BNZ => KET5012447513969.54615426238346.78102.5477945248.553821102
    10
    		USDC => KET381310818048075.885220991318269.21359.013151844236.376044468
    11
    		KET => PHAR165739377691.96622453119154.5946.8871250611.573770393
    12
    		KET => sAVAX1539195250507.890096324105385.04162.77315795768.476309292
    13
    		PHAR => KET121833584146.13925019120908.6769.08550020517.222957166
    14
    		sAVAX => KET792290266763.703751282111750.79334.709791407140.214291092
    15
    		KET => avUSD5934210113.3563653182725.5317.0545638544.596172007
    16
    		avUSD => KET485359506.0697875932548.3919.6001438925.254412371
    17
    		WINK => KET38110623842.6530744957685.8662.57914192822.473274854
    18
    		KET => WINK3527722481.396221987359.2763.86760290322.713796296
    19
    		KET => DOMI721697748.9524432835625.971357.6243394978.138472222
    20
    		DOMI => KET1176087.232997929319.53553.38481799429.048181818
    23
    2KB
    627s