messariStaked v Unstaked Balance Luna (to Q1 2021)
Updated 2022-05-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- Tarik - revised from query by oddharsh: https://app.flipsidecrypto.com/velocity/queries/9a060e7f-cb03-453a-ba81-c8378b20d2b8
select
date_trunc('day', date) AS dayzz,
sum(BALANCE) as Luna_Staked,
sum(BALANCE_USD) as Balance_USD,
BALANCE_TYPE
from
terra.daily_balances
where
-- dayzz >= CURRENT_DATE - (CURRENT_DATE - (CAST('2021-01-01' as Date)))
dayzz >= CAST('2022-05-01' as Date)
and dayzz <= CURRENT_DATE
and CURRENCY = 'LUNA'
and address <> 'terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh'
and BALANCE_TYPE = 'staked'
group by
dayzz,
BALANCE_TYPE --, -- dayzz
order by
dayzz desc
Run a query to Download Data