flipside

    Dately KET Swaps Stats on Avalanche Over Time
    Ali3NDately KET Swaps Stats on Avalanche Over Time
    Updated 1 day ago
    with pricet as (
    select date_trunc (day,block_timestamp) as day,
    '0xffff003a6bad9b743d658048742935fffe2b6ed7' as token_address,
    'KET' as symbol,
    '18' as decimals,
    median (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: 1 day agoAuto-refreshes every 24 hours
    DATE
    TRADING_TYPE
    TX_COUNT
    TRADERS_COUNT
    USD_TRADING_VOLUME
    AVERAGE_USD_TRADING_VOLUME
    CUMULATIVE_TX_COUNT
    CUMULATIVE_USD_TRADING_VOLUME
    1
    		2025-01-21 00:00:00.000Swap From KET (SELL)435210345650.65375.70722826182808101902.08
    2
    		2025-01-30 00:00:00.000Swap To KET (BUY)11515131020929.12490.3598078773352426090847.92
    3
    		2025-01-27 00:00:00.000Swap To KET (BUY)18235631797390.58483.1695107532971221949981.34
    4
    		2025-03-27 00:00:00.000Swap From KET (SELL)32162312321431.28548.024381492371194288758333.49
    5
    		2025-02-10 00:00:00.000Swap From KET (SELL)955056914366031.21287.0481275768853692272779.37
    6
    		2025-03-03 00:00:00.000Swap From KET (SELL)67865184011358.43479.598090626268641219629100.62
    7
    		2025-03-28 00:00:00.000Swap To KET (BUY)25732302204696.79632.08050172290833318317440.16
    8
    		2025-05-27 00:00:00.000Swap To KET (BUY)922869912506759.11272.952580153555127500186385.64
    9
    		2025-04-17 00:00:00.000Swap To KET (BUY)30186771306983.21387.828845697349725352070443.25
    10
    		2025-05-06 00:00:00.000Swap From KET (SELL)2497205833050.98284.6091493482873343950756.54
    11
    		2025-03-24 00:00:00.000Swap From KET (SELL)54733343373757.66518.640685626358092279495457.11
    12
    		2025-04-28 00:00:00.000Swap From KET (SELL)2096207779238.64330.746451613461349336629587.94
    13
    		2025-03-22 00:00:00.000Swap To KET (BUY)27361582093794.73623.524338892273085298505182.27
    14
    		2025-05-04 00:00:00.000Swap To KET (BUY)39031550770463.94194.169339718411488371844466.03
    15
    		2025-05-26 00:00:00.000Swap To KET (BUY)962847112245378.11207.392831789545899487679626.54
    16
    		2025-04-29 00:00:00.000Swap To KET (BUY)417615991298212.56284.758183812387982366036669.69
    17
    		2025-02-05 00:00:00.000Swap From KET (SELL)54457614527269.79690.5536592436049652264732.46
    18
    		2025-04-23 00:00:00.000Swap From KET (SELL)28294491642463.84493.232384384451929332147801.32
    19
    		2025-01-17 00:00:00.000Swap From KET (SELL)19994581495358.97327.28364412357255188726.72
    20
    		2025-01-26 00:00:00.000Swap To KET (BUY)33546292472711.2380.5927658922788920152590.76
    ...
    266
    27KB
    337s