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:endpoint = /tiingo/daily/XLK/prices×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_datedateaction_typetextratio_rawnumericratio_numbigintratio_denbigintdiv_cashnumericvendorsARRAYvendor_valuesjsonbsourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
XLK1999-12-17cash_dividend0.0013230000["tiingo"]{"tiingo":"0.001323"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2002-12-20cash_dividend0.0407500000["tiingo"]{"tiingo":"0.04075"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2003-12-19cash_dividend0.1410600000["tiingo"]{"tiingo":"0.14106"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2004-12-17cash_dividend0.4176600000["tiingo"]{"tiingo":"0.41766"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2005-12-16cash_dividend0.1481000000["tiingo"]{"tiingo":"0.1481"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2006-09-15cash_dividend0.1349100000["tiingo"]{"tiingo":"0.13491"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2006-12-15cash_dividend0.1349100000["tiingo"]{"tiingo":"0.13491"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2007-06-15cash_dividend0.0177100000["tiingo"]{"tiingo":"0.01771"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2007-09-21cash_dividend0.0525500000["tiingo"]{"tiingo":"0.05255"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2007-12-21cash_dividend0.1226200000["tiingo"]{"tiingo":"0.12262"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2008-03-20cash_dividend0.0055000000["tiingo"]{"tiingo":"0.0055"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2008-06-20cash_dividend0.0685800000["tiingo"]{"tiingo":"0.06858"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2008-09-19cash_dividend0.0707000000["tiingo"]{"tiingo":"0.0707"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2008-12-19cash_dividend0.0805100000["tiingo"]{"tiingo":"0.08051"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2009-03-20cash_dividend0.0771680700["tiingo"]{"tiingo":"0.07716807"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2009-06-19cash_dividend0.0806300000["tiingo"]{"tiingo":"0.08063"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2009-09-18cash_dividend0.0767000000["tiingo"]{"tiingo":"0.0767"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2009-12-18cash_dividend0.0794600000["tiingo"]{"tiingo":"0.07946"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2010-03-19cash_dividend0.0731000000["tiingo"]{"tiingo":"0.0731"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2010-06-18cash_dividend0.0789300000["tiingo"]{"tiingo":"0.07893"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2010-09-17cash_dividend0.0807800000["tiingo"]{"tiingo":"0.08078"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2010-12-17cash_dividend0.0900000000["tiingo"]{"tiingo":"0.09"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2011-03-18cash_dividend0.0835900000["tiingo"]{"tiingo":"0.08359"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2011-06-17cash_dividend0.0982300000["tiingo"]{"tiingo":"0.09823"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2011-09-16cash_dividend0.0935000000["tiingo"]{"tiingo":"0.0935"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2011-12-16cash_dividend0.1092300000["tiingo"]{"tiingo":"0.10923"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2012-03-16cash_dividend0.0964000000["tiingo"]{"tiingo":"0.0964"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2012-06-15cash_dividend0.1085700000["tiingo"]{"tiingo":"0.10857"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2012-09-21cash_dividend0.1299600000["tiingo"]{"tiingo":"0.12996"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2012-12-21cash_dividend0.1676300000["tiingo"]{"tiingo":"0.16763"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2013-03-15cash_dividend0.1243400000["tiingo"]{"tiingo":"0.12434"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2013-06-21cash_dividend0.1546400000["tiingo"]{"tiingo":"0.15464"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2013-09-20cash_dividend0.1583300000["tiingo"]{"tiingo":"0.15833"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2013-12-20cash_dividend0.1713100000["tiingo"]{"tiingo":"0.17131"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2014-03-21cash_dividend0.1573200000["tiingo"]{"tiingo":"0.15732"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2014-06-20cash_dividend0.1760200000["tiingo"]{"tiingo":"0.17602"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2014-09-19cash_dividend0.1737600000["tiingo"]{"tiingo":"0.17376"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2014-12-19cash_dividend0.2164900000["tiingo"]{"tiingo":"0.21649"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2015-03-20cash_dividend0.1734300000["tiingo"]{"tiingo":"0.17343"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2015-06-19cash_dividend0.1928900000["tiingo"]{"tiingo":"0.19289"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2015-09-18cash_dividend0.1834300000["tiingo"]{"tiingo":"0.18343"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2015-12-18cash_dividend0.2159050000["tiingo"]{"tiingo":"0.215905"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2016-03-18cash_dividend0.2202260000["tiingo"]{"tiingo":"0.220226"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2016-06-17cash_dividend0.2113090000["tiingo"]{"tiingo":"0.211309"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2016-09-16cash_dividend0.1955720000["tiingo"]{"tiingo":"0.195572"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2016-12-16cash_dividend0.2162320000["tiingo"]{"tiingo":"0.216232"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2017-03-17cash_dividend0.2052390000["tiingo"]{"tiingo":"0.205239"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2017-06-16cash_dividend0.2233800000["tiingo"]{"tiingo":"0.22338"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2017-09-15cash_dividend0.2092240000["tiingo"]{"tiingo":"0.209224"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2017-12-15cash_dividend0.2382530000["tiingo"]{"tiingo":"0.238253"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30