I have database with stock prices. I want to query for a list of prices for every symbol at a specific time. ie. What was the last price value 24 hours ago.
I can do it with individual symbols but it doesn’t make sense when I want to populate a table with 200 symbols.
[select from database where time < now() - ‘24h’ AND “symbol”=xxx ORDER BY time DESC LIMIT 1’]
How can I get a single price for every symbol with 1 query?