Updated 2022-11-13
9
1
2
3
4
5
6
7
›
⌄
select count(*) , PROJECT_NAME from osmosis.core.fact_swaps inner join osmosis.core.dim_labels
on ADDRESS=TO_CURRENCY
where TX_STATUS='SUCCEEDED' and to_date(block_timestamp) > '2022-11-01' and to_date(block_timestamp)!=CURRENT_DATE
and FROM_CURRENCY='uosmo' and TO_CURRENCY!='uosmo'
group by PROJECT_NAME
order by 1 DESC
limit 10
Run a query to Download Data