flipside

    Dately KET Pools' TVL on Avalanche DEXs Over Time
    Ali3NDately KET Pools' TVL on Avalanche DEXs Over Time
    Updated 2025-05-27
    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: 22 days agoAuto-refreshes every 24 hours
    DATE_DAY
    TVL
    INITCAP(PLATFORM) || ' | ' || POOL_NAME
    POOL_NAME
    DAY
    AVG_PRICE
    TVL_AVAX
    1
    		2025-05-26 00:00:00.0005602755.30053393Pharaoh_V1 | WAVAX-KETWAVAX-KET2025-05-26 00:00:00.00023.43625239063.642883735
    2
    		2025-05-26 00:00:00.0001632117.85098817Pharaoh-V2 | WAVAX-KET 10000 200WAVAX-KET 10000 2002025-05-26 00:00:00.00023.4362569640.742481761
    3
    		2025-05-26 00:00:00.000243551.919285291Pharaoh-V2 | WAVAX-KET 3000 60WAVAX-KET 3000 602025-05-26 00:00:00.00023.4362510392.102801655
    4
    		2025-05-26 00:00:00.000174787.498787565Pharaoh-V2 | NOBS-KET 10000 200NOBS-KET 10000 2002025-05-26 00:00:00.00023.436257457.997708147
    5
    		2025-05-26 00:00:00.000119076.923322305Trader-Joe-V2 | KET-WAVAXKET-WAVAX2025-05-26 00:00:00.00023.436255080.886375692
    6
    		2025-05-26 00:00:00.00016539.166419817Pharaoh-V2 | USDC-KET 10000 200USDC-KET 10000 2002025-05-26 00:00:00.00023.43625705.708738378
    7
    		2025-05-26 00:00:00.0005967.402583909Trader-Joe-V1 | BNZ-KETBNZ-KET2025-05-26 00:00:00.00023.43625254.622756794
    8
    		2025-05-26 00:00:00.0004303.25322238Trader-Joe-V2 | KET-WAVAXKET-WAVAX2025-05-26 00:00:00.00023.43625183.615263636
    9
    		2025-05-26 00:00:00.0001959.71437349Trader-Joe-V1 | NOCHILL-KETNOCHILL-KET2025-05-26 00:00:00.00023.4362583.618939612
    10
    		2025-05-26 00:00:00.0001595.365041695Pharaoh-V2 | COQ-KET 10000 200COQ-KET 10000 2002025-05-26 00:00:00.00023.4362568.072538981
    11
    		2025-05-26 00:00:00.000884.159526033Trader-Joe-V2 | KET-USDCKET-USDC2025-05-26 00:00:00.00023.4362537.726151839
    12
    		2025-05-26 00:00:00.000787.53513333Trader-Joe-V1 | WAVAX-KETWAVAX-KET2025-05-26 00:00:00.00023.4362533.603291198
    13
    		2025-05-26 00:00:00.000539.212971426Pharaoh-V2 | avUSD-KET 10000 200avUSD-KET 10000 2002025-05-26 00:00:00.00023.4362523.007647189
    14
    		2025-05-26 00:00:00.000408.377454499Pharaoh-V2 | USDC-KET 3000 60USDC-KET 3000 602025-05-26 00:00:00.00023.4362517.42503406
    15
    		2025-05-26 00:00:00.000309.935772775Pharaoh_V1 | CANS-KETCANS-KET2025-05-26 00:00:00.00023.4362513.224631619
    16
    		2025-05-26 00:00:00.00065.084101431Trader-Joe-V1 | MU-KETMU-KET2025-05-26 00:00:00.00023.436252.777069771
    17
    		2025-05-26 00:00:00.00065.031256929Pangolin | WAVAX-KETWAVAX-KET2025-05-26 00:00:00.00023.436252.774814952
    18
    		2025-05-26 00:00:00.00030.825152324Pharaoh-V2 | WINK-KET 3000 60WINK-KET 3000 602025-05-26 00:00:00.00023.436251.315276647
    19
    		2025-05-26 00:00:00.00016.798587612Uniswap-V3 | WAVAX-KET 3000 60 UNI-V3 LPWAVAX-KET 3000 60 UNI-V3 LP2025-05-26 00:00:00.00023.436250.7167779663
    20
    		2025-05-26 00:00:00.0005.296437323Pharaoh_V1 | WY-KETWY-KET2025-05-26 00:00:00.00023.436250.2259933788
    ...
    5016
    657KB
    97s