gistfile1.txt

query_feed_q = """
                select 
                    toDate(time) as date
                    ,count(distinct user_id) as users_feed
                    ,countIf(action='like') as likes
                    ,countIf(action='view') as views
                    ,countIf(action='like') / countIf(action='view') as CTR
                    ,likes+views as events
                from simulator_20220620.feed_actions
                where toDate(time) between today() - 8 and today() - 1
                group by date
                order by date
                """

data_feed = pd.DataFrame(ph.read_clickhouse(query=query_feed_q, connection=connection))