flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
pool_vol_total
maybeyonas
pool_vol_total
Updated 2021-10-24
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
-- day,
split
(
pool_name
,
'-'
)
[
0
]
::
string
as
pool
,
split
(
pool_name
,
'-'
)
[
0
]
::
string
as
color
,
sum
(
swap_volume_rune_usd
)
as
swap_vol
from
thorchain
.
daily_pool_stats
-- where pool_name = 'LTC.LTC'
group
by
1
,
2
-- order by day desc
-- limit 100
Results
Run a query to Download Data