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

Sources in this table

ex_dateto
column equals (exact text)
sort
chart against ex_date
reset

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
SPY2026-09-18cash_dividend1.8888340000["tiingo"]{"tiingo":"1.888834"}tiingo_prices/tiingo/daily/SPY/prices{}2026-09-182026-09-18 18:052026-09-18 18:05
DIA2026-09-18cash_dividend1.1924200000["tiingo"]{"tiingo":"1.19242"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-182026-09-18 18:052026-09-18 18:05
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
IWM2026-09-15cash_dividend0.7504360000["tiingo"]{"tiingo":"0.750436"}tiingo_prices/tiingo/daily/IWM/prices{}2026-09-152026-09-15 17:302026-09-15 17:30
NVDA2026-09-10cash_dividend0.2500000000["tiingo"]{"tiingo":"0.25"}tiingo_prices/tiingo/daily/NVDA/prices{}2026-09-102026-09-10 17:302026-09-10 17:30
WDC2026-09-08cash_dividend0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/WDC/prices{}2026-09-082026-09-08 21:562026-09-08 21:56
GOOG2026-09-04cash_dividend0.2200000000["tiingo"]{"tiingo":"0.22"}tiingo_prices/tiingo/daily/GOOG/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
LMT2026-09-01cash_dividend3.4500000000["tiingo"]{"tiingo":"3.45"}tiingo_prices/tiingo/daily/LMT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
DIA2026-08-21cash_dividend0.4370200000["tiingo"]{"tiingo":"0.43702"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
MSFT2026-08-20cash_dividend0.9100000000["tiingo"]{"tiingo":"0.91"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
XOM2026-08-17cash_dividend1.0300000000["tiingo"]{"tiingo":"1.03"}tiingo_prices/tiingo/daily/XOM/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
AAPL2026-08-10cash_dividend0.2700000000["tiingo"]{"tiingo":"0.27"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
DELL2026-07-21cash_dividend0.6300000000["tiingo"]{"tiingo":"0.63"}tiingo_prices/tiingo/daily/DELL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2026-07-20cash_dividend1.6300000000["tiingo"]{"tiingo":"1.63"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
DIA2026-07-17cash_dividend0.1486600000["tiingo"]{"tiingo":"0.14866"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
ORCL2026-07-10cash_dividend0.5000000000["tiingo"]{"tiingo":"0.5"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MRVL2026-07-10cash_dividend0.0600000000["tiingo"]{"tiingo":"0.06"}tiingo_prices/tiingo/daily/MRVL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MU2026-07-06cash_dividend0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/MU/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CRWD2026-07-02split4.00000000000000041["tiingo","yfinance"]{"tiingo":"4.0","yfinance":"4.0"}tiingo_prices/tiingo/daily/CRWD/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
DE2026-06-30cash_dividend1.6200000000["tiingo"]{"tiingo":"1.62"}tiingo_prices/tiingo/daily/DE/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
STX2026-06-24cash_dividend0.7400000000["tiingo"]{"tiingo":"0.74"}tiingo_prices/tiingo/daily/STX/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLY2026-06-22cash_dividend0.2332200000["tiingo"]{"tiingo":"0.23322"}tiingo_prices/tiingo/daily/XLY/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLV2026-06-22cash_dividend0.6562520000["tiingo"]{"tiingo":"0.656252"}tiingo_prices/tiingo/daily/XLV/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLU2026-06-22cash_dividend0.2844150000["tiingo"]{"tiingo":"0.284415"}tiingo_prices/tiingo/daily/XLU/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLP2026-06-22cash_dividend0.5741880000["tiingo"]{"tiingo":"0.574188"}tiingo_prices/tiingo/daily/XLP/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
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
XLI2026-06-22cash_dividend0.4440940000["tiingo"]{"tiingo":"0.444094"}tiingo_prices/tiingo/daily/XLI/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLF2026-06-22cash_dividend0.1870830000["tiingo"]{"tiingo":"0.187083"}tiingo_prices/tiingo/daily/XLF/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
XLE2026-06-22cash_dividend0.3848760000["tiingo"]{"tiingo":"0.384876"}tiingo_prices/tiingo/daily/XLE/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
QQQ2026-06-22cash_dividend0.8134900000["tiingo"]{"tiingo":"0.81349"}tiingo_prices/tiingo/daily/QQQ/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
AVGO2026-06-22cash_dividend0.6500000000["tiingo"]{"tiingo":"0.65"}tiingo_prices/tiingo/daily/AVGO/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
SPY2026-06-18cash_dividend1.9035160000["tiingo"]{"tiingo":"1.903516"}tiingo_prices/tiingo/daily/SPY/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2026-06-18cash_dividend1.4054200000["tiingo"]{"tiingo":"1.40542"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13: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
META2026-06-15cash_dividend0.5250000000["tiingo"]{"tiingo":"0.525"}tiingo_prices/tiingo/daily/META/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
IWM2026-06-15cash_dividend0.6951290000["tiingo"]{"tiingo":"0.695129"}tiingo_prices/tiingo/daily/IWM/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
GOOG2026-06-08cash_dividend0.2200000000["tiingo"]{"tiingo":"0.22"}tiingo_prices/tiingo/daily/GOOG/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
WDC2026-06-05cash_dividend0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/WDC/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
NVDA2026-06-04cash_dividend0.2500000000["tiingo"]{"tiingo":"0.25"}tiingo_prices/tiingo/daily/NVDA/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
LMT2026-06-01cash_dividend3.4500000000["tiingo"]{"tiingo":"3.45"}tiingo_prices/tiingo/daily/LMT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2026-05-21cash_dividend0.9100000000["tiingo"]{"tiingo":"0.91"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
XOM2026-05-15cash_dividend1.0300000000["tiingo"]{"tiingo":"1.03"}tiingo_prices/tiingo/daily/XOM/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
DIA2026-05-15cash_dividend0.2755900000["tiingo"]{"tiingo":"0.27559"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
AAPL2026-05-11cash_dividend0.2700000000["tiingo"]{"tiingo":"0.27"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
DELL2026-04-21cash_dividend0.6300000000["tiingo"]{"tiingo":"0.63"}tiingo_prices/tiingo/daily/DELL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2026-04-20cash_dividend1.5100000000["tiingo"]{"tiingo":"1.51"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
DIA2026-04-17cash_dividend0.2062400000["tiingo"]{"tiingo":"0.20624"}tiingo_prices/tiingo/daily/DIA/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
MRVL2026-04-10cash_dividend0.0600000000["tiingo"]{"tiingo":"0.06"}tiingo_prices/tiingo/daily/MRVL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2026-04-09cash_dividend0.5000000000["tiingo"]{"tiingo":"0.5"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
DE2026-03-31cash_dividend1.6200000000["tiingo"]{"tiingo":"1.62"}tiingo_prices/tiingo/daily/DE/prices{}2026-09-072026-09-07 13:292026-09-07 13:29