Export to CSV
clickhouse-client --host=127.0.0.1 --port=9000 --user=default --database=statistics --query "select datetime, key, value, sum(delivered_count) from subscriber_sources_activities where datetime >= '2024-05-01' and datetime < '2024-06-01' group by datetime, key, value;" --format CSV > /tmp/source_param_deliveries.csv
clickhouse-client --host=127.0.0.1 --port=9000 --user=default --database=statistics --query "select toDate(datetime), sum(subscribe_count), sum(unsubscribe_count), sum(subscribe_count) / sum(unsubscribe_count) from channels_stat_daily where toDate(datetime) >= '2024-02-15' and channel_id in [] group by toDate(datetime);" --format CSV > /tmp/alena_subscribers.csv
-- main stat
clickhouse-client --host=127.0.0.1 --port=9000 --user=default --database=statistics --query "select toDate(datetime), sum(delivered_count), sum(unique_click_count) from channels_stat_daily where toDate(datetime) >= '2024-02-01' group by toDate(datetime);" --format CSV > /tmp/delivery_clicks.csv
## Export to CSV with headers
clickhouse-client —host=127.0.0.1 —port=9000 —user=default —database=statistics —query “select toDate(timestamp) as date, round(avg(subscriber_age)) as unsub_age from subscription_events where date > ‘2024-07-01’ and subscriber_age >= 31 and subscriber_age ⇐ 90 and unsubscribe_count > 0 group by date” —format CSVWithNames > /tmp/31_90.csv
clickhouse-client —host=127.0.0.1 —port=9000 —user=default —database=statistics —query "" —format CSVWithNames > /tmp/file.csv