flipside

    KET Swap Pairs' Stats in Avalanche DEXs
    Ali3NKET Swap Pairs' Stats in Avalanche DEXs
    Updated 8 hours ago
    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: about 8 hours 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 => WAVAX62531093572830851982.65227462480579.443751.534926685613.847357877
    2
    		WAVAX => KET522108207803177555495.54863498496264.955052.914332611793.660009983
    3
    		KET => NOCHILL1292416141748386.89566702351667.88135.18803801627.244180353
    4
    		NOCHILL => KET1144713471870291.64834003340665.03163.25869835429.838401507
    5
    		KET => BNZ8605486518989.69764959748733.0860.2985590395.934374087
    6
    		BNZ => KET8375499562122.30817497350279.5567.0870400026.411572303
    7
    		KET => MU77011156172182.80503195834153.8422.3497929694.534498141
    8
    		KET => USDC763810836320975.74546191048880.51647.441948731109.292540377
    9
    		MU => KET74741122177034.37426265733693.6423.6803603884.639719086
    10
    		USDC => KET653414548394251.199925491404631.5953.45879145166.326998224
    11
    		KET => COQ38684211093912.88438422219991.62282.81098355356.874772492
    12
    		COQ => KET31363701293485.21279139257932.06412.46339693682.327500798
    13
    		avUSD => KET216217536052.9931622148745.6616.675760024.045171138
    14
    		BELL => KET2145152150265.46422254669.988572065
    15
    		KET => BELL2091131153001.25615352473.136355714
    16
    		KET => avUSD204223033469.9797041548097.7216.3907834013.965582762
    17
    		KET => PHAR165739377691.96622453119154.5946.8871250611.573770393
    18
    		KET => sAVAX1539195250507.890096324105385.04162.77315795768.476309292
    19
    		PHAR => KET121833584146.13925019120908.6769.08550020517.222957166
    20
    		NOBS => KET81011645187.36716014155.786873037
    42
    3KB
    75s