PREVIEW / stock_30min / 2011-01-27

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-27.parquet
  size:    1.4 MB
  rows:    75,217
  symbols: 3,540

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-27 04:00:00	AAPL	Stock	12.3032	12.3032	12.3032	12.3032	5600.0
2011-01-27 05:30:00	AAPL	Stock	12.3107	12.3386	12.3107	12.3386	42000.0
2011-01-27 06:00:00	AAPL	Stock	12.3257	12.3375	12.325	12.3329	38920.0
2011-01-27 06:30:00	AAPL	Stock	12.3189	12.3268	12.3189	12.3268	19600.0
2011-01-27 07:00:00	AAPL	Stock	12.3268	12.3304	12.295	12.3079	93520.0
2011-01-27 07:30:00	AAPL	Stock	12.3186	12.3214	12.3143	12.3186	107324.0
2011-01-27 08:00:00	AAPL	Stock	12.3054	12.3193	12.3018	12.3175	602308.0
2011-01-27 08:30:00	AAPL	Stock	12.3107	12.3107	12.25	12.2661	1338204.0
2011-01-27 09:00:00	AAPL	Stock	12.2661	12.2961	12.2543	12.2779	1929676.0
2011-01-27 09:30:00	AAPL	Stock	12.2779	12.3025	12.244	12.2914	50871716.0
2011-01-27 10:00:00	AAPL	Stock	12.2936	12.3036	12.2646	12.2982	25161080.0
2011-01-27 10:30:00	AAPL	Stock	12.2982	12.3105	12.2679	12.2764	19079312.0
2011-01-27 11:00:00	AAPL	Stock	12.2764	12.2818	12.2571	12.2746	22460844.0
2011-01-27 11:30:00	AAPL	Stock	12.2767	12.2857	12.2593	12.2796	14545804.0
2011-01-27 12:00:00	AAPL	Stock	12.2805	12.2943	12.2711	12.2854	15004780.0
2011-01-27 12:30:00	AAPL	Stock	12.2854	12.3014	12.2764	12.2989	13673716.0
2011-01-27 13:00:00	AAPL	Stock	12.2989	12.2989	12.2821	12.2832	10987172.0
2011-01-27 13:30:00	AAPL	Stock	12.2836	12.2893	12.271	12.2804	8888068.0
2011-01-27 14:00:00	AAPL	Stock	12.2796	12.2871	12.2643	12.2675	10367392.0
2011-01-27 14:30:00	AAPL	Stock	12.2689	12.2875	12.2671	12.2854	15373316.0
2011-01-27 15:00:00	AAPL	Stock	12.2854	12.2889	12.2732	12.2864	13377420.0
2011-01-27 15:30:00	AAPL	Stock	12.2868	12.2954	12.2486	12.2589	42270144.0
2011-01-27 16:00:00	AAPL	Stock	12.2585	12.2799	12.2361	12.2436	9972116.0
2011-01-27 16:30:00	AAPL	Stock	12.2411	12.2909	12.2368	12.2396	364504.0
2011-01-27 17:00:00	AAPL	Stock	12.2393	12.2411	12.2321	12.24	230888.0
2011-01-27 17:30:00	AAPL	Stock	12.24	12.2411	12.2339	12.2339	121464.0
2011-01-27 18:00:00	AAPL	Stock	12.2357	12.2575	12.2318	12.2371	82320.0
2011-01-27 18:30:00	AAPL	Stock	12.2268	12.2371	12.2268	12.2321	45640.0
2011-01-27 19:00:00	AAPL	Stock	12.2343	12.2371	12.2143	12.2314	134288.0
2011-01-27 19:30:00	AAPL	Stock	12.2307	12.2321	12.2179	12.2261	89236.0
2011-01-27 07:00:00	MSFT	Stock	28.85	28.85	28.8	28.82	2000.0
2011-01-27 07:30:00	MSFT	Stock	28.86	28.91	28.86	28.91	3680.0
2011-01-27 08:00:00	MSFT	Stock	28.9	28.92	28.88	28.9	16293.0
2011-01-27 08:30:00	MSFT	Stock	28.89	28.91	28.85	28.88	19782.0
2011-01-27 09:00:00	MSFT	Stock	28.86	28.89	28.72	28.75	444554.0
2011-01-27 09:30:00	MSFT	Stock	28.75	28.91	28.6	28.738	7913182.0
2011-01-27 10:00:00	MSFT	Stock	28.73	28.74	28.49	28.68	8479615.0
2011-01-27 10:30:00	MSFT	Stock	28.68	28.69	28.565	28.635	4626837.0
2011-01-27 11:00:00	MSFT	Stock	28.63	28.65	28.53	28.578	4307902.0
2011-01-27 11:30:00	MSFT	Stock	28.585	28.64	28.54	28.581	3116611.0
2011-01-27 12:00:00	MSFT	Stock	28.58	28.735	28.58	28.715	2738129.0
2011-01-27 12:30:00	MSFT	Stock	28.71	28.81	28.66	28.81	3879728.0
2011-01-27 13:00:00	MSFT	Stock	28.803	28.9	28.76	28.862	5510728.0
2011-01-27 13:30:00	MSFT	Stock	28.86	28.87	28.76	28.85	3204926.0
2011-01-27 14:00:00	MSFT	Stock	28.85	28.87	28.75	28.77	4969488.0
2011-01-27 14:30:00	MSFT	Stock	28.77	28.83	28.75	28.76	4143555.0
2011-01-27 15:00:00	MSFT	Stock	28.755	28.86	28.67	28.85	7510445.0
2011-01-27 15:30:00	MSFT	Stock	28.84	29.46	28.55	28.89	76189961.0
2011-01-27 16:00:00	MSFT	Stock	28.84	29.05	28.6	28.74	4235003.0
2011-01-27 16:30:00	MSFT	Stock	28.74	28.85	28.6	28.66	415314.0

> showing 50 of 75,217 rows — these rows as CSV

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