SocioCryptoOsmosis: Top pools
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT top 10 CASE WHEN f.value = '1' THEN 'ATOM/OSMO'
WHEN f.value = '722' THEN 'EVMOS/OSMO'
WHEN f.value = '678' THEN 'USDC/OSMO'
WHEN f.value = '497' THEN 'JUNO/OSMO'
WHEN f.value = '816' THEN 'TORI/OSMO'
WHEN f.value = '813' THEN 'REBUS/OSMO'
WHEN f.value = '498' THEN 'ATOM/JUNO'
WHEN f.value = '604' THEN 'STARS/OSMO'
WHEN f.value = '584' THEN 'SCRT/OSMO'
WHEN f.value = '806' THEN 'STRD/OSMO'
ELSE f.value END as pools,
count(DISTINCT p.tx_id) as n_swaps,
COUNT(DISTINCT p.trader) as n_swappers
FROM osmosis.core.fact_swaps p,
table(flatten( p.pool_ids)) f
WHERE date_trunc('day',p.block_timestamp) between CURRENT_DATE-30 AND CURRENT_DATE-1
GROUP BY pools
ORDER by n_swappers DESC
Run a query to Download Data