flipside

    Dately PLSR Pools' TVL on Avalanche DEXs Over Time cop
    Ali3NDately PLSR Pools' TVL on Avalanche DEXs Over Time cop
    Updated 2025-04-04
    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 = '0x7a842193d291840fc38b45f991c5b8cc908f8a7c'
    or tokens:token1 = '0x7a842193d291840fc38b45f991c5b8cc908f8a7c')
    --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: 25 days agoAuto-refreshes every 24 hours
    DATE_DAY
    TVL
    INITCAP(PLATFORM) || ' | ' || POOL_NAME
    POOL_NAME
    DAY
    AVG_PRICE
    TVL_AVAX
    1
    		2025-04-03 00:00:00.00050883.406692764Pharaoh-V2 | PLSR-WAVAX 3000 60PLSR-WAVAX 3000 602025-04-03 00:00:00.00018.2258333332791.828815844
    2
    		2025-04-03 00:00:00.0001707.948105242Trader-Joe-V2 | PLSR-WAVAXPLSR-WAVAX2025-04-03 00:00:00.00018.22583333393.710288797
    3
    		2025-04-03 00:00:00.0002.31172309Pharaoh-V2 | PLSR-WAVAX 10000 200PLSR-WAVAX 10000 2002025-04-03 00:00:00.00018.2258333330.126837717
    4
    		2025-04-02 00:00:00.00055024.310435443Pharaoh-V2 | PLSR-WAVAX 3000 60PLSR-WAVAX 3000 602025-04-02 00:00:00.00019.3195833332848.110618437
    5
    		2025-04-02 00:00:00.0001844.594111696Trader-Joe-V2 | PLSR-WAVAXPLSR-WAVAX2025-04-02 00:00:00.00019.31958333395.477944833
    6
    		2025-04-02 00:00:00.0002.495558561Pharaoh-V2 | PLSR-WAVAX 10000 200PLSR-WAVAX 10000 2002025-04-02 00:00:00.00019.3195833330.1291724836
    7
    		2025-04-01 00:00:00.00068872.268523921Pharaoh-V2 | PLSR-WAVAX 3000 60PLSR-WAVAX 3000 602025-04-01 00:00:00.00019.3254166673563.818038796
    8
    		2025-04-01 00:00:00.0002223.501573508Trader-Joe-V2 | PLSR-WAVAXPLSR-WAVAX2025-04-01 00:00:00.00019.325416667115.055815451
    9
    		2025-04-01 00:00:00.0003.07010064Pharaoh-V2 | PLSR-WAVAX 10000 200PLSR-WAVAX 10000 2002025-04-01 00:00:00.00019.3254166670.1588633608
    10
    		2025-03-31 00:00:00.00073062.507506896Pharaoh-V2 | PLSR-WAVAX 3000 60PLSR-WAVAX 3000 602025-03-31 00:00:00.00018.74253898.226357577
    11
    		2025-03-31 00:00:00.0002298.204284605Trader-Joe-V2 | PLSR-WAVAXPLSR-WAVAX2025-03-31 00:00:00.00018.7425122.619943156
    12
    		2025-03-31 00:00:00.0003.239602954Pharaoh-V2 | PLSR-WAVAX 10000 200PLSR-WAVAX 10000 2002025-03-31 00:00:00.00018.74250.1728479634
    13
    		2025-03-30 00:00:00.00077391.377451542Pharaoh-V2 | PLSR-WAVAX 3000 60PLSR-WAVAX 3000 602025-03-30 00:00:00.00019.4079166673987.619010363
    14
    		2025-03-30 00:00:00.0002382.264389398Trader-Joe-V2 | PLSR-WAVAXPLSR-WAVAX2025-03-30 00:00:00.00019.407916667122.747043401
    15
    		2025-03-30 00:00:00.0003.427023337Pharaoh-V2 | PLSR-WAVAX 10000 200PLSR-WAVAX 10000 2002025-03-30 00:00:00.00019.4079166670.17657863
    16
    		2025-03-29 00:00:00.00094051.812386185Pharaoh-V2 | PLSR-WAVAX 3000 60PLSR-WAVAX 3000 602025-03-29 00:00:00.00020.0683333334686.578143984
    17
    		2025-03-29 00:00:00.0002757.966345999Trader-Joe-V2 | PLSR-WAVAXPLSR-WAVAX2025-03-29 00:00:00.00020.068333333137.428769006
    18
    		2025-03-29 00:00:00.0004.125994869Pharaoh-V2 | PLSR-WAVAX 10000 200PLSR-WAVAX 10000 2002025-03-29 00:00:00.00020.0683333330.2055972861
    19
    		2025-03-28 00:00:00.000120502.161575974Pharaoh-V2 | PLSR-WAVAX 3000 60PLSR-WAVAX 3000 602025-03-28 00:00:00.00020.7841666675797.786531862
    20
    		2025-03-28 00:00:00.0003242.937848398Trader-Joe-V2 | PLSR-WAVAXPLSR-WAVAX2025-03-28 00:00:00.00020.784166667156.029245743
    ...
    174
    25KB
    102s