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×sorted by ex_date ↑×

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

symboltextex_date ↑dateaction_typetextratio_rawnumericratio_numbigintratio_denbigintdiv_cashnumericvendorsARRAYvendor_valuesjsonbsourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
DIA1998-04-17cash_dividend———0.3350430000["tiingo"]{"tiingo":"0.335043"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1998-05-15cash_dividend———0.0939250000["tiingo"]{"tiingo":"0.093925"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1998-06-19cash_dividend———0.1911980000["tiingo"]{"tiingo":"0.191198"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1998-07-17cash_dividend———0.0404150000["tiingo"]{"tiingo":"0.040415"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1998-08-21cash_dividend———0.1971300000["tiingo"]{"tiingo":"0.19713"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1998-09-18cash_dividend———0.1092190000["tiingo"]{"tiingo":"0.109219"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1998-10-16cash_dividend———0.0330700000["tiingo"]{"tiingo":"0.03307"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1998-11-20cash_dividend———0.2097760000["tiingo"]{"tiingo":"0.209776"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1998-12-18cash_dividend———0.1358740000["tiingo"]{"tiingo":"0.135874"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1999-01-15cash_dividend———0.0049050000["tiingo"]{"tiingo":"0.004905"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1999-02-19cash_dividend———0.2138500000["tiingo"]{"tiingo":"0.21385"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1999-03-19cash_dividend———0.1195840000["tiingo"]{"tiingo":"0.119584"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1999-04-16cash_dividend———0.0179890000["tiingo"]{"tiingo":"0.017989"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1999-05-21cash_dividend———0.2289600000["tiingo"]{"tiingo":"0.22896"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1999-06-18cash_dividend———0.1173200000["tiingo"]{"tiingo":"0.11732"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1999-07-16cash_dividend———0.0332980000["tiingo"]{"tiingo":"0.033298"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1999-08-20cash_dividend———0.2291870000["tiingo"]{"tiingo":"0.229187"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1999-09-17cash_dividend———0.1309510000["tiingo"]{"tiingo":"0.130951"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1999-10-15cash_dividend———0.0340030000["tiingo"]{"tiingo":"0.034003"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1999-11-19cash_dividend———0.1904130000["tiingo"]{"tiingo":"0.190413"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA1999-12-17cash_dividend———0.1083900000["tiingo"]{"tiingo":"0.10839"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2000-01-21cash_dividend———0.0744930000["tiingo"]{"tiingo":"0.074493"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2000-02-18cash_dividend———0.1292850000["tiingo"]{"tiingo":"0.129285"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2000-03-17cash_dividend———0.1583770000["tiingo"]{"tiingo":"0.158377"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2000-04-20cash_dividend———0.0452230000["tiingo"]{"tiingo":"0.045223"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2000-05-19cash_dividend———0.1686200000["tiingo"]{"tiingo":"0.16862"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2000-06-16cash_dividend———0.0582850000["tiingo"]{"tiingo":"0.058285"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2000-07-21cash_dividend———0.1536080000["tiingo"]{"tiingo":"0.153608"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2000-08-18cash_dividend———0.1219340000["tiingo"]{"tiingo":"0.121934"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2000-09-15cash_dividend———0.1432300000["tiingo"]{"tiingo":"0.14323"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2000-10-20cash_dividend———0.1330920000["tiingo"]{"tiingo":"0.133092"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2000-11-17cash_dividend———0.1361200000["tiingo"]{"tiingo":"0.13612"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2000-12-15cash_dividend———0.2459900000["tiingo"]{"tiingo":"0.24599"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2001-02-16cash_dividend———0.1648400000["tiingo"]{"tiingo":"0.16484"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2001-03-16cash_dividend———0.1510400000["tiingo"]{"tiingo":"0.15104"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2001-04-20cash_dividend———0.0849900000["tiingo"]{"tiingo":"0.08499"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2001-05-18cash_dividend———0.1794500000["tiingo"]{"tiingo":"0.17945"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2001-06-15cash_dividend———0.1094900000["tiingo"]{"tiingo":"0.10949"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2001-07-20cash_dividend———0.1142700000["tiingo"]{"tiingo":"0.11427"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2001-08-17cash_dividend———0.1179700000["tiingo"]{"tiingo":"0.11797"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2001-09-21cash_dividend———0.1902600000["tiingo"]{"tiingo":"0.19026"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2001-10-19cash_dividend———0.0986000000["tiingo"]{"tiingo":"0.0986"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2001-11-16cash_dividend———0.1370800000["tiingo"]{"tiingo":"0.13708"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2001-12-21cash_dividend———0.2132800000["tiingo"]{"tiingo":"0.21328"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2002-01-18cash_dividend———0.0886100000["tiingo"]{"tiingo":"0.08861"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2002-02-15cash_dividend———0.1348500000["tiingo"]{"tiingo":"0.13485"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2002-03-15cash_dividend———0.1587500000["tiingo"]{"tiingo":"0.15875"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2002-04-19cash_dividend———0.0882600000["tiingo"]{"tiingo":"0.08826"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2002-05-17cash_dividend———0.1372100000["tiingo"]{"tiingo":"0.13721"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2002-06-21cash_dividend———0.1719900000["tiingo"]{"tiingo":"0.17199"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30