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 |
|---|
| QQQ | 2000-03-20 | split | 2.000000000000000 | 2 | 1 | — | ["tiingo","yfinance"] | {"tiingo":"2.0","yfinance":"2.0"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2003-12-24 | cash_dividend | — | — | — | 0.0135800000 | ["tiingo"] | {"tiingo":"0.01358"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2004-12-17 | cash_dividend | — | — | — | 0.3785800000 | ["tiingo"] | {"tiingo":"0.37858"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2005-06-17 | cash_dividend | — | — | — | 0.0347600000 | ["tiingo"] | {"tiingo":"0.03476"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2005-12-16 | cash_dividend | — | — | — | 0.1011000000 | ["tiingo"] | {"tiingo":"0.1011"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2006-03-17 | cash_dividend | — | — | — | 0.0291000000 | ["tiingo"] | {"tiingo":"0.0291"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2006-06-16 | cash_dividend | — | — | — | 0.0257000000 | ["tiingo"] | {"tiingo":"0.0257"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2006-09-15 | cash_dividend | — | — | — | 0.0234000000 | ["tiingo"] | {"tiingo":"0.0234"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2006-12-15 | cash_dividend | — | — | — | 0.0544900000 | ["tiingo"] | {"tiingo":"0.05449"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2007-03-16 | cash_dividend | — | — | — | 0.0267000000 | ["tiingo"] | {"tiingo":"0.0267"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2007-06-15 | cash_dividend | — | — | — | 0.0369300000 | ["tiingo"] | {"tiingo":"0.03693"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2007-09-21 | cash_dividend | — | — | — | 0.0260000000 | ["tiingo"] | {"tiingo":"0.026"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2007-12-21 | cash_dividend | — | — | — | 0.0533100000 | ["tiingo"] | {"tiingo":"0.05331"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2008-03-20 | cash_dividend | — | — | — | 0.0325200000 | ["tiingo"] | {"tiingo":"0.03252"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2008-06-20 | cash_dividend | — | — | — | 0.0344100000 | ["tiingo"] | {"tiingo":"0.03441"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2008-09-19 | cash_dividend | — | — | — | 0.0280700000 | ["tiingo"] | {"tiingo":"0.02807"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2008-12-19 | cash_dividend | — | — | — | 0.0434600000 | ["tiingo"] | {"tiingo":"0.04346"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2009-03-20 | cash_dividend | — | — | — | 0.0488800000 | ["tiingo"] | {"tiingo":"0.04888"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2009-06-19 | cash_dividend | — | — | — | 0.0439400000 | ["tiingo"] | {"tiingo":"0.04394"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2009-09-18 | cash_dividend | — | — | — | 0.0407600000 | ["tiingo"] | {"tiingo":"0.04076"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2009-12-18 | cash_dividend | — | — | — | 0.0776000000 | ["tiingo"] | {"tiingo":"0.0776"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2010-03-19 | cash_dividend | — | — | — | 0.0514600000 | ["tiingo"] | {"tiingo":"0.05146"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2010-06-18 | cash_dividend | — | — | — | 0.0893000000 | ["tiingo"] | {"tiingo":"0.0893"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2010-09-17 | cash_dividend | — | — | — | 0.1115500000 | ["tiingo"] | {"tiingo":"0.11155"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2010-12-17 | cash_dividend | — | — | — | 0.1083200000 | ["tiingo"] | {"tiingo":"0.10832"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2011-03-18 | cash_dividend | — | — | — | 0.0768700000 | ["tiingo"] | {"tiingo":"0.07687"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2011-06-17 | cash_dividend | — | — | — | 0.1207900000 | ["tiingo"] | {"tiingo":"0.12079"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2011-09-16 | cash_dividend | — | — | — | 0.1043400000 | ["tiingo"] | {"tiingo":"0.10434"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2011-12-16 | cash_dividend | — | — | — | 0.1605200000 | ["tiingo"] | {"tiingo":"0.16052"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2012-03-16 | cash_dividend | — | — | — | 0.1128300000 | ["tiingo"] | {"tiingo":"0.11283"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2012-06-15 | cash_dividend | — | — | — | 0.1431200000 | ["tiingo"] | {"tiingo":"0.14312"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2012-09-21 | cash_dividend | — | — | — | 0.2002000000 | ["tiingo"] | {"tiingo":"0.2002"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2012-12-21 | cash_dividend | — | — | — | 0.3666300000 | ["tiingo"] | {"tiingo":"0.36663"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2013-03-15 | cash_dividend | — | — | — | 0.1593100000 | ["tiingo"] | {"tiingo":"0.15931"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2013-06-21 | cash_dividend | — | — | — | 0.2236100000 | ["tiingo"] | {"tiingo":"0.22361"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2013-09-20 | cash_dividend | — | — | — | 0.2377100000 | ["tiingo"] | {"tiingo":"0.23771"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2013-12-20 | cash_dividend | — | — | — | 0.2724100000 | ["tiingo"] | {"tiingo":"0.27241"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2014-02-27 | cash_dividend | — | — | — | 0.3731300000 | ["tiingo"] | {"tiingo":"0.37313"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2014-03-21 | cash_dividend | — | — | — | 0.2060600000 | ["tiingo"] | {"tiingo":"0.20606"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2014-06-20 | cash_dividend | — | — | — | 0.2491000000 | ["tiingo"] | {"tiingo":"0.2491"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2014-09-19 | cash_dividend | — | — | — | 0.2378000000 | ["tiingo"] | {"tiingo":"0.2378"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2014-12-19 | cash_dividend | — | — | — | 0.3868100000 | ["tiingo"] | {"tiingo":"0.38681"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2015-03-20 | cash_dividend | — | — | — | 0.2480600000 | ["tiingo"] | {"tiingo":"0.24806"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2015-06-19 | cash_dividend | — | — | — | 0.2541600000 | ["tiingo"] | {"tiingo":"0.25416"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2015-09-18 | cash_dividend | — | — | — | 0.2600200000 | ["tiingo"] | {"tiingo":"0.26002"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2015-12-18 | cash_dividend | — | — | — | 0.3423300000 | ["tiingo"] | {"tiingo":"0.34233"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2016-03-18 | cash_dividend | — | — | — | 0.3178000000 | ["tiingo"] | {"tiingo":"0.3178"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2016-06-17 | cash_dividend | — | — | — | 0.2866500000 | ["tiingo"] | {"tiingo":"0.28665"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2016-09-16 | cash_dividend | — | — | — | 0.2938700000 | ["tiingo"] | {"tiingo":"0.29387"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| QQQ | 2016-12-16 | cash_dividend | — | — | — | 0.3549400000 | ["tiingo"] | {"tiingo":"0.35494"} | tiingo_prices | /tiingo/daily/QQQ/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |