Get Yahoo!Finance data on ScraperWiki

100%

Get Yahoo!Finance data on ScraperWiki

✓ Published0🌍 Public

Last edited Apr 8, 2014

Created on Apr 8, 2014

This example shows how to pull historical stock price data from Yahoo! Finance and store it in a SQLite database. The code uses pandas’ `DataReader` with the `yahoo` API to fetch daily trading data for a given ticker symbol over a specified date range. It then resets the DataFrame index, converts the date column to ISO format, and writes the result to a table using `pandas.io.sql.write_frame` with a SQLite connection. The script demonstrates a straightforward data pipeline from an online financial API to local relational storage, using only the pandas and sqlite3 libraries.

AI-generated description

Similar vizzes

Loading thumbnail…

Dynamic historical stock data with d3.js and YQL

This interactive line chart displays daily stock prices for a user-selected ticker symbol over a specified date range. HTML input fields and an Update button control the query, which fetches historical data from Yahoo Finance’s YQL API. The visualization, built with d3.js (version 3.5.17), renders an SVG area with axes, a steelblue line for daily high prices, and a dynamically updated title. The code uses `d3.json` for the AJAX call, `d3.time.scale` and `d3.scale.linear` for plotting, and `d3.svg.line` for the path, with no input sanitization.

Dd3noob

63% match

Loading thumbnail…

Yahoo Finance Chart Step 3 - Styling

This example shows a styled financial time-series chart of Yahoo Finance stock data, plotting opening prices as both a line and an area chart over a single trading day. The SVG rendering uses the d3fc library’s `linearTimeSeries` chart, with `area`, `line`, and `gridline` series composed via `multi`. A custom CSS gradient fills the area, while axis labels are repositioned and bolded for readability. Data is loaded from a CSV and parsed into JavaScript `Date` objects using `d3.csv`.

CColinEberhardt

60% match

Loading thumbnail…

Yahoo Finance Chart

This example visualizes intraday stock price data from Yahoo Finance using a combination of D3 and d3fc components. The chart displays high, low, open, and close prices, along with trading volume and a moving average, over a discontinuous time scale that skips non-trading hours. A crosshair tooltip shows detailed values for the hovered data point, while callout annotations highlight the most recent high and moving-average values. Trading hours are marked with vertical annotations and shaded bands, and the chart includes a legend summarizing the OHLC and volume data. The visualization uses an SVG renderer and is built with d3.v5, demonstrating how to compose multiple series and annotations using the d3fc library.

CColinEberhardt

59% match

Loading thumbnail…

Yahoo Finance Chart Step 11 - Intraday Data

A Yahoo Finance intraday stock chart displays open, high, low, close, and volume data as an area-plus-line series with a red exponential moving average line. The visualization uses the D3FC library with D3.js to render SVG elements, including annotations for the last close and EMA values, a legend, and a crosshair. Data comes from a local JSON file containing Yahoo Finance chart data, filtered to trading hours and formatted with time and price scales.

CColinEberhardt

59% match

Loading thumbnail…

Yahoo Finance Chart Step 1 - Basic Chart

This example shows a basic time-series area chart of Yahoo Finance stock prices, plotting opening values over time as a filled area. The visualization uses the d3fc library’s `fc.chart.linearTimeSeries` and `fc.series.area` components, with D3’s `d3.csv` loader parsing timestamps into JavaScript Date objects. The chart is rendered as an SVG element, with data read from a local CSV file containing timestamp, open, high, low, and close price columns. The x- and y-domains are automatically calculated from the data using `fc.util.extent`.

CColinEberhardt

58% match

Loading thumbnail…

Yahoo Finance Chart Step 2 - Gidlines and Area

This example shows a financial time series chart of Yahoo stock prices, plotting open values as both a filled area and an overlaid line against timestamps. The chart uses horizontal gridlines for scale reference, with five y-axis ticks and a cleaned domain for readability. Built with D3 and the d3fc library, the code constructs a `linearTimeSeries` chart, composes area, line, and gridline series via `fc.series.multi`, and renders the result as an SVG. Data is loaded from a CSV file.

CColinEberhardt

57% match

Loading thumbnail…

Yahoo Finance Chart Step 4 - Moving Average

This example shows a Yahoo Finance intraday chart for a stock, combining an area series of opening prices with a blue line and a red exponential moving average line, plus gridlines. The chart uses the d3fc library’s `fc.chart.linearTimeSeries`, `fc.series.area`, `fc.series.line`, and `fc.indicator.algorithm.exponentialMovingAverage` components, all rendered as SVG. Data is loaded from a CSV file via `d3.csv` and parsed into date objects. The moving average is computed over a window size of 20 on closing prices, with axes configured to display time and price.

CColinEberhardt

57% match

Loading thumbnail…

Yahoo Finance Chart Step 9 - Legend

This example shows a Yahoo Finance time-series chart of stock price data, displaying open, high, low, close, and volume values with a moving average line, price callouts, and a legend. It uses the d3fc library's `fc.chart.linearTimeSeries` and `fc.chart.legend` APIs, along with D3.js for rendering SVG. The chart combines area, line, and bar series, and colors volume bars red or green based on price movement. Data is loaded from `yahoo.csv` and parsed from timestamps into dates.

CColinEberhardt

57% match