PREVIEW / stock_5min / 2012-08-07

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-08-07.parquet
  size:    4.8 MB
  rows:    322,041
  symbols: 3,496

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
2012-08-07 04:00:00	AAPL	Stock	22.3029	22.3214	22.3029	22.3214	5600.0
2012-08-07 04:05:00	AAPL	Stock	22.3246	22.3246	22.3246	22.3246	2800.0
2012-08-07 04:35:00	AAPL	Stock	22.3214	22.3214	22.3214	22.3214	2800.0
2012-08-07 04:45:00	AAPL	Stock	22.3214	22.3214	22.3125	22.3125	10724.0
2012-08-07 04:55:00	AAPL	Stock	22.3125	22.3125	22.3125	22.3125	8260.0
2012-08-07 05:05:00	AAPL	Stock	22.3071	22.3071	22.3071	22.3071	3416.0
2012-08-07 05:15:00	AAPL	Stock	22.3	22.3	22.3	22.3	7000.0
2012-08-07 06:05:00	AAPL	Stock	22.2857	22.2857	22.2857	22.2857	2800.0
2012-08-07 06:10:00	AAPL	Stock	22.2857	22.2857	22.2857	22.2857	4200.0
2012-08-07 06:15:00	AAPL	Stock	22.2857	22.2857	22.2857	22.2857	2800.0
2012-08-07 06:35:00	AAPL	Stock	22.2946	22.2946	22.2946	22.2946	5600.0
2012-08-07 07:00:00	AAPL	Stock	22.2786	22.3036	22.2786	22.3	74060.0
2012-08-07 07:05:00	AAPL	Stock	22.3	22.3125	22.2871	22.3061	89488.0
2012-08-07 07:10:00	AAPL	Stock	22.3061	22.3061	22.295	22.3036	24080.0
2012-08-07 07:15:00	AAPL	Stock	22.2946	22.2946	22.2946	22.2946	2800.0
2012-08-07 07:20:00	AAPL	Stock	22.2946	22.2946	22.2946	22.2946	2800.0
2012-08-07 07:25:00	AAPL	Stock	22.2961	22.2964	22.2875	22.2875	74284.0
2012-08-07 07:30:00	AAPL	Stock	22.2875	22.2875	22.2875	22.2875	27440.0
2012-08-07 07:35:00	AAPL	Stock	22.2946	22.3089	22.2929	22.3036	125720.0
2012-08-07 07:40:00	AAPL	Stock	22.3	22.3	22.2964	22.3	14000.0
2012-08-07 07:45:00	AAPL	Stock	22.2982	22.2982	22.2982	22.2982	2800.0
2012-08-07 07:50:00	AAPL	Stock	22.2911	22.2911	22.2893	22.2893	12880.0
2012-08-07 07:55:00	AAPL	Stock	22.2896	22.2896	22.2625	22.2639	35812.0
2012-08-07 08:00:00	AAPL	Stock	22.2786	22.2893	22.2718	22.285	280616.0
2012-08-07 08:05:00	AAPL	Stock	22.2846	22.2957	22.2725	22.2857	271096.0
2012-08-07 08:10:00	AAPL	Stock	22.2854	22.2929	22.2854	22.2929	83720.0
2012-08-07 08:15:00	AAPL	Stock	22.2911	22.3054	22.2911	22.3036	165340.0
2012-08-07 08:20:00	AAPL	Stock	22.3036	22.3125	22.2979	22.3046	307832.0
2012-08-07 08:25:00	AAPL	Stock	22.3046	22.3104	22.3018	22.3064	130396.0
2012-08-07 08:30:00	AAPL	Stock	22.3021	22.3193	22.3004	22.3164	316008.0
2012-08-07 08:35:00	AAPL	Stock	22.3179	22.3214	22.3143	22.3196	296856.0
2012-08-07 08:40:00	AAPL	Stock	22.3204	22.3207	22.3146	22.3186	99120.0
2012-08-07 08:45:00	AAPL	Stock	22.3164	22.3189	22.3089	22.3111	183932.0
2012-08-07 08:50:00	AAPL	Stock	22.3104	22.3121	22.2986	22.3086	103768.0
2012-08-07 08:55:00	AAPL	Stock	22.3104	22.3104	22.2957	22.2996	137536.0
2012-08-07 09:00:00	AAPL	Stock	22.2961	22.3021	22.2925	22.3004	101052.0
2012-08-07 09:05:00	AAPL	Stock	22.3	22.3	22.2961	22.2993	76664.0
2012-08-07 09:10:00	AAPL	Stock	22.2993	22.3079	22.2993	22.3036	117124.0
2012-08-07 09:15:00	AAPL	Stock	22.3036	22.3064	22.3011	22.3032	49000.0
2012-08-07 09:20:00	AAPL	Stock	22.3	22.3075	22.2964	22.3032	178752.0
2012-08-07 09:25:00	AAPL	Stock	22.3036	22.3036	22.2257	22.2429	1186136.0
2012-08-07 09:30:00	AAPL	Stock	22.2296	22.3161	22.2286	22.3021	14381052.0
2012-08-07 09:35:00	AAPL	Stock	22.3039	22.3214	22.2689	22.295	10846668.0
2012-08-07 09:40:00	AAPL	Stock	22.2957	22.3021	22.2379	22.2471	6197548.0
2012-08-07 09:45:00	AAPL	Stock	22.2411	22.2671	22.1643	22.1901	11978960.0
2012-08-07 09:50:00	AAPL	Stock	22.1911	22.1968	22.0729	22.1125	15668268.0
2012-08-07 09:55:00	AAPL	Stock	22.1125	22.1918	22.1104	22.1913	8354892.0
2012-08-07 10:00:00	AAPL	Stock	22.1914	22.25	22.1886	22.246	9116380.0
2012-08-07 10:05:00	AAPL	Stock	22.2421	22.2768	22.2304	22.2679	9287516.0
2012-08-07 10:10:00	AAPL	Stock	22.268	22.2768	22.2129	22.2146	5467420.0

> showing 50 of 322,041 rows — these rows as CSV

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