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
tiingo_prices3,253 rowsexportable
active:endpoint = /tiingo/daily/SPY/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.
| symboltext | ex_date ↓date | action_typetext | ratio_rawnumeric | ratio_numbigint | ratio_denbigint | div_cashnumeric | vendorsARRAY | vendor_valuesjsonb | sourcetext | endpointtext | request_paramsjsonb | as_ofdate | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SPY | 2026-09-18 | cash_dividend | — | — | — | 1.8888340000 | ["tiingo"] | {"tiingo":"1.888834"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-18 | 2026-09-18 18:05 | 2026-09-18 18:05 |
| SPY | 2026-06-18 | cash_dividend | — | — | — | 1.9035160000 | ["tiingo"] | {"tiingo":"1.903516"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2026-03-20 | cash_dividend | — | — | — | 1.7969990000 | ["tiingo"] | {"tiingo":"1.796999"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2025-12-19 | cash_dividend | — | — | — | 1.9933680000 | ["tiingo"] | {"tiingo":"1.993368"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2025-09-19 | cash_dividend | — | — | — | 1.8311140000 | ["tiingo"] | {"tiingo":"1.831114"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2025-06-20 | cash_dividend | — | — | — | 1.7611170000 | ["tiingo"] | {"tiingo":"1.761117"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2025-03-21 | cash_dividend | — | — | — | 1.6955280000 | ["tiingo"] | {"tiingo":"1.695528"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2024-12-20 | cash_dividend | — | — | — | 1.9655480000 | ["tiingo"] | {"tiingo":"1.965548"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2024-09-20 | cash_dividend | — | — | — | 1.7455310000 | ["tiingo"] | {"tiingo":"1.745531"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2024-06-21 | cash_dividend | — | — | — | 1.7590240000 | ["tiingo"] | {"tiingo":"1.759024"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2024-03-15 | cash_dividend | — | — | — | 1.5949370000 | ["tiingo"] | {"tiingo":"1.594937"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2023-12-15 | cash_dividend | — | — | — | 1.9060730000 | ["tiingo"] | {"tiingo":"1.906073"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2023-09-15 | cash_dividend | — | — | — | 1.5831690000 | ["tiingo"] | {"tiingo":"1.583169"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2023-06-16 | cash_dividend | — | — | — | 1.6383670000 | ["tiingo"] | {"tiingo":"1.638367"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2023-03-17 | cash_dividend | — | — | — | 1.5062040000 | ["tiingo"] | {"tiingo":"1.506204"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2022-12-16 | cash_dividend | — | — | — | 1.7814000000 | ["tiingo"] | {"tiingo":"1.7814"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2022-09-16 | cash_dividend | — | — | — | 1.5963980000 | ["tiingo"] | {"tiingo":"1.596398"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2022-06-17 | cash_dividend | — | — | — | 1.5768710000 | ["tiingo"] | {"tiingo":"1.576871"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2022-03-18 | cash_dividend | — | — | — | 1.3660090000 | ["tiingo"] | {"tiingo":"1.366009"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2021-12-17 | cash_dividend | — | — | — | 1.6334850000 | ["tiingo"] | {"tiingo":"1.633485"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2021-09-17 | cash_dividend | — | — | — | 1.4281170000 | ["tiingo"] | {"tiingo":"1.428117"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2021-06-18 | cash_dividend | — | — | — | 1.3758750000 | ["tiingo"] | {"tiingo":"1.375875"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2021-03-19 | cash_dividend | — | — | — | 1.2777880000 | ["tiingo"] | {"tiingo":"1.277788"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2020-12-18 | cash_dividend | — | — | — | 1.5800000000 | ["tiingo"] | {"tiingo":"1.58"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2020-09-18 | cash_dividend | — | — | — | 1.3392240000 | ["tiingo"] | {"tiingo":"1.339224"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2020-06-19 | cash_dividend | — | — | — | 1.3662420000 | ["tiingo"] | {"tiingo":"1.366242"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2020-03-20 | cash_dividend | — | — | — | 1.4055590000 | ["tiingo"] | {"tiingo":"1.405559"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2019-12-20 | cash_dividend | — | — | — | 1.5700000000 | ["tiingo"] | {"tiingo":"1.57"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2019-09-20 | cash_dividend | — | — | — | 1.3836190000 | ["tiingo"] | {"tiingo":"1.383619"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2019-06-21 | cash_dividend | — | — | — | 1.4316000000 | ["tiingo"] | {"tiingo":"1.4316"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2019-03-15 | cash_dividend | — | — | — | 1.2331000000 | ["tiingo"] | {"tiingo":"1.2331"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2018-12-21 | cash_dividend | — | — | — | 1.4354000000 | ["tiingo"] | {"tiingo":"1.4354"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2018-09-21 | cash_dividend | — | — | — | 1.3226000000 | ["tiingo"] | {"tiingo":"1.3226"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2018-06-15 | cash_dividend | — | — | — | 1.2456000000 | ["tiingo"] | {"tiingo":"1.2456"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2018-03-16 | cash_dividend | — | — | — | 1.0967800000 | ["tiingo"] | {"tiingo":"1.09678"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2017-12-15 | cash_dividend | — | — | — | 1.3513330000 | ["tiingo"] | {"tiingo":"1.351333"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2017-09-15 | cash_dividend | — | — | — | 1.2345740000 | ["tiingo"] | {"tiingo":"1.234574"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2017-06-16 | cash_dividend | — | — | — | 1.1831080000 | ["tiingo"] | {"tiingo":"1.183108"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2017-03-17 | cash_dividend | — | — | — | 1.0331180000 | ["tiingo"] | {"tiingo":"1.033118"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2016-12-16 | cash_dividend | — | — | — | 1.3289300000 | ["tiingo"] | {"tiingo":"1.32893"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2016-09-16 | cash_dividend | — | — | — | 1.0820680000 | ["tiingo"] | {"tiingo":"1.082068"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2016-06-17 | cash_dividend | — | — | — | 1.0784420000 | ["tiingo"] | {"tiingo":"1.078442"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2016-03-18 | cash_dividend | — | — | — | 1.0496040000 | ["tiingo"] | {"tiingo":"1.049604"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2015-12-18 | cash_dividend | — | — | — | 1.2115500000 | ["tiingo"] | {"tiingo":"1.21155"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2015-09-18 | cash_dividend | — | — | — | 1.0334300000 | ["tiingo"] | {"tiingo":"1.03343"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2015-06-19 | cash_dividend | — | — | — | 1.0300700000 | ["tiingo"] | {"tiingo":"1.03007"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2015-03-20 | cash_dividend | — | — | — | 0.9308100000 | ["tiingo"] | {"tiingo":"0.93081"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2014-12-19 | cash_dividend | — | — | — | 1.1349200000 | ["tiingo"] | {"tiingo":"1.13492"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2014-09-19 | cash_dividend | — | — | — | 0.9391900000 | ["tiingo"] | {"tiingo":"0.93919"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SPY | 2014-06-20 | cash_dividend | — | — | — | 0.9366900000 | ["tiingo"] | {"tiingo":"0.93669"} | tiingo_prices | /tiingo/daily/SPY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |