main-stat

To enter clickhouse shell:

clickhouse-client --host=127.0.0.1 --port=9000 --user=default --database=statistics

select toDate(datetime), sum(sent_count), sum(delivered_count), sum(unique_click_count), sum(subscribe_count), sum(unsubscribe_count) from channels_stat_daily where toDate(datetime) >= '2024-03-01' group by toDate(datetime);