flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
gem8
warrior
gem8
Updated 2023-06-09
Copy Reference
Fork
9
1
2
3
4
›
⌄
select
count
(
distinct
TRADER
)
,
sum
(
TO_AMOUNT
/
pow
(
10
,
6
)
)
,
avg
(
TO_AMOUNT
/
pow
(
10
,
6
)
)
from
osmosis
.
core
.
fact_swaps
inner
join
osmosis
.
core
.
dim_labels
on
TO_CURRENCY
=
osmosis
.
core
.
dim_labels
.
address
where
PROJECT_NAME
=
'ATOM'
Results
Run a query to Download Data