PREVIEW / stock_5min / 2011-10-17

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-10-17.parquet
  size:    4.7 MB
  rows:    318,252
  symbols: 3,476

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-10-17 04:15:00	AAPL	Stock	15.17	15.17	15.17	15.17	2800.0
2011-10-17 04:20:00	AAPL	Stock	15.17	15.17	15.17	15.17	5600.0
2011-10-17 04:55:00	AAPL	Stock	15.2057	15.2143	15.2057	15.2143	20300.0
2011-10-17 05:00:00	AAPL	Stock	15.2321	15.2321	15.2321	15.2321	2800.0
2011-10-17 05:05:00	AAPL	Stock	15.2321	15.2321	15.2321	15.2321	17920.0
2011-10-17 05:10:00	AAPL	Stock	15.2236	15.2236	15.2232	15.2232	5600.0
2011-10-17 05:15:00	AAPL	Stock	15.2321	15.2321	15.2143	15.2143	15400.0
2011-10-17 05:35:00	AAPL	Stock	15.1536	15.1536	15.1536	15.1536	5040.0
2011-10-17 05:40:00	AAPL	Stock	15.1786	15.1786	15.1786	15.1786	2800.0
2011-10-17 05:45:00	AAPL	Stock	15.1464	15.1464	15.1429	15.1429	25200.0
2011-10-17 05:50:00	AAPL	Stock	15.1304	15.1786	15.1304	15.1786	46900.0
2011-10-17 05:55:00	AAPL	Stock	15.1786	15.1786	15.1786	15.1786	6580.0
2011-10-17 06:05:00	AAPL	Stock	15.1429	15.1429	15.1429	15.1429	14000.0
2011-10-17 06:10:00	AAPL	Stock	15.1429	15.1429	15.1429	15.1429	8400.0
2011-10-17 06:15:00	AAPL	Stock	15.1429	15.1607	15.1429	15.1439	42000.0
2011-10-17 06:25:00	AAPL	Stock	15.1607	15.1607	15.1607	15.1607	2800.0
2011-10-17 06:30:00	AAPL	Stock	15.1457	15.1457	15.1457	15.1457	2800.0
2011-10-17 06:35:00	AAPL	Stock	15.1429	15.1429	15.125	15.125	28000.0
2011-10-17 06:40:00	AAPL	Stock	15.125	15.125	15.125	15.125	8400.0
2011-10-17 06:45:00	AAPL	Stock	15.11	15.11	15.0896	15.0896	19600.0
2011-10-17 06:50:00	AAPL	Stock	15.1071	15.125	15.1071	15.1071	33908.0
2011-10-17 06:55:00	AAPL	Stock	15.0921	15.0921	15.0893	15.0921	22400.0
2011-10-17 07:00:00	AAPL	Stock	15.1061	15.1429	15.1061	15.1429	177352.0
2011-10-17 07:05:00	AAPL	Stock	15.1429	15.1429	15.1161	15.1168	171248.0
2011-10-17 07:10:00	AAPL	Stock	15.1154	15.1271	15.1154	15.1271	57960.0
2011-10-17 07:15:00	AAPL	Stock	15.1339	15.1339	15.1071	15.1071	113512.0
2011-10-17 07:20:00	AAPL	Stock	15.1068	15.1125	15.0914	15.1125	57680.0
2011-10-17 07:25:00	AAPL	Stock	15.1089	15.1339	15.1089	15.1339	92960.0
2011-10-17 07:30:00	AAPL	Stock	15.1425	15.1554	15.1393	15.1536	122724.0
2011-10-17 07:35:00	AAPL	Stock	15.1536	15.1679	15.1536	15.1607	96600.0
2011-10-17 07:40:00	AAPL	Stock	15.1607	15.1957	15.1564	15.1893	137900.0
2011-10-17 07:45:00	AAPL	Stock	15.1825	15.1964	15.1786	15.1875	185864.0
2011-10-17 07:50:00	AAPL	Stock	15.1807	15.1807	15.1375	15.1375	123872.0
2011-10-17 07:55:00	AAPL	Stock	15.1321	15.1393	15.1071	15.1096	178500.0
2011-10-17 08:00:00	AAPL	Stock	15.1229	15.1532	15.1075	15.1429	596764.0
2011-10-17 08:05:00	AAPL	Stock	15.1518	15.1639	15.1393	15.1518	548212.0
2011-10-17 08:10:00	AAPL	Stock	15.1518	15.1557	15.1339	15.1346	487144.0
2011-10-17 08:15:00	AAPL	Stock	15.1343	15.1429	15.115	15.1161	489972.0
2011-10-17 08:20:00	AAPL	Stock	15.1182	15.1429	15.1161	15.1429	259280.0
2011-10-17 08:25:00	AAPL	Stock	15.1514	15.1679	15.1254	15.1589	615748.0
2011-10-17 08:30:00	AAPL	Stock	15.1443	15.1629	15.1393	15.1518	314244.0
2011-10-17 08:35:00	AAPL	Stock	15.1536	15.1571	15.1204	15.1232	410340.0
2011-10-17 08:40:00	AAPL	Stock	15.1243	15.1732	15.1093	15.1286	1604428.0
2011-10-17 08:45:00	AAPL	Stock	15.1254	15.1254	15.0893	15.1079	1288224.0
2011-10-17 08:50:00	AAPL	Stock	15.1096	15.1161	15.0929	15.1029	896280.0
2011-10-17 08:55:00	AAPL	Stock	15.0982	15.1029	15.0714	15.0789	1091272.0
2011-10-17 09:00:00	AAPL	Stock	15.08	15.0907	15.0632	15.0668	641480.0
2011-10-17 09:05:00	AAPL	Stock	15.0668	15.0825	15.0571	15.0607	665980.0
2011-10-17 09:10:00	AAPL	Stock	15.0575	15.0611	15.025	15.0271	802620.0
2011-10-17 09:15:00	AAPL	Stock	15.0271	15.0357	14.9918	15.0	1069488.0

> showing 50 of 318,252 rows — these rows as CSV

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