flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
LUNA Stats - kian
freemartian
LUNA Stats - kian
Updated 2022-04-19
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
SELECT
from_asset
AS
asset
,
sum
(
from_amount_usd
)
AS
amount
,
block_timestamp
::
date
AS
DATE
,
count
(
tx_id
)
AS
number
FROM
thorchain
.
swaps
WHERE
asset
=
'TERRA.LUNA'
AND
DATE
>=
'2022-03-25'
AND
DATE
<=
'2022-03-27'
GROUP
BY
DATE
,
asset
Results
Run a query to Download Data