gokcinTop swapped currencies from atom
Updated 2022-10-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select DISTINCT TO_CURRENCY as Currency, count(TO_CURRENCY) as Total,
CASE
when Currency = 'ibc/3BCCC93AD5DF58D11A6F8A05FA8BC801CBA0BA61A981F57E91B8B598BF8061CB' then 'MED'
when Currency = 'uosmo' then 'Osmosis'
when Currency = 'ibc/6AE98883D4D5D5FF9E50D7130F1305DA2FFA0C652D1DD9C123657C6B4EB2DF8A' then 'Evmos'
when Currency = 'ibc/46B44899322F3CD854D2D46DEEF881958467CDD4B3B10086DA49296BBED94BED' then 'Juno'
when Currency = 'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858' then 'USD Coin'
end as Name
from osmosis.core.fact_swaps
where FROM_CURRENCY = 'ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2'
and TX_STATUS = 'SUCCEEDED'
and BLOCK_TIMESTAMP > CURRENT_DATE - 21
GROUP by 1
order by 2 desc
limit 5
Run a query to Download Data