select date_trunc('hour', t) as hour,

count(sender) n_sender,

count(tx_id) as swap_txn,

avg(psi_price) as avg_psi_price,

sum(swapust/1000000)/1000 as sum_ust_swapped_per_1k

from (

Select block_timestamp as t,

msg_value:sender::string as sender,

tx_id,

msg_value:execute_msg:swap:belief_price::string as psi_price,

msg_value:execute_msg:swap:offer_asset:amount as swapust

from terra.msgs

where --tx_id='225206833EA05F94814A3065ADDD5504D681EEA10EDF66A0B1AF9FD2140AEAA6' AND

msg_value:contract='terra163pkeeuwxzr0yhndf8xd2jprm9hrtk59xf7nqf' and

--psi swap contract

msg_value:execute_msg:swap:offer_asset:info:native_token:denom='uusd' and

t>'2021-10-31'

)

where hour<='2021-11-03'

group by 1 order by 1