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