PREVIEW / stock_30min / 2011-03-23

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-23.parquet
  size:    1.4 MB
  rows:    75,219
  symbols: 3,514

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-03-23 04:00:00	AAPL	Stock	12.1875	12.1875	12.1875	12.1875	8400.0
2011-03-23 04:30:00	AAPL	Stock	12.1857	12.1857	12.1829	12.1829	8400.0
2011-03-23 05:30:00	AAPL	Stock	12.175	12.1964	12.175	12.1964	39200.0
2011-03-23 06:00:00	AAPL	Stock	12.1964	12.2207	12.1964	12.2207	11200.0
2011-03-23 06:30:00	AAPL	Stock	12.2186	12.2193	12.2186	12.2193	5600.0
2011-03-23 07:00:00	AAPL	Stock	12.2036	12.2143	12.1946	12.1968	31500.0
2011-03-23 07:30:00	AAPL	Stock	12.1932	12.1932	12.1407	12.1429	120512.0
2011-03-23 08:00:00	AAPL	Stock	12.1429	12.155	12.1357	12.1361	632296.0
2011-03-23 08:30:00	AAPL	Stock	12.1393	12.1536	12.1154	12.1179	467544.0
2011-03-23 09:00:00	AAPL	Stock	12.1157	12.1411	12.1029	12.1114	869428.0
2011-03-23 09:30:00	AAPL	Stock	12.1211	12.1214	12.0629	12.0718	54958204.0
2011-03-23 10:00:00	AAPL	Stock	12.0718	12.0718	11.9982	12.0432	51570876.0
2011-03-23 10:30:00	AAPL	Stock	12.0421	12.0511	12.0136	12.0364	28480368.0
2011-03-23 11:00:00	AAPL	Stock	12.0375	12.0839	12.0366	12.0654	24148432.0
2011-03-23 11:30:00	AAPL	Stock	12.0668	12.0929	12.0668	12.0721	18229932.0
2011-03-23 12:00:00	AAPL	Stock	12.0714	12.1164	12.0625	12.1093	18894512.0
2011-03-23 12:30:00	AAPL	Stock	12.1068	12.1193	12.0825	12.0911	18522392.0
2011-03-23 13:00:00	AAPL	Stock	12.0911	12.0964	12.0725	12.0786	14226464.0
2011-03-23 13:30:00	AAPL	Stock	12.08	12.1046	12.0743	12.0775	16377508.0
2011-03-23 14:00:00	AAPL	Stock	12.0769	12.0904	12.0654	12.0839	14287924.0
2011-03-23 14:30:00	AAPL	Stock	12.0839	12.1282	12.0643	12.1086	28295932.0
2011-03-23 15:00:00	AAPL	Stock	12.1111	12.1507	12.1036	12.1343	32665920.0
2011-03-23 15:30:00	AAPL	Stock	12.1339	12.1418	12.1111	12.1118	32239312.0
2011-03-23 16:00:00	AAPL	Stock	12.1118	12.134	12.0815	12.1179	13315568.0
2011-03-23 16:30:00	AAPL	Stock	12.1089	12.1421	12.1064	12.1136	927220.0
2011-03-23 17:00:00	AAPL	Stock	12.115	12.1154	12.1089	12.1089	182224.0
2011-03-23 17:30:00	AAPL	Stock	12.1121	12.1286	12.1093	12.125	314412.0
2011-03-23 18:00:00	AAPL	Stock	12.1286	12.1304	12.1139	12.13	59808.0
2011-03-23 18:30:00	AAPL	Stock	12.13	12.1314	12.125	12.125	180264.0
2011-03-23 19:00:00	AAPL	Stock	12.1296	12.1296	12.1236	12.1271	35000.0
2011-03-23 19:30:00	AAPL	Stock	12.1286	12.1339	12.1268	12.1339	91224.0
2011-03-23 07:00:00	MSFT	Stock	25.27	25.27	25.27	25.27	200.0
2011-03-23 07:30:00	MSFT	Stock	25.35	25.35	25.35	25.35	200.0
2011-03-23 08:00:00	MSFT	Stock	25.3	25.3	25.3	25.3	400.0
2011-03-23 08:30:00	MSFT	Stock	25.33	25.33	25.33	25.33	200.0
2011-03-23 09:00:00	MSFT	Stock	25.26	25.28	25.22	25.22	11796.0
2011-03-23 09:30:00	MSFT	Stock	25.23	25.41	25.2	25.39	4229980.0
2011-03-23 10:00:00	MSFT	Stock	25.395	25.41	25.18	25.3	4925081.0
2011-03-23 10:30:00	MSFT	Stock	25.3	25.32	25.18	25.18	2276681.0
2011-03-23 11:00:00	MSFT	Stock	25.185	25.316	25.18	25.3	1678247.0
2011-03-23 11:30:00	MSFT	Stock	25.31	25.37	25.3	25.315	1947298.0
2011-03-23 12:00:00	MSFT	Stock	25.315	25.38	25.28	25.38	1655438.0
2011-03-23 12:30:00	MSFT	Stock	25.375	25.38	25.34	25.355	1458279.0
2011-03-23 13:00:00	MSFT	Stock	25.356	25.37	25.32	25.37	1182495.0
2011-03-23 13:30:00	MSFT	Stock	25.362	25.39	25.36	25.365	1779678.0
2011-03-23 14:00:00	MSFT	Stock	25.36	25.37	25.3	25.335	2291168.0
2011-03-23 14:30:00	MSFT	Stock	25.336	25.5	25.33	25.475	3564005.0
2011-03-23 15:00:00	MSFT	Stock	25.48	25.58	25.46	25.57	4631664.0
2011-03-23 15:30:00	MSFT	Stock	25.568	25.61	25.53	25.54	7021547.0
2011-03-23 16:00:00	MSFT	Stock	25.54	25.54	25.388	25.5	4465605.0

> showing 50 of 75,219 rows — these rows as CSV

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