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×

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
XLK2026-06-22cash_dividend0.2279180000["tiingo"]{"tiingo":"0.227918"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2026-03-23cash_dividend0.1675050000["tiingo"]{"tiingo":"0.167505"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2025-12-22cash_dividend0.2188270000["tiingo"]{"tiingo":"0.218827"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2025-12-05split2.00000000000000021["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2025-09-22cash_dividend0.3578670000["tiingo"]{"tiingo":"0.357867"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2025-06-23cash_dividend0.3975080000["tiingo"]{"tiingo":"0.397508"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2025-03-24cash_dividend0.3748920000["tiingo"]{"tiingo":"0.374892"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2024-12-23cash_dividend0.3859570000["tiingo"]{"tiingo":"0.385957"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2024-09-23cash_dividend0.3985140000["tiingo"]{"tiingo":"0.398514"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2024-06-24cash_dividend0.4000010000["tiingo"]{"tiingo":"0.400001"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2024-03-18cash_dividend0.3391990000["tiingo"]{"tiingo":"0.339199"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2023-12-18cash_dividend0.4220140000["tiingo"]{"tiingo":"0.422014"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2023-09-18cash_dividend0.3602860000["tiingo"]{"tiingo":"0.360286"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2023-06-20cash_dividend0.3615830000["tiingo"]{"tiingo":"0.361583"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2023-03-20cash_dividend0.3154520000["tiingo"]{"tiingo":"0.315452"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2022-12-19cash_dividend0.3653640000["tiingo"]{"tiingo":"0.365364"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2022-09-19cash_dividend0.3166660000["tiingo"]{"tiingo":"0.316666"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2022-06-21cash_dividend0.3231670000["tiingo"]{"tiingo":"0.323167"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2022-03-21cash_dividend0.2856190000["tiingo"]{"tiingo":"0.285619"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2021-12-20cash_dividend0.3165440000["tiingo"]{"tiingo":"0.316544"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2021-09-20cash_dividend0.2728620000["tiingo"]{"tiingo":"0.272862"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2021-06-21cash_dividend0.2594910000["tiingo"]{"tiingo":"0.259491"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2021-03-22cash_dividend0.2731490000["tiingo"]{"tiingo":"0.273149"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2020-12-21cash_dividend0.2976420000["tiingo"]{"tiingo":"0.297642"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2020-09-21cash_dividend0.2465260000["tiingo"]{"tiingo":"0.246526"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2020-06-22cash_dividend0.2805170000["tiingo"]{"tiingo":"0.280517"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2020-03-23cash_dividend0.3714820000["tiingo"]{"tiingo":"0.371482"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2019-12-20cash_dividend0.2950000000["tiingo"]{"tiingo":"0.295"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2019-09-20cash_dividend0.2527030000["tiingo"]{"tiingo":"0.252703"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2019-06-21cash_dividend0.2783000000["tiingo"]{"tiingo":"0.2783"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2019-03-15cash_dividend0.2334000000["tiingo"]{"tiingo":"0.2334"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2018-12-21cash_dividend0.2651000000["tiingo"]{"tiingo":"0.2651"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2018-09-21cash_dividend0.2544000000["tiingo"]{"tiingo":"0.2544"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2018-06-15cash_dividend0.2553000000["tiingo"]{"tiingo":"0.2553"}tiingo_prices/tiingo/daily/XLK/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLK2018-03-16cash_dividend0.2177470000["tiingo"]{"tiingo":"0.217747"}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
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-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-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
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
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-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-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
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
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-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-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
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
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-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