Home / Historical data / All tickers / RY

RY

RY historical data download

Royal Bank of Canada · NYSE · listed 1995-10-16 · Common stock · 1-minute to daily · split & dividend adjusted · CSV

Updated to 2026-11-13Refreshed every trading night
Trading days
5,833
2003-09-10 to 2026-11-13
1-minute bars
~3.6M rows
Extended hours, ~71 MB zipped
Splits
1
2006: 2-for-1
Dividends
21
Latest ex-date 2015-04-21

Download options

Full history (2003-09-10 to today), 23.18 ticker-years. "Select" opens the download page with these settings, where you can still change the date range, adjustment and time zone.

Bar sizeRowsSize (zip)Full history
1 min~3.6M~71 MB$23Select
5 min~649K~13 MB$12Select
15 min~216K~4 MB$12Select
1 hour~57K~1 MB$8Select
DailyFree5,83398 KBFreeDownload free
The last month of minute data is free. Priced per ticker-year; Advanced subscribers save 20%.Download with other tickers →

Data preview

Real rows from the most recent trading day, adjusted, in US Eastern time: exactly what the download contains.

RY_1min_qfq.csv· 296 bars on 2026-11-13; showing the first, the open and the last
datetime_etopenhighlowclosevolumevwaptrades
2026-11-13 09:30:00Regular203.4203.495203.08203.323,342203.372868
2026-11-13 09:31:00Regular203.345204.12203.345203.913,213203.807252
2026-11-13 09:32:00Regular203.8203.8203.4203.4780203.594830
⋯
2026-11-13 15:59:00Regular202.265202.4202.21202.3621,585202.2877470
2026-11-13 16:00:00After202.31202.31202.31202.31991202.3128
2026-11-13 16:05:00After201.64201.64201.64201.64369201.641

Splits, dividends and ticker changes

The adjusted data already accounts for every event below, so there is nothing left for you to fix.

Splits 1

EffectiveRatioEarlier prices ×
2006-04-072-for-11/2
In total, adjusted prices before 2006-04-07 are divided by 2.

Dividends 21

Ex-datePer share (USD)
2015-04-210.6189
2014-04-220.646
2014-01-230.6089
2013-10-220.6507
2013-07-230.6068
2013-04-230.613999
Showing the latest 6. Each factor uses the close before the ex-date.

Ticker changes 0

Traded as RY throughout the data period, so there is nothing to stitch.

Year by year

Computed from adjusted daily bars. The table also lists estimated 1-minute rows per year, to help size a download.

Annual return (first open → last close)

UpDown
Show data table

RY data FAQ

Why do early RY prices look so low?

Because the data is split-adjusted. RY had a 2-for-1 split in 2006, so every price before the first split is divided by 2. That keeps the whole history comparable with today's price and the returns correct. Choose "Unadjusted" if you need prices as originally traded.

How are RY dividends adjusted?

RY paid 21 cash dividends in the data period, most recently $0.6189 per share with an ex-date of 2015-04-21. Each dividend gives a factor of 1 − dividend ÷ prior close, and every price before the ex-date is multiplied by it. Many sources only adjust for splits, which leaves a fake drop on every ex-dividend date in your returns.

Why does the data start on 2003-09-10 and not the listing date?

RY listed on 1995-10-16, but our minute-level history begins on 2003-09-10. Earlier data isn't available.

Do you have overnight (20:00–4:00 ET) data?

Not yet. The data comes from the consolidated tape (SIP), which covers 4:00–20:00 ET. US exchanges plan to add overnight trading to the SIP from 2026-12-06, and we will follow.

Can I keep the download up to date with the API?

Yes. Downloads and the market data API share the same data and the same adjustment. Download the history once, then pull each new day from the /v2/aggs endpoint.

Related tickers

All tickers →