permarymathematical-ivory
    Updated 2025-03-13
    select
    date AS "Date",
    round(tvl_usd, 2) AS "TVL (USD)",
    round(lag(tvl_usd, 1) over (order by date), 2) as "Previous Day TVL",
    round(((tvl_usd - lag(tvl_usd, 1) over (order by date)) / nullif(lag(tvl_usd, 1) over (order by date), 0)) * 100, 2) as "Daily % Change"
    from external.defillama.fact_chain_tvl
    where chain = 'Stellar'
    and date >= current_date - interval '12 months'
    order by date desc;

    Last run: about 1 month ago
    Date
    TVL (USD)
    Previous Day TVL
    Daily % Change
    1
    2025-03-13 00:00:00.00053504157520676582.76
    2
    2025-03-12 00:00:00.00052067658516806590.75
    3
    2025-03-11 00:00:00.0005168065953569288-3.53
    4
    2025-03-10 00:00:00.0005356928854085225-0.95
    5
    2025-03-09 00:00:00.0005408522554552537-0.86
    6
    2025-03-08 00:00:00.0005455253757501273-5.13
    7
    2025-03-07 00:00:00.0005750127358442726-1.61
    8
    2025-03-06 00:00:00.0005844272658773701-0.56
    9
    2025-03-05 00:00:00.00058773701565424083.95
    10
    2025-03-04 00:00:00.0005654240861740960-8.42
    11
    2025-03-03 00:00:00.00061740960601751542.6
    12
    2025-03-02 00:00:00.00060175154582271373.35
    13
    2025-03-01 00:00:00.00058227137531660039.52
    14
    2025-02-28 00:00:00.0005316600356857484-6.49
    15
    2025-02-27 00:00:00.0005685748457269499-0.72
    16
    2025-02-26 00:00:00.00057269499551698413.81
    17
    2025-02-25 00:00:00.0005516984159232926-6.86
    18
    2025-02-24 00:00:00.0005923292660739873-2.48
    19
    2025-02-23 00:00:00.00060739873607224220.03
    20
    2025-02-22 00:00:00.0006072242262006586-2.07
    ...
    366
    18KB
    4s