core.corporate_actions
Splits, cash dividends and price factors. The second half of the PIT price spine - these are what core.prices_asof() applies.
Simplify Analyticstiingo_prices3,264 rowsexportableex_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.
| symboltext | ex_date ↑date | action_typetext | ratio_rawnumeric | ratio_numbigint | ratio_denbigint | div_cashnumeric | vendorsARRAY | vendor_valuesjsonb | source |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| SPY | 1993-03-19 | cash_dividend | — | — | — | 0.2131910000 | ["tiingo"] | {"tiingo":"0.213191"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1993-06-18 | cash_dividend | — | — | — | 0.3180200000 | ["tiingo"] | {"tiingo":"0.31802"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1993-09-17 | cash_dividend | — | — | — | 0.2861870000 | ["tiingo"] | {"tiingo":"0.286187"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1993-12-17 | cash_dividend | — | — | — | 0.2872390000 | ["tiingo"] | {"tiingo":"0.287239"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1994-03-18 | cash_dividend | — | — | — | 0.2711770000 | ["tiingo"] | {"tiingo":"0.271177"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1994-06-17 | cash_dividend | — | — | — | 0.3049760000 | ["tiingo"] | {"tiingo":"0.304976"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1994-09-16 | cash_dividend | — | — | — | 0.2881800000 | ["tiingo"] | {"tiingo":"0.28818"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1994-12-16 | cash_dividend | — | — | — | 0.3627300000 | ["tiingo"] | {"tiingo":"0.36273"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1995-03-17 | cash_dividend | — | — | — | 0.2682200000 | ["tiingo"] | {"tiingo":"0.26822"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1995-06-16 | cash_dividend | — | — | — | 0.3162100000 | ["tiingo"] | {"tiingo":"0.31621"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1995-09-15 | cash_dividend | — | — | — | 0.3122600000 | ["tiingo"] | {"tiingo":"0.31226"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1995-12-15 | cash_dividend | — | — | — | 0.3720000000 | ["tiingo"] | {"tiingo":"0.372"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1996-03-15 | cash_dividend | — | — | — | 0.2854500000 | ["tiingo"] | {"tiingo":"0.28545"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1996-06-21 | cash_dividend | — | — | — | 0.3509400000 | ["tiingo"] | {"tiingo":"0.35094"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1996-09-20 | cash_dividend | — | — | — | 0.3519400000 | ["tiingo"] | {"tiingo":"0.35194"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1996-12-20 | cash_dividend | — | — | — | 0.4068100000 | ["tiingo"] | {"tiingo":"0.40681"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1997-03-21 | cash_dividend | — | — | — | 0.2992580000 | ["tiingo"] | {"tiingo":"0.299258"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1997-06-20 | cash_dividend | — | — | — | 0.3499530000 | ["tiingo"] | {"tiingo":"0.349953"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1997-09-19 | cash_dividend | — | — | — | 0.3483550000 | ["tiingo"] | {"tiingo":"0.348355"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1997-12-19 | cash_dividend | — | — | — | 0.3795040000 | ["tiingo"] | {"tiingo":"0.379504"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1998-03-20 | cash_dividend | — | — | — | 0.3134210000 | ["tiingo"] | {"tiingo":"0.313421"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1998-06-19 | cash_dividend | — | — | — | 0.3520100000 | ["tiingo"] | {"tiingo":"0.35201"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1998-09-18 | cash_dividend | — | — | — | 0.3585300000 | ["tiingo"] | {"tiingo":"0.35853"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1998-12-18 | cash_dividend | — | — | — | 0.3918230000 | ["tiingo"] | {"tiingo":"0.391823"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1999-03-19 | cash_dividend | — | — | — | 0.3198530000 | ["tiingo"] | {"tiingo":"0.319853"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1999-06-18 | cash_dividend | — | — | — | 0.4049700000 | ["tiingo"] | {"tiingo":"0.40497"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1999-09-17 | cash_dividend | — | — | — | 0.3722180000 | ["tiingo"] | {"tiingo":"0.372218"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 1999-12-17 | cash_dividend | — | — | — | 0.3475520000 | ["tiingo"] | {"tiingo":"0.347552"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2000-03-17 | cash_dividend | — | — | — | 0.3708230000 | ["tiingo"] | {"tiingo":"0.370823"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2000-06-16 | cash_dividend | — | — | — | 0.3484080000 | ["tiingo"] | {"tiingo":"0.348408"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2000-09-15 | cash_dividend | — | — | — | 0.3753190000 | ["tiingo"] | {"tiingo":"0.375319"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2000-12-15 | cash_dividend | — | — | — | 0.4113300000 | ["tiingo"] | {"tiingo":"0.41133"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2001-03-16 | cash_dividend | — | — | — | 0.3155100000 | ["tiingo"] | {"tiingo":"0.31551"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2001-06-15 | cash_dividend | — | — | — | 0.3464400000 | ["tiingo"] | {"tiingo":"0.34644"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2001-09-21 | cash_dividend | — | — | — | 0.3690000000 | ["tiingo"] | {"tiingo":"0.369"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2001-12-21 | cash_dividend | — | — | — | 0.3927700000 | ["tiingo"] | {"tiingo":"0.39277"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2002-03-15 | cash_dividend | — | — | — | 0.3309800000 | ["tiingo"] | {"tiingo":"0.33098"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2002-06-21 | cash_dividend | — | — | — | 0.3533700000 | ["tiingo"] | {"tiingo":"0.35337"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2002-09-20 | cash_dividend | — | — | — | 0.3781000000 | ["tiingo"] | {"tiingo":"0.3781"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2002-12-20 | cash_dividend | — | — | — | 0.4358400000 | ["tiingo"] | {"tiingo":"0.43584"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2003-03-21 | cash_dividend | — | — | — | 0.3543800000 | ["tiingo"] | {"tiingo":"0.35438"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2003-06-20 | cash_dividend | — | — | — | 0.3602500000 | ["tiingo"] | {"tiingo":"0.36025"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2003-09-19 | cash_dividend | — | — | — | 0.4000600000 | ["tiingo"] | {"tiingo":"0.40006"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2003-12-19 | cash_dividend | — | — | — | 0.5155900000 | ["tiingo"] | {"tiingo":"0.51559"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2004-03-19 | cash_dividend | — | — | — | 0.3947600000 | ["tiingo"] | {"tiingo":"0.39476"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2004-06-18 | cash_dividend | — | — | — | 0.4137600000 | ["tiingo"] | {"tiingo":"0.41376"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2004-09-17 | cash_dividend | — | — | — | 0.4687800000 | ["tiingo"] | {"tiingo":"0.46878"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2004-11-15 | cash_dividend | — | — | — | 0.3510200000 | ["tiingo"] | {"tiingo":"0.35102"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2004-12-17 | cash_dividend | — | — | — | 0.5678900000 | ["tiingo"] | {"tiingo":"0.56789"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2005-03-18 | cash_dividend | — | — | — | 0.4670900000 | ["tiingo"] | {"tiingo":"0.46709"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |