PREVIEW / stock_30min / 2014-05-09

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-09.parquet
  size:    1.6 MB
  rows:    81,119
  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
2014-05-09 04:00:00	AAPL	Stock	20.9964	20.9964	20.8929	20.8929	11200.0
2014-05-09 05:00:00	AAPL	Stock	20.9479	20.9479	20.9457	20.9457	5600.0
2014-05-09 05:30:00	AAPL	Stock	20.9554	20.9554	20.9554	20.9554	2800.0
2014-05-09 06:00:00	AAPL	Stock	20.9518	20.9518	20.8839	20.8839	30800.0
2014-05-09 06:30:00	AAPL	Stock	20.9082	20.9082	20.9082	20.9082	2800.0
2014-05-09 07:00:00	AAPL	Stock	20.9107	20.9107	20.8636	20.8636	98560.0
2014-05-09 07:30:00	AAPL	Stock	20.8907	20.9696	20.8907	20.905	146132.0
2014-05-09 08:00:00	AAPL	Stock	20.9107	20.9214	20.8571	20.8714	497812.0
2014-05-09 08:30:00	AAPL	Stock	20.875	20.9004	20.8482	20.8939	610820.0
2014-05-09 09:00:00	AAPL	Stock	20.8907	20.9229	20.8732	20.8754	993244.0
2014-05-09 09:30:00	AAPL	Stock	20.8764	20.9375	20.7707	20.8146	42435680.0
2014-05-09 10:00:00	AAPL	Stock	20.8154	20.875	20.7814	20.8186	19266912.0
2014-05-09 10:30:00	AAPL	Stock	20.8175	20.8382	20.7796	20.7814	12263468.0
2014-05-09 11:00:00	AAPL	Stock	20.7829	20.7861	20.7261	20.7843	18324292.0
2014-05-09 11:30:00	AAPL	Stock	20.785	20.81	20.7625	20.7896	10494036.0
2014-05-09 12:00:00	AAPL	Stock	20.7904	20.8007	20.7429	20.7489	9280096.0
2014-05-09 12:30:00	AAPL	Stock	20.7493	20.8036	20.7441	20.7857	9382884.0
2014-05-09 13:00:00	AAPL	Stock	20.7879	20.7996	20.7382	20.7532	7430332.0
2014-05-09 13:30:00	AAPL	Stock	20.751	20.7621	20.735	20.7486	6825196.0
2014-05-09 14:00:00	AAPL	Stock	20.7479	20.7789	20.7389	20.7614	7659092.0
2014-05-09 14:30:00	AAPL	Stock	20.7611	20.8343	20.76	20.8339	11221700.0
2014-05-09 15:00:00	AAPL	Stock	20.8343	20.9171	20.833	20.8818	19064556.0
2014-05-09 15:30:00	AAPL	Stock	20.8796	20.9179	20.8696	20.9121	22837472.0
2014-05-09 16:00:00	AAPL	Stock	20.9125	20.9286	20.8104	20.9125	7228844.0
2014-05-09 16:30:00	AAPL	Stock	20.9196	20.9196	20.8125	20.9129	273924.0
2014-05-09 17:00:00	AAPL	Stock	20.9125	20.9161	20.9079	20.9079	72800.0
2014-05-09 17:30:00	AAPL	Stock	20.9125	20.9125	20.9125	20.9125	175280.0
2014-05-09 18:00:00	AAPL	Stock	20.9107	20.9107	20.9093	20.9107	32228.0
2014-05-09 18:30:00	AAPL	Stock	20.9193	20.9214	20.9107	20.9107	138376.0
2014-05-09 19:00:00	AAPL	Stock	20.9179	20.9179	20.9114	20.9118	38640.0
2014-05-09 19:30:00	AAPL	Stock	20.9114	20.9193	20.9107	20.9193	42308.0
2014-05-09 07:00:00	MSFT	Stock	39.63	39.63	39.63	39.63	300.0
2014-05-09 08:00:00	MSFT	Stock	39.51	39.51	39.5	39.5	710.0
2014-05-09 08:30:00	MSFT	Stock	39.5	39.55	39.5	39.55	4408.0
2014-05-09 09:00:00	MSFT	Stock	39.55	39.57	39.52	39.54	11847.0
2014-05-09 09:30:00	MSFT	Stock	39.54	39.66	39.45	39.61	4264866.0
2014-05-09 10:00:00	MSFT	Stock	39.6	39.85	39.56	39.74	3022663.0
2014-05-09 10:30:00	MSFT	Stock	39.74	39.745	39.56	39.565	1941543.0
2014-05-09 11:00:00	MSFT	Stock	39.56	39.61	39.49	39.54	3326498.0
2014-05-09 11:30:00	MSFT	Stock	39.55	39.58	39.46	39.466	1774369.0
2014-05-09 12:00:00	MSFT	Stock	39.46	39.555	39.45	39.5	1335370.0
2014-05-09 12:30:00	MSFT	Stock	39.5	39.69	39.495	39.67	1825793.0
2014-05-09 13:00:00	MSFT	Stock	39.67	39.68	39.57	39.6	789074.0
2014-05-09 13:30:00	MSFT	Stock	39.61	39.64	39.5	39.52	881041.0
2014-05-09 14:00:00	MSFT	Stock	39.51	39.53	39.37	39.47	2672208.0
2014-05-09 14:30:00	MSFT	Stock	39.47	39.59	39.47	39.535	865427.0
2014-05-09 15:00:00	MSFT	Stock	39.54	39.59	39.52	39.545	1226747.0
2014-05-09 15:30:00	MSFT	Stock	39.54	39.59	39.52	39.55	2647607.0
2014-05-09 16:00:00	MSFT	Stock	39.54	39.567	39.53	39.54	1742927.0
2014-05-09 16:30:00	MSFT	Stock	39.53	39.548	39.53	39.54	66533.0

> showing 50 of 81,119 rows — these rows as CSV

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