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/SOXX/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
SOXX2026-09-15cash_dividend0.3250460000["tiingo"]{"tiingo":"0.325046"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-152026-09-15 17:302026-09-15 17:30
SOXX2026-06-15cash_dividend0.2827260000["tiingo"]{"tiingo":"0.282726"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2026-03-17cash_dividend0.2079440000["tiingo"]{"tiingo":"0.207944"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2025-12-16cash_dividend0.4362720000["tiingo"]{"tiingo":"0.436272"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2025-09-16cash_dividend0.5407480000["tiingo"]{"tiingo":"0.540748"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2025-06-16cash_dividend0.4832760000["tiingo"]{"tiingo":"0.483276"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2025-03-18cash_dividend0.2611150000["tiingo"]{"tiingo":"0.261115"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2024-12-17cash_dividend0.3578300000["tiingo"]{"tiingo":"0.35783"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2024-09-25cash_dividend0.5523800000["tiingo"]{"tiingo":"0.55238"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2024-06-11cash_dividend0.3103260000["tiingo"]{"tiingo":"0.310326"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2024-03-21cash_dividend0.2249470000["tiingo"]{"tiingo":"0.224947"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2024-03-07split3.00000000000000031["tiingo","yfinance"]{"tiingo":"3.0","yfinance":"3.0"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2023-12-20cash_dividend1.1232820000["tiingo"]{"tiingo":"1.123282"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2023-09-26cash_dividend1.6657560000["tiingo"]{"tiingo":"1.665756"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2023-06-07cash_dividend0.6507090000["tiingo"]{"tiingo":"0.650709"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2023-03-23cash_dividend1.0724100000["tiingo"]{"tiingo":"1.07241"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2022-12-13cash_dividend1.0623750000["tiingo"]{"tiingo":"1.062375"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2022-09-26cash_dividend1.8018100000["tiingo"]{"tiingo":"1.80181"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2022-06-09cash_dividend0.6279650000["tiingo"]{"tiingo":"0.627965"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2022-03-24cash_dividend0.8751710000["tiingo"]{"tiingo":"0.875171"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2021-12-30cash_dividend0.1545490000["tiingo"]{"tiingo":"0.154549"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2021-12-13cash_dividend0.8731790000["tiingo"]{"tiingo":"0.873179"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2021-09-24cash_dividend1.1567080000["tiingo"]{"tiingo":"1.156708"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2021-06-10cash_dividend0.5121760000["tiingo"]{"tiingo":"0.512176"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2021-03-25cash_dividend0.7556640000["tiingo"]{"tiingo":"0.755664"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2020-12-14cash_dividend0.7468910000["tiingo"]{"tiingo":"0.746891"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2020-09-23cash_dividend1.0693140000["tiingo"]{"tiingo":"1.069314"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2020-06-15cash_dividend0.5628720000["tiingo"]{"tiingo":"0.562872"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2020-03-25cash_dividend0.6956510000["tiingo"]{"tiingo":"0.695651"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2019-12-16cash_dividend0.8615310000["tiingo"]{"tiingo":"0.861531"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2019-09-24cash_dividend0.9600970000["tiingo"]{"tiingo":"0.960097"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2019-06-17cash_dividend0.7573230000["tiingo"]{"tiingo":"0.757323"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2019-03-20cash_dividend0.5196100000["tiingo"]{"tiingo":"0.51961"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2018-12-17cash_dividend0.3389920000["tiingo"]{"tiingo":"0.338992"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2018-09-26cash_dividend0.8165410000["tiingo"]{"tiingo":"0.816541"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2018-06-26cash_dividend0.6203600000["tiingo"]{"tiingo":"0.62036"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2018-03-22cash_dividend0.3753920000["tiingo"]{"tiingo":"0.375392"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2017-12-19cash_dividend0.3166860000["tiingo"]{"tiingo":"0.316686"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2017-09-26cash_dividend0.4985270000["tiingo"]{"tiingo":"0.498527"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2017-06-27cash_dividend0.3597530000["tiingo"]{"tiingo":"0.359753"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2017-03-24cash_dividend0.3531670000["tiingo"]{"tiingo":"0.353167"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2016-12-21cash_dividend0.2898690000["tiingo"]{"tiingo":"0.289869"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2016-09-26cash_dividend0.4568830000["tiingo"]{"tiingo":"0.456883"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2016-06-21cash_dividend0.2987970000["tiingo"]{"tiingo":"0.298797"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2016-03-23cash_dividend0.2760380000["tiingo"]{"tiingo":"0.276038"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2015-12-24cash_dividend0.1933430000["tiingo"]{"tiingo":"0.193343"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2015-09-25cash_dividend0.4476530000["tiingo"]{"tiingo":"0.447653"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2015-06-24cash_dividend0.2546450000["tiingo"]{"tiingo":"0.254645"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2015-03-25cash_dividend0.2591550000["tiingo"]{"tiingo":"0.259155"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SOXX2014-12-24cash_dividend0.7611410000["tiingo"]{"tiingo":"0.761141"}tiingo_prices/tiingo/daily/SOXX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30