PREVIEW / stock_5min / 2012-05-14

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-05-14.parquet
  size:    4.8 MB
  rows:    326,762
  symbols: 3,562

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-05-14 04:05:00	AAPL	Stock	20.1071	20.1071	20.1071	20.1071	2800.0
2012-05-14 04:20:00	AAPL	Stock	20.1021	20.1021	20.0893	20.0893	16800.0
2012-05-14 04:35:00	AAPL	Stock	20.1071	20.1071	20.1071	20.1071	2800.0
2012-05-14 06:00:00	AAPL	Stock	20.1346	20.1346	20.1346	20.1346	8400.0
2012-05-14 06:15:00	AAPL	Stock	20.1196	20.1196	20.1196	20.1196	2800.0
2012-05-14 06:25:00	AAPL	Stock	20.1425	20.1425	20.1425	20.1425	2800.0
2012-05-14 06:45:00	AAPL	Stock	20.1732	20.1732	20.1732	20.1732	2800.0
2012-05-14 06:55:00	AAPL	Stock	20.1607	20.1607	20.1607	20.1607	2800.0
2012-05-14 07:00:00	AAPL	Stock	20.1261	20.1261	20.0989	20.0996	14000.0
2012-05-14 07:05:00	AAPL	Stock	20.1086	20.1125	20.1086	20.1093	16800.0
2012-05-14 07:10:00	AAPL	Stock	20.1375	20.1607	20.1129	20.1607	33600.0
2012-05-14 07:15:00	AAPL	Stock	20.1189	20.1189	20.1189	20.1189	2800.0
2012-05-14 07:20:00	AAPL	Stock	20.1411	20.1554	20.1411	20.1554	18844.0
2012-05-14 07:25:00	AAPL	Stock	20.1436	20.1525	20.1429	20.1496	22400.0
2012-05-14 07:30:00	AAPL	Stock	20.1589	20.1604	20.1532	20.1593	14000.0
2012-05-14 07:35:00	AAPL	Stock	20.1636	20.1636	20.1636	20.1636	2800.0
2012-05-14 07:40:00	AAPL	Stock	20.1639	20.1875	20.1639	20.1782	39200.0
2012-05-14 07:45:00	AAPL	Stock	20.1607	20.1779	20.1607	20.1611	21308.0
2012-05-14 07:55:00	AAPL	Stock	20.1571	20.1571	20.1571	20.1571	5600.0
2012-05-14 08:00:00	AAPL	Stock	20.1768	20.1779	20.1221	20.1221	150528.0
2012-05-14 08:05:00	AAPL	Stock	20.1225	20.1332	20.1189	20.1221	88480.0
2012-05-14 08:10:00	AAPL	Stock	20.1218	20.1279	20.1036	20.1086	248304.0
2012-05-14 08:15:00	AAPL	Stock	20.1064	20.1071	20.0982	20.0982	120680.0
2012-05-14 08:20:00	AAPL	Stock	20.0921	20.1114	20.0893	20.1075	144788.0
2012-05-14 08:25:00	AAPL	Stock	20.1171	20.1286	20.1086	20.1107	117600.0
2012-05-14 08:30:00	AAPL	Stock	20.1107	20.1171	20.0929	20.1071	337904.0
2012-05-14 08:35:00	AAPL	Stock	20.1175	20.1175	20.1075	20.1129	22400.0
2012-05-14 08:40:00	AAPL	Stock	20.1196	20.1304	20.1146	20.1264	75964.0
2012-05-14 08:45:00	AAPL	Stock	20.1271	20.1279	20.1196	20.1207	78344.0
2012-05-14 08:50:00	AAPL	Stock	20.125	20.1257	20.1146	20.1214	22400.0
2012-05-14 08:55:00	AAPL	Stock	20.1232	20.1261	20.1175	20.1246	29540.0
2012-05-14 09:00:00	AAPL	Stock	20.125	20.1607	20.125	20.1589	139300.0
2012-05-14 09:05:00	AAPL	Stock	20.1596	20.1721	20.1482	20.1489	95648.0
2012-05-14 09:10:00	AAPL	Stock	20.1468	20.1514	20.1396	20.1429	49728.0
2012-05-14 09:15:00	AAPL	Stock	20.1429	20.1464	20.1339	20.1339	138880.0
2012-05-14 09:20:00	AAPL	Stock	20.1339	20.1421	20.1339	20.1357	148456.0
2012-05-14 09:25:00	AAPL	Stock	20.1364	20.1464	20.0893	20.0907	1006096.0
2012-05-14 09:30:00	AAPL	Stock	20.0914	20.1886	20.0893	20.1796	11792088.0
2012-05-14 09:35:00	AAPL	Stock	20.1775	20.205	20.1429	20.1743	11032364.0
2012-05-14 09:40:00	AAPL	Stock	20.1782	20.2682	20.1339	20.1375	17574116.0
2012-05-14 09:45:00	AAPL	Stock	20.1357	20.1779	20.1125	20.1529	8365672.0
2012-05-14 09:50:00	AAPL	Stock	20.1482	20.2343	20.1393	20.1921	6408584.0
2012-05-14 09:55:00	AAPL	Stock	20.1864	20.2036	20.1429	20.1621	4936820.0
2012-05-14 10:00:00	AAPL	Stock	20.163	20.1689	20.1429	20.1576	5371856.0
2012-05-14 10:05:00	AAPL	Stock	20.1551	20.1629	20.1125	20.1307	6830376.0
2012-05-14 10:10:00	AAPL	Stock	20.1307	20.135	20.0775	20.0986	7340816.0
2012-05-14 10:15:00	AAPL	Stock	20.0902	20.1209	20.075	20.0786	5378632.0
2012-05-14 10:20:00	AAPL	Stock	20.0793	20.1532	20.0714	20.1308	6575604.0
2012-05-14 10:25:00	AAPL	Stock	20.1307	20.14	20.0893	20.1039	3870804.0
2012-05-14 10:30:00	AAPL	Stock	20.1016	20.15	20.0929	20.1429	4013520.0

> showing 50 of 326,762 rows — these rows as CSV

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