PREVIEW / stock_30min / 2013-10-07

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-07.parquet
  size:    1.5 MB
  rows:    80,738
  symbols: 3,543

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-07 04:00:00	AAPL	Stock	17.33	17.33	17.2896	17.3214	359380.0
2013-10-07 04:30:00	AAPL	Stock	17.3104	17.3504	17.3104	17.3504	328720.0
2013-10-07 05:00:00	AAPL	Stock	17.3268	17.3271	17.325	17.3271	12600.0
2013-10-07 05:30:00	AAPL	Stock	17.3464	17.3932	17.3296	17.3886	283220.0
2013-10-07 06:00:00	AAPL	Stock	17.3779	17.3779	17.3539	17.3661	62188.0
2013-10-07 06:30:00	AAPL	Stock	17.3607	17.3789	17.3539	17.3729	186060.0
2013-10-07 07:00:00	AAPL	Stock	17.3696	17.3886	17.3325	17.3479	716072.0
2013-10-07 07:30:00	AAPL	Stock	17.3479	17.375	17.3411	17.3679	638288.0
2013-10-07 08:00:00	AAPL	Stock	17.3625	17.3907	17.2143	17.3629	3642996.0
2013-10-07 08:30:00	AAPL	Stock	17.3714	17.3886	17.3575	17.3789	981624.0
2013-10-07 09:00:00	AAPL	Stock	17.3789	17.3929	17.3629	17.3743	2215220.0
2013-10-07 09:30:00	AAPL	Stock	17.3786	17.5514	17.3339	17.5314	76692420.0
2013-10-07 10:00:00	AAPL	Stock	17.5343	17.5686	17.4747	17.5586	35760200.0
2013-10-07 10:30:00	AAPL	Stock	17.5611	17.5882	17.5108	17.5614	26327896.0
2013-10-07 11:00:00	AAPL	Stock	17.5614	17.5682	17.5079	17.5268	13170640.0
2013-10-07 11:30:00	AAPL	Stock	17.5272	17.5907	17.5236	17.5693	16357404.0
2013-10-07 12:00:00	AAPL	Stock	17.5657	17.5946	17.5414	17.5525	12827276.0
2013-10-07 12:30:00	AAPL	Stock	17.5546	17.5811	17.5268	17.5341	12662888.0
2013-10-07 13:00:00	AAPL	Stock	17.5346	17.5625	17.5214	17.5279	9491132.0
2013-10-07 13:30:00	AAPL	Stock	17.5279	17.5696	17.5082	17.5693	10255700.0
2013-10-07 14:00:00	AAPL	Stock	17.5668	17.5686	17.5286	17.5418	8650544.0
2013-10-07 14:30:00	AAPL	Stock	17.5418	17.5518	17.5118	17.5254	8624392.0
2013-10-07 15:00:00	AAPL	Stock	17.5236	17.526	17.4407	17.4491	19160344.0
2013-10-07 15:30:00	AAPL	Stock	17.4507	17.4629	17.3754	17.4196	41136256.0
2013-10-07 16:00:00	AAPL	Stock	17.4196	17.5417	17.3929	17.4196	5853596.0
2013-10-07 16:30:00	AAPL	Stock	17.3986	17.4593	17.3929	17.4125	425796.0
2013-10-07 17:00:00	AAPL	Stock	17.4125	17.4175	17.3936	17.3936	44800.0
2013-10-07 17:30:00	AAPL	Stock	17.3982	17.4196	17.3964	17.4143	122640.0
2013-10-07 18:00:00	AAPL	Stock	17.4086	17.4157	17.3839	17.4107	283136.0
2013-10-07 18:30:00	AAPL	Stock	17.4143	17.4229	17.4143	17.4229	87108.0
2013-10-07 19:00:00	AAPL	Stock	17.4193	17.4246	17.4143	17.4214	113372.0
2013-10-07 19:30:00	AAPL	Stock	17.4243	17.4243	17.4161	17.4232	129276.0
2013-10-07 04:00:00	MSFT	Stock	33.61	33.61	33.61	33.61	100.0
2013-10-07 05:30:00	MSFT	Stock	33.61	33.61	33.61	33.61	100.0
2013-10-07 06:00:00	MSFT	Stock	33.56	33.56	33.55	33.55	400.0
2013-10-07 07:00:00	MSFT	Stock	33.56	33.58	33.55	33.55	600.0
2013-10-07 08:00:00	MSFT	Stock	33.7	33.7	33.63	33.67	4100.0
2013-10-07 08:30:00	MSFT	Stock	33.63	33.67	33.63	33.67	5930.0
2013-10-07 09:00:00	MSFT	Stock	33.67	33.69	33.63	33.65	8115.0
2013-10-07 09:30:00	MSFT	Stock	33.6	33.71	33.38	33.572	4980885.0
2013-10-07 10:00:00	MSFT	Stock	33.572	33.67	33.51	33.55	2335928.0
2013-10-07 10:30:00	MSFT	Stock	33.545	33.64	33.46	33.58	2195241.0
2013-10-07 11:00:00	MSFT	Stock	33.58	33.588	33.48	33.5	1300277.0
2013-10-07 11:30:00	MSFT	Stock	33.5	33.555	33.48	33.49	1060987.0
2013-10-07 12:00:00	MSFT	Stock	33.49	33.52	33.36	33.38	1793727.0
2013-10-07 12:30:00	MSFT	Stock	33.39	33.41	33.3	33.34	2058226.0
2013-10-07 13:00:00	MSFT	Stock	33.343	33.47	33.31	33.43	2083835.0
2013-10-07 13:30:00	MSFT	Stock	33.43	33.47	33.4	33.45	2533070.0
2013-10-07 14:00:00	MSFT	Stock	33.45	33.48	33.34	33.39	1806986.0
2013-10-07 14:30:00	MSFT	Stock	33.38	33.46	33.35	33.46	1463517.0

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

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