PREVIEW / stock_30min / 2014-06-11

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-11.parquet
  size:    1.6 MB
  rows:    84,236
  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
2014-06-11 04:00:00	AAPL	Stock	23.54	23.54	23.54	23.54	1200.0
2014-06-11 04:30:00	AAPL	Stock	23.555	23.555	23.515	23.515	5968.0
2014-06-11 05:00:00	AAPL	Stock	23.515	23.515	23.5025	23.5025	2000.0
2014-06-11 05:30:00	AAPL	Stock	23.465	23.465	23.405	23.4375	8788.0
2014-06-11 06:00:00	AAPL	Stock	23.435	23.4475	23.4025	23.4075	8748.0
2014-06-11 06:30:00	AAPL	Stock	23.4275	23.4375	23.4125	23.4125	16588.0
2014-06-11 07:00:00	AAPL	Stock	23.435	23.45	23.36	23.375	195600.0
2014-06-11 07:30:00	AAPL	Stock	23.37	23.395	23.3375	23.375	310884.0
2014-06-11 08:00:00	AAPL	Stock	23.3825	23.495	23.3475	23.425	596072.0
2014-06-11 08:30:00	AAPL	Stock	23.4275	23.435	23.3825	23.3875	182556.0
2014-06-11 09:00:00	AAPL	Stock	23.3925	23.55	23.3925	23.5325	1105016.0
2014-06-11 09:30:00	AAPL	Stock	23.53	23.635	23.475	23.6325	33298548.0
2014-06-11 10:00:00	AAPL	Stock	23.632	23.69	23.59	23.6125	17769600.0
2014-06-11 10:30:00	AAPL	Stock	23.61	23.65	23.5275	23.58	16085764.0
2014-06-11 11:00:00	AAPL	Stock	23.5822	23.6075	23.5375	23.575	9844444.0
2014-06-11 11:30:00	AAPL	Stock	23.575	23.6125	23.5525	23.5975	6923232.0
2014-06-11 12:00:00	AAPL	Stock	23.595	23.6	23.55	23.55	5695888.0
2014-06-11 12:30:00	AAPL	Stock	23.5502	23.6075	23.545	23.5988	5273796.0
2014-06-11 13:00:00	AAPL	Stock	23.5988	23.6	23.5525	23.5675	5662736.0
2014-06-11 13:30:00	AAPL	Stock	23.565	23.5775	23.43	23.43	10495232.0
2014-06-11 14:00:00	AAPL	Stock	23.43	23.5	23.3675	23.4342	17182244.0
2014-06-11 14:30:00	AAPL	Stock	23.4328	23.4825	23.4225	23.4502	7663908.0
2014-06-11 15:00:00	AAPL	Stock	23.45	23.475	23.425	23.475	6885324.0
2014-06-11 15:30:00	AAPL	Stock	23.4725	23.4972	23.4325	23.4675	14935604.0
2014-06-11 16:00:00	AAPL	Stock	23.4675	23.57	23.4375	23.4625	7919568.0
2014-06-11 16:30:00	AAPL	Stock	23.465	23.465	23.4575	23.4625	73304.0
2014-06-11 17:00:00	AAPL	Stock	23.4625	23.4625	23.4525	23.46	68964.0
2014-06-11 17:30:00	AAPL	Stock	23.46	23.46	23.45	23.45	86284.0
2014-06-11 18:00:00	AAPL	Stock	23.455	23.4675	23.4525	23.4625	36468.0
2014-06-11 18:30:00	AAPL	Stock	23.465	23.4675	23.4525	23.465	51388.0
2014-06-11 19:00:00	AAPL	Stock	23.465	23.475	23.465	23.4725	9056.0
2014-06-11 19:30:00	AAPL	Stock	23.4675	23.4725	23.465	23.465	80836.0
2014-06-11 06:00:00	MSFT	Stock	41.05	41.05	41.05	41.05	100.0
2014-06-11 07:00:00	MSFT	Stock	40.99	40.99	40.99	40.99	3500.0
2014-06-11 07:30:00	MSFT	Stock	40.95	40.95	40.9	40.91	3000.0
2014-06-11 08:00:00	MSFT	Stock	40.9	40.9	40.8	40.82	6149.0
2014-06-11 08:30:00	MSFT	Stock	40.82	40.91	40.82	40.82	19990.0
2014-06-11 09:00:00	MSFT	Stock	40.88	40.92	40.82	40.92	6200.0
2014-06-11 09:30:00	MSFT	Stock	40.93	41.07	40.77	41.005	2874130.0
2014-06-11 10:00:00	MSFT	Stock	41.01	41.06	40.8	40.83	1251834.0
2014-06-11 10:30:00	MSFT	Stock	40.825	40.915	40.8	40.9	1227992.0
2014-06-11 11:00:00	MSFT	Stock	40.91	40.97	40.9	40.94	602148.0
2014-06-11 11:30:00	MSFT	Stock	40.93	40.99	40.9	40.955	624782.0
2014-06-11 12:00:00	MSFT	Stock	40.96	40.96	40.9	40.91	394825.0
2014-06-11 12:30:00	MSFT	Stock	40.91	40.965	40.893	40.94	538548.0
2014-06-11 13:00:00	MSFT	Stock	40.94	40.96	40.86	40.91	418816.0
2014-06-11 13:30:00	MSFT	Stock	40.91	40.92	40.855	40.875	451176.0
2014-06-11 14:00:00	MSFT	Stock	40.87	40.89	40.81	40.875	572131.0
2014-06-11 14:30:00	MSFT	Stock	40.875	40.9	40.81	40.83	1608495.0
2014-06-11 15:00:00	MSFT	Stock	40.84	40.845	40.77	40.81	964195.0

> showing 50 of 84,236 rows — these rows as CSV

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