PREVIEW / stock_5min / 2012-01-23

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-01-23.parquet
  size:    4.7 MB
  rows:    317,743
  symbols: 3,538

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-23 04:20:00	AAPL	Stock	15.0786	15.0786	15.0786	15.0786	2800.0
2012-01-23 04:40:00	AAPL	Stock	15.0714	15.0714	15.0714	15.0714	14000.0
2012-01-23 05:10:00	AAPL	Stock	15.0714	15.0714	15.0714	15.0714	2800.0
2012-01-23 05:15:00	AAPL	Stock	15.0714	15.0714	15.0714	15.0714	5600.0
2012-01-23 05:35:00	AAPL	Stock	15.0982	15.0982	15.0982	15.0982	5460.0
2012-01-23 05:50:00	AAPL	Stock	15.1168	15.1168	15.1168	15.1168	2940.0
2012-01-23 05:55:00	AAPL	Stock	15.1214	15.1214	15.1214	15.1214	2800.0
2012-01-23 06:05:00	AAPL	Stock	15.1429	15.1429	15.1429	15.1429	9268.0
2012-01-23 06:10:00	AAPL	Stock	15.1429	15.1429	15.1429	15.1429	8400.0
2012-01-23 06:15:00	AAPL	Stock	15.1429	15.1429	15.1429	15.1429	14000.0
2012-01-23 06:25:00	AAPL	Stock	15.1429	15.1429	15.1429	15.1429	5600.0
2012-01-23 06:30:00	AAPL	Stock	15.1429	15.1429	15.1429	15.1429	16800.0
2012-01-23 06:35:00	AAPL	Stock	15.1429	15.1736	15.1429	15.1736	22400.0
2012-01-23 06:40:00	AAPL	Stock	15.1686	15.1686	15.1518	15.1518	8400.0
2012-01-23 06:50:00	AAPL	Stock	15.1464	15.1507	15.1464	15.1507	5600.0
2012-01-23 06:55:00	AAPL	Stock	15.1464	15.1464	15.1464	15.1464	8400.0
2012-01-23 07:00:00	AAPL	Stock	15.1411	15.1582	15.1329	15.1329	74200.0
2012-01-23 07:05:00	AAPL	Stock	15.1379	15.1429	15.1293	15.1293	49840.0
2012-01-23 07:10:00	AAPL	Stock	15.1354	15.1354	15.1125	15.115	70588.0
2012-01-23 07:15:00	AAPL	Stock	15.1196	15.125	15.0893	15.0893	71736.0
2012-01-23 07:20:00	AAPL	Stock	15.1036	15.1036	15.1036	15.1036	2800.0
2012-01-23 07:25:00	AAPL	Stock	15.1032	15.1057	15.1032	15.1057	5600.0
2012-01-23 07:30:00	AAPL	Stock	15.1071	15.1071	15.1071	15.1071	19600.0
2012-01-23 07:35:00	AAPL	Stock	15.1036	15.1107	15.09	15.1107	52500.0
2012-01-23 07:40:00	AAPL	Stock	15.1089	15.1125	15.1075	15.1125	33320.0
2012-01-23 07:50:00	AAPL	Stock	15.1214	15.1264	15.1125	15.1125	81396.0
2012-01-23 07:55:00	AAPL	Stock	15.1107	15.1107	15.1107	15.1107	2800.0
2012-01-23 08:00:00	AAPL	Stock	15.1186	15.1621	15.1171	15.1321	252532.0
2012-01-23 08:05:00	AAPL	Stock	15.1321	15.1339	15.1246	15.1321	75600.0
2012-01-23 08:10:00	AAPL	Stock	15.1268	15.14	15.125	15.1375	152824.0
2012-01-23 08:15:00	AAPL	Stock	15.1364	15.1461	15.1321	15.1321	292124.0
2012-01-23 08:20:00	AAPL	Stock	15.1332	15.1432	15.1332	15.1425	167972.0
2012-01-23 08:25:00	AAPL	Stock	15.1364	15.1429	15.1304	15.1368	202132.0
2012-01-23 08:30:00	AAPL	Stock	15.1343	15.1357	15.115	15.1154	122808.0
2012-01-23 08:35:00	AAPL	Stock	15.1168	15.1179	15.1082	15.1161	136192.0
2012-01-23 08:40:00	AAPL	Stock	15.1157	15.1239	15.1143	15.1239	72352.0
2012-01-23 08:45:00	AAPL	Stock	15.1157	15.1157	15.1036	15.1071	205352.0
2012-01-23 08:50:00	AAPL	Stock	15.1071	15.1071	15.1039	15.1039	24584.0
2012-01-23 08:55:00	AAPL	Stock	15.1071	15.1071	15.095	15.095	89796.0
2012-01-23 09:00:00	AAPL	Stock	15.0964	15.1071	15.0918	15.0989	87668.0
2012-01-23 09:05:00	AAPL	Stock	15.1036	15.1154	15.1	15.1154	121548.0
2012-01-23 09:10:00	AAPL	Stock	15.1161	15.1193	15.1071	15.1107	155680.0
2012-01-23 09:15:00	AAPL	Stock	15.1036	15.1039	15.0107	15.0768	5624164.0
2012-01-23 09:20:00	AAPL	Stock	15.0846	15.0875	15.0725	15.075	431004.0
2012-01-23 09:25:00	AAPL	Stock	15.0746	15.1071	15.0607	15.0964	799344.0
2012-01-23 09:30:00	AAPL	Stock	15.0964	15.1611	15.0821	15.1486	18301976.0
2012-01-23 09:35:00	AAPL	Stock	15.1486	15.1918	15.1475	15.1732	10733940.0
2012-01-23 09:40:00	AAPL	Stock	15.1739	15.2575	15.1654	15.2554	10758580.0
2012-01-23 09:45:00	AAPL	Stock	15.2539	15.2732	15.225	15.2319	10644928.0
2012-01-23 09:50:00	AAPL	Stock	15.2318	15.2432	15.2207	15.2266	6343204.0

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

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