ramishoowUntitled Query
    Updated 2022-11-16
    select count(*) as " number of swaps",sum(TO_AMOUNT/TO_DECIMAL) as "volume of swaps" , PROJECT_NAME , to_date(block_timestamp) as day
    from osmosis.core.fact_swaps inner join osmosis.core.dim_labels
    on ADDRESS=FROM_CURRENCY
    where TX_STATUS='SUCCEEDED' and to_date(block_timestamp) > '2022-11-01' and to_date(block_timestamp)!=CURRENT_DATE
    and (PROJECT_NAME like '%USDC%' or PROJECT_NAME like '%DAI%' or PROJECT_NAME like '%USDT%')
    group by PROJECT_NAME , to_date(block_timestamp)
    Run a query to Download Data