PREVIEW / stock_5min / 2013-07-16

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-07-16.parquet
  size:    5.1 MB
  rows:    338,300
  symbols: 3,497

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-16 04:00:00	AAPL	Stock	15.2786	15.2786	15.2786	15.2786	7140.0
2013-07-16 06:15:00	AAPL	Stock	15.2857	15.2857	15.2857	15.2857	2800.0
2013-07-16 07:00:00	AAPL	Stock	15.2475	15.2475	15.2475	15.2475	6048.0
2013-07-16 07:05:00	AAPL	Stock	15.2607	15.3	15.2607	15.3	11200.0
2013-07-16 07:10:00	AAPL	Stock	15.2889	15.2889	15.2889	15.2889	2800.0
2013-07-16 07:15:00	AAPL	Stock	15.2682	15.2682	15.2607	15.2607	8400.0
2013-07-16 07:20:00	AAPL	Stock	15.2657	15.2657	15.2657	15.2657	2800.0
2013-07-16 07:25:00	AAPL	Stock	15.2657	15.2657	15.2657	15.2657	2800.0
2013-07-16 07:45:00	AAPL	Stock	15.2607	15.2607	15.2607	15.2607	5600.0
2013-07-16 07:50:00	AAPL	Stock	15.2457	15.2457	15.2457	15.2457	2800.0
2013-07-16 08:00:00	AAPL	Stock	15.2432	15.2432	15.2407	15.2411	50400.0
2013-07-16 08:05:00	AAPL	Stock	15.2411	15.2454	15.2411	15.2454	11200.0
2013-07-16 08:10:00	AAPL	Stock	15.2454	15.25	15.2454	15.2468	89544.0
2013-07-16 08:15:00	AAPL	Stock	15.25	15.25	15.25	15.25	29400.0
2013-07-16 08:20:00	AAPL	Stock	15.2471	15.2471	15.2357	15.2357	47068.0
2013-07-16 08:25:00	AAPL	Stock	15.25	15.25	15.2475	15.2493	18060.0
2013-07-16 08:30:00	AAPL	Stock	15.25	15.25	15.24	15.2493	110264.0
2013-07-16 08:35:00	AAPL	Stock	15.2482	15.2482	15.2482	15.2482	2800.0
2013-07-16 08:40:00	AAPL	Stock	15.25	15.25	15.2304	15.2436	227640.0
2013-07-16 08:45:00	AAPL	Stock	15.2464	15.2468	15.2464	15.2468	14000.0
2013-07-16 08:50:00	AAPL	Stock	15.2468	15.2468	15.2439	15.2439	12740.0
2013-07-16 08:55:00	AAPL	Stock	15.2439	15.2493	15.2368	15.2464	133560.0
2013-07-16 09:00:00	AAPL	Stock	15.2457	15.2457	15.2446	15.2446	40068.0
2013-07-16 09:05:00	AAPL	Stock	15.2425	15.2425	15.2154	15.2246	195524.0
2013-07-16 09:10:00	AAPL	Stock	15.2211	15.2321	15.22	15.2321	190848.0
2013-07-16 09:15:00	AAPL	Stock	15.2321	15.2354	15.2264	15.2354	50400.0
2013-07-16 09:20:00	AAPL	Stock	15.2321	15.235	15.2254	15.2296	212520.0
2013-07-16 09:25:00	AAPL	Stock	15.2296	15.2357	15.2257	15.2339	126364.0
2013-07-16 09:30:00	AAPL	Stock	15.2329	15.2586	15.1489	15.2079	14343056.0
2013-07-16 09:35:00	AAPL	Stock	15.2057	15.2746	15.1982	15.2629	7902048.0
2013-07-16 09:40:00	AAPL	Stock	15.2618	15.3121	15.2529	15.2673	7156716.0
2013-07-16 09:45:00	AAPL	Stock	15.265	15.2711	15.2054	15.2325	6050576.0
2013-07-16 09:50:00	AAPL	Stock	15.2361	15.2571	15.2039	15.2115	4313764.0
2013-07-16 09:55:00	AAPL	Stock	15.2129	15.2375	15.2086	15.2239	1854692.0
2013-07-16 10:00:00	AAPL	Stock	15.2279	15.2479	15.2165	15.2214	3429860.0
2013-07-16 10:05:00	AAPL	Stock	15.2214	15.2682	15.19	15.2575	9439108.0
2013-07-16 10:10:00	AAPL	Stock	15.2589	15.2775	15.245	15.2529	3934140.0
2013-07-16 10:15:00	AAPL	Stock	15.2575	15.2707	15.2418	15.2632	2450756.0
2013-07-16 10:20:00	AAPL	Stock	15.2621	15.2636	15.2396	15.25	1766296.0
2013-07-16 10:25:00	AAPL	Stock	15.25	15.2625	15.2118	15.2214	2554384.0
2013-07-16 10:30:00	AAPL	Stock	15.2196	15.2461	15.2114	15.2248	1503572.0
2013-07-16 10:35:00	AAPL	Stock	15.2232	15.2396	15.2182	15.22	1076992.0
2013-07-16 10:40:00	AAPL	Stock	15.2228	15.2554	15.218	15.2425	1722252.0
2013-07-16 10:45:00	AAPL	Stock	15.2425	15.2689	15.2425	15.2629	2316860.0
2013-07-16 10:50:00	AAPL	Stock	15.265	15.2689	15.2489	15.2625	1207976.0
2013-07-16 10:55:00	AAPL	Stock	15.2654	15.2709	15.2275	15.2332	3122896.0
2013-07-16 11:00:00	AAPL	Stock	15.2326	15.2568	15.2257	15.2261	3771012.0
2013-07-16 11:05:00	AAPL	Stock	15.2289	15.2443	15.2254	15.2346	2234708.0
2013-07-16 11:10:00	AAPL	Stock	15.2368	15.2639	15.2368	15.2593	1919288.0
2013-07-16 11:15:00	AAPL	Stock	15.2621	15.2675	15.2314	15.235	2598848.0

> showing 50 of 338,300 rows — these rows as CSV

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