gistfile1.txt

data_new_users_q = """
select date, 
        uniqExact(user_id) as new_user, 
        uniqExactIf(user_id, source='ads') as new_user_ads,
        uniqExactIf(user_id, source='organic') as new_user_organic
from(
    select user_id,
            source, 
            min(dt_reg) as date 
    from
        (select user_id, 
                min(toDate(time)) as dt_reg, 
                source
        from simulator_20220620.feed_actions
        where toDate(time) between today() - 8 and today() - 1
        group by user_id, source
        union all
        select user_id,
                min(toDate(time)) as dt_reg, 
                source
        from simulator_20220620.message_actions
        where toDate(time) between today() - 8 and today() - 1
        group by user_id, source) as t1
    group by user_id, source) as t2
group by date
where date between today() - 8 and today() - 1
"""
data_new_users = pd.DataFrame(ph.read_clickhouse(query=data_new_users_q, connection=connection))