date | TVL (USD) | SOL Price (USD) | TVL (SOL) | |
|---|---|---|---|---|
1 | 2025-06-12 00:00:00.000 | 8704451827 | 160.14 | 54355263.0635694 |
2 | 2025-06-11 00:00:00.000 | 9019510834 | 164.17 | 54940067.2108181 |
3 | 2025-06-10 00:00:00.000 | 8853398554 | 159.63 | 55461996.8301698 |
4 | 2025-06-09 00:00:00.000 | 8490487002 | 153.49 | 55316222.5682455 |
5 | 2025-06-08 00:00:00.000 | 8377031308 | 151.25 | 55385330.9619835 |
6 | 2025-06-07 00:00:00.000 | 8326960965 | 148.55 | 56054937.4957927 |
7 | 2025-06-06 00:00:00.000 | 8155440740 | 144.65 | 56380509.782233 |
8 | 2025-06-05 00:00:00.000 | 8549392919 | 153.68 | 55631135.5999479 |
9 | 2025-06-04 00:00:00.000 | 8660519459 | 156.16 | 55459269.0765881 |
10 | 2025-06-03 00:00:00.000 | 8754894367 | 156.3 | 56013399.6609085 |
11 | 2025-06-02 00:00:00.000 | 8599729858 | 156.81 | 54841718.3725528 |
12 | 2025-06-01 00:00:00.000 | 8571248765 | 157.24 | 54510612.8529636 |
13 | 2025-05-31 00:00:00.000 | 8531203359 | 158.71 | 53753407.8444963 |
14 | 2025-05-30 00:00:00.000 | 8952755085 | 167.67 | 53395092.0558239 |
15 | 2025-05-29 00:00:00.000 | 9223602033 | 170.72 | 54027659.5185098 |
16 | 2025-05-28 00:00:00.000 | 9421306596 | 176.51 | 53375483.5193473 |
17 | 2025-05-27 00:00:00.000 | 9352026180 | 174.49 | 53596344.6615852 |
18 | 2025-05-26 00:00:00.000 | 9393276398 | 174.08 | 53959538.1318934 |
19 | 2025-05-25 00:00:00.000 | 9299368612 | 176.38 | 52723486.8579204 |
20 | 2025-05-24 00:00:00.000 | 9309021300 | 176.14 | 52850126.6038379 |
defi__joshSolana historical TVL and Price
Updated 19 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
WITH defillama_data AS (
SELECT
to_timestamp(value:date) AS "date",
value:tvl AS "TVL (USD)"
FROM
(
SELECT
live.udf_api(
'https://api.llama.fi/v2/historicalChainTvl/Solana'
) AS response
),
lateral flatten(input => response:data)
),
sol_prices AS (
SELECT
date_trunc('hour', hour) as price_hour,
price as sol_price
FROM solana.price.ez_prices_hourly
WHERE symbol = 'SOL'
AND blockchain = 'solana'
AND is_native = true
)
SELECT
d."date",
d."TVL (USD)",
p.sol_price "SOL Price (USD)",
d."TVL (USD)" / NULLIF(p.sol_price, 0) as "TVL (SOL)"
FROM
defillama_data d
LEFT JOIN sol_prices p ON date_trunc('hour', d."date") = p.price_hour
ORDER BY
d."date" DESC;
Last run: about 19 hours agoAuto-refreshes every 12 hours
...
1548
101KB
200s