PREVIEW / stock_30min / 2012-07-30

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-30.parquet
  size:    1.4 MB
  rows:    74,029
  symbols: 3,502

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-07-30 04:00:00	AAPL	Stock	20.8964	20.8964	20.8964	20.8964	2800.0
2012-07-30 04:30:00	AAPL	Stock	20.8661	20.8679	20.8661	20.8679	8400.0
2012-07-30 05:00:00	AAPL	Stock	20.8682	20.8682	20.8679	20.8682	19600.0
2012-07-30 05:30:00	AAPL	Stock	20.8929	20.9171	20.8929	20.9171	7532.0
2012-07-30 06:00:00	AAPL	Stock	20.9104	20.9104	20.8696	20.8696	19908.0
2012-07-30 06:30:00	AAPL	Stock	20.9107	20.9107	20.8964	20.8964	18928.0
2012-07-30 07:00:00	AAPL	Stock	20.8964	20.9125	20.87	20.9086	188888.0
2012-07-30 07:30:00	AAPL	Stock	20.9071	20.9071	20.8711	20.8839	118580.0
2012-07-30 08:00:00	AAPL	Stock	20.8832	21.1071	20.875	21.08	3983028.0
2012-07-30 08:30:00	AAPL	Stock	21.0732	21.1929	21.0614	21.1071	2047612.0
2012-07-30 09:00:00	AAPL	Stock	21.1064	21.1286	21.0786	21.1029	1198260.0
2012-07-30 09:30:00	AAPL	Stock	21.1029	21.3686	20.9936	21.3179	89611760.0
2012-07-30 10:00:00	AAPL	Stock	21.3199	21.4086	21.2904	21.3346	48283704.0
2012-07-30 10:30:00	AAPL	Stock	21.3361	21.3443	21.2039	21.2229	32552660.0
2012-07-30 11:00:00	AAPL	Stock	21.2236	21.2946	21.1754	21.1993	26924800.0
2012-07-30 11:30:00	AAPL	Stock	21.1936	21.2657	21.1775	21.2571	21874440.0
2012-07-30 12:00:00	AAPL	Stock	21.2528	21.3321	21.2386	21.3218	18356968.0
2012-07-30 12:30:00	AAPL	Stock	21.3218	21.3346	21.2864	21.2921	15283128.0
2012-07-30 13:00:00	AAPL	Stock	21.2939	21.3214	21.2654	21.3082	11069436.0
2012-07-30 13:30:00	AAPL	Stock	21.31	21.3357	21.2857	21.3129	9857064.0
2012-07-30 14:00:00	AAPL	Stock	21.3136	21.3146	21.2686	21.285	13324752.0
2012-07-30 14:30:00	AAPL	Stock	21.2846	21.3036	21.2518	21.2721	14587244.0
2012-07-30 15:00:00	AAPL	Stock	21.2721	21.2821	21.1686	21.2632	21493192.0
2012-07-30 15:30:00	AAPL	Stock	21.2639	21.2964	21.1968	21.2486	34930756.0
2012-07-30 16:00:00	AAPL	Stock	21.2507	21.3196	21.2349	21.2982	6030332.0
2012-07-30 16:30:00	AAPL	Stock	21.2986	21.3204	21.2511	21.3204	661136.0
2012-07-30 17:00:00	AAPL	Stock	21.3193	21.3346	21.2511	21.3214	410396.0
2012-07-30 17:30:00	AAPL	Stock	21.3225	21.3293	21.3214	21.3214	117180.0
2012-07-30 18:00:00	AAPL	Stock	21.3214	21.3261	21.3154	21.3161	130760.0
2012-07-30 18:30:00	AAPL	Stock	21.3129	21.3129	21.3	21.3107	98980.0
2012-07-30 19:00:00	AAPL	Stock	21.3193	21.3282	21.3114	21.3261	126756.0
2012-07-30 19:30:00	AAPL	Stock	21.3261	21.3275	21.3214	21.325	90300.0
2012-07-30 04:00:00	MSFT	Stock	30.09	30.09	30.08	30.08	2740.0
2012-07-30 07:30:00	MSFT	Stock	29.9	29.9	29.9	29.9	142.0
2012-07-30 08:00:00	MSFT	Stock	29.73	29.83	29.73	29.75	4680.0
2012-07-30 08:30:00	MSFT	Stock	29.74	29.77	29.73	29.73	1424.0
2012-07-30 09:00:00	MSFT	Stock	29.72	29.75	29.65	29.74	12658.0
2012-07-30 09:30:00	MSFT	Stock	29.75	29.82	29.61	29.68	3205986.0
2012-07-30 10:00:00	MSFT	Stock	29.675	29.73	29.58	29.66	2515385.0
2012-07-30 10:30:00	MSFT	Stock	29.67	29.68	29.56	29.57	2277927.0
2012-07-30 11:00:00	MSFT	Stock	29.56	29.63	29.47	29.5	2914208.0
2012-07-30 11:30:00	MSFT	Stock	29.5	29.56	29.46	29.545	1901915.0
2012-07-30 12:00:00	MSFT	Stock	29.545	29.55	29.48	29.525	1437856.0
2012-07-30 12:30:00	MSFT	Stock	29.525	29.62	29.49	29.554	1409964.0
2012-07-30 13:00:00	MSFT	Stock	29.56	29.645	29.52	29.63	1105227.0
2012-07-30 13:30:00	MSFT	Stock	29.625	29.66	29.595	29.618	1334211.0
2012-07-30 14:00:00	MSFT	Stock	29.61	29.63	29.57	29.59	1473674.0
2012-07-30 14:30:00	MSFT	Stock	29.59	29.66	29.59	29.645	1595953.0
2012-07-30 15:00:00	MSFT	Stock	29.65	29.65	29.52	29.62	2046587.0
2012-07-30 15:30:00	MSFT	Stock	29.62	29.65	29.54	29.635	3892700.0

> showing 50 of 74,029 rows — these rows as CSV

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