Simplify Analytics
← Data Explorer

Corporate actions

core.corporate_actions

Splits, cash dividends and price factors. The second half of the PIT price spine - these are what core.prices_asof() applies.

3,253 rowsCSV — whole table, not this view

Sources in this table

ex_dateto
column equals (exact text)
sort
chart against ex_date
reset
active:symbol = DIA×

ex_date leads no index, so this sort reads every matching row and keeps only the top 100 in a heap (the page LIMIT), under a 5s statement timeout.

symboltextex_datedateaction_typetextratio_rawnumericratio_numbigintratio_denbigintdiv_cashnumericvendorsARRAYvendor_valuesjsonbsourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
DIA2022-07-15cash_dividend0.1284800000["tiingo"]{"tiingo":"0.12848"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2022-06-17cash_dividend0.6920600000["tiingo"]{"tiingo":"0.69206"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2022-05-20cash_dividend0.7451200000["tiingo"]{"tiingo":"0.74512"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2022-04-14cash_dividend0.1260300000["tiingo"]{"tiingo":"0.12603"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2022-03-18cash_dividend0.7715700000["tiingo"]{"tiingo":"0.77157"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2022-02-18cash_dividend0.5194000000["tiingo"]{"tiingo":"0.5194"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2022-01-21cash_dividend0.2577700000["tiingo"]{"tiingo":"0.25777"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2021-12-17cash_dividend0.6622410000["tiingo"]{"tiingo":"0.662241"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2021-11-19cash_dividend0.7009600000["tiingo"]{"tiingo":"0.70096"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2021-10-15cash_dividend0.1167100000["tiingo"]{"tiingo":"0.11671"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2021-09-17cash_dividend0.7356400000["tiingo"]{"tiingo":"0.73564"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2021-08-20cash_dividend0.6111100000["tiingo"]{"tiingo":"0.61111"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2021-07-16cash_dividend0.2066900000["tiingo"]{"tiingo":"0.20669"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2021-06-18cash_dividend0.4927000000["tiingo"]{"tiingo":"0.4927"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2021-05-21cash_dividend0.7030900000["tiingo"]{"tiingo":"0.70309"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2021-04-16cash_dividend0.1119500000["tiingo"]{"tiingo":"0.11195"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2021-03-19cash_dividend0.6714200000["tiingo"]{"tiingo":"0.67142"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2021-02-19cash_dividend0.6013300000["tiingo"]{"tiingo":"0.60133"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2021-01-15cash_dividend0.1275000000["tiingo"]{"tiingo":"0.1275"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2020-12-18cash_dividend0.5874600000["tiingo"]{"tiingo":"0.58746"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2020-11-20cash_dividend0.6522500000["tiingo"]{"tiingo":"0.65225"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2020-10-16cash_dividend0.1167900000["tiingo"]{"tiingo":"0.11679"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2020-09-18cash_dividend0.6668000000["tiingo"]{"tiingo":"0.6668"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2020-08-21cash_dividend0.6035000000["tiingo"]{"tiingo":"0.6035"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2020-07-17cash_dividend0.2112300000["tiingo"]{"tiingo":"0.21123"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2020-06-19cash_dividend0.7526600000["tiingo"]{"tiingo":"0.75266"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2020-05-15cash_dividend0.4622800000["tiingo"]{"tiingo":"0.46228"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2020-04-17cash_dividend0.1301800000["tiingo"]{"tiingo":"0.13018"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2020-03-20cash_dividend0.6018300000["tiingo"]{"tiingo":"0.60183"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2020-02-21cash_dividend0.8039000000["tiingo"]{"tiingo":"0.8039"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2020-01-17cash_dividend0.1384800000["tiingo"]{"tiingo":"0.13848"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2019-12-20cash_dividend0.8660000000["tiingo"]{"tiingo":"0.866"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2019-11-15cash_dividend0.5137000000["tiingo"]{"tiingo":"0.5137"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2019-10-18cash_dividend0.1729000000["tiingo"]{"tiingo":"0.1729"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2019-09-20cash_dividend0.6470300000["tiingo"]{"tiingo":"0.64703"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2019-07-19cash_dividend0.2234000000["tiingo"]{"tiingo":"0.2234"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2019-06-21cash_dividend0.6371000000["tiingo"]{"tiingo":"0.6371"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2019-05-17cash_dividend0.6437000000["tiingo"]{"tiingo":"0.6437"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2019-04-18cash_dividend0.1580000000["tiingo"]{"tiingo":"0.158"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2019-03-15cash_dividend0.5446000000["tiingo"]{"tiingo":"0.5446"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2019-02-15cash_dividend0.6980000000["tiingo"]{"tiingo":"0.698"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2019-01-18cash_dividend0.1739000000["tiingo"]{"tiingo":"0.1739"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2018-12-21cash_dividend0.6159000000["tiingo"]{"tiingo":"0.6159"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2018-11-16cash_dividend0.6009000000["tiingo"]{"tiingo":"0.6009"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2018-10-19cash_dividend0.1552000000["tiingo"]{"tiingo":"0.1552"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2018-09-21cash_dividend0.5458000000["tiingo"]{"tiingo":"0.5458"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2018-08-17cash_dividend0.5385000000["tiingo"]{"tiingo":"0.5385"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2018-07-20cash_dividend0.3179000000["tiingo"]{"tiingo":"0.3179"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2018-06-15cash_dividend0.3764000000["tiingo"]{"tiingo":"0.3764"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2018-05-18cash_dividend0.6973000000["tiingo"]{"tiingo":"0.6973"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30