PREVIEW / stock_30min / 2011-01-12

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-12.parquet
  size:    1.4 MB
  rows:    76,044
  symbols: 3,520

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
2011-01-12 04:00:00	AAPL	Stock	12.2679	12.2896	12.2679	12.2896	18200.0
2011-01-12 04:30:00	AAPL	Stock	12.2893	12.2893	12.2893	12.2893	5600.0
2011-01-12 05:00:00	AAPL	Stock	12.285	12.3	12.2679	12.2971	30800.0
2011-01-12 05:30:00	AAPL	Stock	12.3143	12.3214	12.2929	12.3214	25200.0
2011-01-12 06:00:00	AAPL	Stock	12.2893	12.2929	12.2893	12.2929	22400.0
2011-01-12 06:30:00	AAPL	Stock	12.2893	12.2936	12.2732	12.2732	14000.0
2011-01-12 07:00:00	AAPL	Stock	12.2736	12.2857	12.2736	12.2854	232260.0
2011-01-12 07:30:00	AAPL	Stock	12.2821	12.2821	12.25	12.2507	411880.0
2011-01-12 08:00:00	AAPL	Stock	12.25	12.2729	12.2393	12.2589	927360.0
2011-01-12 08:30:00	AAPL	Stock	12.2589	12.2754	12.2511	12.2543	1207304.0
2011-01-12 09:00:00	AAPL	Stock	12.2518	12.2664	12.2329	12.2654	2002868.0
2011-01-12 09:30:00	AAPL	Stock	12.2664	12.2693	12.2143	12.2618	49195216.0
2011-01-12 10:00:00	AAPL	Stock	12.2619	12.2625	12.2275	12.2468	31366636.0
2011-01-12 10:30:00	AAPL	Stock	12.2464	12.2589	12.2436	12.2539	19175996.0
2011-01-12 11:00:00	AAPL	Stock	12.2518	12.2986	12.25	12.2757	31715712.0
2011-01-12 11:30:00	AAPL	Stock	12.2757	12.2818	12.2679	12.2704	11500244.0
2011-01-12 12:00:00	AAPL	Stock	12.2693	12.2786	12.2582	12.2782	12044536.0
2011-01-12 12:30:00	AAPL	Stock	12.2785	12.2785	12.2575	12.2593	9159584.0
2011-01-12 13:00:00	AAPL	Stock	12.2586	12.2746	12.2586	12.2729	7211792.0
2011-01-12 13:30:00	AAPL	Stock	12.2729	12.2975	12.2704	12.2936	17842748.0
2011-01-12 14:00:00	AAPL	Stock	12.2932	12.2961	12.2732	12.2796	16036048.0
2011-01-12 14:30:00	AAPL	Stock	12.2796	12.2857	12.2721	12.2764	13940836.0
2011-01-12 15:00:00	AAPL	Stock	12.2769	12.2929	12.2714	12.2807	18692856.0
2011-01-12 15:30:00	AAPL	Stock	12.2809	12.3011	12.2804	12.3007	36849512.0
2011-01-12 16:00:00	AAPL	Stock	12.2982	12.3036	12.267	12.3036	18457012.0
2011-01-12 16:30:00	AAPL	Stock	12.3	12.3004	12.2349	12.2961	339108.0
2011-01-12 17:00:00	AAPL	Stock	12.2954	12.3029	12.2946	12.3029	314692.0
2011-01-12 17:30:00	AAPL	Stock	12.3	12.3046	12.3	12.3046	93940.0
2011-01-12 18:00:00	AAPL	Stock	12.3068	12.3071	12.3007	12.3068	60648.0
2011-01-12 18:30:00	AAPL	Stock	12.3071	12.3071	12.3036	12.3068	95340.0
2011-01-12 19:00:00	AAPL	Stock	12.3064	12.3121	12.3054	12.3104	109844.0
2011-01-12 19:30:00	AAPL	Stock	12.3107	12.3207	12.3071	12.3193	222460.0
2011-01-12 07:00:00	MSFT	Stock	28.16	28.16	28.16	28.16	5000.0
2011-01-12 07:30:00	MSFT	Stock	28.16	28.24	28.16	28.24	2500.0
2011-01-12 08:00:00	MSFT	Stock	28.2	28.21	28.18	28.2	4900.0
2011-01-12 08:30:00	MSFT	Stock	28.19	28.21	28.17	28.19	20000.0
2011-01-12 09:00:00	MSFT	Stock	28.18	28.18	28.09	28.12	46778.0
2011-01-12 09:30:00	MSFT	Stock	28.12	28.3	28.07	28.3	5187055.0
2011-01-12 10:00:00	MSFT	Stock	28.3	28.38	28.25	28.36	3415065.0
2011-01-12 10:30:00	MSFT	Stock	28.37	28.47	28.34	28.46	3669330.0
2011-01-12 11:00:00	MSFT	Stock	28.465	28.52	28.41	28.52	4185651.0
2011-01-12 11:30:00	MSFT	Stock	28.52	28.59	28.5	28.52	4077566.0
2011-01-12 12:00:00	MSFT	Stock	28.53	28.55	28.49	28.55	2789964.0
2011-01-12 12:30:00	MSFT	Stock	28.54	28.55	28.46	28.48	3355745.0
2011-01-12 13:00:00	MSFT	Stock	28.471	28.51	28.44	28.44	1953166.0
2011-01-12 13:30:00	MSFT	Stock	28.44	28.51	28.4	28.5	4607232.0
2011-01-12 14:00:00	MSFT	Stock	28.49	28.54	28.49	28.51	1924290.0
2011-01-12 14:30:00	MSFT	Stock	28.51	28.56	28.5	28.51	2350773.0
2011-01-12 15:00:00	MSFT	Stock	28.505	28.51	28.42	28.45	4293131.0
2011-01-12 15:30:00	MSFT	Stock	28.445	28.57	28.44	28.55	7161100.0

> showing 50 of 76,044 rows — these rows as CSV

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