Manually remove history data based on timestamp

Look if there is any data for tables history, history_uint, history_text, history_str, history_log, trends, trends_uint:

select * from history where clock < UNIX_TIMESTAMP('2018-06-01 00:00:00') LIMIT 5000;
select * from history_uint where clock < UNIX_TIMESTAMP('2018-06-01 00:00:00') LIMIT 5000;
select * from history_text where clock < UNIX_TIMESTAMP('2018-06-01 00:00:00') LIMIT 5000;
select * from history_str where clock < UNIX_TIMESTAMP('2018-06-01 00:00:00') LIMIT 5000;
select * from history_log where clock < UNIX_TIMESTAMP('2018-06-01 00:00:00') LIMIT 5000;
select * from trends where clock < UNIX_TIMESTAMP('2018-06-01 00:00:00') LIMIT 5000;
select * from trends_uint where clock < UNIX_TIMESTAMP('2018-06-01 00:00:00') LIMIT 5000;

To delete the data:

delete from history where clock < UNIX_TIMESTAMP('2018-06-01 00:00:00') LIMIT 5000;
delete from history_uint where clock < UNIX_TIMESTAMP('2018-06-01 00:00:00') LIMIT 5000;
delete from history_text where clock < UNIX_TIMESTAMP('2018-06-01 00:00:00') LIMIT 5000;
delete from history_str where clock < UNIX_TIMESTAMP('2018-06-01 00:00:00') LIMIT 5000;
delete from history_log where clock < UNIX_TIMESTAMP('2018-06-01 00:00:00') LIMIT 5000;
delete from trends where clock < UNIX_TIMESTAMP('2018-06-01 00:00:00') LIMIT 5000;
delete from trends_uint where clock < UNIX_TIMESTAMP('2018-06-01 00:00:00') LIMIT 5000;