flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Distribution of Swaps in $RUNE and USD Values - 2
Crazy_Kid
Distribution of Swaps in $RUNE and USD Values - 2
Updated 2022-09-05
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
SELECT
date_trunc
(
'MONTH'
,
block_timestamp
)
as
month
,
sum
(
to_amount_usd
)
as
swap_amount_in_usd
,
sum
(
to_amount_usd
/
rune_usd
)
as
swap_amount_in_
$
rune
FROM
thorchain
.
swaps
WHERE
date
(
block_timestamp
)
>
'2022-01-01'
GROUP
BY
month
ORDER
BY
month
Results
Run a query to Download Data