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 150 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
DIA2018-04-20cash_dividend0.1320000000["tiingo"]{"tiingo":"0.132"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2018-03-16cash_dividend0.4540100000["tiingo"]{"tiingo":"0.45401"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2018-02-16cash_dividend0.6447600000["tiingo"]{"tiingo":"0.64476"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2018-01-19cash_dividend0.1437300000["tiingo"]{"tiingo":"0.14373"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2017-12-15cash_dividend0.5606100000["tiingo"]{"tiingo":"0.56061"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2017-11-17cash_dividend0.5617700000["tiingo"]{"tiingo":"0.56177"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2017-10-20cash_dividend0.1827700000["tiingo"]{"tiingo":"0.18277"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2017-09-15cash_dividend0.4577100000["tiingo"]{"tiingo":"0.45771"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2017-08-18cash_dividend0.5288300000["tiingo"]{"tiingo":"0.52883"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2017-07-21cash_dividend0.2357100000["tiingo"]{"tiingo":"0.23571"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2017-06-16cash_dividend0.3940700000["tiingo"]{"tiingo":"0.39407"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2017-05-19cash_dividend0.6079700000["tiingo"]{"tiingo":"0.60797"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2017-04-21cash_dividend0.1822600000["tiingo"]{"tiingo":"0.18226"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2017-03-17cash_dividend0.4081700000["tiingo"]{"tiingo":"0.40817"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2017-02-17cash_dividend0.5605300000["tiingo"]{"tiingo":"0.56053"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2017-01-20cash_dividend0.1929800000["tiingo"]{"tiingo":"0.19298"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2016-12-16cash_dividend0.4324700000["tiingo"]{"tiingo":"0.43247"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2016-11-18cash_dividend0.5330000000["tiingo"]{"tiingo":"0.533"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2016-10-21cash_dividend0.1803600000["tiingo"]{"tiingo":"0.18036"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2016-09-16cash_dividend0.3543000000["tiingo"]{"tiingo":"0.3543"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2016-08-19cash_dividend0.6562200000["tiingo"]{"tiingo":"0.65622"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2016-07-15cash_dividend0.1347500000["tiingo"]{"tiingo":"0.13475"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2016-06-17cash_dividend0.3552000000["tiingo"]{"tiingo":"0.3552"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2016-05-20cash_dividend0.6116100000["tiingo"]{"tiingo":"0.61161"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2016-04-15cash_dividend0.1300300000["tiingo"]{"tiingo":"0.13003"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2016-03-18cash_dividend0.3748600000["tiingo"]{"tiingo":"0.37486"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2016-02-19cash_dividend0.6126200000["tiingo"]{"tiingo":"0.61262"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2016-01-15cash_dividend0.0858800000["tiingo"]{"tiingo":"0.08588"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2015-12-18cash_dividend0.4075400000["tiingo"]{"tiingo":"0.40754"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2015-11-20cash_dividend0.5732400000["tiingo"]{"tiingo":"0.57324"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2015-10-16cash_dividend0.0795800000["tiingo"]{"tiingo":"0.07958"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2015-09-18cash_dividend0.3283300000["tiingo"]{"tiingo":"0.32833"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2015-08-21cash_dividend0.5504200000["tiingo"]{"tiingo":"0.55042"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2015-07-17cash_dividend0.1719800000["tiingo"]{"tiingo":"0.17198"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2015-06-19cash_dividend0.4802500000["tiingo"]{"tiingo":"0.48025"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2015-05-15cash_dividend0.4027000000["tiingo"]{"tiingo":"0.4027"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2015-04-17cash_dividend0.1184600000["tiingo"]{"tiingo":"0.11846"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2015-03-20cash_dividend0.3111500000["tiingo"]{"tiingo":"0.31115"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2015-02-20cash_dividend0.4901300000["tiingo"]{"tiingo":"0.49013"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2015-01-16cash_dividend0.1482900000["tiingo"]{"tiingo":"0.14829"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2014-12-19cash_dividend0.3834000000["tiingo"]{"tiingo":"0.3834"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2014-11-21cash_dividend0.4483800000["tiingo"]{"tiingo":"0.44838"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2014-10-17cash_dividend0.1425400000["tiingo"]{"tiingo":"0.14254"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2014-09-19cash_dividend0.4126400000["tiingo"]{"tiingo":"0.41264"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2014-08-15cash_dividend0.2959100000["tiingo"]{"tiingo":"0.29591"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2014-07-18cash_dividend0.1823400000["tiingo"]{"tiingo":"0.18234"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2014-06-20cash_dividend0.3260200000["tiingo"]{"tiingo":"0.32602"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2014-05-16cash_dividend0.4208400000["tiingo"]{"tiingo":"0.42084"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2014-04-17cash_dividend0.1324600000["tiingo"]{"tiingo":"0.13246"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2014-03-21cash_dividend0.2823500000["tiingo"]{"tiingo":"0.28235"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30