nitsHot Pools
Updated 2022-07-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select value, count(DISTINCT tx_id) as total_txs,
case when value = 1 then 'ATOM/OSMO'
when value = 678 then 'USDC/OSMO'
when value = 560 then 'USTC/OSMO'
when value = 561 then 'LUNC/OSMO'
when value = 722 then 'EVMOS/OSMO'
when value = 497 then 'JUNO/OSMO'
when value = 608 then 'LUM/OSMO'
when value = 565 then 'LUNC/ATOM'
when value = 5 then 'DVPN/OSMO'
when value = 498 then 'ATOM/JUNO' end as contract_name
from osmosis.core.fact_swaps, table(flatten(input => pool_ids))
where date(block_timestamp) >= '2022-05-01'
GROUP by 1
order by 2 desc
limit 10
Run a query to Download Data