flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
5. [Easy] Swapping
binhachon
5. [Easy] Swapping
Updated 2021-10-25
Copy Reference
Fork
9
1
2
3
›
⌄
select
day
,
pool_name
,
coalesce
(
sum
(
swap_count
)
,
0
)
as
swap_count
,
coalesce
(
sum
(
unique_swapper_count
)
,
0
)
as
unique_swapper
from
thorchain
.
daily_pool_stats
where
swap_count
>
0
group
by
day
,
pool_name
Results
Run a query to Download Data