flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Fees derived from Native Swaps Over weeks
nilo
Fees derived from Native Swaps Over weeks
Updated 2022-03-31
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
SELECT
date_trunc
(
week
,
block_timestamp
)
::
date
as
weekly
,
sum
(
SWAP_FEE_AMOUNT_USD
)
as
fee_amount
FROM
terra
.
swaps
WHERE
(
(
token_0_currency
IN
(
'LUNA'
,
'UST'
)
)
OR
(
token_1_currency
IN
(
'LUNA'
,
'UST'
)
)
)
group
by
1
order
by
1
,
weekly
asc
Results
Run a query to Download Data