PREVIEW / stock_5min / 2011-06-07

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-06-07.parquet
  size:    4.9 MB
  rows:    333,789
  symbols: 3,543

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-06-07 04:00:00	AAPL	Stock	12.1107	12.1107	12.1107	12.1107	2800.0
2011-06-07 04:35:00	AAPL	Stock	12.1425	12.1425	12.1425	12.1425	2800.0
2011-06-07 04:55:00	AAPL	Stock	12.1425	12.1425	12.1425	12.1425	2800.0
2011-06-07 06:00:00	AAPL	Stock	12.1382	12.1425	12.1382	12.1425	14000.0
2011-06-07 06:20:00	AAPL	Stock	12.1354	12.1354	12.1354	12.1354	2800.0
2011-06-07 07:00:00	AAPL	Stock	12.1107	12.1143	12.0893	12.1071	31668.0
2011-06-07 07:10:00	AAPL	Stock	12.1118	12.1118	12.1071	12.1118	19600.0
2011-06-07 07:15:00	AAPL	Stock	12.1118	12.1118	12.11	12.1104	41580.0
2011-06-07 07:20:00	AAPL	Stock	12.1114	12.1114	12.1061	12.1071	25200.0
2011-06-07 07:25:00	AAPL	Stock	12.1071	12.1071	12.1071	12.1071	6300.0
2011-06-07 07:30:00	AAPL	Stock	12.1071	12.1118	12.1071	12.1071	38052.0
2011-06-07 07:35:00	AAPL	Stock	12.1071	12.1071	12.1064	12.1068	30800.0
2011-06-07 07:40:00	AAPL	Stock	12.1071	12.1071	12.0936	12.0971	81088.0
2011-06-07 07:45:00	AAPL	Stock	12.1046	12.1193	12.1046	12.1154	70000.0
2011-06-07 07:50:00	AAPL	Stock	12.1125	12.115	12.1125	12.1143	25200.0
2011-06-07 07:55:00	AAPL	Stock	12.1157	12.1332	12.1157	12.1161	246904.0
2011-06-07 08:00:00	AAPL	Stock	12.1175	12.1214	12.1043	12.1043	108248.0
2011-06-07 08:05:00	AAPL	Stock	12.1036	12.1179	12.1032	12.1107	116340.0
2011-06-07 08:10:00	AAPL	Stock	12.1114	12.1136	12.1036	12.1036	87360.0
2011-06-07 08:15:00	AAPL	Stock	12.1068	12.1071	12.0982	12.0982	52472.0
2011-06-07 08:20:00	AAPL	Stock	12.0968	12.1014	12.0932	12.0961	74060.0
2011-06-07 08:25:00	AAPL	Stock	12.0957	12.1018	12.0929	12.1014	137228.0
2011-06-07 08:30:00	AAPL	Stock	12.0964	12.1204	12.0932	12.12	273784.0
2011-06-07 08:35:00	AAPL	Stock	12.1164	12.1164	12.1079	12.115	76188.0
2011-06-07 08:40:00	AAPL	Stock	12.1129	12.115	12.1071	12.1139	92260.0
2011-06-07 08:45:00	AAPL	Stock	12.1104	12.1161	12.1104	12.1161	53200.0
2011-06-07 08:50:00	AAPL	Stock	12.1168	12.12	12.1014	12.1079	340704.0
2011-06-07 08:55:00	AAPL	Stock	12.1107	12.1114	12.1071	12.1114	138292.0
2011-06-07 09:00:00	AAPL	Stock	12.1118	12.1211	12.1075	12.1211	174048.0
2011-06-07 09:05:00	AAPL	Stock	12.1214	12.1239	12.1182	12.1182	105616.0
2011-06-07 09:10:00	AAPL	Stock	12.1186	12.1239	12.1171	12.1214	189700.0
2011-06-07 09:15:00	AAPL	Stock	12.1214	12.1239	12.1164	12.1204	194320.0
2011-06-07 09:20:00	AAPL	Stock	12.1229	12.1243	12.1221	12.1232	70000.0
2011-06-07 09:25:00	AAPL	Stock	12.1186	12.1186	12.0725	12.0786	1424836.0
2011-06-07 09:30:00	AAPL	Stock	12.0786	12.0793	12.0129	12.0379	25919936.0
2011-06-07 09:35:00	AAPL	Stock	12.0375	12.0379	11.9689	11.9854	21769888.0
2011-06-07 09:40:00	AAPL	Stock	11.9854	11.9857	11.9526	11.962	21761460.0
2011-06-07 09:45:00	AAPL	Stock	11.9611	11.9746	11.9429	11.9548	17414012.0
2011-06-07 09:50:00	AAPL	Stock	11.9561	11.9614	11.9261	11.934	16989420.0
2011-06-07 09:55:00	AAPL	Stock	11.9339	11.9459	11.9046	11.9229	18032364.0
2011-06-07 10:00:00	AAPL	Stock	11.9214	11.9418	11.9075	11.9345	13672708.0
2011-06-07 10:05:00	AAPL	Stock	11.935	11.9516	11.9307	11.9454	11001760.0
2011-06-07 10:10:00	AAPL	Stock	11.9414	11.98	11.9304	11.9786	11740316.0
2011-06-07 10:15:00	AAPL	Stock	11.9786	11.9939	11.9664	11.9696	8568336.0
2011-06-07 10:20:00	AAPL	Stock	11.9693	11.9782	11.9582	11.9736	5738096.0
2011-06-07 10:25:00	AAPL	Stock	11.9743	11.9843	11.9471	11.9557	5287212.0
2011-06-07 10:30:00	AAPL	Stock	11.9543	11.9704	11.9542	11.9629	4285876.0
2011-06-07 10:35:00	AAPL	Stock	11.9629	11.9779	11.9575	11.9718	4863404.0
2011-06-07 10:40:00	AAPL	Stock	11.9718	11.9746	11.9361	11.9508	6165656.0
2011-06-07 10:45:00	AAPL	Stock	11.9536	11.9589	11.9368	11.9575	2824612.0

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

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