{"id":208512,"date":"2024-06-27T12:08:50","date_gmt":"2024-06-27T16:08:50","guid":{"rendered":"https:\/\/ibkrcampus.com\/?p=208512"},"modified":"2024-06-27T12:08:38","modified_gmt":"2024-06-27T16:08:38","slug":"using-pandas-for-market-data-management","status":"publish","type":"post","link":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/using-pandas-for-market-data-management\/","title":{"rendered":"Using Pandas for Market Data Management"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong><em><u>Introduction<\/u><\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the fast-paced world of financial markets, the ability to efficiently store, manipulate, and analyze data is crucial. This is where Pandas, a powerful and flexible Python library, becomes an important tool for finance professionals, traders, and data analysts. Pandas is known for its simplicity, great performance and popularity across Data enthusiasts. At the end of this article, we will provide a Sample code to pull and store Historical Data into a DataFrame using our own TWS API (Documentation can be found here: <a href=\"\/campus\/ibkr-api-page\/twsapi-doc\/\">\/campus\/ibkr-api-page\/twsapi-doc\/<\/a>).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em><u>What is Pandas?<\/u><\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pandas is an open-source library that provides high-performance, easy-to-use data structures, and data analysis tools for the Python programming language. At the heart of Pandas are two primary data structures: Series and DataFrames. A Series is essentially a one-dimensional array capable of storing any data type, whereas a DataFrame is a two-dimensional, size-mutable, and potentially heterogeneous tabular data structure with labeled axes (rows and columns).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em><u>How Pandas Works with Market Data<\/u><\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><u>Receiving Data<\/u><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The first step in working with market data is data ingestion. Market data can come from various sources, including APIs. You can easily import data from various file formats (CSV, JSON, Excel, etc.) or directly from a dictionary in your code; which can be created by requesting Market Data via an API.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><u>Data Storage and Manipulation<\/u><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once the market data is imported into Pandas, it is stored in DataFrame format. This structure is particularly suited for financial time series data as it allows for easy manipulation and transformation of data. For example, you can:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Resample or aggregate data: Convert high-frequency data into lower-frequency data (e.g., from minute-by-minute to daily), which is particularly useful for historical trend analysis.<\/li>\n\n\n\n<li>Handle missing values: Fill or drop missing values, which is common in real-world market data.<\/li>\n\n\n\n<li>Perform data transformations: Apply mathematical operations to adjust prices for splits, dividends, or to calculate returns.<\/li>\n\n\n\n<li>Filtering and sorting: Easily filter out data based on certain criteria or sort data according to date, price, or any other column.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><u>Analysis and Visualization<\/u><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Beyond data storage and manipulation, Pandas seamlessly integrates with other libraries for data analysis and visualization, such as NumPy for numerical computations and Matplotlib or Seaborn for plotting. This integration allows for comprehensive financial analysis, such as calculating financial indicators (moving averages, RSI, etc.), performing statistical tests, or visualizing price movements and trading signals.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this example, we will be requesting historical data for Apple stock (Symbol AAPL) in the form of 1 hour bars for the past 2 days. To request this data, we will be using our TWS API method, reqHistoricalData. You can check our Python tutorials on how to request historical data: (<a href=\"\/campus\/trading-lessons\/python-receiving-market-data\/\">Tutorial<\/a>). Once this data is received, we will store it into a Pandas DataFrame then set the index to Datetime (explain why). Finally, using the MatplotLib library, we will graph the prices and volume in a simple chart. Code Snippet below:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em><u>Example of pulling Historical Data using TWS API<\/u><\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this example, we will demonstrate how to request historical data for Apple Inc. (AAPL) stock in the form of 1-hour bars over the past two days. We will utilize the TWS API method, <a href=\"\/campus\/ibkr-api-page\/twsapi-doc\/#requesting-historical-bars\">reqHistoricalData<\/a>, to obtain this data. For detailed instructions on using this method, you can refer to our <a href=\"\/campus\/trading-lessons\/python-receiving-market-data\/\">Python tutorials<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once the historical data is received, we will store it in a Pandas DataFrame. Setting the index to Datetime is crucial because it allows us to efficiently handle and analyze time-series data. This indexing facilitates various time-based operations and visualizations.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Finally, we will use the Matplotlib library to create a simple chart displaying the prices and volume of the stock. Below is a code snippet illustrating the process.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">from ibapi.client import *\nfrom ibapi.wrapper import *\nimport pandas as pd\nimport matplotlib.pyplot as plt\nimport matplotlib.dates as mdates\n\nport = 7496\n\nclass TestApp(EClient, EWrapper):\n    def __init__(self):\n        EClient.__init__(self, self)\n        self.data = []\n\n    def nextValidId(self, orderId: OrderId):\n        mycontract = Contract()\n        mycontract.conId = 265598\n        mycontract.exchange = \"SMART\"\n        \n        self.reqHistoricalData(\n            reqId=123,\n            contract=mycontract,\n            endDateTime=\"\",\n            durationStr= \"2 D\",\n            barSizeSetting = \"1 hour\",\n            whatToShow= \"TRADES\",\n            useRTH=0,\n            formatDate=1,\n            keepUpToDate=False,\n            chartOptions=[],\n        )\n\n    def historicalData(self, reqId: int, bar: BarData):\n        print(\"Historical Bar\", bar)\n        # Remove timezone information before appending\n        date_without_tz = bar.date.split(' ')[0] + ' ' + bar.date.split(' ')[1]\n        self.data.append([\n            date_without_tz, bar.open, bar.high, bar.low, bar.close,\n            bar.volume, bar.wap, bar.barCount\n        ])\n\n    def historicalDataEnd(self, reqId: int, start: str, end: str):\n        print(\"\\nHistorical Data received \\n\")\n        df = pd.DataFrame(self.data, columns=[\n            'Date', 'Open', 'High', 'Low', 'Close', 'Volume', 'WAP', 'BarCount'\n        ])\n        # Convert 'Date' to datetime and set as index\n        df['Date'] = pd.to_datetime(df['Date'], format='%Y%m%d %H:%M:%S')\n        df.set_index('Date', inplace=True)\n        print(\"Creating Data Frame...Printing DataFrame:\\n\")\n        print(df)\n        \n        # Plot the data\n        fig, ax1 = plt.subplots(figsize=(12, 8))\n\n        # Plot OHLC data\n        ax1.plot(df.index, df['Open'], label='Open', color='blue')\n        ax1.plot(df.index, df['High'], label='High', color='green')\n        ax1.plot(df.index, df['Low'], label='Low', color='red')\n        ax1.plot(df.index, df['Close'], label='Close', color='black')\n        ax1.set_ylabel('Price')\n        ax1.legend(loc='upper left')\n\n        # Create another y-axis for the volume data\n        ax2 = ax1.twinx()\n        ax2.fill_between(df.index, df['Volume'], color='gray', alpha=0.3, label='Volume')\n        ax2.set_ylabel('Volume')\n        ax2.legend(loc='upper right')\n\n        # Format the x-axis to show the full date and time\n        ax1.xaxis.set_major_formatter(mdates.DateFormatter('%Y-%m-%d %H:%M:%S'))\n        plt.xticks(rotation=45)\n        plt.gcf().autofmt_xdate()  # Auto format date for better visibility\n\n        plt.title('Stock Price and Volume')\n        plt.show()\n        \n        return super().historicalDataEnd(reqId, start, end)\n\n    def error(self, reqId: TickerId, errorCode: int, errorString: str, advancedOrderRejectJson=\"\"):\n        print(reqId, errorCode, errorString, advancedOrderRejectJson)\n\napp = TestApp()\napp.connect(\"127.0.0.1\", port, 1)\napp.run()<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em><u>Conclusion<\/u><\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pandas is a cornerstone tool for anyone dealing with market data. Its comprehensive features for data ingestion, manipulation, analysis, and visualization make it a robust and useful tool in a financial analyst&#8217;s toolkit. By abstracting away much of the complexity involved in data handling, Pandas allows analysts to focus more on extracting insights and making informed decisions, thereby playing a crucial role in the financial decision-making process.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Reference: <a href=\"https:\/\/pandas.pydata.org\/\">https:\/\/pandas.pydata.org\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the fast-paced world of financial markets, the ability to efficiently store, manipulate, and analyze data is crucial. This is where Pandas, a powerful and flexible Python library, becomes an important tool for finance professionals, traders, and data analysts.<\/p>\n","protected":false},"author":1193,"featured_media":208535,"comment_status":"open","ping_status":"closed","sticky":true,"template":"","format":"standard","meta":{"_acf_changed":true,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[339,340,343,349,338,341],"tags":[851,575,4659,1224,595],"contributors-categories":[13576],"class_list":["post-208512","post","type-post","status-publish","format-standard","has-post-thumbnail","category-data-science","category-api-development","category-programing-languages","category-python-development","category-ibkr-quant-news","category-quant-development","tag-algo-trading","tag-ibkr-api","tag-matplotlib","tag-pandas","tag-python","contributors-categories-interactive-brokers"],"pp_statuses_selecting_workflow":false,"pp_workflow_action":"current","pp_status_selection":"publish","acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.9 (Yoast SEO v28.0) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Using Pandas for Market Data Management | IBKR Quant<\/title>\n<meta name=\"description\" content=\"In the fast-paced world of financial markets, the ability to efficiently store, manipulate, and analyze data is crucial.\" \/>\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.interactivebrokers.com\/campus\/wp-json\/wp\/v2\/posts\/208512\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Pandas for Market Data Management\" \/>\n<meta property=\"og:description\" content=\"In the fast-paced world of financial markets, the ability to efficiently store, manipulate, and analyze data is crucial. This is where Pandas, a powerful and flexible Python library, becomes an important tool for finance professionals, traders, and data analysts.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/using-pandas-for-market-data-management\/\" \/>\n<meta property=\"og:site_name\" content=\"IBKR Campus US\" \/>\n<meta property=\"article:published_time\" content=\"2024-06-27T16:08:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/06\/api-chip-blue.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"563\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Yassine Raouz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yassine Raouz\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t    \"@context\": \"https:\\\/\\\/schema.org\",\n\t    \"@graph\": [\n\t        {\n\t            \"@type\": \"NewsArticle\",\n\t            \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/using-pandas-for-market-data-management\\\/#article\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/using-pandas-for-market-data-management\\\/\"\n\t            },\n\t            \"author\": {\n\t                \"name\": \"Yassine Raouz\",\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/person\\\/2b2dffe746a2790ac0c5395b23f3a68b\"\n\t            },\n\t            \"headline\": \"Using Pandas for Market Data Management\",\n\t            \"datePublished\": \"2024-06-27T16:08:50+00:00\",\n\t            \"mainEntityOfPage\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/using-pandas-for-market-data-management\\\/\"\n\t            },\n\t            \"wordCount\": 695,\n\t            \"commentCount\": 8,\n\t            \"publisher\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#organization\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/using-pandas-for-market-data-management\\\/#primaryimage\"\n\t            },\n\t            \"thumbnailUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/06\\\/api-chip-blue.jpg\",\n\t            \"keywords\": [\n\t                \"Algo Trading\",\n\t                \"IBKR API\",\n\t                \"Matplotlib\",\n\t                \"Pandas\",\n\t                \"Python\"\n\t            ],\n\t            \"articleSection\": [\n\t                \"Data Science\",\n\t                \"IBKR API Development\",\n\t                \"Programming Languages\",\n\t                \"Python Development\",\n\t                \"Quant\",\n\t                \"Quant Development\"\n\t            ],\n\t            \"inLanguage\": \"en-US\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"CommentAction\",\n\t                    \"name\": \"Comment\",\n\t                    \"target\": [\n\t                        \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/using-pandas-for-market-data-management\\\/#respond\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"WebPage\",\n\t            \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/using-pandas-for-market-data-management\\\/\",\n\t            \"url\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/using-pandas-for-market-data-management\\\/\",\n\t            \"name\": \"Using Pandas for Market Data Management | IBKR Campus US\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#website\"\n\t            },\n\t            \"primaryImageOfPage\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/using-pandas-for-market-data-management\\\/#primaryimage\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/using-pandas-for-market-data-management\\\/#primaryimage\"\n\t            },\n\t            \"thumbnailUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/06\\\/api-chip-blue.jpg\",\n\t            \"datePublished\": \"2024-06-27T16:08:50+00:00\",\n\t            \"description\": \"In the fast-paced world of financial markets, the ability to efficiently store, manipulate, and analyze data is crucial.\",\n\t            \"inLanguage\": \"en-US\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"ReadAction\",\n\t                    \"target\": [\n\t                        \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/using-pandas-for-market-data-management\\\/\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"ImageObject\",\n\t            \"inLanguage\": \"en-US\",\n\t            \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/using-pandas-for-market-data-management\\\/#primaryimage\",\n\t            \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/06\\\/api-chip-blue.jpg\",\n\t            \"contentUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/06\\\/api-chip-blue.jpg\",\n\t            \"width\": 1000,\n\t            \"height\": 563,\n\t            \"caption\": \"Application Programming Interface (API). Software development tool, information technology, modern technology, internet and networking concept on dark blue background.\"\n\t        },\n\t        {\n\t            \"@type\": \"WebSite\",\n\t            \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#website\",\n\t            \"url\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/\",\n\t            \"name\": \"IBKR Campus US\",\n\t            \"description\": \"Financial Education from Interactive Brokers\",\n\t            \"publisher\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#organization\"\n\t            },\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"SearchAction\",\n\t                    \"target\": {\n\t                        \"@type\": \"EntryPoint\",\n\t                        \"urlTemplate\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/?s={search_term_string}\"\n\t                    },\n\t                    \"query-input\": {\n\t                        \"@type\": \"PropertyValueSpecification\",\n\t                        \"valueRequired\": true,\n\t                        \"valueName\": \"search_term_string\"\n\t                    }\n\t                }\n\t            ],\n\t            \"inLanguage\": \"en-US\"\n\t        },\n\t        {\n\t            \"@type\": \"Organization\",\n\t            \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#organization\",\n\t            \"name\": \"Interactive Brokers\",\n\t            \"alternateName\": \"IBKR\",\n\t            \"url\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/\",\n\t            \"logo\": {\n\t                \"@type\": \"ImageObject\",\n\t                \"inLanguage\": \"en-US\",\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/logo\\\/image\\\/\",\n\t                \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/05\\\/ibkr-campus-logo.jpg\",\n\t                \"contentUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/05\\\/ibkr-campus-logo.jpg\",\n\t                \"width\": 669,\n\t                \"height\": 669,\n\t                \"caption\": \"Interactive Brokers\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/logo\\\/image\\\/\"\n\t            },\n\t            \"publishingPrinciples\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/about-ibkr-campus\\\/\",\n\t            \"ethicsPolicy\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/cyber-security-notice\\\/\"\n\t        },\n\t        {\n\t            \"@type\": \"Person\",\n\t            \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/person\\\/2b2dffe746a2790ac0c5395b23f3a68b\",\n\t            \"name\": \"Yassine Raouz\",\n\t            \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/author\\\/yassine\\\/\"\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Using Pandas for Market Data Management | IBKR Quant","description":"In the fast-paced world of financial markets, the ability to efficiently store, manipulate, and analyze data is crucial.","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.interactivebrokers.com\/campus\/wp-json\/wp\/v2\/posts\/208512\/","og_locale":"en_US","og_type":"article","og_title":"Using Pandas for Market Data Management","og_description":"In the fast-paced world of financial markets, the ability to efficiently store, manipulate, and analyze data is crucial. This is where Pandas, a powerful and flexible Python library, becomes an important tool for finance professionals, traders, and data analysts.","og_url":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/using-pandas-for-market-data-management\/","og_site_name":"IBKR Campus US","article_published_time":"2024-06-27T16:08:50+00:00","og_image":[{"width":1000,"height":563,"url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/06\/api-chip-blue.jpg","type":"image\/jpeg"}],"author":"Yassine Raouz","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Yassine Raouz","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"NewsArticle","@id":"https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/using-pandas-for-market-data-management\/#article","isPartOf":{"@id":"https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/using-pandas-for-market-data-management\/"},"author":{"name":"Yassine Raouz","@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/person\/2b2dffe746a2790ac0c5395b23f3a68b"},"headline":"Using Pandas for Market Data Management","datePublished":"2024-06-27T16:08:50+00:00","mainEntityOfPage":{"@id":"https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/using-pandas-for-market-data-management\/"},"wordCount":695,"commentCount":8,"publisher":{"@id":"https:\/\/ibkrcampus.com\/campus\/#organization"},"image":{"@id":"https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/using-pandas-for-market-data-management\/#primaryimage"},"thumbnailUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/06\/api-chip-blue.jpg","keywords":["Algo Trading","IBKR API","Matplotlib","Pandas","Python"],"articleSection":["Data Science","IBKR API Development","Programming Languages","Python Development","Quant","Quant Development"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/using-pandas-for-market-data-management\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/using-pandas-for-market-data-management\/","url":"https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/using-pandas-for-market-data-management\/","name":"Using Pandas for Market Data Management | IBKR Campus US","isPartOf":{"@id":"https:\/\/ibkrcampus.com\/campus\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/using-pandas-for-market-data-management\/#primaryimage"},"image":{"@id":"https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/using-pandas-for-market-data-management\/#primaryimage"},"thumbnailUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/06\/api-chip-blue.jpg","datePublished":"2024-06-27T16:08:50+00:00","description":"In the fast-paced world of financial markets, the ability to efficiently store, manipulate, and analyze data is crucial.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/using-pandas-for-market-data-management\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/using-pandas-for-market-data-management\/#primaryimage","url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/06\/api-chip-blue.jpg","contentUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/06\/api-chip-blue.jpg","width":1000,"height":563,"caption":"Application Programming Interface (API). Software development tool, information technology, modern technology, internet and networking concept on dark blue background."},{"@type":"WebSite","@id":"https:\/\/ibkrcampus.com\/campus\/#website","url":"https:\/\/ibkrcampus.com\/campus\/","name":"IBKR Campus US","description":"Financial Education from Interactive Brokers","publisher":{"@id":"https:\/\/ibkrcampus.com\/campus\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ibkrcampus.com\/campus\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ibkrcampus.com\/campus\/#organization","name":"Interactive Brokers","alternateName":"IBKR","url":"https:\/\/ibkrcampus.com\/campus\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/logo\/image\/","url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/05\/ibkr-campus-logo.jpg","contentUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/05\/ibkr-campus-logo.jpg","width":669,"height":669,"caption":"Interactive Brokers"},"image":{"@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/logo\/image\/"},"publishingPrinciples":"https:\/\/www.interactivebrokers.com\/campus\/about-ibkr-campus\/","ethicsPolicy":"https:\/\/www.interactivebrokers.com\/campus\/cyber-security-notice\/"},{"@type":"Person","@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/person\/2b2dffe746a2790ac0c5395b23f3a68b","name":"Yassine Raouz","url":"https:\/\/www.interactivebrokers.com\/campus\/author\/yassine\/"}]}},"jetpack_featured_media_url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/06\/api-chip-blue.jpg","_links":{"self":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts\/208512","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/users\/1193"}],"replies":[{"embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/comments?post=208512"}],"version-history":[{"count":0,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts\/208512\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/media\/208535"}],"wp:attachment":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/media?parent=208512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/categories?post=208512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/tags?post=208512"},{"taxonomy":"contributors-categories","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/contributors-categories?post=208512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}