flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
$RUNE Flow 1
Crazy_Kid
$RUNE Flow 1
Updated 2022-05-03
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
SELECT
date_trunc
(
'day'
,
block_timestamp
)
as
day
,
sum
(
rune_amount
)
as
volume
,
sum
(
rune_amount_usd
)
as
volume_usd
FROM
thorchain
.
transfers
WHERE
asset
=
'THOR.RUNE'
AND
date
(
block_timestamp
)
>=
'2022-01-01'
GROUP
by
day
ORDER
BY
day
Results
Run a query to Download Data