I've been ingesting stock market trading data into MongoDB and using Metabase[1] to visualize it. It is essentially date, price, volume, ticker symbol, exchange. Around 400M documents so far.
Queries out of Metabase take upwards of 2-5 minutes to run even simple questions like:
Plot the average price of Apple for the last 5 days grouping by minute.
Would Timescale Cloud be a better replacement in terms of performance? Is there a nice GUI visualization platform like Metabase for it?
Queries out of Metabase take upwards of 2-5 minutes to run even simple questions like:
Would Timescale Cloud be a better replacement in terms of performance? Is there a nice GUI visualization platform like Metabase for it?[1] https://metabase.com/