2,170 answered market questions

SELECT ticker,
       formatDateTime(declaration_date, '%Y-%m-%d') AS declared,
       formatDateTime(ex_dividend_date, '%Y-%m-%d') AS ex_date,
       formatDateTime(record_date, '%Y-%m-%d') AS record,
       formatDateTime(pay_date, '%Y-%m-%d') AS paid,
       cash_amount AS dividend_per_share,
       dateDiff('day', declaration_date, ex_dividend_date) AS declared_to_ex_days,
       dateDiff('day', ex_dividend_date, record_date) AS ex_to_record_days,
       dateDiff('day', record_date, pay_date) AS record_to_pay_days
FROM global_markets.stocks_dividends
WHERE ticker = 'AAPL'
  AND currency = 'USD'
  AND distribution_type = 'recurring'
  AND ex_dividend_date <= today()
  AND record_date IS NOT NULL
  AND pay_date IS NOT NULL
  AND declaration_date IS NOT NULL
ORDER BY ex_dividend_date DESC
LIMIT 1