dariustay_0512Top 100 $OSMO swaps
Updated 2022-06-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select block_timestamp,
trader,
from_amount,
case when from_currency = 'uosmo' then 'OSMO' else from_currency end as from_currency,
case when to_currency = 'ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2' THEN 'ATOM'
when to_currency = 'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858' then 'USDC'
when to_currency = 'ibc/BE1BB42D4BE3C30D50B68D7C41DB4DFCE9678E8EF8C539F6E6A9345048894FCC' then 'USTC'
when to_currency = 'ibc/46B44899322F3CD854D2D46DEEF881958467CDD4B3B10086DA49296BBED94BED' then 'JUNO'
when to_currency = 'ibc/D1542AA8762DB13087D8364F3EA6509FD6F009A34F00426AF9E4F9FA85CBBF1F' then 'WBTC'
when to_currency = 'ibc/6AE98883D4D5D5FF9E50D7130F1305DA2FFA0C652D1DD9C123657C6B4EB2DF8A' then 'EVMOS'
when to_currency = 'ibc/EA1D43981D5C9A1C4AAEA9C23BB1D4FA126BA9BC7020A25E0AE4AA841EA25DC5' then 'WETH'
else to_currency end as to_currency,
to_amount from osmosis.core.fact_swaps
where block_timestamp >= '2022-06-01' and
from_currency = 'uosmo'
and to_currency != 'uosmo'
order by 3 desc
limit 100
Run a query to Download Data