PREVIEW / stock_30min / 2013-10-10

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-10.parquet
  size:    1.6 MB
  rows:    83,070
  symbols: 3,537

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
2013-10-10 04:00:00	AAPL	Stock	17.4707	17.5064	17.4707	17.5064	6216.0
2013-10-10 04:30:00	AAPL	Stock	17.5004	17.5011	17.5004	17.5011	17500.0
2013-10-10 05:00:00	AAPL	Stock	17.5068	17.5068	17.4857	17.4996	72240.0
2013-10-10 05:30:00	AAPL	Stock	17.4857	17.5	17.4732	17.4946	59360.0
2013-10-10 06:00:00	AAPL	Stock	17.4821	17.5	17.4821	17.5	64288.0
2013-10-10 06:30:00	AAPL	Stock	17.5	17.5179	17.4996	17.5146	152404.0
2013-10-10 07:00:00	AAPL	Stock	17.5104	17.5511	17.5039	17.55	794304.0
2013-10-10 07:30:00	AAPL	Stock	17.5489	17.5643	17.5421	17.5557	1014048.0
2013-10-10 08:00:00	AAPL	Stock	17.5529	17.5668	17.3571	17.5446	2867760.0
2013-10-10 08:30:00	AAPL	Stock	17.5421	17.5564	17.5257	17.5393	1043028.0
2013-10-10 09:00:00	AAPL	Stock	17.5379	17.5804	17.5311	17.5482	2607892.0
2013-10-10 09:30:00	AAPL	Stock	17.5454	17.5568	17.3943	17.4736	57672692.0
2013-10-10 10:00:00	AAPL	Stock	17.4721	17.5182	17.415	17.5156	27592012.0
2013-10-10 10:30:00	AAPL	Stock	17.5148	17.5482	17.49	17.5239	24082436.0
2013-10-10 11:00:00	AAPL	Stock	17.5211	17.5354	17.4836	17.5321	13991880.0
2013-10-10 11:30:00	AAPL	Stock	17.5346	17.5793	17.5089	17.5718	21510216.0
2013-10-10 12:00:00	AAPL	Stock	17.5714	17.585	17.5454	17.5682	11000276.0
2013-10-10 12:30:00	AAPL	Stock	17.5682	17.585	17.5254	17.5436	10809204.0
2013-10-10 13:00:00	AAPL	Stock	17.54	17.5421	17.4683	17.5215	12179916.0
2013-10-10 13:30:00	AAPL	Stock	17.5179	17.5318	17.5021	17.519	5767188.0
2013-10-10 14:00:00	AAPL	Stock	17.5213	17.5225	17.4086	17.4234	17061296.0
2013-10-10 14:30:00	AAPL	Stock	17.4236	17.4786	17.41	17.4675	15133076.0
2013-10-10 15:00:00	AAPL	Stock	17.4668	17.5196	17.4668	17.4982	15572648.0
2013-10-10 15:30:00	AAPL	Stock	17.5007	17.5096	17.4661	17.4957	23933700.0
2013-10-10 16:00:00	AAPL	Stock	17.4957	17.5465	17.4721	17.5046	8470588.0
2013-10-10 16:30:00	AAPL	Stock	17.4725	17.4964	17.3781	17.4804	1293740.0
2013-10-10 17:00:00	AAPL	Stock	17.4689	17.4964	17.4536	17.4636	224756.0
2013-10-10 17:30:00	AAPL	Stock	17.4636	17.4964	17.4482	17.4532	286888.0
2013-10-10 18:00:00	AAPL	Stock	17.4507	17.4507	17.3964	17.3964	491400.0
2013-10-10 18:30:00	AAPL	Stock	17.4107	17.4375	17.3661	17.3821	495096.0
2013-10-10 19:00:00	AAPL	Stock	17.3989	17.4214	17.3839	17.4114	235760.0
2013-10-10 19:30:00	AAPL	Stock	17.4143	17.4232	17.4014	17.4071	338408.0
2013-10-10 04:00:00	MSFT	Stock	33.12	33.12	33.12	33.12	100.0
2013-10-10 06:30:00	MSFT	Stock	33.29	33.3	33.29	33.3	700.0
2013-10-10 07:00:00	MSFT	Stock	33.3	33.35	33.29	33.29	4400.0
2013-10-10 07:30:00	MSFT	Stock	33.25	33.25	33.06	33.25	7800.0
2013-10-10 08:00:00	MSFT	Stock	33.29	33.29	33.16	33.21	5530.0
2013-10-10 08:30:00	MSFT	Stock	33.21	33.27	33.21	33.27	2960.0
2013-10-10 09:00:00	MSFT	Stock	33.28	33.4	33.28	33.38	75283.0
2013-10-10 09:30:00	MSFT	Stock	33.31	33.55	33.26	33.422	4738104.0
2013-10-10 10:00:00	MSFT	Stock	33.43	33.52	33.34	33.475	3782049.0
2013-10-10 10:30:00	MSFT	Stock	33.475	33.59	33.415	33.44	2266425.0
2013-10-10 11:00:00	MSFT	Stock	33.44	33.47	33.32	33.38	2222696.0
2013-10-10 11:30:00	MSFT	Stock	33.39	33.49	33.33	33.46	3722142.0
2013-10-10 12:00:00	MSFT	Stock	33.46	33.47	33.37	33.433	1339833.0
2013-10-10 12:30:00	MSFT	Stock	33.438	33.49	33.43	33.48	1011611.0
2013-10-10 13:00:00	MSFT	Stock	33.48	33.51	33.46	33.47	1195752.0
2013-10-10 13:30:00	MSFT	Stock	33.477	33.48	33.34	33.36	2188246.0
2013-10-10 14:00:00	MSFT	Stock	33.36	33.49	33.26	33.475	2467052.0
2013-10-10 14:30:00	MSFT	Stock	33.48	33.67	33.43	33.67	2527206.0

> showing 50 of 83,070 rows — these rows as CSV

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