superflyWAVAX swaps on Osmosis WAVAX swaps on Osmosis
Updated 2023-02-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select BLOCK_TIMESTAMP::date date,
count(distinct TRADER) traders,
coalesce(sum(case when FROM_CURRENCY = 'ibc/6F62F01D913E3FFE472A38C78235B8F021B511BC6596ADFF02615C8F83D3B373' then FROM_AMOUNT/pow(10,FROM_DECIMAL) end),0) sell,
coalesce(sum(case when TO_CURRENCY = 'ibc/6F62F01D913E3FFE472A38C78235B8F021B511BC6596ADFF02615C8F83D3B373' then TO_AMOUNT/pow(10,TO_DECIMAL) end ),0) buy,
count(*) swaps
from osmosis.core.fact_swaps
where ( FROM_CURRENCY = 'ibc/6F62F01D913E3FFE472A38C78235B8F021B511BC6596ADFF02615C8F83D3B373' or
TO_CURRENCY = 'ibc/6F62F01D913E3FFE472A38C78235B8F021B511BC6596ADFF02615C8F83D3B373' )
and TX_SUCCEEDED = True
group by 1
order by 1
Run a query to Download Data