SalehHot Contracts on Osmosis-total of contracts
    Updated 2022-07-08
    select
    'Cont_Id:' || POOL_IDS[0] as contract_id
    ,count( s.TX_ID) as tx_count
    ,sum( FROM_AMOUNT/pow(10,FROM_DECIMAL)) as amount_from
    ,sum( TO_AMOUNT/pow(10,TO_DECIMAL)) as amount_to
    from osmosis.core.fact_swaps s
    where block_timestamp::date>='2022-05-01'
    and TX_STATUS='SUCCEEDED'
    group by 1



    Run a query to Download Data