Timestream Historical Data (10s of years old)

Hi,

(Quite new to timestream, old hat with SQL)

I've added Millions (80M+) rows of data to a timestream table around 3 days ago. The data is historical, and goes back to the late 1800s.

When querying it with:

SELECT * FROM <database>.<table> ORDER BY time ASC LIMIT 1

The earliest record it shows 'time' is in the year 2016 (this is actually around the date of the first record inserted into the table), there are however millions of records before this date (but these were added later to the table), I've confirmed all the records exist in the table by running:

SELECT count(id) FROM <database>.<table>

Which results in a count equal to all the rows I've added (80M+)

The table is setup to hold data in memory for 6 months, and in magnetic store for 200 years. Magnetic writes are also turned on.

Why does this behaviour happen? are query results or records cached/indexed by timestream in some way, if so is there a way to clear this cache or documentation about it? Is it the normal behaviour of the magnetic store, as its such a large dataset added recently, is magnetic store still organising it?

Thanks,

James