gistfile1.txt

query_msg_q = """
                  select 
                      toDate(time) as date
                      ,count(distinct user_id) as users_msg
                      ,count(user_id) as msg
                      , msg / users_msg as mpu
                  from simulator_20220620.message_actions
                  where toDate(time) between today() - 8 and today() - 1
                  group by date
                  order by date
                  """
data_msg = pd.DataFrame(ph.read_clickhouse(query=query_msg_q, connection=connection))