boomer77KRT vs UST volume
Updated 2021-08-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with KRT as (select date_trunc('month', block_timestamp) as block_month,
sum(event_amount_USD) as Volume_KRT
from terra.transfers
where event_from in (select address
from terra.daily_balances
where currency = 'KRT' and date = CURRENT_DATE and balance > 11750)
and tx_status = 'SUCCEEDED' and event_currency = 'KRT'
group by 1),
UST as (select date_trunc('month', block_timestamp) as block_month,
sum(event_amount_USD) as Volume_UST
from terra.transfers
where event_from in (select address
from terra.daily_balances
where currency = 'UST' and date = CURRENT_DATE and balance > 10)
and tx_status = 'SUCCEEDED' and event_currency = 'UST'
group by 1)
select
A.block_month, A.Volume_KRT, B.Volume_UST
from KRT A
join UST B on A.block_month = B.block_month
Run a query to Download Data