LTirrellUntitled Query
Updated 2022-04-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- select
-- balance,
-- balance_type,
-- address,
-- address_label
-- from terra.daily_balances
-- where date = current_date and currency = 'LUNA' and balance > 0
-- AND address_label ilike ('terra%') and balance_type = 'staked'
-- -- group by balance_type
-- ORDER BY balance DESC
select * from terra.daily_balances
where date = CURRENT_DATE-1 and currency = 'LUNA'
and address='terra1sk06e3dyexuq4shw77y3dsv480xv42mq73anxu'
-- and address NOT IN (
-- 'terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh',
-- 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6'
-- )
-- and balance > 0 and address_name is not NULL
order by balance DESC
limit 100
Run a query to Download Data