ThanosGains Network (GNS) Protocol Liquidity
Updated 2023-12-12
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
›
⌄
with api as(
SELECT
defillama.get('/updatedProtocol/gains-network', { }) as resp
),
db as(
select 'Arbitrum' as allocate, VALUE:"date" as date, VALUE:"totalLiquidityUSD" as tvl from api, lateral flatten(input => resp:data:chainTvls:Arbitrum:tvl) union all
select 'Polygon' as allocate, VALUE:"date" as date, VALUE:"totalLiquidityUSD" as tvl from api, lateral flatten(input => resp:data:chainTvls:Polygon:tvl) union all
select 'Staking' as allocate, VALUE:"date" as date, VALUE:"totalLiquidityUSD" as tvl from api, lateral flatten(input => resp:data:chainTvls:staking:tvl)
)
select
date(to_timestamp(date)) as date, allocate,
sum(tvl) as LIQUIDITY
from
db
where
date(to_timestamp(date)) != date(current_date)
group by
1,2
order by
1 desc , 2
Run a query to Download Data