SniperTop ten most popular pools on Osmosis
Updated 2022-07-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with contracs as ( select date(block_timestamp) as date_ ,tx_id , FROM_CURRENCY , TO_CURRENCY ,pool_ids[0]::string as pool_
from osmosis.core.fact_swaps
)
,
from_token as ( select date_ ,tx_id, LABEL as from_label_token, TO_CURRENCY , pool_
from contracs A join osmosis.core.dim_labels B on A.from_currency = B.ADDRESS)
,
to_token as ( select date_ ,tx_id, from_label_token, label as to_label_token , pool_
from from_token A join osmosis.core.dim_labels B on A.TO_CURRENCY = B.ADDRESS)
select pool_ , from_label_token || ' / ' || to_label_token as contract, count(DISTINCT(tx_id)) as total_tx_id
from to_token
where date_ >= '2022-05-01'
group by 1,2
order by 3 desc
limit 10
Run a query to Download Data