View creation with larger dataset is not working accurately

[ShivaniSK]

Hi @alex-karpovich
We are creating a view in timebase with larger dataset of 33.3M records for a particular symbol. We have unchecked the live option and we notice that the view does not load correct data. A lot of symbols are skipped and records are missed out.
The query is like below

select last{}  (bid_size AS DECIMAL)/1000000 as bidSize, 
last{}  (ask_size AS DECIMAL)/1000000 as askSize, 
last{}  (bid_price) as bidPrice,  last{}  (ask_price) as askPrice,
last{}  (bid_count) as bidCount,  last{}  (ask_count) as askCount, 
venue as venue, level, 
last{}  (timestamp) as timestampOg, 
trade_type as tradeType,
venue as venueFlag
from order_book_depth RESET over TIME (1s) 
where timestamp BETWEEN '2024-03-05 00:00:00.000'd AND '2024-03-05 23:59:59.999'd 
GROUP BY SYMBOL, trade_type, venue, level

With live option checked, the same view is created correctly with full data.
Can you please check and let us know why is there a discrepancy with live option.

Regards,
Shivani