PREVIEW / stock_5min / 2013-06-27

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-06-27.parquet
  size:    5.2 MB
  rows:    346,656
  symbols: 3,527

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-06-27 05:10:00	AAPL	Stock	14.2054	14.2054	14.2054	14.2054	2800.0
2013-06-27 05:35:00	AAPL	Stock	14.2018	14.2018	14.2	14.2	14000.0
2013-06-27 06:45:00	AAPL	Stock	14.2143	14.2143	14.2143	14.2143	2800.0
2013-06-27 07:00:00	AAPL	Stock	14.2232	14.2232	14.2232	14.2232	18312.0
2013-06-27 07:10:00	AAPL	Stock	14.2143	14.2143	14.2143	14.2143	2800.0
2013-06-27 07:15:00	AAPL	Stock	14.2143	14.2143	14.1914	14.1914	5600.0
2013-06-27 07:20:00	AAPL	Stock	14.1946	14.1946	14.1868	14.1868	33600.0
2013-06-27 07:30:00	AAPL	Stock	14.1868	14.1875	14.1786	14.1786	10528.0
2013-06-27 07:35:00	AAPL	Stock	14.1779	14.1779	14.1779	14.1779	2800.0
2013-06-27 07:40:00	AAPL	Stock	14.1786	14.1821	14.1732	14.1732	20860.0
2013-06-27 07:45:00	AAPL	Stock	14.1957	14.2321	14.1957	14.2304	70000.0
2013-06-27 07:50:00	AAPL	Stock	14.2204	14.2232	14.2107	14.2107	64176.0
2013-06-27 07:55:00	AAPL	Stock	14.2229	14.2429	14.2229	14.2429	63840.0
2013-06-27 08:00:00	AAPL	Stock	14.2321	14.2368	14.1929	14.2311	85680.0
2013-06-27 08:05:00	AAPL	Stock	14.2286	14.2464	14.2286	14.2464	203560.0
2013-06-27 08:10:00	AAPL	Stock	14.2339	14.2568	14.2311	14.2543	147084.0
2013-06-27 08:15:00	AAPL	Stock	14.25	14.2696	14.2496	14.2571	109228.0
2013-06-27 08:20:00	AAPL	Stock	14.2679	14.2714	14.2521	14.2589	121352.0
2013-06-27 08:25:00	AAPL	Stock	14.2636	14.2643	14.2536	14.2643	19656.0
2013-06-27 08:30:00	AAPL	Stock	14.2675	14.2696	14.2464	14.2536	157500.0
2013-06-27 08:35:00	AAPL	Stock	14.25	14.2589	14.2375	14.2375	306040.0
2013-06-27 08:40:00	AAPL	Stock	14.25	14.25	14.2332	14.2454	71372.0
2013-06-27 08:45:00	AAPL	Stock	14.2375	14.24	14.2375	14.2375	12600.0
2013-06-27 08:50:00	AAPL	Stock	14.2439	14.2439	14.2439	14.2439	2800.0
2013-06-27 08:55:00	AAPL	Stock	14.2429	14.2493	14.2429	14.2493	24500.0
2013-06-27 09:00:00	AAPL	Stock	14.2493	14.2589	14.2436	14.2589	66640.0
2013-06-27 09:05:00	AAPL	Stock	14.2579	14.2579	14.25	14.25	62524.0
2013-06-27 09:10:00	AAPL	Stock	14.2554	14.2554	14.2536	14.2536	12292.0
2013-06-27 09:15:00	AAPL	Stock	14.255	14.2682	14.255	14.2682	75376.0
2013-06-27 09:20:00	AAPL	Stock	14.2632	14.2657	14.25	14.2507	103824.0
2013-06-27 09:25:00	AAPL	Stock	14.2582	14.2593	14.2361	14.2411	197764.0
2013-06-27 09:30:00	AAPL	Stock	14.2589	14.2621	14.1336	14.1339	16496228.0
2013-06-27 09:35:00	AAPL	Stock	14.1339	14.1729	14.1272	14.1357	7251132.0
2013-06-27 09:40:00	AAPL	Stock	14.1368	14.1607	14.1275	14.1357	5818456.0
2013-06-27 09:45:00	AAPL	Stock	14.1357	14.1907	14.1357	14.1725	7477512.0
2013-06-27 09:50:00	AAPL	Stock	14.1732	14.2029	14.1471	14.1569	5243028.0
2013-06-27 09:55:00	AAPL	Stock	14.1575	14.2607	14.1396	14.2514	10865428.0
2013-06-27 10:00:00	AAPL	Stock	14.2514	14.2582	14.2036	14.2107	7620816.0
2013-06-27 10:05:00	AAPL	Stock	14.2107	14.2757	14.2107	14.2573	9774380.0
2013-06-27 10:10:00	AAPL	Stock	14.2589	14.2593	14.2325	14.2425	5543636.0
2013-06-27 10:15:00	AAPL	Stock	14.2425	14.2493	14.2111	14.2321	4359096.0
2013-06-27 10:20:00	AAPL	Stock	14.2307	14.2639	14.2289	14.2525	4108104.0
2013-06-27 10:25:00	AAPL	Stock	14.2539	14.3296	14.2511	14.3043	10684772.0
2013-06-27 10:30:00	AAPL	Stock	14.3075	14.3354	14.2893	14.3049	7359436.0
2013-06-27 10:35:00	AAPL	Stock	14.3045	14.3214	14.2611	14.265	5975228.0
2013-06-27 10:40:00	AAPL	Stock	14.2641	14.2936	14.2379	14.2568	5575192.0
2013-06-27 10:45:00	AAPL	Stock	14.2543	14.2564	14.225	14.2289	5088916.0
2013-06-27 10:50:00	AAPL	Stock	14.2305	14.2561	14.2289	14.2343	2356844.0
2013-06-27 10:55:00	AAPL	Stock	14.2361	14.2568	14.2346	14.2425	2327164.0
2013-06-27 11:00:00	AAPL	Stock	14.2464	14.2582	14.2339	14.2546	1733648.0

> showing 50 of 346,656 rows — these rows as CSV

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