DATE | TVL (USD) | TVL (SEI) | PRICES | |
|---|---|---|---|---|
1 | 2024-03-11 00:00:00.000 | 25783956 | 29722977.7044838 | 0.8674755355 |
2 | 2024-10-14 00:00:00.000 | 180872712 | 368409672.928357 | 0.4909553828 |
3 | 2024-10-23 00:00:00.000 | 172628786 | 406375600.495765 | 0.4248010604 |
4 | 2024-01-01 00:00:00.000 | 5382135 | 8392971.12989878 | 0.6412669502 |
5 | 2024-12-07 00:00:00.000 | 269426385 | 388269721.838717 | 0.6939155176 |
6 | 2024-06-25 00:00:00.000 | 43458823 | 116386997.075932 | 0.373399298 |
7 | 2024-04-20 00:00:00.000 | 32616336 | 56146631.8023196 | 0.580913493 |
8 | 2024-04-26 00:00:00.000 | 36422161 | 60377733.4552935 | 0.6032382952 |
9 | 2025-02-18 00:00:00.000 | 183723936 | 824798270.653656 | 0.222750147 |
10 | 2023-12-01 00:00:00.000 | 3267657 | 12626660.9233389 | 0.2587902708 |
11 | 2024-12-23 00:00:00.000 | 212779984 | 496020113.588151 | 0.4289745076 |
12 | 2024-04-19 00:00:00.000 | 29694334 | 54550251.0430859 | 0.5443482556 |
13 | 2023-08-31 00:00:00.000 | 3216087 | 22956559.8498551 | 0.1400944663 |
14 | 2023-08-27 00:00:00.000 | 3216183 | 24553297.5163051 | 0.1309878234 |
15 | 2024-07-11 00:00:00.000 | 79128902 | 245496499.010196 | 0.3223219163 |
16 | 2025-01-14 00:00:00.000 | 195771650 | 527645228.398587 | 0.3710289404 |
17 | 2024-08-28 00:00:00.000 | 103195438 | 332817086.59764 | 0.3100665265 |
18 | 2023-08-29 00:00:00.000 | 3209758 | 24857607.6548453 | 0.1291257809 |
19 | 2025-02-28 00:00:00.000 | 194913052 | 801762948.49378 | 0.2431055867 |
20 | 2023-11-15 00:00:00.000 | 3157618 | 20100580.1973474 | 0.1570908884 |
hessSei TVL
Updated 6 days 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
›
⌄
with tvl_usdd as ( select * from (
SELECT
livequery.live.udf_api (
'https://api.dune.com/api/v1/query/4281530/results?api_key=ZUTpBBwY5IhK5S1NfbV0EJ1VfVQ72wt3') as resp)
,
table(FLATTEN(parse_json(resp:data:"result":"rows"))))
,
tvl as (select TO_TIMESTAMP(REPLACE(value:"date", ' UTC', '')) AS date,
value:"tvl" as "TVL (USD)"
from tvl_usdd)
,
price as ( select RECORDED_HOUR::date as day,
avg(price) as prices
from osmosis.price.ez_prices
where symbol = 'SEI'
group by 1)
select date,
"TVL (USD)",
"TVL (USD)"/prices as "TVL (SEI)",
prices
from tvl a join price b on a.date= b.day
Last run: 6 days ago
...
571
37KB
23s