round(sum(amount/pow (10, decimal)),2) as tot_inflow_volume,

round(avg(amount/pow (10, decimal)),2) as avg_inflow_volume,

count(distinct(tx_id)) as no_of_inflow_txns,

count(distinct(sender)) as no_of_users

from osmosis.core.fact_transfers

where tx_status = 'SUCCEEDED'

and currency = 'uosmo'

and (receiver = 'osmo129uhlqcsvmehxgzcsdxksnsyz94dvea907e575' or

receiver = 'osmo1krmqr8zhvteevq4hnl7q0pxtff6xpnqz4ckxcu')

and block_timestamp >= '2022-10-28'

group by hour

order by hour DESC