Updated 2022-11-13
9
1
2
3
4
›
⌄
select count(*) , sum(FROM_AMOUNT/FROM_DECIMAL) ,count(distinct TRADER) , to_date(block_timestamp) from osmosis.core.fact_swaps
where TX_STATUS='SUCCEEDED' and to_date(block_timestamp) > '2022-11-01' and to_date(block_timestamp)!=CURRENT_DATE
and FROM_CURRENCY='uosmo'
group by to_date(block_timestamp)
Run a query to Download Data