PREVIEW / stock_5min / 2011-04-06

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-04-06.parquet
  size:    4.9 MB
  rows:    334,075
  symbols: 3,540

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2011-04-06 04:00:00	AAPL	Stock	12.1471	12.1471	12.1471	12.1471	2800.0
2011-04-06 04:10:00	AAPL	Stock	12.1429	12.1429	12.1429	12.1429	19600.0
2011-04-06 04:25:00	AAPL	Stock	12.1429	12.1429	12.1429	12.1429	2800.0
2011-04-06 04:35:00	AAPL	Stock	12.1607	12.1607	12.1607	12.1607	33600.0
2011-04-06 04:50:00	AAPL	Stock	12.15	12.15	12.15	12.15	14000.0
2011-04-06 05:20:00	AAPL	Stock	12.1679	12.1679	12.1679	12.1679	14000.0
2011-04-06 06:05:00	AAPL	Stock	12.1661	12.1661	12.1661	12.1661	2800.0
2011-04-06 06:10:00	AAPL	Stock	12.1714	12.1714	12.1661	12.1661	5600.0
2011-04-06 06:20:00	AAPL	Stock	12.1714	12.1714	12.1714	12.1714	2800.0
2011-04-06 06:25:00	AAPL	Stock	12.1643	12.1643	12.1643	12.1643	2800.0
2011-04-06 06:30:00	AAPL	Stock	12.1711	12.1714	12.1711	12.1714	11200.0
2011-04-06 06:35:00	AAPL	Stock	12.1732	12.1732	12.1604	12.1714	18480.0
2011-04-06 06:40:00	AAPL	Stock	12.1714	12.1757	12.1693	12.1693	20300.0
2011-04-06 06:55:00	AAPL	Stock	12.1761	12.1768	12.1761	12.1768	14000.0
2011-04-06 07:00:00	AAPL	Stock	12.1768	12.1768	12.1607	12.1607	75460.0
2011-04-06 07:05:00	AAPL	Stock	12.1636	12.1729	12.1554	12.1729	22400.0
2011-04-06 07:10:00	AAPL	Stock	12.1682	12.1682	12.1679	12.1679	14000.0
2011-04-06 07:15:00	AAPL	Stock	12.1679	12.1693	12.1679	12.1693	8064.0
2011-04-06 07:20:00	AAPL	Stock	12.1661	12.1661	12.1643	12.165	16800.0
2011-04-06 07:25:00	AAPL	Stock	12.1693	12.1696	12.1607	12.1607	19600.0
2011-04-06 07:30:00	AAPL	Stock	12.1679	12.1714	12.1679	12.1704	25704.0
2011-04-06 07:35:00	AAPL	Stock	12.1707	12.1707	12.1704	12.1707	8400.0
2011-04-06 07:40:00	AAPL	Stock	12.1721	12.1746	12.1686	12.1686	14504.0
2011-04-06 07:50:00	AAPL	Stock	12.1607	12.1607	12.1582	12.1582	50400.0
2011-04-06 07:55:00	AAPL	Stock	12.1554	12.1732	12.1554	12.1729	106400.0
2011-04-06 08:00:00	AAPL	Stock	12.1618	12.1786	12.1607	12.1611	174636.0
2011-04-06 08:05:00	AAPL	Stock	12.1629	12.1704	12.1629	12.1643	63952.0
2011-04-06 08:10:00	AAPL	Stock	12.1646	12.1664	12.1643	12.1664	25200.0
2011-04-06 08:15:00	AAPL	Stock	12.1661	12.1839	12.1661	12.1839	145684.0
2011-04-06 08:20:00	AAPL	Stock	12.1832	12.1964	12.1832	12.1964	245896.0
2011-04-06 08:25:00	AAPL	Stock	12.1964	12.2143	12.1964	12.2093	614124.0
2011-04-06 08:30:00	AAPL	Stock	12.2093	12.2179	12.2054	12.2104	158900.0
2011-04-06 08:35:00	AAPL	Stock	12.2086	12.2089	12.1893	12.1893	63224.0
2011-04-06 08:40:00	AAPL	Stock	12.1979	12.1979	12.1814	12.1857	121184.0
2011-04-06 08:45:00	AAPL	Stock	12.1857	12.1857	12.1707	12.1814	224756.0
2011-04-06 08:50:00	AAPL	Stock	12.1839	12.1893	12.1832	12.1875	170268.0
2011-04-06 08:55:00	AAPL	Stock	12.1875	12.1875	12.1739	12.1821	164164.0
2011-04-06 09:00:00	AAPL	Stock	12.1793	12.1793	12.1032	12.1718	387492.0
2011-04-06 09:05:00	AAPL	Stock	12.1782	12.1868	12.1754	12.1857	138964.0
2011-04-06 09:10:00	AAPL	Stock	12.1839	12.1875	12.1821	12.1821	66836.0
2011-04-06 09:15:00	AAPL	Stock	12.1811	12.1811	12.1614	12.1711	248472.0
2011-04-06 09:20:00	AAPL	Stock	12.1732	12.1814	12.1711	12.175	113568.0
2011-04-06 09:25:00	AAPL	Stock	12.1743	12.1964	12.1743	12.1943	571760.0
2011-04-06 09:30:00	AAPL	Stock	12.1943	12.2071	12.1621	12.19	13531364.0
2011-04-06 09:35:00	AAPL	Stock	12.1893	12.2679	12.1886	12.2679	16469152.0
2011-04-06 09:40:00	AAPL	Stock	12.2675	12.2821	12.2418	12.2525	14713720.0
2011-04-06 09:45:00	AAPL	Stock	12.2507	12.2536	12.2098	12.2286	14001484.0
2011-04-06 09:50:00	AAPL	Stock	12.2291	12.2471	12.2261	12.2368	7152236.0
2011-04-06 09:55:00	AAPL	Stock	12.2341	12.2442	12.2189	12.2354	5908700.0
2011-04-06 10:00:00	AAPL	Stock	12.235	12.2464	12.2307	12.2432	5607980.0

> showing 50 of 334,075 rows — these rows as CSV

> unlock the full archive -- $79 one-time