Pmisha-bmlMdxfee.swaps
Updated 2022-03-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with ust as(select
block_timestamp::date as dt1,
sum(SWAP_FEE_AMOUNT) as UST_fee,
sum(SWAP_FEE_AMOUNT_USD) as USD_fee_UST
from terra.swaps where SWAP_FEE_CURRENCY='UST' group by 1),
luna as(select
block_timestamp::date as dt2,
sum(SWAP_FEE_AMOUNT) as LUNA_fee,
sum(SWAP_FEE_AMOUNT_USD) as USD_fee_LUNA
from terra.swaps where SWAP_FEE_CURRENCY='LUNA' group by 1)
select
ust.dt1 as dt,
UST_fee,
USD_fee_UST,
LUNA_fee,
USD_fee_LUNA
from ust
inner join luna on ust.dt1=luna.dt2
Run a query to Download Data