PREVIEW / stock_5min / 2012-01-24

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-01-24.parquet
  size:    4.7 MB
  rows:    317,969
  symbols: 3,522

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
2012-01-24 04:10:00	AAPL	Stock	15.2679	15.2679	15.2643	15.2643	14000.0
2012-01-24 04:15:00	AAPL	Stock	15.2643	15.2679	15.2643	15.2679	8400.0
2012-01-24 04:45:00	AAPL	Stock	15.25	15.25	15.2354	15.2496	16800.0
2012-01-24 05:00:00	AAPL	Stock	15.2432	15.2432	15.2143	15.2143	5600.0
2012-01-24 05:20:00	AAPL	Stock	15.2279	15.2279	15.2279	15.2279	8400.0
2012-01-24 05:55:00	AAPL	Stock	15.2143	15.2143	15.2143	15.2143	2800.0
2012-01-24 06:00:00	AAPL	Stock	15.1964	15.1964	15.1964	15.1964	18200.0
2012-01-24 06:20:00	AAPL	Stock	15.2232	15.2232	15.2	15.2	10640.0
2012-01-24 07:00:00	AAPL	Stock	15.2143	15.2311	15.2143	15.2232	49000.0
2012-01-24 07:05:00	AAPL	Stock	15.2143	15.2143	15.2107	15.2107	5600.0
2012-01-24 07:10:00	AAPL	Stock	15.2179	15.2214	15.2164	15.2214	14000.0
2012-01-24 07:15:00	AAPL	Stock	15.2232	15.2268	15.2107	15.2107	35000.0
2012-01-24 07:20:00	AAPL	Stock	15.2196	15.2196	15.2179	15.2179	8848.0
2012-01-24 07:25:00	AAPL	Stock	15.225	15.225	15.2046	15.2046	23436.0
2012-01-24 07:30:00	AAPL	Stock	15.2193	15.2214	15.2107	15.2107	27300.0
2012-01-24 07:35:00	AAPL	Stock	15.2143	15.2143	15.1964	15.1964	28000.0
2012-01-24 07:40:00	AAPL	Stock	15.1996	15.2007	15.1964	15.2007	73528.0
2012-01-24 07:45:00	AAPL	Stock	15.2	15.2	15.2	15.2	2800.0
2012-01-24 07:50:00	AAPL	Stock	15.2032	15.2032	15.2018	15.2018	11200.0
2012-01-24 07:55:00	AAPL	Stock	15.2	15.2068	15.1964	15.1964	31472.0
2012-01-24 08:00:00	AAPL	Stock	15.2032	15.23	15.1943	15.2125	154112.0
2012-01-24 08:05:00	AAPL	Stock	15.2089	15.2121	15.2	15.2	113260.0
2012-01-24 08:10:00	AAPL	Stock	15.2018	15.2018	15.1946	15.2018	78708.0
2012-01-24 08:15:00	AAPL	Stock	15.2054	15.2064	15.2043	15.2043	62944.0
2012-01-24 08:20:00	AAPL	Stock	15.2036	15.2036	15.1964	15.1982	129416.0
2012-01-24 08:25:00	AAPL	Stock	15.2071	15.2154	15.1886	15.1886	504196.0
2012-01-24 08:30:00	AAPL	Stock	15.1886	15.1904	15.1679	15.1732	273756.0
2012-01-24 08:35:00	AAPL	Stock	15.1746	15.175	15.1671	15.1714	79800.0
2012-01-24 08:40:00	AAPL	Stock	15.1743	15.1854	15.1696	15.1854	181048.0
2012-01-24 08:45:00	AAPL	Stock	15.1857	15.2079	15.1829	15.2079	255332.0
2012-01-24 08:50:00	AAPL	Stock	15.2079	15.2175	15.1911	15.1961	398832.0
2012-01-24 08:55:00	AAPL	Stock	15.1893	15.1946	15.1821	15.1857	92400.0
2012-01-24 09:00:00	AAPL	Stock	15.1861	15.1861	15.1786	15.1796	175896.0
2012-01-24 09:05:00	AAPL	Stock	15.18	15.1896	15.175	15.1857	237888.0
2012-01-24 09:10:00	AAPL	Stock	15.1839	15.1871	15.1821	15.1821	84028.0
2012-01-24 09:15:00	AAPL	Stock	15.1868	15.1875	15.175	15.1854	100604.0
2012-01-24 09:20:00	AAPL	Stock	15.1854	15.1911	15.1789	15.1839	128800.0
2012-01-24 09:25:00	AAPL	Stock	15.1857	15.1904	15.18	15.1807	354452.0
2012-01-24 09:30:00	AAPL	Stock	15.1825	15.1825	15.1129	15.1321	16842392.0
2012-01-24 09:35:00	AAPL	Stock	15.1321	15.1711	15.124	15.1625	8363488.0
2012-01-24 09:40:00	AAPL	Stock	15.1625	15.1757	15.1468	15.1714	6323492.0
2012-01-24 09:45:00	AAPL	Stock	15.1714	15.1743	15.1514	15.1654	4573940.0
2012-01-24 09:50:00	AAPL	Stock	15.1654	15.1729	15.1343	15.1486	6078828.0
2012-01-24 09:55:00	AAPL	Stock	15.1486	15.1568	15.1357	15.1389	4579988.0
2012-01-24 10:00:00	AAPL	Stock	15.1386	15.1536	15.1171	15.1475	6900012.0
2012-01-24 10:05:00	AAPL	Stock	15.1479	15.1536	15.1343	15.1432	4932928.0
2012-01-24 10:10:00	AAPL	Stock	15.1429	15.1696	15.1411	15.1643	3936212.0
2012-01-24 10:15:00	AAPL	Stock	15.1643	15.1786	15.1607	15.1739	4634616.0
2012-01-24 10:20:00	AAPL	Stock	15.1754	15.1761	15.1507	15.1662	3914512.0
2012-01-24 10:25:00	AAPL	Stock	15.1684	15.1685	15.1489	15.1489	2338196.0

> showing 50 of 317,969 rows — these rows as CSV

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