PREVIEW / stock_30min / 2012-10-15

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-15.parquet
  size:    1.4 MB
  rows:    73,042
  symbols: 3,478

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-10-15 04:00:00	AAPL	Stock	22.5357	22.6071	22.5357	22.6071	50400.0
2012-10-15 04:30:00	AAPL	Stock	22.5968	22.6071	22.5968	22.6071	16800.0
2012-10-15 05:00:00	AAPL	Stock	22.6071	22.6214	22.6071	22.6214	9688.0
2012-10-15 05:30:00	AAPL	Stock	22.6393	22.6393	22.6393	22.6393	2800.0
2012-10-15 06:00:00	AAPL	Stock	22.6268	22.6346	22.6268	22.6346	13580.0
2012-10-15 06:30:00	AAPL	Stock	22.6346	22.6346	22.6346	22.6346	7000.0
2012-10-15 07:00:00	AAPL	Stock	22.625	22.6429	22.6004	22.6429	190316.0
2012-10-15 07:30:00	AAPL	Stock	22.6436	22.6436	22.6089	22.6146	244132.0
2012-10-15 08:00:00	AAPL	Stock	22.6129	22.6325	22.5786	22.5857	977564.0
2012-10-15 08:30:00	AAPL	Stock	22.5889	22.6171	22.5536	22.5636	864136.0
2012-10-15 09:00:00	AAPL	Stock	22.5621	22.5911	22.5568	22.5839	1049692.0
2012-10-15 09:30:00	AAPL	Stock	22.5821	22.6686	22.455	22.5186	52109092.0
2012-10-15 10:00:00	AAPL	Stock	22.5186	22.5836	22.3789	22.3914	39695684.0
2012-10-15 10:30:00	AAPL	Stock	22.3843	22.4196	22.2804	22.3848	47195092.0
2012-10-15 11:00:00	AAPL	Stock	22.3918	22.5411	22.3521	22.475	34800388.0
2012-10-15 11:30:00	AAPL	Stock	22.48	22.5804	22.4396	22.4643	31862376.0
2012-10-15 12:00:00	AAPL	Stock	22.4643	22.5	22.3907	22.5	20797084.0
2012-10-15 12:30:00	AAPL	Stock	22.5	22.525	22.4375	22.465	15685740.0
2012-10-15 13:00:00	AAPL	Stock	22.4718	22.545	22.3964	22.4029	19190416.0
2012-10-15 13:30:00	AAPL	Stock	22.3994	22.4596	22.3779	22.4243	16738680.0
2012-10-15 14:00:00	AAPL	Stock	22.4236	22.53	22.4236	22.4911	13724900.0
2012-10-15 14:30:00	AAPL	Stock	22.488	22.5221	22.4411	22.4857	14310156.0
2012-10-15 15:00:00	AAPL	Stock	22.4871	22.6382	22.4554	22.6282	31218264.0
2012-10-15 15:30:00	AAPL	Stock	22.6346	22.6832	22.5754	22.6696	53118996.0
2012-10-15 16:00:00	AAPL	Stock	22.67	22.6768	22.4839	22.6661	23046576.0
2012-10-15 16:30:00	AAPL	Stock	22.6682	22.67	22.4188	22.6607	399644.0
2012-10-15 17:00:00	AAPL	Stock	22.6611	22.6857	22.6611	22.6839	453180.0
2012-10-15 17:30:00	AAPL	Stock	22.6811	22.6911	22.6807	22.6904	78960.0
2012-10-15 18:00:00	AAPL	Stock	22.6893	22.6993	22.6893	22.695	179088.0
2012-10-15 18:30:00	AAPL	Stock	22.6964	22.71	22.6932	22.7071	109200.0
2012-10-15 19:00:00	AAPL	Stock	22.7036	22.7064	22.6929	22.7043	91000.0
2012-10-15 19:30:00	AAPL	Stock	22.7064	22.73	22.7036	22.7271	248024.0
2012-10-15 07:30:00	MSFT	Stock	29.38	29.38	29.38	29.38	500.0
2012-10-15 08:00:00	MSFT	Stock	29.32	29.39	29.32	29.37	9400.0
2012-10-15 08:30:00	MSFT	Stock	29.39	29.43	29.36	29.38	8395.0
2012-10-15 09:00:00	MSFT	Stock	29.37	29.4	29.29	29.32	43707.0
2012-10-15 09:30:00	MSFT	Stock	29.39	29.49	29.3	29.345	4302712.0
2012-10-15 10:00:00	MSFT	Stock	29.34	29.45	29.32	29.33	3825048.0
2012-10-15 10:30:00	MSFT	Stock	29.33	29.36	29.25	29.29	1903798.0
2012-10-15 11:00:00	MSFT	Stock	29.29	29.37	29.27	29.35	1753372.0
2012-10-15 11:30:00	MSFT	Stock	29.355	29.49	29.35	29.485	2543412.0
2012-10-15 12:00:00	MSFT	Stock	29.48	29.65	29.48	29.65	3215781.0
2012-10-15 12:30:00	MSFT	Stock	29.65	29.72	29.55	29.59	3168810.0
2012-10-15 13:00:00	MSFT	Stock	29.58	29.66	29.55	29.565	2041047.0
2012-10-15 13:30:00	MSFT	Stock	29.58	29.59	29.53	29.55	1896729.0
2012-10-15 14:00:00	MSFT	Stock	29.54	29.57	29.5	29.5	1772690.0
2012-10-15 14:30:00	MSFT	Stock	29.5	29.51	29.4	29.46	2052151.0
2012-10-15 15:00:00	MSFT	Stock	29.46	29.53	29.46	29.48	2231655.0
2012-10-15 15:30:00	MSFT	Stock	29.495	29.54	29.44	29.505	5455176.0
2012-10-15 16:00:00	MSFT	Stock	29.51	29.556	29.476	29.51	4485709.0

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

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