PREVIEW / stock_30min / 2011-11-29

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-11-29.parquet
  size:    1.4 MB
  rows:    73,524
  symbols: 3,528

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-11-29 05:00:00	AAPL	Stock	13.5	13.5	13.5	13.5	8400.0
2011-11-29 05:30:00	AAPL	Stock	13.5414	13.5414	13.5357	13.5357	11200.0
2011-11-29 06:00:00	AAPL	Stock	13.5411	13.5411	13.5411	13.5411	17500.0
2011-11-29 06:30:00	AAPL	Stock	13.5	13.5357	13.5	13.5357	30800.0
2011-11-29 07:00:00	AAPL	Stock	13.4721	13.4904	13.4371	13.4375	184940.0
2011-11-29 07:30:00	AAPL	Stock	13.4321	13.4375	13.4018	13.4018	236516.0
2011-11-29 08:00:00	AAPL	Stock	13.4107	13.4823	13.3961	13.4464	753144.0
2011-11-29 08:30:00	AAPL	Stock	13.4418	13.4418	13.4125	13.4214	449876.0
2011-11-29 09:00:00	AAPL	Stock	13.4286	13.4286	13.3968	13.4221	1080072.0
2011-11-29 09:30:00	AAPL	Stock	13.4182	13.4829	13.3532	13.4661	47901868.0
2011-11-29 10:00:00	AAPL	Stock	13.4768	13.5296	13.4236	13.4896	38067260.0
2011-11-29 10:30:00	AAPL	Stock	13.4936	13.5057	13.4161	13.4471	26208336.0
2011-11-29 11:00:00	AAPL	Stock	13.4471	13.45	13.3646	13.3771	21531412.0
2011-11-29 11:30:00	AAPL	Stock	13.3782	13.4143	13.2393	13.2846	40473692.0
2011-11-29 12:00:00	AAPL	Stock	13.2829	13.3289	13.2554	13.3068	29124424.0
2011-11-29 12:30:00	AAPL	Stock	13.3067	13.3067	13.2439	13.3	21896336.0
2011-11-29 13:00:00	AAPL	Stock	13.2957	13.2979	13.2214	13.2931	20923252.0
2011-11-29 13:30:00	AAPL	Stock	13.2911	13.3011	13.2525	13.2639	13062588.0
2011-11-29 14:00:00	AAPL	Stock	13.2582	13.3432	13.25	13.3346	18630276.0
2011-11-29 14:30:00	AAPL	Stock	13.3346	13.41	13.3306	13.3693	29978032.0
2011-11-29 15:00:00	AAPL	Stock	13.3693	13.4364	13.3521	13.3882	24271044.0
2011-11-29 15:30:00	AAPL	Stock	13.3889	13.4082	13.3249	13.3286	33108880.0
2011-11-29 16:00:00	AAPL	Stock	13.3286	13.4396	13.3254	13.3254	4961376.0
2011-11-29 16:30:00	AAPL	Stock	13.3254	13.3905	13.2968	13.3011	514276.0
2011-11-29 17:00:00	AAPL	Stock	13.3043	13.3054	13.2857	13.2864	68852.0
2011-11-29 17:30:00	AAPL	Stock	13.2925	13.3046	13.2775	13.3046	169848.0
2011-11-29 18:00:00	AAPL	Stock	13.3079	13.3286	13.2932	13.2932	27692.0
2011-11-29 18:30:00	AAPL	Stock	13.2964	13.3036	13.2804	13.2821	162456.0
2011-11-29 19:00:00	AAPL	Stock	13.2821	13.2975	13.2821	13.2879	114800.0
2011-11-29 19:30:00	AAPL	Stock	13.2886	13.3032	13.2886	13.2946	37156.0
2011-11-29 07:30:00	MSFT	Stock	24.9	24.9	24.9	24.9	100.0
2011-11-29 08:00:00	MSFT	Stock	24.87	24.87	24.81	24.81	7600.0
2011-11-29 08:30:00	MSFT	Stock	24.81	24.81	24.73	24.8	11516.0
2011-11-29 09:00:00	MSFT	Stock	24.76	24.88	24.73	24.84	14693.0
2011-11-29 09:30:00	MSFT	Stock	24.86	25.04	24.75	24.95	3867075.0
2011-11-29 10:00:00	MSFT	Stock	24.95	25.02	24.84	24.919	4105610.0
2011-11-29 10:30:00	MSFT	Stock	24.92	24.95	24.85	24.88	2374594.0
2011-11-29 11:00:00	MSFT	Stock	24.875	24.92	24.82	24.9	2244962.0
2011-11-29 11:30:00	MSFT	Stock	24.9	24.98	24.75	24.87	4978359.0
2011-11-29 12:00:00	MSFT	Stock	24.865	25.03	24.86	24.942	3559113.0
2011-11-29 12:30:00	MSFT	Stock	24.94	24.96	24.83	24.86	1981529.0
2011-11-29 13:00:00	MSFT	Stock	24.86	24.92	24.8	24.884	1365438.0
2011-11-29 13:30:00	MSFT	Stock	24.88	24.89	24.8	24.81	1840373.0
2011-11-29 14:00:00	MSFT	Stock	24.805	24.89	24.78	24.88	1857218.0
2011-11-29 14:30:00	MSFT	Stock	24.88	24.97	24.88	24.89	2243759.0
2011-11-29 15:00:00	MSFT	Stock	24.89	25.03	24.89	24.975	2415708.0
2011-11-29 15:30:00	MSFT	Stock	24.975	25.0	24.82	24.841	6031429.0
2011-11-29 16:00:00	MSFT	Stock	24.84	24.969	24.84	24.84	1297098.0
2011-11-29 16:30:00	MSFT	Stock	24.86	24.895	24.73	24.8	9750.0
2011-11-29 17:00:00	MSFT	Stock	24.76	24.81	24.76	24.81	200.0

> showing 50 of 73,524 rows — these rows as CSV

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