PREVIEW / stock_30min / 2011-11-17

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-11-17.parquet
  size:    1.4 MB
  rows:    75,659
  symbols: 3,499

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-17 05:30:00	AAPL	Stock	13.7143	13.7143	13.7143	13.7143	2800.0
2011-11-17 06:30:00	AAPL	Stock	13.7264	13.7264	13.6893	13.6893	28000.0
2011-11-17 07:00:00	AAPL	Stock	13.6893	13.6943	13.6643	13.6821	175000.0
2011-11-17 07:30:00	AAPL	Stock	13.6821	13.7143	13.6736	13.7046	91812.0
2011-11-17 08:00:00	AAPL	Stock	13.7118	13.7136	13.6886	13.7089	206864.0
2011-11-17 08:30:00	AAPL	Stock	13.7125	13.7418	13.7061	13.7207	2359672.0
2011-11-17 09:00:00	AAPL	Stock	13.7189	13.7646	13.6854	13.7032	2356928.0
2011-11-17 09:30:00	AAPL	Stock	13.7136	13.735	13.6429	13.6997	47245772.0
2011-11-17 10:00:00	AAPL	Stock	13.7032	13.7221	13.6471	13.6964	30479708.0
2011-11-17 10:30:00	AAPL	Stock	13.6968	13.7086	13.6571	13.6611	24279836.0
2011-11-17 11:00:00	AAPL	Stock	13.6643	13.6782	13.5971	13.6464	40324928.0
2011-11-17 11:30:00	AAPL	Stock	13.645	13.6696	13.6168	13.6239	16279116.0
2011-11-17 12:00:00	AAPL	Stock	13.6236	13.6329	13.5268	13.5296	31964436.0
2011-11-17 12:30:00	AAPL	Stock	13.5295	13.5328	13.4107	13.4491	65716084.0
2011-11-17 13:00:00	AAPL	Stock	13.4525	13.5122	13.4161	13.4857	34749960.0
2011-11-17 13:30:00	AAPL	Stock	13.4825	13.4886	13.4321	13.4707	30672208.0
2011-11-17 14:00:00	AAPL	Stock	13.4668	13.4821	13.4318	13.4748	28655620.0
2011-11-17 14:30:00	AAPL	Stock	13.4729	13.5168	13.4532	13.4756	27713168.0
2011-11-17 15:00:00	AAPL	Stock	13.4746	13.4979	13.4364	13.4577	30393244.0
2011-11-17 15:30:00	AAPL	Stock	13.4582	13.4932	13.42	13.4789	50758596.0
2011-11-17 16:00:00	AAPL	Stock	13.4904	13.5399	13.463	13.4789	9656388.0
2011-11-17 16:30:00	AAPL	Stock	13.4789	13.5089	13.4279	13.5	1097432.0
2011-11-17 17:00:00	AAPL	Stock	13.5096	13.5214	13.4789	13.5089	139496.0
2011-11-17 17:30:00	AAPL	Stock	13.5029	13.5161	13.4789	13.4789	96012.0
2011-11-17 18:00:00	AAPL	Stock	13.5064	13.5064	13.4789	13.4911	192164.0
2011-11-17 18:30:00	AAPL	Stock	13.4879	13.4893	13.4793	13.4793	40768.0
2011-11-17 19:00:00	AAPL	Stock	13.4821	13.4954	13.4821	13.4821	68432.0
2011-11-17 19:30:00	AAPL	Stock	13.5	13.5104	13.5	13.5	30072.0
2011-11-17 04:00:00	MSFT	Stock	26.0	26.0	26.0	26.0	150.0
2011-11-17 06:30:00	MSFT	Stock	26.01	26.01	25.92	25.92	700.0
2011-11-17 07:00:00	MSFT	Stock	25.9	25.95	25.84	25.88	6500.0
2011-11-17 07:30:00	MSFT	Stock	25.89	25.96	25.87	25.93	4935.0
2011-11-17 08:00:00	MSFT	Stock	26.0	26.01	25.9	25.92	35483.0
2011-11-17 08:30:00	MSFT	Stock	25.97	26.12	25.5	26.0	585251.0
2011-11-17 09:00:00	MSFT	Stock	26.03	26.12	25.97	26.02	40012.0
2011-11-17 09:30:00	MSFT	Stock	26.01	26.04	25.87	25.94	5189907.0
2011-11-17 10:00:00	MSFT	Stock	25.93	25.99	25.85	25.989	4602391.0
2011-11-17 10:30:00	MSFT	Stock	25.99	25.99	25.9	25.915	2980367.0
2011-11-17 11:00:00	MSFT	Stock	25.92	25.939	25.81	25.89	4234890.0
2011-11-17 11:30:00	MSFT	Stock	25.895	25.958	25.86	25.889	2207479.0
2011-11-17 12:00:00	MSFT	Stock	25.89	25.92	25.8	25.81	2925327.0
2011-11-17 12:30:00	MSFT	Stock	25.81	25.815	25.6	25.72	8060699.0
2011-11-17 13:00:00	MSFT	Stock	25.72	25.74	25.57	25.69	4297133.0
2011-11-17 13:30:00	MSFT	Stock	25.69	25.695	25.56	25.669	4280173.0
2011-11-17 14:00:00	MSFT	Stock	25.65	25.658	25.49	25.55	4694657.0
2011-11-17 14:30:00	MSFT	Stock	25.55	25.65	25.535	25.595	4462308.0
2011-11-17 15:00:00	MSFT	Stock	25.59	25.64	25.48	25.51	5613988.0
2011-11-17 15:30:00	MSFT	Stock	25.51	25.58	25.44	25.57	10025047.0
2011-11-17 16:00:00	MSFT	Stock	25.58	25.945	25.54	25.59	3541668.0
2011-11-17 16:30:00	MSFT	Stock	25.6	25.6	25.455	25.6	283772.0

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

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