PREVIEW / stock_30min / 2012-04-27

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-27.parquet
  size:    1.5 MB
  rows:    80,415
  symbols: 3,531

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-04-27 04:00:00	AAPL	Stock	21.6136	21.6518	21.6136	21.6429	20160.0
2012-04-27 04:30:00	AAPL	Stock	21.6536	21.675	21.6536	21.675	19208.0
2012-04-27 05:00:00	AAPL	Stock	21.6768	21.6786	21.6768	21.6786	16100.0
2012-04-27 05:30:00	AAPL	Stock	21.6436	21.6614	21.6436	21.6607	11200.0
2012-04-27 06:00:00	AAPL	Stock	21.6782	21.6786	21.6671	21.6786	15288.0
2012-04-27 06:30:00	AAPL	Stock	21.6821	21.7036	21.6821	21.7036	5908.0
2012-04-27 07:00:00	AAPL	Stock	21.6964	21.7321	21.6964	21.7143	123368.0
2012-04-27 07:30:00	AAPL	Stock	21.7143	21.7232	21.6679	21.7043	182784.0
2012-04-27 08:00:00	AAPL	Stock	21.6911	21.7357	21.6454	21.6957	714504.0
2012-04-27 08:30:00	AAPL	Stock	21.685	21.685	21.5696	21.6246	1834336.0
2012-04-27 09:00:00	AAPL	Stock	21.6257	21.6493	21.6	21.6132	1116248.0
2012-04-27 09:30:00	AAPL	Stock	21.6096	21.6296	21.4464	21.5079	88911088.0
2012-04-27 10:00:00	AAPL	Stock	21.505	21.5768	21.4582	21.5736	46163768.0
2012-04-27 10:30:00	AAPL	Stock	21.5736	21.5886	21.5268	21.5654	33546968.0
2012-04-27 11:00:00	AAPL	Stock	21.5618	21.6214	21.5429	21.5868	27865600.0
2012-04-27 11:30:00	AAPL	Stock	21.5864	21.6493	21.585	21.61	25312140.0
2012-04-27 12:00:00	AAPL	Stock	21.6104	21.6161	21.5389	21.5639	17882732.0
2012-04-27 12:30:00	AAPL	Stock	21.5639	21.5732	21.5357	21.5607	14122696.0
2012-04-27 13:00:00	AAPL	Stock	21.5621	21.5746	21.5536	21.5643	8571948.0
2012-04-27 13:30:00	AAPL	Stock	21.5661	21.6071	21.5625	21.5743	14461860.0
2012-04-27 14:00:00	AAPL	Stock	21.5725	21.5746	21.4832	21.4857	22955520.0
2012-04-27 14:30:00	AAPL	Stock	21.4886	21.5411	21.4793	21.5371	19000996.0
2012-04-27 15:00:00	AAPL	Stock	21.5389	21.5446	21.4932	21.5236	21214900.0
2012-04-27 15:30:00	AAPL	Stock	21.5221	21.5357	21.4954	21.5357	47708724.0
2012-04-27 16:00:00	AAPL	Stock	21.5357	21.5671	21.5161	21.5318	9333268.0
2012-04-27 16:30:00	AAPL	Stock	21.5325	21.5393	21.5321	21.5393	379820.0
2012-04-27 17:00:00	AAPL	Stock	21.5361	21.5518	21.5357	21.5357	323652.0
2012-04-27 17:30:00	AAPL	Stock	21.5368	21.5368	21.5261	21.5286	55328.0
2012-04-27 18:00:00	AAPL	Stock	21.5257	21.53	21.5193	21.5214	46144.0
2012-04-27 18:30:00	AAPL	Stock	21.5189	21.5264	21.5189	21.5264	11900.0
2012-04-27 19:00:00	AAPL	Stock	21.5268	21.5311	21.5268	21.5271	34720.0
2012-04-27 19:30:00	AAPL	Stock	21.5304	21.5311	21.5186	21.5311	109788.0
2012-04-27 07:00:00	MSFT	Stock	32.07	32.1	32.06	32.1	2700.0
2012-04-27 07:30:00	MSFT	Stock	32.05	32.1	32.05	32.1	5000.0
2012-04-27 08:00:00	MSFT	Stock	32.05	32.13	32.05	32.11	7775.0
2012-04-27 08:30:00	MSFT	Stock	32.09	32.7	32.05	32.21	30576.0
2012-04-27 09:00:00	MSFT	Stock	32.25	32.29	32.13	32.15	26567.0
2012-04-27 09:30:00	MSFT	Stock	32.16	32.22	31.93	31.99	4293471.0
2012-04-27 10:00:00	MSFT	Stock	31.99	32.05	31.91	31.97	3203101.0
2012-04-27 10:30:00	MSFT	Stock	31.98	32.06	31.94	32.04	2864352.0
2012-04-27 11:00:00	MSFT	Stock	32.04	32.09	31.99	32.045	2399791.0
2012-04-27 11:30:00	MSFT	Stock	32.05	32.05	31.97	32.0	2305747.0
2012-04-27 12:00:00	MSFT	Stock	32.0	32.015	31.97	32.0	1373810.0
2012-04-27 12:30:00	MSFT	Stock	32.0	32.01	31.98	31.999	1212148.0
2012-04-27 13:00:00	MSFT	Stock	32.0	32.01	31.98	32.0	1581665.0
2012-04-27 13:30:00	MSFT	Stock	32.0	32.07	31.99	32.04	2787515.0
2012-04-27 14:00:00	MSFT	Stock	32.036	32.08	32.03	32.03	3300007.0
2012-04-27 14:30:00	MSFT	Stock	32.03	32.05	32.01	32.025	2047653.0
2012-04-27 15:00:00	MSFT	Stock	32.025	32.025	31.95	31.95	2134329.0
2012-04-27 15:30:00	MSFT	Stock	31.95	32.0	31.88	31.98	5306519.0

> showing 50 of 80,415 rows — these rows as CSV

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