SpecterSui Tvl
    Updated 2025-05-16
    WITH SuitVL AS(
    select Date, chain, tvl_usd
    from
    external.defillama.fact_chain_tvl
    where
    chain LIKE '%Sui%'
    )

    SELECT *, LAG(tvl_usd) OVER (ORDER BY Date) AS Prev_TVl,
    ((tvl_usd - LAG(tvl_usd) OVER (ORDER BY Date)) / LAG(tvl_usd) OVER (ORDER BY Date)) * 100 AS Percentage_Change
    FROM SuitVL
    ORDER BY DATE DESC

    Last run: 12 days ago
    DATE
    CHAIN
    TVL_USD
    PREV_TVL
    PERCENTAGE_CHANGE
    1
    2025-05-15 00:00:00.000Sui27037097492822679942-4.2148
    2
    2025-05-14 00:00:00.000Sui282267994227496587662.6556
    3
    2025-05-13 00:00:00.000Sui27496587662813100625-2.2552
    4
    2025-05-12 00:00:00.000Sui28131006252834507068-0.7552
    5
    2025-05-11 00:00:00.000Sui283450706827103764444.5798
    6
    2025-05-10 00:00:00.000Sui27103764442716344351-0.2197
    7
    2025-05-09 00:00:00.000Sui2716344351235294400115.4445
    8
    2025-05-08 00:00:00.000Sui235294400123165898971.5693
    9
    2025-05-07 00:00:00.000Sui23165898972346081533-1.2571
    10
    2025-05-06 00:00:00.000Sui234608153322872293042.5731
    11
    2025-05-05 00:00:00.000Sui22872293042307829178-0.8926
    12
    2025-05-04 00:00:00.000Sui23078291782342007225-1.4593
    13
    2025-05-03 00:00:00.000Sui23420072252451632300-4.4715
    14
    2025-05-02 00:00:00.000Sui245163230024119869591.6437
    15
    2025-05-01 00:00:00.000Sui24119869592429304088-0.7128
    16
    2025-04-30 00:00:00.000Sui242930408824239262790.2219
    17
    2025-04-29 00:00:00.000Sui242392627924239136720.0005
    18
    2025-04-28 00:00:00.000Sui242391367223709204252.2351
    19
    2025-04-27 00:00:00.000Sui23709204252373698332-0.117
    20
    2025-04-26 00:00:00.000Sui237369833222686188064.6319
    ...
    741
    45KB
    2s