zakkisyedBlast TVL Change
Updated 2024-03-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with blast_tvl as (
SELECT
LiveQuery.live.udf_Api('https://api.llama.fi/v2/historicalChainTvl/Blast') :data as repsonse
)
SELECT
to_timestamp(value:date) AS block_timestamp,
value:totalLiquidityUSD as TVL
FROM
blast_tvl,
LATERAL FLATTEN (input => repsonse:tvl)
ORDER by 1 desc
limit 60
QueryRunArchived: QueryRun has been archived