winnie-fsQuery 1
Updated 2024-08-01
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
33
34
35
36
›
⌄
-- forked from Masi / Daily Near Vs. Liquid @ https://flipsidecrypto.xyz/Masi/q/1l9xtB-9005M/daily-near-vs.-liquid
WITH
linear as (
SELECT defillama.get('/protocol/linear-protocol', {}) as resp
)
,
linear_tvl as ( SELECT *
FROM (
SELECT
TO_TIMESTAMP(v.value:date::INT) AS date,
'Linear' as protocol,
v.value:totalLiquidityUSD::FLOAT AS TVL
FROM
linear,
LATERAL FLATTEN(input => resp['data']['chainTvls']['Near']['tvl']) AS v
))
,
meta as (
SELECT defillama.get('/protocol/meta-pool-near', {}) as resp
)
,
meta_tvl as ( SELECT *
FROM (
SELECT
TO_TIMESTAMP(v.value:date::INT) AS date,
'Meta Pool' as protocol,
v.value:totalLiquidityUSD::FLOAT AS TVL
FROM
meta,
LATERAL FLATTEN(input => resp['data']['chainTvls']['Near']['tvl']) AS v
))
,
tb1 as (select *
QueryRunArchived: QueryRun has been archived