boomer77KRT vs UST
Updated 2021-11-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with krt as (select count(distinct address) as KRT_address, date
from terra.daily_balances
where currency = 'KRT' and date = CURRENT_DATE and balance > 11750
group by 2
),
ust as (select count(distinct address) as UST_address, date
from terra.daily_balances
where currency = 'UST' and date = CURRENT_DATE and balance > 10
group by 2
)
select A.date, A.KRT_address, B.UST_address
from krt A
join ust B on A.date = B.date
Run a query to Download Data