NuveveCryptoArchivedUntitled Query
Updated 2022-07-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with pools as (
select
from_currency,
to_currency,
count(tx_id) as activity
from osmosis.core.fact_swaps
where pool_ids[0] is not null
group by from_currency, to_currency
order by activity desc
limit 10
)
select
from_label.project_name as from_asset,
to_label.project_name as to_asset,
pools.activity as activity
from pools
inner join osmosis.core.dim_labels as from_label on pools.from_currency = from_label.address
inner join osmosis.core.dim_labels as to_label on pools.to_currency = to_label.address
order by pools.activity desc
Run a query to Download Data