boomer77swap volume
Updated 2021-11-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with swap_volume as (select date_trunc('day', block_timestamp) as dt,
trader, case
when trader = 'terra10kjnhhsgm4jfakr85673and3aw2y4a03598e0m' then 'Comm Pool'
else 'users' end as who,
sum(offer_amount_usd) as total_volume
from terra.swaps
where swap_pair like '%LUNA%'
and block_timestamp > CURRENT_DATE - 89
group by 1,2)
select dt, who, sum(total_volume) as swap_volume
from swap_volume
group by 1,2
Run a query to Download Data