flipside

    Dately avUSD Pools' TVL on Avalanche DEXs Over Time
    Ali3NDately avUSD Pools' TVL on Avalanche DEXs Over Time
    Updated 4 days ago
    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 = '0x24de8771bc5ddb3362db529fc3358f2df3a0e346'
    or tokens:token1 = '0x24de8771bc5ddb3362db529fc3358f2df3a0e346')
    --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: 4 days agoAuto-refreshes every 24 hours
    DATE_DAY
    TVL
    INITCAP(PLATFORM) || ' | ' || POOL_NAME
    POOL_NAME
    DAY
    AVG_PRICE
    TVL_AVAX
    1
    		2025-04-20 00:00:00.0002533113.11877704Trader-Joe-V2 | savUSD-avUSDsavUSD-avUSD2025-04-20 00:00:00.00019.6325129026.518210978
    2
    		2025-04-20 00:00:00.0001639365.30469221Pharaoh_V1 | savUSD-avUSDsavUSD-avUSD2025-04-20 00:00:00.00019.632583502.625987124
    3
    		2025-04-20 00:00:00.0001380550.23621006Trader-Joe-V2 | avUSD-USDCavUSD-USDC2025-04-20 00:00:00.00019.632570319.635105568
    4
    		2025-04-20 00:00:00.000464834.397402719Pharaoh-V2 | avUSD-USDC 3000 60avUSD-USDC 3000 602025-04-20 00:00:00.00019.632523676.780715789
    5
    		2025-04-20 00:00:00.000147932.318834232Pharaoh_V1 | avUSD-ggAVAXavUSD-ggAVAX2025-04-20 00:00:00.00019.63257535.072906366
    6
    		2025-04-20 00:00:00.00037518.542995633Trader-Joe-V1 | avUSD-sAVAXavUSD-sAVAX2025-04-20 00:00:00.00019.63251911.042556762
    7
    		2025-04-20 00:00:00.00030475.201056902Trader-Joe-V1 | savUSD-avUSDsavUSD-avUSD2025-04-20 00:00:00.00019.63251552.283257705
    8
    		2025-04-20 00:00:00.00014502.17708882Trader-Joe-V2 | WAVAX-avUSDWAVAX-avUSD2025-04-20 00:00:00.00019.6325738.68213874
    9
    		2025-04-20 00:00:00.00010085.360052537Trader-Joe-V1 | avUSD-USDCavUSD-USDC2025-04-20 00:00:00.00019.6325513.707375655
    10
    		2025-04-20 00:00:00.0008688.933422507Trader-Joe-V2 | sAVAX-avUSDsAVAX-avUSD2025-04-20 00:00:00.00019.6325442.579061378
    11
    		2025-04-20 00:00:00.0001210.181805069Pharaoh-V2 | BLUB-avUSD 10000 200BLUB-avUSD 10000 2002025-04-20 00:00:00.00019.632561.641757548
    12
    		2025-04-20 00:00:00.000895.129169938Pharaoh-V2 | avUSD-KET 10000 200avUSD-KET 10000 2002025-04-20 00:00:00.00019.632545.594252894
    13
    		2025-04-20 00:00:00.000194.879717819Pharaoh-V2 | avUSD-XSGD 100 1avUSD-XSGD 100 12025-04-20 00:00:00.00019.63259.926383182
    14
    		2025-04-20 00:00:00.000154.555246558Pharaoh-V2 | avUSD-PHAR 10000 200avUSD-PHAR 10000 2002025-04-20 00:00:00.00019.63257.872418009
    15
    		2025-04-20 00:00:00.00092.683828922Pharaoh_V1 | avUSD-aUSDavUSD-aUSD2025-04-20 00:00:00.00019.63254.720938695
    16
    		2025-04-20 00:00:00.00057.143232127Pharaoh-V2 | avUSD-WAIFU 10000 200avUSD-WAIFU 10000 2002025-04-20 00:00:00.00019.63252.910644703
    17
    		2025-04-20 00:00:00.00041.626022427Pharaoh-V2 | avUSD-WINK 10000 200avUSD-WINK 10000 2002025-04-20 00:00:00.00019.63252.120260916
    18
    		2025-04-20 00:00:00.0005.350111766Pharaoh-V2 | avUSD-ggAVAX 500 10avUSD-ggAVAX 500 102025-04-20 00:00:00.00019.63250.2725130149
    19
    		2025-04-20 00:00:00.0004.491062544Pharaoh_V1 | avUSD-WAVAXavUSD-WAVAX2025-04-20 00:00:00.00019.63250.2287565284
    20
    		2025-04-20 00:00:00.0000.03111722286Pharaoh-V2 | avUSD-ggAVAX 250 5avUSD-ggAVAX 250 52025-04-20 00:00:00.00019.63250.001584985247
    ...
    2222
    301KB
    57s