PREVIEW / stock_5min / 2011-05-20

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-05-20.parquet
  size:    4.8 MB
  rows:    323,919
  symbols: 3,534

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-05-20 04:40:00	AAPL	Stock	12.1664	12.1664	12.1664	12.1664	2800.0
2011-05-20 05:25:00	AAPL	Stock	12.1643	12.1643	12.1429	12.1429	14000.0
2011-05-20 07:00:00	AAPL	Stock	12.1429	12.165	12.1429	12.165	12600.0
2011-05-20 07:05:00	AAPL	Stock	12.1629	12.1629	12.1554	12.1554	14000.0
2011-05-20 07:15:00	AAPL	Stock	12.1643	12.1643	12.1625	12.1643	26320.0
2011-05-20 07:20:00	AAPL	Stock	12.1432	12.1432	12.1429	12.1429	14000.0
2011-05-20 07:30:00	AAPL	Stock	12.1432	12.1432	12.1432	12.1432	2800.0
2011-05-20 07:45:00	AAPL	Stock	12.1429	12.1429	12.1429	12.1429	2800.0
2011-05-20 07:55:00	AAPL	Stock	12.1346	12.1346	12.1346	12.1346	2800.0
2011-05-20 08:00:00	AAPL	Stock	12.1375	12.1429	12.1375	12.1414	21504.0
2011-05-20 08:05:00	AAPL	Stock	12.1375	12.1375	12.1286	12.1289	134400.0
2011-05-20 08:10:00	AAPL	Stock	12.1286	12.1618	12.1286	12.1618	92316.0
2011-05-20 08:15:00	AAPL	Stock	12.1286	12.1357	12.1286	12.1357	27440.0
2011-05-20 08:20:00	AAPL	Stock	12.1393	12.1393	12.1393	12.1393	3220.0
2011-05-20 08:30:00	AAPL	Stock	12.1393	12.1393	12.1357	12.1393	13300.0
2011-05-20 08:35:00	AAPL	Stock	12.1429	12.1429	12.1429	12.1429	2800.0
2011-05-20 08:45:00	AAPL	Stock	12.1429	12.1429	12.1429	12.1429	5600.0
2011-05-20 08:55:00	AAPL	Stock	12.1429	12.1429	12.1429	12.1429	8736.0
2011-05-20 09:00:00	AAPL	Stock	12.1432	12.1432	12.1393	12.1393	21056.0
2011-05-20 09:05:00	AAPL	Stock	12.1346	12.1361	12.12	12.1282	213752.0
2011-05-20 09:10:00	AAPL	Stock	12.1411	12.1429	12.125	12.125	129248.0
2011-05-20 09:15:00	AAPL	Stock	12.1268	12.1271	12.125	12.1268	55300.0
2011-05-20 09:20:00	AAPL	Stock	12.1271	12.1271	12.1204	12.1239	107072.0
2011-05-20 09:25:00	AAPL	Stock	12.12	12.1346	12.1189	12.1332	623252.0
2011-05-20 09:30:00	AAPL	Stock	12.1271	12.1768	12.125	12.1543	15148084.0
2011-05-20 09:35:00	AAPL	Stock	12.1532	12.1564	12.1307	12.1471	5190248.0
2011-05-20 09:40:00	AAPL	Stock	12.1482	12.1514	12.1321	12.1402	4872532.0
2011-05-20 09:45:00	AAPL	Stock	12.14	12.1414	12.1175	12.1237	5950840.0
2011-05-20 09:50:00	AAPL	Stock	12.1254	12.1296	12.115	12.1261	4967396.0
2011-05-20 09:55:00	AAPL	Stock	12.125	12.1279	12.0986	12.1114	8064588.0
2011-05-20 10:00:00	AAPL	Stock	12.1114	12.1213	12.1021	12.1086	4287584.0
2011-05-20 10:05:00	AAPL	Stock	12.1086	12.1286	12.1043	12.1105	5115488.0
2011-05-20 10:10:00	AAPL	Stock	12.1093	12.1264	12.1036	12.11	5936392.0
2011-05-20 10:15:00	AAPL	Stock	12.1086	12.1271	12.0986	12.1174	6419028.0
2011-05-20 10:20:00	AAPL	Stock	12.1175	12.1186	12.1079	12.1089	2430120.0
2011-05-20 10:25:00	AAPL	Stock	12.1086	12.1232	12.1075	12.1193	2520924.0
2011-05-20 10:30:00	AAPL	Stock	12.1179	12.125	12.1054	12.1129	2688644.0
2011-05-20 10:35:00	AAPL	Stock	12.1143	12.1175	12.1036	12.1082	2147796.0
2011-05-20 10:40:00	AAPL	Stock	12.1082	12.1121	12.0493	12.0518	11601576.0
2011-05-20 10:45:00	AAPL	Stock	12.0529	12.0875	12.0368	12.0813	11623584.0
2011-05-20 10:50:00	AAPL	Stock	12.0811	12.0821	12.0657	12.0657	4118016.0
2011-05-20 10:55:00	AAPL	Stock	12.0669	12.0696	12.0557	12.0618	4269524.0
2011-05-20 11:00:00	AAPL	Stock	12.0618	12.0625	12.0536	12.0568	3512628.0
2011-05-20 11:05:00	AAPL	Stock	12.0582	12.0714	12.0575	12.0693	2402736.0
2011-05-20 11:10:00	AAPL	Stock	12.0693	12.0746	12.0654	12.0654	3114468.0
2011-05-20 11:15:00	AAPL	Stock	12.0671	12.0725	12.0639	12.0718	2134748.0
2011-05-20 11:20:00	AAPL	Stock	12.0714	12.0779	12.0711	12.0718	2009868.0
2011-05-20 11:25:00	AAPL	Stock	12.0719	12.0729	12.0657	12.0682	2203572.0
2011-05-20 11:30:00	AAPL	Stock	12.0679	12.0807	12.0679	12.0711	3024476.0
2011-05-20 11:35:00	AAPL	Stock	12.0714	12.0882	12.0696	12.0879	2715860.0

> showing 50 of 323,919 rows — these rows as CSV

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