messariCore DAO TVL
Updated 2025-04-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
-- forked from alitaslimi / TVL @ https://flipsidecrypto.xyz/alitaslimi/q/BUijAd3Q1Bct/tvl
with
lq as (
select
to_timestamp(lf.value:date) as date,
to_number(lf.value:tvl) as tvl
from
(
select
livequery.live.udf_api('https://api.llama.fi/v2/historicalChainTvl/CORE') as data
) response,
lateral flatten (input => response.data:data) lf
)
select
date as "Date",
tvl as "TVL"
from
lq
order by
"Date" desc
QueryRunArchived: QueryRun has been archived