Data collected for fiscal quarters ending within the reporting period. Companies are matched by ticker symbol across time periods.
Stock price percentage change following earnings announcement (typically measured as close-to-close or intraday swing).
The following table shows individual company data used in calculations. Total records: 1
| Symbol | Company | Report Date | Revenue | Rev Growth % | EPS | EPS Est. | EPS Growth % | Surprise | Reaction % |
|---|---|---|---|---|---|---|---|---|---|
| REX | REX American Resources Corporation | Mar 26, 2026 | $0.16B | -10.1% | $1.32 | $0.15 | +87.5% | +$1.18 | +9.2% |
SELECT
e.symbol,
e.revenue as current_revenue,
e.eps as current_eps,
-- Previous quarter (flexible 2-5 month lookback)
(SELECT revenue FROM earningscalendar
WHERE symbol = e.symbol
AND fiscalDateEnding < e.fiscalDateEnding
AND fiscalDateEnding >= DATE_SUB(e.fiscalDateEnding, INTERVAL 5 MONTH)
ORDER BY fiscalDateEnding DESC LIMIT 1) as prev_quarter_revenue,
-- Previous year (11-14 month lookback)
(SELECT revenue FROM earningscalendar
WHERE symbol = e.symbol
AND fiscalDateEnding BETWEEN DATE_SUB(e.fiscalDateEnding, INTERVAL 14 MONTH)
AND DATE_SUB(e.fiscalDateEnding, INTERVAL 11 MONTH)
ORDER BY ABS(DATEDIFF(fiscalDateEnding, DATE_SUB(e.fiscalDateEnding, INTERVAL 1 YEAR)))
LIMIT 1) as prev_year_revenue
FROM earningscalendar e
JOIN ticker t ON e.symbol = t.ticker
WHERE t.sector = 'Basic Materials'
AND e.fiscalDateEnding IS NOT NULL
AND e.revenue > 1000000 -- Minimum revenue threshold