PREVIEW / stock_30min / 2014-05-13

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-13.parquet
  size:    1.6 MB
  rows:    82,098
  symbols: 3,551

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
2014-05-13 04:30:00	AAPL	Stock	21.1804	21.1836	21.1725	21.1836	8400.0
2014-05-13 05:00:00	AAPL	Stock	21.1511	21.1511	21.1511	21.1511	9520.0
2014-05-13 05:30:00	AAPL	Stock	21.1929	21.1929	21.1929	21.1929	2800.0
2014-05-13 06:00:00	AAPL	Stock	21.1536	21.1536	21.1464	21.1464	11200.0
2014-05-13 07:00:00	AAPL	Stock	21.1607	21.1786	21.1607	21.1786	25732.0
2014-05-13 07:30:00	AAPL	Stock	21.1857	21.1868	21.1679	21.1679	126392.0
2014-05-13 08:00:00	AAPL	Stock	21.1807	21.185	21.1179	21.1296	311976.0
2014-05-13 08:30:00	AAPL	Stock	21.13	21.1375	21.1071	21.1332	306096.0
2014-05-13 09:00:00	AAPL	Stock	21.1425	21.1536	21.1346	21.1411	226380.0
2014-05-13 09:30:00	AAPL	Stock	21.1429	21.1875	21.0964	21.1196	24084564.0
2014-05-13 10:00:00	AAPL	Stock	21.1211	21.2054	21.1079	21.1525	13154708.0
2014-05-13 10:30:00	AAPL	Stock	21.1518	21.1943	21.1293	21.1675	8093456.0
2014-05-13 11:00:00	AAPL	Stock	21.1679	21.1875	21.1346	21.1761	5992476.0
2014-05-13 11:30:00	AAPL	Stock	21.1764	21.1925	21.1446	21.1629	4919488.0
2014-05-13 12:00:00	AAPL	Stock	21.1582	21.1871	21.1393	21.1729	4763472.0
2014-05-13 12:30:00	AAPL	Stock	21.1729	21.1839	21.1479	21.1836	4176816.0
2014-05-13 13:00:00	AAPL	Stock	21.1821	21.1964	21.1718	21.1861	4377380.0
2014-05-13 13:30:00	AAPL	Stock	21.1875	21.1925	21.1575	21.1714	5630352.0
2014-05-13 14:00:00	AAPL	Stock	21.1718	21.2289	21.1689	21.2257	9001300.0
2014-05-13 14:30:00	AAPL	Stock	21.2264	21.2336	21.2071	21.2136	7183820.0
2014-05-13 15:00:00	AAPL	Stock	21.2111	21.2202	21.1661	21.2029	8619492.0
2014-05-13 15:30:00	AAPL	Stock	21.2046	21.2179	21.1175	21.2036	11122636.0
2014-05-13 16:00:00	AAPL	Stock	21.2057	21.2057	21.1758	21.1993	8976016.0
2014-05-13 16:30:00	AAPL	Stock	21.1893	21.2057	21.1886	21.1886	152208.0
2014-05-13 17:00:00	AAPL	Stock	21.1886	21.1911	21.1786	21.1786	79408.0
2014-05-13 18:00:00	AAPL	Stock	21.1811	21.2057	21.1807	21.2057	192752.0
2014-05-13 19:00:00	AAPL	Stock	21.1875	21.1889	21.1775	21.1786	35168.0
2014-05-13 19:30:00	AAPL	Stock	21.1875	21.1893	21.1804	21.1893	21532.0
2014-05-13 04:30:00	MSFT	Stock	39.9	39.9	39.9	39.9	800.0
2014-05-13 06:00:00	MSFT	Stock	39.92	39.92	39.9	39.92	2700.0
2014-05-13 07:00:00	MSFT	Stock	39.9	39.92	39.86	39.9	8544.0
2014-05-13 07:30:00	MSFT	Stock	39.9	40.0	39.9	39.91	8056.0
2014-05-13 08:00:00	MSFT	Stock	39.91	39.97	39.85	39.86	15521.0
2014-05-13 08:30:00	MSFT	Stock	39.87	39.87	39.8	39.8	9583.0
2014-05-13 09:00:00	MSFT	Stock	39.79	39.96	39.79	39.91	19909.0
2014-05-13 09:30:00	MSFT	Stock	39.88	40.38	39.85	40.32	4356189.0
2014-05-13 10:00:00	MSFT	Stock	40.32	40.5	40.31	40.445	4426189.0
2014-05-13 10:30:00	MSFT	Stock	40.45	40.5	40.415	40.425	1538586.0
2014-05-13 11:00:00	MSFT	Stock	40.42	40.44	40.24	40.33	1774847.0
2014-05-13 11:30:00	MSFT	Stock	40.33	40.34	40.2	40.285	1271337.0
2014-05-13 12:00:00	MSFT	Stock	40.28	40.39	40.23	40.3	949308.0
2014-05-13 12:30:00	MSFT	Stock	40.3	40.38	40.26	40.36	798997.0
2014-05-13 13:00:00	MSFT	Stock	40.36	40.4	40.34	40.4	784905.0
2014-05-13 13:30:00	MSFT	Stock	40.39	40.4	40.31	40.37	1025071.0
2014-05-13 14:00:00	MSFT	Stock	40.38	40.4	40.33	40.335	901862.0
2014-05-13 14:30:00	MSFT	Stock	40.34	40.5	40.335	40.46	1955774.0
2014-05-13 15:00:00	MSFT	Stock	40.469	40.48	40.29	40.35	1649268.0
2014-05-13 15:30:00	MSFT	Stock	40.345	40.42	40.34	40.42	3010756.0
2014-05-13 16:00:00	MSFT	Stock	40.42	40.57	40.336	40.42	1223462.0
2014-05-13 16:30:00	MSFT	Stock	40.381	40.45	40.376	40.42	59853.0

> showing 50 of 82,098 rows — these rows as CSV

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