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,264 rowsCSV — whole table, not this view

Sources in this table

ex_dateto
column equals (exact text)
sort
chart against ex_date
reset
active:symbol = XLI×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
XLI1999-03-19cash_dividend———0.0935300000["tiingo"]{"tiingo":"0.09353"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI1999-06-18cash_dividend———0.0384890000["tiingo"]{"tiingo":"0.038489"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI1999-09-17cash_dividend———0.0536060000["tiingo"]{"tiingo":"0.053606"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI1999-12-17cash_dividend———0.1947730000["tiingo"]{"tiingo":"0.194773"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2000-03-17cash_dividend———0.0574090000["tiingo"]{"tiingo":"0.057409"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2000-06-16cash_dividend———0.0607600000["tiingo"]{"tiingo":"0.06076"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2000-09-15cash_dividend———0.0853650000["tiingo"]{"tiingo":"0.085365"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2000-12-15cash_dividend———0.1279700000["tiingo"]{"tiingo":"0.12797"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2001-03-16cash_dividend———0.0791900000["tiingo"]{"tiingo":"0.07919"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2001-06-15cash_dividend———0.0648700000["tiingo"]{"tiingo":"0.06487"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2001-09-21cash_dividend———0.0907800000["tiingo"]{"tiingo":"0.09078"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2001-12-21cash_dividend———0.1053300000["tiingo"]{"tiingo":"0.10533"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2002-03-15cash_dividend———0.0815300000["tiingo"]{"tiingo":"0.08153"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2002-06-21cash_dividend———0.0585900000["tiingo"]{"tiingo":"0.05859"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2002-09-20cash_dividend———0.0771100000["tiingo"]{"tiingo":"0.07711"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2002-12-20cash_dividend———0.1130200000["tiingo"]{"tiingo":"0.11302"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2003-03-21cash_dividend———0.0763200000["tiingo"]{"tiingo":"0.07632"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2003-06-20cash_dividend———0.0498900000["tiingo"]{"tiingo":"0.04989"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2003-09-19cash_dividend———0.0872800000["tiingo"]{"tiingo":"0.08728"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2003-12-19cash_dividend———0.1302000000["tiingo"]{"tiingo":"0.1302"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2004-03-19cash_dividend———0.0909200000["tiingo"]{"tiingo":"0.09092"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2004-06-18cash_dividend———0.0578000000["tiingo"]{"tiingo":"0.0578"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2004-09-17cash_dividend———0.0985800000["tiingo"]{"tiingo":"0.09858"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2004-12-17cash_dividend———0.1563000000["tiingo"]{"tiingo":"0.1563"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2005-03-18cash_dividend———0.1067100000["tiingo"]{"tiingo":"0.10671"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2005-06-17cash_dividend———0.0746700000["tiingo"]{"tiingo":"0.07467"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2005-09-16cash_dividend———0.1180100000["tiingo"]{"tiingo":"0.11801"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2005-12-16cash_dividend———0.1901600000["tiingo"]{"tiingo":"0.19016"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2006-03-17cash_dividend———0.1264600000["tiingo"]{"tiingo":"0.12646"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2006-06-16cash_dividend———0.0852200000["tiingo"]{"tiingo":"0.08522"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2006-09-15cash_dividend———0.2831700000["tiingo"]{"tiingo":"0.28317"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2006-12-15cash_dividend———0.2831700000["tiingo"]{"tiingo":"0.28317"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2007-03-16cash_dividend———0.0755000000["tiingo"]{"tiingo":"0.0755"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2007-06-15cash_dividend———0.1011900000["tiingo"]{"tiingo":"0.10119"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2007-09-21cash_dividend———0.2041600000["tiingo"]{"tiingo":"0.20416"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2007-12-21cash_dividend———0.1862700000["tiingo"]{"tiingo":"0.18627"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2008-03-20cash_dividend———0.1604800000["tiingo"]{"tiingo":"0.16048"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2008-06-20cash_dividend———0.1713100000["tiingo"]{"tiingo":"0.17131"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2008-09-19cash_dividend———0.1763900000["tiingo"]{"tiingo":"0.17639"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2008-12-19cash_dividend———0.2174700000["tiingo"]{"tiingo":"0.21747"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2009-03-20cash_dividend———0.1725489600["tiingo"]{"tiingo":"0.17254896"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2009-06-19cash_dividend———0.1484300000["tiingo"]{"tiingo":"0.14843"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2009-09-18cash_dividend———0.1438900000["tiingo"]{"tiingo":"0.14389"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2009-12-18cash_dividend———0.1805600000["tiingo"]{"tiingo":"0.18056"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2010-03-19cash_dividend———0.1063800000["tiingo"]{"tiingo":"0.10638"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2010-06-18cash_dividend———0.1470600000["tiingo"]{"tiingo":"0.14706"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2010-09-17cash_dividend———0.1551000000["tiingo"]{"tiingo":"0.1551"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2010-12-17cash_dividend———0.1774100000["tiingo"]{"tiingo":"0.17741"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2011-03-18cash_dividend———0.1571400000["tiingo"]{"tiingo":"0.15714"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLI2011-06-17cash_dividend———0.1750300000["tiingo"]{"tiingo":"0.17503"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30