PREVIEW / stock_5min / 2013-07-11

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-07-11.parquet
  size:    5.2 MB
  rows:    344,644
  symbols: 3,500

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
2013-07-11 04:05:00	AAPL	Stock	15.1596	15.1596	15.1596	15.1596	11200.0
2013-07-11 04:15:00	AAPL	Stock	15.1586	15.1586	15.1586	15.1586	5600.0
2013-07-11 04:25:00	AAPL	Stock	15.1604	15.1604	15.1604	15.1604	3500.0
2013-07-11 04:35:00	AAPL	Stock	15.1521	15.1521	15.1521	15.1521	2800.0
2013-07-11 04:45:00	AAPL	Stock	15.1521	15.1521	15.1518	15.1518	21112.0
2013-07-11 04:50:00	AAPL	Stock	15.1479	15.1479	15.1479	15.1479	2800.0
2013-07-11 05:00:00	AAPL	Stock	15.1479	15.1479	15.1479	15.1479	2800.0
2013-07-11 05:05:00	AAPL	Stock	15.1479	15.1479	15.1479	15.1479	2800.0
2013-07-11 05:10:00	AAPL	Stock	15.1429	15.1429	15.1429	15.1429	5600.0
2013-07-11 05:15:00	AAPL	Stock	15.1375	15.1375	15.1375	15.1375	2800.0
2013-07-11 05:25:00	AAPL	Stock	15.1293	15.1293	15.1293	15.1293	7000.0
2013-07-11 06:15:00	AAPL	Stock	15.1286	15.1286	15.1286	15.1286	2800.0
2013-07-11 06:25:00	AAPL	Stock	15.1296	15.1296	15.1296	15.1296	2800.0
2013-07-11 07:00:00	AAPL	Stock	15.1286	15.1357	15.1286	15.1357	29316.0
2013-07-11 07:05:00	AAPL	Stock	15.1354	15.1429	15.1354	15.1425	62272.0
2013-07-11 07:10:00	AAPL	Stock	15.1357	15.1357	15.1268	15.1268	6328.0
2013-07-11 07:15:00	AAPL	Stock	15.1129	15.1129	15.1071	15.1071	8400.0
2013-07-11 07:20:00	AAPL	Stock	15.115	15.115	15.115	15.115	2800.0
2013-07-11 07:25:00	AAPL	Stock	15.13	15.13	15.1171	15.1179	13860.0
2013-07-11 07:30:00	AAPL	Stock	15.1146	15.1146	15.1146	15.1146	2800.0
2013-07-11 07:40:00	AAPL	Stock	15.1168	15.1182	15.0857	15.1071	192416.0
2013-07-11 07:45:00	AAPL	Stock	15.1104	15.13	15.1104	15.1214	11200.0
2013-07-11 07:50:00	AAPL	Stock	15.1164	15.1211	15.1075	15.1075	32396.0
2013-07-11 08:00:00	AAPL	Stock	15.1071	15.1429	15.1071	15.1421	312368.0
2013-07-11 08:05:00	AAPL	Stock	15.1386	15.1386	15.1125	15.1143	192136.0
2013-07-11 08:10:00	AAPL	Stock	15.1246	15.1357	15.1232	15.1339	193452.0
2013-07-11 08:15:00	AAPL	Stock	15.1357	15.1357	15.1304	15.1311	113680.0
2013-07-11 08:20:00	AAPL	Stock	15.1321	15.1357	15.1164	15.1164	85764.0
2013-07-11 08:25:00	AAPL	Stock	15.1186	15.1304	15.1171	15.1304	127120.0
2013-07-11 08:30:00	AAPL	Stock	15.1304	15.1304	15.1071	15.1275	363944.0
2013-07-11 08:35:00	AAPL	Stock	15.1232	15.1246	15.1111	15.1111	81956.0
2013-07-11 08:40:00	AAPL	Stock	15.1118	15.1118	15.0982	15.1114	177940.0
2013-07-11 08:45:00	AAPL	Stock	15.1143	15.1246	15.1143	15.1246	101276.0
2013-07-11 08:50:00	AAPL	Stock	15.1182	15.125	15.1182	15.125	68656.0
2013-07-11 08:55:00	AAPL	Stock	15.1204	15.1204	15.1071	15.1071	106372.0
2013-07-11 09:00:00	AAPL	Stock	15.1071	15.1196	15.0996	15.1196	176120.0
2013-07-11 09:05:00	AAPL	Stock	15.1196	15.125	15.1107	15.1111	76636.0
2013-07-11 09:10:00	AAPL	Stock	15.1125	15.1143	15.1054	15.1071	74480.0
2013-07-11 09:15:00	AAPL	Stock	15.1125	15.1139	15.1075	15.1075	39200.0
2013-07-11 09:20:00	AAPL	Stock	15.1129	15.1139	15.1079	15.1079	107576.0
2013-07-11 09:25:00	AAPL	Stock	15.1071	15.1071	15.0946	15.0961	259560.0
2013-07-11 09:30:00	AAPL	Stock	15.1036	15.1371	15.0418	15.0911	13341664.0
2013-07-11 09:35:00	AAPL	Stock	15.0911	15.1061	15.0668	15.0804	4183760.0
2013-07-11 09:40:00	AAPL	Stock	15.0821	15.1011	15.0546	15.0943	6514928.0
2013-07-11 09:45:00	AAPL	Stock	15.0932	15.1357	15.0904	15.1053	8909348.0
2013-07-11 09:50:00	AAPL	Stock	15.105	15.1414	15.0918	15.1187	6456016.0
2013-07-11 09:55:00	AAPL	Stock	15.1206	15.1214	15.0686	15.1029	7881776.0
2013-07-11 10:00:00	AAPL	Stock	15.1064	15.1118	15.0743	15.0979	6074544.0
2013-07-11 10:05:00	AAPL	Stock	15.0975	15.1046	15.0804	15.09	5131364.0
2013-07-11 10:10:00	AAPL	Stock	15.0954	15.1071	15.0875	15.1071	3613848.0

> showing 50 of 344,644 rows — these rows as CSV

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