All pastes #779205 Raw Edit

Miscellany

public text v1 · immutable
·published 2007-11-18 08:38 UTC
rendered paste body
SELECT
	marketdaily.marketdaily_id
	, marketdaily.date
	, marketdaily.closing_price
FROM
	marketdaily INNER JOIN (
		SELECT
			marketdaily_id
		FROM
			marketdaily
		WHERE
			symbol = 'ARBK'
			AND
			DAY(date)  <= 3
		ORDER BY
			date DESC
	) sub ON marketdaily.marketdaily_id = sub.marketdaily_id
GROUP BY
	YEAR(marketdaily.date) DESC, MONTH(marketdaily.date) DESC;