smartymetricsEigenLayer TVL copy
Updated 2024-12-06
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
›
⌄
-- forked from Abbas_ra21 / EigenLayer TVL @ https://flipsidecrypto.xyz/Abbas_ra21/q/W92FJzrcF81s/eigenlayer-tvl
-- forked from base tvl daily @ https://flipsidecrypto.xyz/edit/queries/07cb98cd-a06d-4127-95fc-d2253121caf3
with
tb AS (
select
livequery.live.udf_api ('https://api.llama.fi/protocol/eigenlayer') as resp
)
select
TO_TIMESTAMP(VALUE:date)::DATE AS Day,
max(VALUE:totalLiquidityUSD) AS TVL
from
tb,
TABLE (
FLATTEN(
input => parse_json(resp:data:tvl)
)
) f
group by 1 order by 1
QueryRunArchived: QueryRun has been archived