No Data to Display
hessDaily TVL Per Platform
Updated 2024-09-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with tops as ( select protocol,
CHAIN_TVL
from external.defillama.fact_protocol_tvl
where chain = 'Klaytn'
and date = current_date - 1
order by 2 desc
limit 10)
select date,
case when protocol ilike '%neopin%' then 'Neopin'
when protocol ilike '%klayswap%' then 'Klayswap'
when protocol ilike '%swapscanner%' then 'Swapscanner' else protocol end as platform,
sum(chain_tvl) as tvl
from external.defillama.fact_protocol_tvl
where chain in ('Klaytn-staking','Klaytn')
and date >= current_date - 90
and protocol in (select protocol from tops)
group by 1,2
Last run: 3 months ago
0
2B
14s