bmorkaiTotal UST swapped to Luna comparison
Updated 2021-08-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
with may as (select
swap_pair,
--DATE_TRUNC('day', block_timestamp) as day,
sum(token_0_amount_usd) as may_total
from terra.swaps
where swap_pair = 'UST to LUNA'
and block_timestamp >= '2021-05-15'
and block_timestamp <= '2021-05-31'
group by swap_pair),
aug as (select
swap_pair,
--DATE_TRUNC('day', block_timestamp) as day,
sum(token_0_amount_usd) as aug_total
from terra.swaps
where swap_pair = 'UST to LUNA'
and block_timestamp >= '2021-07-20'
and block_timestamp <= '2021-08-03'
group by swap_pair)
select
m.swap_pair,
m.may_total,
a.aug_total
from may m
inner join aug a
on m.swap_pair = a.swap_pair