Original query:


SELECT
	s.symbol,
	l.closing_price,
	opening.closing_price AS opening,
	l.change_1H,
	l.change_7D,
	l.change_1M,
	l.change_1Y,
	M.MAX AS high,
	M.MIN AS low
FROM symbols s
JOIN LATERAL ( SELECT t.* FROM tickers T WHERE T.symbol=s.symbol AND TIME> now()-INTERVAL '1 month' LIMIT 1 ) AS l ON TRUE
JOIN LATERAL ( SELECT MAX (closing_price),MIN (closing_price) FROM tickers T WHERE T.symbol=s.symbol ON T.symbol=s.symbol AND TIME> now()-INTERVAL '1 month') AS M ON TRUE
JOIN LATERAL ( SELECT symbol, closing_price FROM tickers T WHERE T.symbol=s.symbol AND TIME> now()-INTERVAL '1 month' AND T.symbol=s.symbol ORDER BY TIME ASC LIMIT 1 ) AS opening ON TRUE