Rules:

1. The time zone for this data is UTC.
2. Data from thorchain refreshes every 1-2 hours.
3. Data for the latest date is not a constant, as the day has not ended yet. (Hence, only data before the latest date can be used for analysis)

Scenario:

1. Assuming, you want to get the constant data for "2024-08-27 22:00 UTC UTC". You would need to wait for "2024-08-28 00:00 UTC" data to be populated.
2. Due to the 2 hours data delay, you would need to wait 2 hours. So you can only get the data starting from "2024-08-28 00:00 UTC".
3. Assuming you are GMT +8. That would mean "2024-08-28 08:00 GMT+8". (In the morning)

Concerns:

1. Total Value Lock, may be using avg day price (for all the assets) instead of price at exactly 22:00
2. This means the deterministic rune_price, is actually a daily average
3. This is due to using data from the table "thorchain.defi.fact_daily_tvl".
4. Meanwhile rune price is hourly data at exactly 22:00