Trying to write a query from the following table that calculates a count of records for every day date(timestamp) and the prior 4 days. So basically a rolling count of records for every previous 5 days. Every time i do…
I have the following two tables: CREATE TABLE products ( id INT, created_at DATE, sold_at DATE ); CREATE TABLE product_prices ( id INT, product_id INT, price numeric, created_at DATE ); The data model logic works as follows: When a new…
I have the following table which stores historical prices for stocks stock_id | open | close | high | low | timestamp ----------+--------+--------+--------+--------+--------------------- 2 | 338 | 330 | 338 | 330 | 2022-10-21 05:30:00 2 | 341 | 338…
In a Postgres DB I have entries for "events", associated with an id, and when they happened. I need to count them with a special rule. When an event happens the counter is incremented and for the next 14 days…
We are storing data corresponding to rates (ex: electricity price) in a SQL table, such as: Date Value 2022-08-25 01:00 12.3 2022-09-23 06:12 14.5 2022-10-18 05:34 9.8 The date interval between two rows is not regular. In this table, 12.3…
I'm looking for some advice from anyone who's tried aws Sagemaker. I'm very new to this and would appreciate anyone kind enough to help me out. I have created a basic time series project in a Sagemaker notebook. It trains…
{ { "symbol": "MSFT", "close": [0, 1, 2, 3, 4, 5], "open": [0, 1, 2, 3, 4, 5], "high": [0, 1, 2, 3, 4, 5], "low": [0, 1, 2, 3, 4, 5], "volume": [0, 1, 2, 3, 4, 5], "dates":…
We are using Django with its ORM in connection with an underlying PostgreSQL database and want to extend the data model and technology stack to store massive amounts of time series data (~5 million entries per day onwards). The closest…
I have a Mongo database filled with "Events" records, that look like this: { timestamp: 2022-03-15T22:11:34.711Z, _id: new ObjectId("62310f16b0d71321e887a905") } Using a NodeJs server, I need to fetch the last 30 days of Events, grouped/summed by date, and any dates…
I am currently trying to do a simple implementation for stock price candle sticks. Let's say we have a stock called XYZ. This stock receives a stream of prices (in no particular frequency), which (for example) looks like: XYZ: [10.2,…