You are right. I gave no detailed information:
Vantage Vue
Raspberry Pi + Raspbian Buster
Your query gives no records with rainRate > 100 (and no errors)
sqlite> SELECT dateTime, datetime(dateTime, 'unixepoch', 'localtime'), usUnits, rain, rainRate FROM archive WHERE rainRate > 100.0 LIMIT 100;
sqlite>
But I executed that query for the archive_day_rainRate table and you can see that impossible rainRate value:
sqlite> SELECT dateTime, datetime(dateTime, 'unixepoch', 'localtime'), max FROM archive_day_rainRate WHERE max > 100.0 LIMIT 100;
1588975200|2020-05-09 00:00:00|516.0236188995
1589148000|2020-05-11 00:00:00|516.0236188995
1589234400|2020-05-12 00:00:00|516.0236188995
1589320800|2020-05-13 00:00:00|516.0236188995
1589407200|2020-05-14 00:00:00|516.0236188995
1589493600|2020-05-15 00:00:00|516.0236188995
1589580000|2020-05-16 00:00:00|516.0236188995
1589752800|2020-05-18 00:00:00|516.0236188995
1589839200|2020-05-19 00:00:00|516.0236188995
1589925600|2020-05-20 00:00:00|516.0236188995
1590012000|2020-05-21 00:00:00|516.0236188995
1590098400|2020-05-22 00:00:00|516.0236188995
1590184800|2020-05-23 00:00:00|516.0236188995
1590357600|2020-05-25 00:00:00|516.0236188995
1590444000|2020-05-26 00:00:00|516.0236188995
1590530400|2020-05-27 00:00:00|516.0236188995
1590616800|2020-05-28 00:00:00|516.0236188995
1590703200|2020-05-29 00:00:00|516.0236188995
1590789600|2020-05-30 00:00:00|516.0236188995
1590876000|2020-05-31 00:00:00|516.0236188995
1590962400|2020-06-01 00:00:00|516.0236188995
1591048800|2020-06-02 00:00:00|516.0236188995
1592863200|2020-06-23 00:00:00|516.0236188995
1592949600|2020-06-24 00:00:00|516.0236188995
1594504800|2020-07-12 00:00:00|516.0236188995
1594591200|2020-07-13 00:00:00|516.0236188995
1594677600|2020-07-14 00:00:00|516.0236188995
1594764000|2020-07-15 00:00:00|516.0236188995
1594850400|2020-07-16 00:00:00|516.0236188995
1594936800|2020-07-17 00:00:00|516.0236188995
1595023200|2020-07-18 00:00:00|516.0236188995
1595109600|2020-07-19 00:00:00|516.0236188995
1595196000|2020-07-20 00:00:00|516.0236188995
1595282400|2020-07-21 00:00:00|516.0236188995
1595368800|2020-07-22 00:00:00|516.0236188995
1596232800|2020-08-01 00:00:00|516.0236188995
1596319200|2020-08-02 00:00:00|516.0236188995
1596405600|2020-08-03 00:00:00|516.0236188995
1596492000|2020-08-04 00:00:00|516.0236188995
1596578400|2020-08-05 00:00:00|516.0236188995
1596664800|2020-08-06 00:00:00|516.0236188995
1596751200|2020-08-07 00:00:00|516.0236188995
1596837600|2020-08-08 00:00:00|516.0236188995
1596924000|2020-08-09 00:00:00|516.0236188995
1597010400|2020-08-10 00:00:00|516.0236188995
1598306400|2020-08-25 00:00:00|516.0236188995
1598392800|2020-08-26 00:00:00|516.0236188995
1598479200|2020-08-27 00:00:00|516.0236188995
1598565600|2020-08-28 00:00:00|516.0236188995
1598652000|2020-08-29 00:00:00|516.0236188995
1598738400|2020-08-30 00:00:00|516.0236188995
1598997600|2020-09-02 00:00:00|516.0236188995
1599084000|2020-09-03 00:00:00|516.0236188995
1599170400|2020-09-04 00:00:00|516.0236188995
1599256800|2020-09-05 00:00:00|516.0236188995
1599343200|2020-09-06 00:00:00|516.0236188995
1599429600|2020-09-07 00:00:00|516.0236188995
1599516000|2020-09-08 00:00:00|516.0236188995
1599602400|2020-09-09 00:00:00|516.0236188995
1599688800|2020-09-10 00:00:00|516.0236188995
1599775200|2020-09-11 00:00:00|516.0236188995
1599861600|2020-09-12 00:00:00|516.0236188995
1599948000|2020-09-13 00:00:00|516.0236188995
1600034400|2020-09-14 00:00:00|516.0236188995
1600120800|2020-09-15 00:00:00|516.0236188995
1600207200|2020-09-16 00:00:00|516.0236188995
1600293600|2020-09-17 00:00:00|516.0236188995
1600380000|2020-09-18 00:00:00|516.0236188995
1600466400|2020-09-19 00:00:00|516.0236188995
1600552800|2020-09-20 00:00:00|516.0236188995
1600725600|2020-09-22 00:00:00|516.0236188995
1600812000|2020-09-23 00:00:00|516.0236188995
1600898400|2020-09-24 00:00:00|516.0236188995
1600984800|2020-09-25 00:00:00|516.0236188995
1601071200|2020-09-26 00:00:00|516.0236188995
1601157600|2020-09-27 00:00:00|516.0236188995
1601244000|2020-09-28 00:00:00|516.0236188995
1601330400|2020-09-29 00:00:00|516.0236188995
1601416800|2020-09-30 00:00:00|516.0236188995
1601503200|2020-10-01 00:00:00|516.0236188995
1601589600|2020-10-02 00:00:00|516.0236188995
1601676000|2020-10-03 00:00:00|516.0236188995
1601762400|2020-10-04 00:00:00|516.0236188995
1601848800|2020-10-05 00:00:00|516.0236188995
1601935200|2020-10-06 00:00:00|516.0236188995
1602021600|2020-10-07 00:00:00|516.0236188995
1602108000|2020-10-08 00:00:00|516.0236188995
1602194400|2020-10-09 00:00:00|516.0236188995
1602280800|2020-10-10 00:00:00|516.0236188995
1603058400|2020-10-19 00:00:00|516.0236188995
1603144800|2020-10-20 00:00:00|516.0236188995
1603231200|2020-10-21 00:00:00|516.0236188995
1603317600|2020-10-22 00:00:00|516.0236188995
1603404000|2020-10-23 00:00:00|516.0236188995
1603753200|2020-10-27 00:00:00|516.0236188995
1603839600|2020-10-28 00:00:00|516.0236188995
1603926000|2020-10-29 00:00:00|516.0236188995
1604012400|2020-10-30 00:00:00|516.0236188995
1604098800|2020-10-31 00:00:00|516.0236188995
1604185200|2020-11-01 00:00:00|516.0236188995
The archive table does not contain strange values (result of your query is no records and no error is produced).
On the other hand, the archive_day_rainRate table does contain that error for every day at 00:00:00 and only at that hour.