ramishoowUntitled Query
Updated 2022-11-16
9
1
2
3
4
5
›
⌄
select sum(a.FROM_AMOUNT)/10e+22as "amount", PROJECT_NAME as "NAMES" from osmosis.core.fact_swaps a
join osmosis.core.dim_labels b on a.FROM_CURRENCY = b.ADDRESS where TO_CURRENCY= 'uosmo'
--join osmosis.core.dim_labels b on a.FROM_CURRENCY = b.ADDRESS where TO_CURRENCY= 'uosmo'
and a.block_timestamp >= '2022-10-10' and not FROM_CURRENCY = 'uosmo'
GROUP by 2 order by 1 DESC limit 5
Run a query to Download Data