PREVIEW / stock_5min / 2013-04-09

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-04-09.parquet
  size:    4.9 MB
  rows:    324,789
  symbols: 3,494

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-04-09 05:20:00	AAPL	Stock	15.2668	15.2668	15.2668	15.2668	23772.0
2013-04-09 05:40:00	AAPL	Stock	15.25	15.25	15.25	15.25	2800.0
2013-04-09 05:55:00	AAPL	Stock	15.25	15.25	15.25	15.25	5600.0
2013-04-09 06:10:00	AAPL	Stock	15.25	15.25	15.25	15.25	2800.0
2013-04-09 06:50:00	AAPL	Stock	15.2464	15.2464	15.2464	15.2464	2800.0
2013-04-09 07:00:00	AAPL	Stock	15.2464	15.2514	15.2464	15.2514	28000.0
2013-04-09 07:05:00	AAPL	Stock	15.2514	15.2514	15.2514	15.2514	5600.0
2013-04-09 07:15:00	AAPL	Stock	15.2671	15.2671	15.2668	15.2668	16156.0
2013-04-09 07:20:00	AAPL	Stock	15.2671	15.2704	15.2671	15.2704	11452.0
2013-04-09 07:25:00	AAPL	Stock	15.28	15.28	15.2646	15.28	9828.0
2013-04-09 07:30:00	AAPL	Stock	15.2696	15.2696	15.2696	15.2696	3052.0
2013-04-09 07:35:00	AAPL	Stock	15.2675	15.2675	15.2675	15.2675	2800.0
2013-04-09 07:40:00	AAPL	Stock	15.2625	15.2625	15.2625	15.2625	2800.0
2013-04-09 07:45:00	AAPL	Stock	15.2571	15.2618	15.2557	15.2557	11396.0
2013-04-09 07:50:00	AAPL	Stock	15.2525	15.2607	15.2496	15.2521	77000.0
2013-04-09 08:00:00	AAPL	Stock	15.2486	15.28	15.2218	15.2318	155680.0
2013-04-09 08:05:00	AAPL	Stock	15.2318	15.2321	15.1786	15.2232	25592.0
2013-04-09 08:10:00	AAPL	Stock	15.2225	15.2225	15.2204	15.2221	36400.0
2013-04-09 08:15:00	AAPL	Stock	15.2286	15.2286	15.1982	15.1982	116592.0
2013-04-09 08:20:00	AAPL	Stock	15.2054	15.2057	15.1814	15.1825	180180.0
2013-04-09 08:25:00	AAPL	Stock	15.1864	15.2054	15.1864	15.2029	107184.0
2013-04-09 08:30:00	AAPL	Stock	15.2029	15.2275	15.1982	15.2268	115808.0
2013-04-09 08:35:00	AAPL	Stock	15.2232	15.2243	15.2207	15.2207	29400.0
2013-04-09 08:40:00	AAPL	Stock	15.2207	15.2211	15.2143	15.2143	71932.0
2013-04-09 08:45:00	AAPL	Stock	15.215	15.2375	15.215	15.2214	179060.0
2013-04-09 08:50:00	AAPL	Stock	15.2318	15.2386	15.225	15.2254	109200.0
2013-04-09 08:55:00	AAPL	Stock	15.2321	15.2364	15.2289	15.2364	44940.0
2013-04-09 09:00:00	AAPL	Stock	15.2386	15.2429	15.2357	15.2375	56308.0
2013-04-09 09:05:00	AAPL	Stock	15.2375	15.25	15.2375	15.25	27720.0
2013-04-09 09:10:00	AAPL	Stock	15.2482	15.2482	15.2296	15.2393	162988.0
2013-04-09 09:15:00	AAPL	Stock	15.2379	15.25	15.2379	15.2471	75264.0
2013-04-09 09:20:00	AAPL	Stock	15.2429	15.2761	15.2411	15.2757	247324.0
2013-04-09 09:25:00	AAPL	Stock	15.2643	15.2643	15.2286	15.2286	242564.0
2013-04-09 09:30:00	AAPL	Stock	15.2257	15.2493	15.1615	15.1929	9731232.0
2013-04-09 09:35:00	AAPL	Stock	15.1919	15.2082	15.1164	15.1504	8490692.0
2013-04-09 09:40:00	AAPL	Stock	15.15	15.1739	15.1364	15.1671	4596536.0
2013-04-09 09:45:00	AAPL	Stock	15.167	15.1889	15.1443	15.1682	7021336.0
2013-04-09 09:50:00	AAPL	Stock	15.1643	15.1696	15.1304	15.1464	5331508.0
2013-04-09 09:55:00	AAPL	Stock	15.1471	15.1518	15.1261	15.1402	5543412.0
2013-04-09 10:00:00	AAPL	Stock	15.1346	15.1391	15.1136	15.1204	4261600.0
2013-04-09 10:05:00	AAPL	Stock	15.1186	15.1554	15.115	15.1429	3718148.0
2013-04-09 10:10:00	AAPL	Stock	15.1444	15.1625	15.1393	15.1586	3442516.0
2013-04-09 10:15:00	AAPL	Stock	15.1532	15.1618	15.1429	15.1489	2033220.0
2013-04-09 10:20:00	AAPL	Stock	15.1482	15.1693	15.1475	15.1477	3562636.0
2013-04-09 10:25:00	AAPL	Stock	15.1471	15.1536	15.1314	15.145	3887212.0
2013-04-09 10:30:00	AAPL	Stock	15.145	15.1582	15.1314	15.144	3663604.0
2013-04-09 10:35:00	AAPL	Stock	15.1418	15.1568	15.1382	15.1568	3089016.0
2013-04-09 10:40:00	AAPL	Stock	15.1541	15.1568	15.1339	15.1346	1435056.0
2013-04-09 10:45:00	AAPL	Stock	15.1385	15.1479	15.1289	15.1368	2061500.0
2013-04-09 10:50:00	AAPL	Stock	15.1343	15.1471	15.1193	15.1411	4567024.0

> showing 50 of 324,789 rows — these rows as CSV

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