permarystrategic-tan
    Updated 2025-03-13
    with most_recent_date as (
    select max(date) as latest_date
    from external.defillama.fact_protocol_tvl
    where chain = 'Stellar'
    )

    select
    t.date,
    case
    when upper(t.category) like 'DEX%' then 'DEX'
    else t.category
    end as category,
    t.protocol,
    concat('$', to_char(t.chain_tvl, 'FM999,999,999,999')) as tvl
    from external.defillama.fact_protocol_tvl t
    join most_recent_date r
    on t.date = r.latest_date
    where t.chain = 'Stellar'
    and t.chain_tvl is not null
    order by t.chain_tvl desc;

    Last run: 25 days ago
    DATE
    CATEGORY
    PROTOCOL
    TVL
    1
    2025-03-13 00:00:00.000RWAFranklin Templeton$449,989,090
    2
    2025-03-13 00:00:00.000DEXLumenSwap$12,088,615
    3
    2025-03-13 00:00:00.000Partially Algorithmic StablecoinFxDAO$11,563,593
    4
    2025-03-13 00:00:00.000DEXAquarius Stellar$9,038,967
    5
    2025-03-13 00:00:00.000LendingBlend Pools$8,394,198
    6
    2025-03-13 00:00:00.000DEXSoroswap$5,677,391
    7
    2025-03-13 00:00:00.000DEXScopuly$2,675,188
    8
    2025-03-13 00:00:00.000InsuranceBlend Backstop$2,276,707
    9
    2025-03-13 00:00:00.000DEXPhoenix DeFi Hub$1,323,248
    10
    2025-03-13 00:00:00.000RWAVNX$470,362
    11
    2025-03-13 00:00:00.000DEXBalanced Exchange$95,921
    11
    713B
    1s