flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
THORChain Swap Volume by Chain
kellen
THORChain Swap Volume by Chain
Updated 2022-12-09
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
SPLIT
(
SPLIT
(
t
.
pool_name
,
'.'
)
[
0
]
,
'/'
)
[
0
]
AS
chain
,
ROUND
(
SUM
(
swap_volume_rune_usd
)
)
AS
swap_volume_usd
FROM
thorchain
.
core
.
fact_daily_pool_stats
t
WHERE
day
>=
DATEADD
(
'month'
,
-
18
,
CURRENT_DATE
)
GROUP
BY
1
ORDER
BY
2
DESC
Results
Run a query to Download Data