flipside

    Dately KET Pools' TVL on Avalanche DEXs Over Time
    Ali3NDately KET Pools' TVL on Avalanche DEXs Over Time
    Updated 2025-03-16
    with top_lp as (
    select
    sum(case when amount_in_usd is null then 0 else amount_in_usd end) as total,
    sum(case when token_in='0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7' then amount_in
    when token_out='0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7' then amount_out else 0
    end
    ) as total_eth,
    contract_address as pool_address,
    pool_name,
    platform
    from avalanche.defi.ez_dex_swaps
    where
    1=1--date(block_timestamp)>= current_date() - 365
    and contract_address in (
    select pool_address from avalanche.defi.dim_dex_liquidity_pools
    where tokens:token0 = '0xffff003a6bad9b743d658048742935fffe2b6ed7'
    or tokens:token1 = '0xffff003a6bad9b743d658048742935fffe2b6ed7')
    --and date(creation_time)>='2023-01-01'
    and (pool_name not like ('0x%') or pool_name not like ('%-0x%'))

    group by contract_address, pool_name,platform
    order by total desc, total_eth desc
    limit 1000
    ),

    lps as (
    select
    pool_name, pool_address, tokens:token0 as token0, tokens:token1 as token1,platform
    from
    avalanche.defi.dim_dex_liquidity_pools
    where
    1=1
    and pool_address in (select pool_address from top_lp where pool_name not like ('0x%'))
    ),

    Last run: 23 days agoAuto-refreshes every 24 hours
    DATE_DAY
    TVL
    INITCAP(PLATFORM) || ' | ' || POOL_NAME
    POOL_NAME
    DAY
    AVG_PRICE
    TVL_AVAX
    1
    		2025-03-15 00:00:00.0003073577.76010137Pharaoh_V1 | WAVAX-KETWAVAX-KET2025-03-15 00:00:00.00018.672916667164600.839545761
    2
    		2025-03-15 00:00:00.0001049546.15779277Pharaoh-V2 | WAVAX-KET 10000 200WAVAX-KET 10000 2002025-03-15 00:00:00.00018.67291666756206.867760853
    3
    		2025-03-15 00:00:00.000512522.089084286Trader-Joe-V2 | KET-WAVAXKET-WAVAX2025-03-15 00:00:00.00018.67291666727447.350525545
    4
    		2025-03-15 00:00:00.00067730.147716253Pharaoh-V2 | WAVAX-KET 3000 60WAVAX-KET 3000 602025-03-15 00:00:00.00018.6729166673627.186310811
    5
    		2025-03-15 00:00:00.0004790.508212821Trader-Joe-V2 | KET-WAVAXKET-WAVAX2025-03-15 00:00:00.00018.672916667256.548470619
    6
    		2025-03-15 00:00:00.0003306.073342804Trader-Joe-V1 | BNZ-KETBNZ-KET2025-03-15 00:00:00.00018.672916667177.051791202
    7
    		2025-03-15 00:00:00.0002004.458213344Trader-Joe-V1 | MU-KETMU-KET2025-03-15 00:00:00.00018.672916667107.345748344
    8
    		2025-03-15 00:00:00.0001292.605719269Trader-Joe-V1 | WAVAX-KETWAVAX-KET2025-03-15 00:00:00.00018.67291666769.22355743
    9
    		2025-03-15 00:00:00.000992.033351488Trader-Joe-V1 | NOCHILL-KETNOCHILL-KET2025-03-15 00:00:00.00018.67291666753.12685582
    10
    		2025-03-15 00:00:00.000799.119418948Pharaoh-V2 | USDC-KET 3000 60USDC-KET 3000 602025-03-15 00:00:00.00018.67291666742.795639975
    11
    		2025-03-15 00:00:00.000620.015740318Pharaoh-V2 | avUSD-KET 10000 200avUSD-KET 10000 2002025-03-15 00:00:00.00018.67291666733.204011531
    12
    		2025-03-15 00:00:00.000479.141808352Trader-Joe-V2 | KET-USDCKET-USDC2025-03-15 00:00:00.00018.67291666725.659719738
    13
    		2025-03-15 00:00:00.000234.746047671Pharaoh-V2 | WINK-KET 3000 60WINK-KET 3000 602025-03-15 00:00:00.00018.67291666712.571471927
    14
    		2025-03-15 00:00:00.00041.06569742Pharaoh-V2 | sAVAX-KET 10000 200sAVAX-KET 10000 2002025-03-15 00:00:00.00018.6729166672.199211733
    15
    		2025-03-15 00:00:00.00036.204578553Pangolin | WAVAX-KETWAVAX-KET2025-03-15 00:00:00.00018.6729166671.938881815
    16
    		2025-03-15 00:00:00.0007.470879759Pharaoh-V2 | USDC-KET 10000 200USDC-KET 10000 2002025-03-15 00:00:00.00018.6729166670.4000917421
    17
    		2025-03-15 00:00:00.0006.739780752Uniswap-V3 | WAVAX-KET 3000 60 UNI-V3 LPWAVAX-KET 3000 60 UNI-V3 LP2025-03-15 00:00:00.00018.6729166670.3609388331
    18
    		2025-03-15 00:00:00.0000.0173483713Uniswap-V3 | WAVAX-KET 10000 200 UNI-V3 LPWAVAX-KET 10000 200 UNI-V3 LP2025-03-15 00:00:00.00018.6729166670.0009290659628
    19
    		2025-03-15 00:00:00.0000.01365780368Trader-Joe-V1 | WINK-KETWINK-KET2025-03-15 00:00:00.00018.6729166670.0007314231579
    20
    		2025-03-15 00:00:00.0000.0003831601049Trader-Joe-V1 | MUi-KETMUi-KET2025-03-15 00:00:00.00018.6729166670.0000205195638
    ...
    1560
    208KB
    496s