flipside
FLIPSIDEAI
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
Untitled Query
Mrfti
Untitled Query
Updated 2022-07-12
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
DISTINCT
pool_ids
,
to_currency
,
from_currency
FROM
osmosis
.
core
.
fact_swaps
where
pool_ids
IN
(
select
pool_ids
FROM
osmosis
.
core
.
fact_swaps
group
by
pool_ids
ORDER
BY
COUNT
(
tx_id
)
desc
limit
10
)
Results
Run a query to Download Data