PREVIEW / stock_5min / 2011-08-01

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-08-01.parquet
  size:    5.0 MB
  rows:    333,855
  symbols: 3,520

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-08-01 04:00:00	AAPL	Stock	14.195	14.2043	14.1936	14.1936	18200.0
2011-08-01 04:05:00	AAPL	Stock	14.2036	14.2036	14.2036	14.2036	8400.0
2011-08-01 04:10:00	AAPL	Stock	14.21	14.2143	14.2089	14.2143	8400.0
2011-08-01 04:15:00	AAPL	Stock	14.2111	14.2111	14.2111	14.2111	2800.0
2011-08-01 04:20:00	AAPL	Stock	14.2111	14.2111	14.2029	14.2029	5600.0
2011-08-01 04:25:00	AAPL	Stock	14.1979	14.2004	14.1861	14.1868	23800.0
2011-08-01 04:30:00	AAPL	Stock	14.1889	14.1889	14.1639	14.1639	14000.0
2011-08-01 04:35:00	AAPL	Stock	14.1943	14.1943	14.1943	14.1943	2800.0
2011-08-01 04:45:00	AAPL	Stock	14.1786	14.1786	14.1786	14.1786	2800.0
2011-08-01 04:55:00	AAPL	Stock	14.1961	14.1961	14.1961	14.1961	2800.0
2011-08-01 05:00:00	AAPL	Stock	14.1961	14.2232	14.1961	14.2232	5600.0
2011-08-01 05:05:00	AAPL	Stock	14.2054	14.2054	14.2054	14.2054	2800.0
2011-08-01 05:10:00	AAPL	Stock	14.2118	14.2118	14.2111	14.2111	5600.0
2011-08-01 05:15:00	AAPL	Stock	14.2036	14.2143	14.2036	14.2107	100800.0
2011-08-01 05:25:00	AAPL	Stock	14.2121	14.2121	14.2107	14.2107	14000.0
2011-08-01 05:30:00	AAPL	Stock	14.2232	14.2232	14.2232	14.2232	2800.0
2011-08-01 05:35:00	AAPL	Stock	14.21	14.21	14.2036	14.2036	19600.0
2011-08-01 05:50:00	AAPL	Stock	14.2	14.2	14.1907	14.1907	11200.0
2011-08-01 05:55:00	AAPL	Stock	14.1907	14.1907	14.1907	14.1907	22400.0
2011-08-01 06:00:00	AAPL	Stock	14.2	14.2036	14.2	14.2036	11200.0
2011-08-01 06:05:00	AAPL	Stock	14.2071	14.2071	14.2071	14.2071	32200.0
2011-08-01 06:10:00	AAPL	Stock	14.2	14.2	14.2	14.2	14000.0
2011-08-01 06:15:00	AAPL	Stock	14.2018	14.2071	14.2	14.2	26600.0
2011-08-01 06:25:00	AAPL	Stock	14.2	14.2	14.2	14.2	16800.0
2011-08-01 06:30:00	AAPL	Stock	14.1907	14.1907	14.1854	14.1854	11200.0
2011-08-01 06:35:00	AAPL	Stock	14.2	14.2	14.1821	14.1832	11200.0
2011-08-01 06:40:00	AAPL	Stock	14.1889	14.1929	14.1825	14.1929	61040.0
2011-08-01 06:45:00	AAPL	Stock	14.2	14.2	14.1932	14.1932	25200.0
2011-08-01 06:50:00	AAPL	Stock	14.1871	14.2071	14.1871	14.2007	29400.0
2011-08-01 06:55:00	AAPL	Stock	14.1929	14.1946	14.1893	14.1893	43372.0
2011-08-01 07:00:00	AAPL	Stock	14.2007	14.25	14.1929	14.2104	344092.0
2011-08-01 07:05:00	AAPL	Stock	14.1971	14.2036	14.1875	14.1893	139160.0
2011-08-01 07:10:00	AAPL	Stock	14.1893	14.1893	14.1604	14.1764	237048.0
2011-08-01 07:15:00	AAPL	Stock	14.16	14.1768	14.16	14.1729	58380.0
2011-08-01 07:20:00	AAPL	Stock	14.175	14.175	14.165	14.1661	75600.0
2011-08-01 07:25:00	AAPL	Stock	14.1661	14.1661	14.1518	14.1607	113484.0
2011-08-01 07:30:00	AAPL	Stock	14.1714	14.1714	14.1714	14.1714	23772.0
2011-08-01 07:35:00	AAPL	Stock	14.1714	14.1729	14.1607	14.1621	92876.0
2011-08-01 07:40:00	AAPL	Stock	14.17	14.1739	14.1446	14.1471	110852.0
2011-08-01 07:45:00	AAPL	Stock	14.1536	14.1554	14.1429	14.145	235228.0
2011-08-01 07:50:00	AAPL	Stock	14.1468	14.1468	14.1429	14.1429	13132.0
2011-08-01 07:55:00	AAPL	Stock	14.1668	14.1668	14.1439	14.1439	9100.0
2011-08-01 08:00:00	AAPL	Stock	14.1596	14.2143	14.1339	14.1696	1599164.0
2011-08-01 08:05:00	AAPL	Stock	14.1943	14.2125	14.17	14.17	1107008.0
2011-08-01 08:10:00	AAPL	Stock	14.1761	14.1911	14.1743	14.1857	564984.0
2011-08-01 08:15:00	AAPL	Stock	14.1929	14.1929	14.1786	14.1807	496804.0
2011-08-01 08:20:00	AAPL	Stock	14.1811	14.1929	14.1807	14.1929	474404.0
2011-08-01 08:25:00	AAPL	Stock	14.1907	14.1946	14.1807	14.1854	392980.0
2011-08-01 08:30:00	AAPL	Stock	14.1793	14.1854	14.1743	14.1743	311780.0
2011-08-01 08:35:00	AAPL	Stock	14.175	14.1786	14.1693	14.175	226436.0

> showing 50 of 333,855 rows — these rows as CSV

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