flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
CHAI - KRT price
maybeyonas
CHAI - KRT price
Updated 2021-09-12
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with
krt
as
(
select
*
-- date(block_timestamp) as date,
-- avg(price_usd) as usd_price
from
terra
.
daily_balances
where
currency
=
'KRT'
and
balance_type
=
'liquid'
)
select
date
,
sum
(
balance
)
as
tvl
from
krt
group
by
date
Results
Run a query to Download Data