PREVIEW / stock_30min / 2011-11-16

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-11-16.parquet
  size:    1.4 MB
  rows:    76,008
  symbols: 3,526

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
2011-11-16 04:00:00	AAPL	Stock	13.9057	13.9061	13.9057	13.9057	42000.0
2011-11-16 04:30:00	AAPL	Stock	13.9214	13.9304	13.9214	13.9304	16800.0
2011-11-16 05:00:00	AAPL	Stock	13.9304	13.9304	13.9304	13.9304	5600.0
2011-11-16 05:30:00	AAPL	Stock	13.9304	13.9304	13.8875	13.8929	79240.0
2011-11-16 06:00:00	AAPL	Stock	13.875	13.875	13.8625	13.8625	25732.0
2011-11-16 06:30:00	AAPL	Stock	13.8875	13.8929	13.8571	13.8571	19040.0
2011-11-16 07:00:00	AAPL	Stock	13.8393	13.9271	13.8332	13.8743	148540.0
2011-11-16 07:30:00	AAPL	Stock	13.8861	13.91	13.8443	13.8575	143276.0
2011-11-16 08:00:00	AAPL	Stock	13.8571	13.8679	13.8339	13.8571	429436.0
2011-11-16 08:30:00	AAPL	Stock	13.8482	13.8482	13.8143	13.8243	623028.0
2011-11-16 09:00:00	AAPL	Stock	13.8232	13.9107	13.8232	13.9021	1710912.0
2011-11-16 09:30:00	AAPL	Stock	13.9041	13.9693	13.8604	13.9114	65309412.0
2011-11-16 10:00:00	AAPL	Stock	13.9143	13.9311	13.8179	13.8379	36317764.0
2011-11-16 10:30:00	AAPL	Stock	13.8364	13.9103	13.8221	13.8943	23654260.0
2011-11-16 11:00:00	AAPL	Stock	13.8943	13.9018	13.8525	13.8661	13756316.0
2011-11-16 11:30:00	AAPL	Stock	13.8679	13.8782	13.7966	13.8089	20381788.0
2011-11-16 12:00:00	AAPL	Stock	13.8114	13.8457	13.8061	13.8296	11241916.0
2011-11-16 12:30:00	AAPL	Stock	13.8277	13.8661	13.82	13.84	12044648.0
2011-11-16 13:00:00	AAPL	Stock	13.8407	13.8564	13.8171	13.8564	12464256.0
2011-11-16 13:30:00	AAPL	Stock	13.8554	13.9036	13.8504	13.8682	22394960.0
2011-11-16 14:00:00	AAPL	Stock	13.8668	13.8818	13.8486	13.8696	10941532.0
2011-11-16 14:30:00	AAPL	Stock	13.8711	13.8911	13.8429	13.8654	11156908.0
2011-11-16 15:00:00	AAPL	Stock	13.8639	13.885	13.8089	13.8143	25227020.0
2011-11-16 15:30:00	AAPL	Stock	13.8143	13.8173	13.7257	13.7461	60189612.0
2011-11-16 16:00:00	AAPL	Stock	13.7471	13.8513	13.7182	13.7286	17282468.0
2011-11-16 16:30:00	AAPL	Stock	13.7264	13.8136	13.7089	13.715	1004948.0
2011-11-16 17:00:00	AAPL	Stock	13.7236	13.7239	13.7107	13.7161	119952.0
2011-11-16 17:30:00	AAPL	Stock	13.7243	13.7246	13.7182	13.7182	124712.0
2011-11-16 18:00:00	AAPL	Stock	13.7236	13.7418	13.7214	13.7214	38052.0
2011-11-16 18:30:00	AAPL	Stock	13.7236	13.7375	13.7232	13.7375	149240.0
2011-11-16 19:00:00	AAPL	Stock	13.7304	13.7364	13.7268	13.7354	153636.0
2011-11-16 19:30:00	AAPL	Stock	13.7321	13.7361	13.7282	13.7321	309988.0
2011-11-16 05:30:00	MSFT	Stock	26.72	26.72	26.71	26.71	300.0
2011-11-16 06:00:00	MSFT	Stock	26.48	26.48	26.48	26.48	100.0
2011-11-16 07:00:00	MSFT	Stock	26.54	26.59	26.54	26.59	600.0
2011-11-16 07:30:00	MSFT	Stock	26.55	26.55	26.5	26.55	1808.0
2011-11-16 08:00:00	MSFT	Stock	26.53	26.59	26.5	26.54	10160.0
2011-11-16 08:30:00	MSFT	Stock	26.52	26.52	26.48	26.48	23533.0
2011-11-16 09:00:00	MSFT	Stock	26.49	26.52	26.45	26.47	82732.0
2011-11-16 09:30:00	MSFT	Stock	26.47	26.51	26.36	26.37	9158961.0
2011-11-16 10:00:00	MSFT	Stock	26.38	26.39	26.27	26.34	4323431.0
2011-11-16 10:30:00	MSFT	Stock	26.335	26.49	26.31	26.45	3940871.0
2011-11-16 11:00:00	MSFT	Stock	26.45	26.49	26.4	26.44	2655001.0
2011-11-16 11:30:00	MSFT	Stock	26.439	26.45	26.38	26.41	1495293.0
2011-11-16 12:00:00	MSFT	Stock	26.4	26.45	26.38	26.42	1153286.0
2011-11-16 12:30:00	MSFT	Stock	26.425	26.48	26.4	26.41	1512140.0
2011-11-16 13:00:00	MSFT	Stock	26.41	26.47	26.4	26.46	2069242.0
2011-11-16 13:30:00	MSFT	Stock	26.465	26.51	26.43	26.45	2272444.0
2011-11-16 14:00:00	MSFT	Stock	26.45	26.5	26.42	26.475	1624748.0
2011-11-16 14:30:00	MSFT	Stock	26.48	26.5	26.4	26.45	2221834.0

> showing 50 of 76,008 rows — these rows as CSV

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