{"id":187,"date":"2023-05-23T11:57:16","date_gmt":"2023-05-23T15:57:16","guid":{"rendered":"https:\/\/api.tiingo.com\/kb\/?post_type=ht_kb&p=187"},"modified":"2023-05-23T11:59:15","modified_gmt":"2023-05-23T15:59:15","slug":"the-fastest-method-to-ingest-tiingo-end-of-day-stock-api-data","status":"publish","type":"ht_kb","link":"https:\/\/www.tiingo.com\/kb\/article\/the-fastest-method-to-ingest-tiingo-end-of-day-stock-api-data\/","title":{"rendered":"The Fastest Method to Ingest Tiingo End-of-Day Stock API Data"},"content":{"rendered":"
\n
\"Tiingo<\/figure>\n<\/div>\n\n\n

Introduction<\/h2>\n\n\n\n

This post discusses the fastest method to ingest Tiingo End-of-Day Stock API data<\/a>. This will allow you to keep your database up-to-date in the fastest, and most efficient way that will also protect your Tiingo API usage limits.<\/p>\n\n\n\n

Steps to keep your data up to date<\/h2>\n\n\n\n

For the fastest update of Tiingo End-of-Day (EOD)<\/a> data, we recommend the following workflow.<\/p>\n\n\n\n

1. Cycle through the tickers you need with our historical prices endpoint. E.g. https:\/\/api.tiingo.com\/tiingo\/daily\/aapl\/prices?startDate=1960-1-1<\/a><\/p>\n\n\n\n

2. Once you have this data cached, you can query https:\/\/api.tiingo.com\/tiingo\/daily\/prices<\/a> to get the latest price values for the current day. If splitFactor != 1 or divCash > 0, then we recommend redownloading the entire price history from step 1 above. This is to ensure you get the latest adjusted prices.<\/p>\n\n\n\n

This workflow means you only have to cycle through ticker histories once, and then you can use the delta to make minimal queries to keep your database up to date.<\/p>\n\n\n\n

Conclusion and further optimizations<\/h2>\n\n\n\n

With these two steps, you can can minimize data requests. If you want further optimizations we recommend appending &format=csv to the queries above. This will allow for quicker downloads since file sizes will be lower. This concludes the fastest method to ingest Tiingo End-of-Day Stock API data and keep your data up-to-date!<\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction This post discusses the fastest method to ingest Tiingo End-of-Day Stock API data. This will allow you to keep your database up-to-date in the fastest, and most efficient way that will also protect your Tiingo API usage limits. Steps to keep your data up to date For the fastest…<\/p>\n","protected":false},"author":1,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"ht-kb-category":[22,6],"ht-kb-tag":[],"class_list":["post-187","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-tiingo-api-best-practices","ht_kb_category-tiingo-api"],"yoast_head":"\nThe Fastest Method to Ingest Tiingo End-of-Day Stock API Data - Tiingo Knowledge Base<\/title>\n<meta name=\"description\" content=\"This post discusses the fastest method to ingest Tiingo End-of-Day Stock API data. In just two steps, you can keep your data up to date!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.tiingo.com\/kb\/article\/the-fastest-method-to-ingest-tiingo-end-of-day-stock-api-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Fastest Method to Ingest Tiingo End-of-Day Stock API Data\" \/>\n<meta property=\"og:description\" content=\"This post discusses the fastest method to ingest Tiingo End-of-Day Stock API data. In just two steps, you can keep your data up to date!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.tiingo.com\/kb\/article\/the-fastest-method-to-ingest-tiingo-end-of-day-stock-api-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Tiingo Knowledge Base\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/tiingofinance\/\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-23T15:59:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/api.tiingo.com\/kb\/wp-content\/uploads\/2023\/05\/Clean-Data-1024x1024.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@tiingofinance\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tiingo.com\/kb\/article\/the-fastest-method-to-ingest-tiingo-end-of-day-stock-api-data\/\",\"url\":\"https:\/\/www.tiingo.com\/kb\/article\/the-fastest-method-to-ingest-tiingo-end-of-day-stock-api-data\/\",\"name\":\"The Fastest Method to Ingest Tiingo End-of-Day Stock API Data - Tiingo Knowledge Base\",\"isPartOf\":{\"@id\":\"\/#website\"},\"datePublished\":\"2023-05-23T15:57:16+00:00\",\"dateModified\":\"2023-05-23T15:59:15+00:00\",\"description\":\"This post discusses the fastest method to ingest Tiingo End-of-Day Stock API data. In just two steps, you can keep your data up to date!\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.tiingo.com\/kb\/article\/the-fastest-method-to-ingest-tiingo-end-of-day-stock-api-data\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"\/#website\",\"url\":\"\/\",\"name\":\"Tiingo Knowledge Base\",\"description\":\"\",\"publisher\":{\"@id\":\"\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"\/#organization\",\"name\":\"Tiingo.com\",\"url\":\"\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.tiingo.com\/kb\/wp-content\/uploads\/2023\/05\/purple-for-light-bg.svg\",\"contentUrl\":\"https:\/\/www.tiingo.com\/kb\/wp-content\/uploads\/2023\/05\/purple-for-light-bg.svg\",\"width\":\"1024\",\"height\":\"1024\",\"caption\":\"Tiingo.com\"},\"image\":{\"@id\":\"\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/tiingofinance\/\",\"https:\/\/twitter.com\/tiingofinance\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"The Fastest Method to Ingest Tiingo End-of-Day Stock API Data - Tiingo Knowledge Base","description":"This post discusses the fastest method to ingest Tiingo End-of-Day Stock API data. In just two steps, you can keep your data up to date!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.tiingo.com\/kb\/article\/the-fastest-method-to-ingest-tiingo-end-of-day-stock-api-data\/","og_locale":"en_US","og_type":"article","og_title":"The Fastest Method to Ingest Tiingo End-of-Day Stock API Data","og_description":"This post discusses the fastest method to ingest Tiingo End-of-Day Stock API data. In just two steps, you can keep your data up to date!","og_url":"https:\/\/www.tiingo.com\/kb\/article\/the-fastest-method-to-ingest-tiingo-end-of-day-stock-api-data\/","og_site_name":"Tiingo Knowledge Base","article_publisher":"https:\/\/www.facebook.com\/tiingofinance\/","article_modified_time":"2023-05-23T15:59:15+00:00","og_image":[{"url":"https:\/\/api.tiingo.com\/kb\/wp-content\/uploads\/2023\/05\/Clean-Data-1024x1024.png"}],"twitter_card":"summary_large_image","twitter_site":"@tiingofinance","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.tiingo.com\/kb\/article\/the-fastest-method-to-ingest-tiingo-end-of-day-stock-api-data\/","url":"https:\/\/www.tiingo.com\/kb\/article\/the-fastest-method-to-ingest-tiingo-end-of-day-stock-api-data\/","name":"The Fastest Method to Ingest Tiingo End-of-Day Stock API Data - Tiingo Knowledge Base","isPartOf":{"@id":"\/#website"},"datePublished":"2023-05-23T15:57:16+00:00","dateModified":"2023-05-23T15:59:15+00:00","description":"This post discusses the fastest method to ingest Tiingo End-of-Day Stock API data. In just two steps, you can keep your data up to date!","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.tiingo.com\/kb\/article\/the-fastest-method-to-ingest-tiingo-end-of-day-stock-api-data\/"]}]},{"@type":"WebSite","@id":"\/#website","url":"\/","name":"Tiingo Knowledge Base","description":"","publisher":{"@id":"\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"\/#organization","name":"Tiingo.com","url":"\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"\/#\/schema\/logo\/image\/","url":"https:\/\/www.tiingo.com\/kb\/wp-content\/uploads\/2023\/05\/purple-for-light-bg.svg","contentUrl":"https:\/\/www.tiingo.com\/kb\/wp-content\/uploads\/2023\/05\/purple-for-light-bg.svg","width":"1024","height":"1024","caption":"Tiingo.com"},"image":{"@id":"\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/tiingofinance\/","https:\/\/twitter.com\/tiingofinance"]}]}},"_links":{"self":[{"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/ht-kb\/187","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/comments?post=187"}],"version-history":[{"count":1,"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/ht-kb\/187\/revisions"}],"predecessor-version":[{"id":191,"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/ht-kb\/187\/revisions\/191"}],"wp:attachment":[{"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/media?parent=187"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=187"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}