sarathDEX change osmo6
Updated 2022-11-16
9
1
2
3
4
5
6
7
›
⌄
SELECT top 1000 date(block_timestamp) as date, count(trader) as swappers, sum(to_amount) as swap_volume from osmosis.core.fact_swaps
where date>'2022-10-01' and to_currency in ('ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858',
'ibc/8242AD24008032E457D2E12D46588FD39FB4FB29680C6C7663D296B383C37C4',
'ibc/0CD3A0285E1341859B5E86B6AB7682F023D03E97607CCC1DC95706411D866DF7')
GROUP by 1
order by swap_volume desc
Run a query to Download Data