ramishoowUntitled Query
    Updated 2022-11-16
    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