PREVIEW / stock_30min / 2016-03-11

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-03-11.parquet
  size:    1.6 MB
  rows:    82,363
  symbols: 3,342

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
2016-03-11 04:00:00	AAPL	Stock	25.5075	25.5625	25.5075	25.5625	2380.0
2016-03-11 04:30:00	AAPL	Stock	25.5	25.5	25.5	25.5	400.0
2016-03-11 05:00:00	AAPL	Stock	25.505	25.59	25.505	25.59	14524.0
2016-03-11 05:30:00	AAPL	Stock	25.53	25.55	25.53	25.55	16504.0
2016-03-11 06:00:00	AAPL	Stock	25.55	25.5625	25.53	25.5625	18820.0
2016-03-11 06:30:00	AAPL	Stock	25.55	25.5725	25.5	25.5	10784.0
2016-03-11 07:00:00	AAPL	Stock	25.4975	25.5	25.4675	25.5	82964.0
2016-03-11 07:30:00	AAPL	Stock	25.5125	25.5175	25.475	25.48	48152.0
2016-03-11 08:00:00	AAPL	Stock	25.4975	25.5625	25.46	25.475	176744.0
2016-03-11 08:30:00	AAPL	Stock	25.475	25.4825	25.44	25.4525	95132.0
2016-03-11 09:00:00	AAPL	Stock	25.4475	25.56	25.2925	25.5575	365864.0
2016-03-11 09:30:00	AAPL	Stock	25.5575	25.5625	25.3888	25.4675	13956428.0
2016-03-11 10:00:00	AAPL	Stock	25.47	25.5	25.375	25.4975	7687404.0
2016-03-11 10:30:00	AAPL	Stock	25.5	25.545	25.4625	25.49	7842584.0
2016-03-11 11:00:00	AAPL	Stock	25.4925	25.5075	25.425	25.44	5401192.0
2016-03-11 11:30:00	AAPL	Stock	25.4375	25.4925	25.4025	25.4515	4961776.0
2016-03-11 12:00:00	AAPL	Stock	25.4525	25.4725	25.4075	25.45	5253108.0
2016-03-11 12:30:00	AAPL	Stock	25.45	25.485	25.4388	25.455	3689596.0
2016-03-11 13:00:00	AAPL	Stock	25.454	25.4725	25.4125	25.45	4492044.0
2016-03-11 13:30:00	AAPL	Stock	25.45	25.485	25.42	25.4675	3307400.0
2016-03-11 14:00:00	AAPL	Stock	25.47	25.515	25.4525	25.4925	4220352.0
2016-03-11 14:30:00	AAPL	Stock	25.4925	25.505	25.4725	25.4925	3723352.0
2016-03-11 15:00:00	AAPL	Stock	25.4938	25.5575	25.4828	25.535	7548964.0
2016-03-11 15:30:00	AAPL	Stock	25.533	25.57	25.5025	25.5625	17033832.0
2016-03-11 16:00:00	AAPL	Stock	25.565	25.565	25.4735	25.555	9437568.0
2016-03-11 16:30:00	AAPL	Stock	25.5575	25.5625	25.496	25.5475	543280.0
2016-03-11 17:00:00	AAPL	Stock	25.54	25.5625	25.5375	25.5525	24292.0
2016-03-11 17:30:00	AAPL	Stock	25.5525	25.555	25.54	25.555	22364.0
2016-03-11 18:00:00	AAPL	Stock	25.555	25.555	25.5375	25.5375	12800.0
2016-03-11 18:30:00	AAPL	Stock	25.5375	25.545	25.5375	25.54	18528.0
2016-03-11 19:00:00	AAPL	Stock	25.5425	25.5425	25.5425	25.5425	852.0
2016-03-11 19:30:00	AAPL	Stock	25.5425	25.555	25.5425	25.555	20800.0
2016-03-11 05:30:00	MSFT	Stock	52.6	52.6	52.6	52.6	148.0
2016-03-11 07:00:00	MSFT	Stock	52.5	52.56	52.48	52.56	7193.0
2016-03-11 07:30:00	MSFT	Stock	52.56	52.59	52.51	52.51	2201.0
2016-03-11 08:00:00	MSFT	Stock	52.54	52.63	52.52	52.52	16320.0
2016-03-11 08:30:00	MSFT	Stock	52.53	52.59	52.47	52.55	6090.0
2016-03-11 09:00:00	MSFT	Stock	52.47	53.0	52.46	53.0	126468.0
2016-03-11 09:30:00	MSFT	Stock	53.0	53.0	52.52	52.655	4515204.0
2016-03-11 10:00:00	MSFT	Stock	52.655	52.705	52.38	52.68	2745018.0
2016-03-11 10:30:00	MSFT	Stock	52.68	52.84	52.68	52.77	2429805.0
2016-03-11 11:00:00	MSFT	Stock	52.77	52.84	52.71	52.81	1549973.0
2016-03-11 11:30:00	MSFT	Stock	52.81	52.93	52.72	52.86	1749710.0
2016-03-11 12:00:00	MSFT	Stock	52.86	52.92	52.804	52.83	1678914.0
2016-03-11 12:30:00	MSFT	Stock	52.83	52.88	52.76	52.799	727871.0
2016-03-11 13:00:00	MSFT	Stock	52.79	52.792	52.69	52.745	781917.0
2016-03-11 13:30:00	MSFT	Stock	52.75	52.85	52.625	52.8	997696.0
2016-03-11 14:00:00	MSFT	Stock	52.8	52.89	52.78	52.855	1111861.0
2016-03-11 14:30:00	MSFT	Stock	52.85	52.895	52.72	52.73	1175624.0
2016-03-11 15:00:00	MSFT	Stock	52.725	52.954	52.7	52.95	1931274.0

> showing 50 of 82,363 rows — these rows as CSV

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