PREVIEW / stock_5min / 2014-03-31

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-03-31.parquet
  size:    5.6 MB
  rows:    374,477
  symbols: 3,565

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
2014-03-31 04:30:00	AAPL	Stock	19.2586	19.2586	19.2586	19.2586	2800.0
2014-03-31 04:35:00	AAPL	Stock	19.275	19.275	19.2729	19.2729	5600.0
2014-03-31 04:40:00	AAPL	Stock	19.2729	19.2857	19.2729	19.2857	5600.0
2014-03-31 05:15:00	AAPL	Stock	19.2807	19.2857	19.2807	19.2857	5600.0
2014-03-31 07:00:00	AAPL	Stock	19.2875	19.2875	19.2857	19.2857	9772.0
2014-03-31 07:20:00	AAPL	Stock	19.2789	19.2789	19.2789	19.2789	2800.0
2014-03-31 07:25:00	AAPL	Stock	19.2593	19.2714	19.255	19.2714	42560.0
2014-03-31 07:30:00	AAPL	Stock	19.2811	19.2857	19.2811	19.2857	13300.0
2014-03-31 07:35:00	AAPL	Stock	19.2846	19.2861	19.2768	19.2857	63420.0
2014-03-31 07:45:00	AAPL	Stock	19.2804	19.2804	19.2804	19.2804	5320.0
2014-03-31 07:50:00	AAPL	Stock	19.2821	19.2929	19.2821	19.2929	94304.0
2014-03-31 07:55:00	AAPL	Stock	19.2982	19.2982	19.2836	19.2836	11200.0
2014-03-31 08:00:00	AAPL	Stock	19.2839	19.2893	19.2614	19.2714	88508.0
2014-03-31 08:05:00	AAPL	Stock	19.2679	19.2714	19.2421	19.2421	103908.0
2014-03-31 08:10:00	AAPL	Stock	19.2386	19.2543	19.2386	19.2411	22232.0
2014-03-31 08:15:00	AAPL	Stock	19.2411	19.2411	19.2411	19.2411	14000.0
2014-03-31 08:20:00	AAPL	Stock	19.2464	19.2621	19.2446	19.25	42420.0
2014-03-31 08:25:00	AAPL	Stock	19.2475	19.2475	19.24	19.24	8400.0
2014-03-31 08:30:00	AAPL	Stock	19.2379	19.2668	19.2379	19.2668	64120.0
2014-03-31 08:35:00	AAPL	Stock	19.2554	19.2554	19.2457	19.2457	47712.0
2014-03-31 08:40:00	AAPL	Stock	19.255	19.2582	19.25	19.2557	19600.0
2014-03-31 08:45:00	AAPL	Stock	19.2564	19.2564	19.2443	19.25	54404.0
2014-03-31 08:50:00	AAPL	Stock	19.2468	19.2571	19.2429	19.2571	36400.0
2014-03-31 08:55:00	AAPL	Stock	19.2557	19.2857	19.2557	19.2857	302680.0
2014-03-31 09:00:00	AAPL	Stock	19.2857	19.2989	19.285	19.2857	129976.0
2014-03-31 09:05:00	AAPL	Stock	19.2857	19.2893	19.2857	19.2893	27776.0
2014-03-31 09:10:00	AAPL	Stock	19.2879	19.2939	19.2857	19.2893	101108.0
2014-03-31 09:15:00	AAPL	Stock	19.2939	19.3036	19.2918	19.3036	73780.0
2014-03-31 09:20:00	AAPL	Stock	19.2996	19.3082	19.2929	19.3075	96320.0
2014-03-31 09:25:00	AAPL	Stock	19.3075	19.3214	19.25	19.2704	385728.0
2014-03-31 09:30:00	AAPL	Stock	19.2711	19.3146	19.2146	19.225	9344972.0
2014-03-31 09:35:00	AAPL	Stock	19.2221	19.2661	19.2	19.2371	4613112.0
2014-03-31 09:40:00	AAPL	Stock	19.2339	19.2407	19.2068	19.2125	2996784.0
2014-03-31 09:45:00	AAPL	Stock	19.2057	19.2464	19.2057	19.2464	2433284.0
2014-03-31 09:50:00	AAPL	Stock	19.2464	19.2755	19.23	19.2411	3608780.0
2014-03-31 09:55:00	AAPL	Stock	19.2486	19.2657	19.2318	19.2604	2808596.0
2014-03-31 10:00:00	AAPL	Stock	19.2621	19.2804	19.2486	19.2486	3171168.0
2014-03-31 10:05:00	AAPL	Stock	19.2546	19.2551	19.2286	19.247	2348780.0
2014-03-31 10:10:00	AAPL	Stock	19.2502	19.26	19.225	19.2286	1901872.0
2014-03-31 10:15:00	AAPL	Stock	19.2286	19.2479	19.215	19.215	1912680.0
2014-03-31 10:20:00	AAPL	Stock	19.2161	19.2375	19.2057	19.2236	1743140.0
2014-03-31 10:25:00	AAPL	Stock	19.2261	19.2318	19.2125	19.2221	1237460.0
2014-03-31 10:30:00	AAPL	Stock	19.2261	19.2335	19.2095	19.2136	1208340.0
2014-03-31 10:35:00	AAPL	Stock	19.2146	19.2295	19.2136	19.2186	1003828.0
2014-03-31 10:40:00	AAPL	Stock	19.2186	19.2304	19.2082	19.2143	992768.0
2014-03-31 10:45:00	AAPL	Stock	19.2143	19.2364	19.2121	19.2304	1290016.0
2014-03-31 10:50:00	AAPL	Stock	19.2314	19.2439	19.2279	19.2357	1155364.0
2014-03-31 10:55:00	AAPL	Stock	19.2366	19.2389	19.2089	19.2189	975828.0
2014-03-31 11:00:00	AAPL	Stock	19.2157	19.2232	19.1875	19.1991	2234960.0
2014-03-31 11:05:00	AAPL	Stock	19.1989	19.2129	19.1921	19.2046	1243816.0

> showing 50 of 374,477 rows — these rows as CSV

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