PREVIEW / stock_5min / 2014-01-28

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-01-28.parquet
  size:    5.5 MB
  rows:    364,033
  symbols: 3,546

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-01-28 04:00:00	AAPL	Stock	18.2232	18.5714	18.1982	18.2857	103544.0
2014-01-28 04:05:00	AAPL	Stock	18.2679	18.2679	18.2582	18.2582	8400.0
2014-01-28 04:10:00	AAPL	Stock	18.3054	18.3071	18.2857	18.3071	16800.0
2014-01-28 04:15:00	AAPL	Stock	18.3071	18.3071	18.3071	18.3071	25200.0
2014-01-28 04:20:00	AAPL	Stock	18.3071	18.3071	18.3071	18.3071	19600.0
2014-01-28 04:25:00	AAPL	Stock	18.3214	18.3286	18.3214	18.3286	94332.0
2014-01-28 04:30:00	AAPL	Stock	18.3393	18.3393	18.3361	18.3361	8400.0
2014-01-28 04:35:00	AAPL	Stock	18.3571	18.3679	18.3571	18.3661	87640.0
2014-01-28 04:40:00	AAPL	Stock	18.3625	18.3929	18.3143	18.3179	81592.0
2014-01-28 04:45:00	AAPL	Stock	18.3179	18.3179	18.3068	18.3179	16800.0
2014-01-28 04:50:00	AAPL	Stock	18.3561	18.3561	18.325	18.3411	33600.0
2014-01-28 04:55:00	AAPL	Stock	18.3214	18.3357	18.3214	18.3357	8400.0
2014-01-28 05:00:00	AAPL	Stock	18.3411	18.375	18.3411	18.3571	47600.0
2014-01-28 05:10:00	AAPL	Stock	18.3571	18.3579	18.3532	18.3532	31500.0
2014-01-28 05:15:00	AAPL	Stock	18.3736	18.3757	18.37	18.3757	25200.0
2014-01-28 05:20:00	AAPL	Stock	18.3757	18.3757	18.3757	18.3757	2800.0
2014-01-28 05:25:00	AAPL	Stock	18.3596	18.3596	18.3571	18.3571	5600.0
2014-01-28 05:30:00	AAPL	Stock	18.3482	18.3482	18.3211	18.3211	30772.0
2014-01-28 05:35:00	AAPL	Stock	18.3211	18.3211	18.3079	18.3211	11200.0
2014-01-28 05:40:00	AAPL	Stock	18.3111	18.3111	18.3	18.31	77980.0
2014-01-28 05:45:00	AAPL	Stock	18.3089	18.3211	18.3089	18.3207	15120.0
2014-01-28 05:50:00	AAPL	Stock	18.3211	18.3214	18.3211	18.3214	23828.0
2014-01-28 06:00:00	AAPL	Stock	18.315	18.3189	18.2582	18.2582	259812.0
2014-01-28 06:05:00	AAPL	Stock	18.2639	18.2946	18.25	18.25	225372.0
2014-01-28 06:10:00	AAPL	Stock	18.2443	18.2443	18.2143	18.2232	127904.0
2014-01-28 06:15:00	AAPL	Stock	18.2179	18.2768	18.1989	18.2768	147616.0
2014-01-28 06:20:00	AAPL	Stock	18.2846	18.2857	18.2443	18.2679	38556.0
2014-01-28 06:25:00	AAPL	Stock	18.2771	18.2857	18.275	18.2857	29960.0
2014-01-28 06:30:00	AAPL	Stock	18.2964	18.2964	18.2643	18.2857	61600.0
2014-01-28 06:35:00	AAPL	Stock	18.25	18.2504	18.2179	18.2186	153440.0
2014-01-28 06:40:00	AAPL	Stock	18.2318	18.2679	18.2318	18.2679	24416.0
2014-01-28 06:45:00	AAPL	Stock	18.2679	18.2986	18.2571	18.2571	50792.0
2014-01-28 06:50:00	AAPL	Stock	18.2571	18.2996	18.2571	18.2996	38332.0
2014-01-28 06:55:00	AAPL	Stock	18.3018	18.3036	18.2696	18.2696	47600.0
2014-01-28 07:00:00	AAPL	Stock	18.3032	18.3171	18.2375	18.2432	184716.0
2014-01-28 07:05:00	AAPL	Stock	18.2568	18.2968	18.2564	18.2568	181524.0
2014-01-28 07:10:00	AAPL	Stock	18.2575	18.2657	18.2232	18.2232	210168.0
2014-01-28 07:15:00	AAPL	Stock	18.2321	18.33	18.2179	18.33	291900.0
2014-01-28 07:20:00	AAPL	Stock	18.3218	18.355	18.3025	18.3214	214256.0
2014-01-28 07:25:00	AAPL	Stock	18.3214	18.3518	18.3214	18.3514	163492.0
2014-01-28 07:30:00	AAPL	Stock	18.3457	18.3504	18.2896	18.3143	274792.0
2014-01-28 07:35:00	AAPL	Stock	18.2932	18.3196	18.2857	18.3143	123228.0
2014-01-28 07:40:00	AAPL	Stock	18.3211	18.3321	18.2961	18.3086	156184.0
2014-01-28 07:45:00	AAPL	Stock	18.3036	18.3054	18.2571	18.26	240548.0
2014-01-28 07:50:00	AAPL	Stock	18.2525	18.2746	18.2436	18.2746	649796.0
2014-01-28 07:55:00	AAPL	Stock	18.2671	18.33	18.2671	18.3189	570108.0
2014-01-28 08:00:00	AAPL	Stock	18.3161	18.3489	18.2214	18.2393	1454656.0
2014-01-28 08:05:00	AAPL	Stock	18.2393	18.2671	18.1839	18.1864	963928.0
2014-01-28 08:10:00	AAPL	Stock	18.1918	18.1918	18.1432	18.1579	1177092.0
2014-01-28 08:15:00	AAPL	Stock	18.1579	18.1889	18.1429	18.1429	849576.0

> showing 50 of 364,033 rows — these rows as CSV

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