PREVIEW / stock_30min / 2016-05-13

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-05-13.parquet
  size:    1.5 MB
  rows:    80,656
  symbols: 3,280

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-05-13 04:00:00	AAPL	Stock	22.4675	22.5	22.25	22.5	20880.0
2016-05-13 04:30:00	AAPL	Stock	22.48	22.48	22.48	22.48	1600.0
2016-05-13 05:00:00	AAPL	Stock	22.48	22.48	22.425	22.4625	4000.0
2016-05-13 05:30:00	AAPL	Stock	22.4725	22.475	22.46	22.46	5000.0
2016-05-13 06:00:00	AAPL	Stock	22.48	22.5075	22.465	22.5	24624.0
2016-05-13 06:30:00	AAPL	Stock	22.535	22.535	22.5025	22.5025	1612.0
2016-05-13 07:00:00	AAPL	Stock	22.5025	22.54	22.4775	22.5	42424.0
2016-05-13 07:30:00	AAPL	Stock	22.5175	22.5325	22.5	22.5025	29272.0
2016-05-13 08:00:00	AAPL	Stock	22.5125	22.5425	22.47	22.475	279204.0
2016-05-13 08:30:00	AAPL	Stock	22.4825	22.56	22.475	22.515	288892.0
2016-05-13 09:00:00	AAPL	Stock	22.515	22.5725	22.4775	22.5025	755120.0
2016-05-13 09:30:00	AAPL	Stock	22.5025	22.83	22.5	22.6625	35236916.0
2016-05-13 10:00:00	AAPL	Stock	22.6625	22.8238	22.6525	22.75	16417668.0
2016-05-13 10:30:00	AAPL	Stock	22.748	22.8325	22.6975	22.785	11041004.0
2016-05-13 11:00:00	AAPL	Stock	22.7842	22.9175	22.7842	22.8975	14257004.0
2016-05-13 11:30:00	AAPL	Stock	22.8975	22.905	22.795	22.8325	7800596.0
2016-05-13 12:00:00	AAPL	Stock	22.8325	22.85	22.8	22.8175	5394860.0
2016-05-13 12:30:00	AAPL	Stock	22.82	22.82	22.6925	22.7042	8246172.0
2016-05-13 13:00:00	AAPL	Stock	22.705	22.7375	22.63	22.634	6749840.0
2016-05-13 13:30:00	AAPL	Stock	22.6325	22.6575	22.55	22.58	10119400.0
2016-05-13 14:00:00	AAPL	Stock	22.58	22.6425	22.5425	22.5925	7425980.0
2016-05-13 14:30:00	AAPL	Stock	22.5912	22.6025	22.54	22.564	7293108.0
2016-05-13 15:00:00	AAPL	Stock	22.565	22.635	22.5425	22.6125	8223992.0
2016-05-13 15:30:00	AAPL	Stock	22.6125	22.6725	22.5925	22.63	16947660.0
2016-05-13 16:00:00	AAPL	Stock	22.63	22.66	22.63	22.6425	7246868.0
2016-05-13 16:30:00	AAPL	Stock	22.6425	22.6425	22.625	22.6325	90092.0
2016-05-13 17:00:00	AAPL	Stock	22.6375	22.6375	22.605	22.605	44656.0
2016-05-13 17:30:00	AAPL	Stock	22.6025	22.6125	22.585	22.585	37720.0
2016-05-13 18:00:00	AAPL	Stock	22.585	22.61	22.565	22.61	22664.0
2016-05-13 18:30:00	AAPL	Stock	22.6075	22.6075	22.5525	22.575	37388.0
2016-05-13 19:00:00	AAPL	Stock	22.5775	22.5975	22.575	22.5975	11420.0
2016-05-13 19:30:00	AAPL	Stock	22.58	22.5975	22.58	22.595	49284.0
2016-05-13 08:00:00	MSFT	Stock	51.3	51.3	51.3	51.3	559.0
2016-05-13 08:30:00	MSFT	Stock	51.44	51.44	51.4	51.4	859.0
2016-05-13 09:00:00	MSFT	Stock	51.44	51.44	51.23	51.44	30141.0
2016-05-13 09:30:00	MSFT	Stock	51.44	51.86	51.38	51.76	2181723.0
2016-05-13 10:00:00	MSFT	Stock	51.76	51.895	51.68	51.72	1348415.0
2016-05-13 10:30:00	MSFT	Stock	51.72	51.755	51.6	51.66	1195242.0
2016-05-13 11:00:00	MSFT	Stock	51.66	51.81	51.64	51.73	1525355.0
2016-05-13 11:30:00	MSFT	Stock	51.72	51.745	51.565	51.57	933850.0
2016-05-13 12:00:00	MSFT	Stock	51.58	51.72	51.56	51.69	1004513.0
2016-05-13 12:30:00	MSFT	Stock	51.695	51.735	51.54	51.57	902609.0
2016-05-13 13:00:00	MSFT	Stock	51.57	51.68	51.47	51.49	1068840.0
2016-05-13 13:30:00	MSFT	Stock	51.49	51.53	51.32	51.35	1339439.0
2016-05-13 14:00:00	MSFT	Stock	51.34	51.37	51.14	51.26	1197153.0
2016-05-13 14:30:00	MSFT	Stock	51.26	51.27	51.04	51.15	1503965.0
2016-05-13 15:00:00	MSFT	Stock	51.15	51.249	51.06	51.16	1195479.0
2016-05-13 15:30:00	MSFT	Stock	51.16	51.26	51.06	51.08	3162612.0
2016-05-13 16:00:00	MSFT	Stock	51.09	51.15	51.08	51.12	2537860.0
2016-05-13 16:30:00	MSFT	Stock	51.03	51.15	51.03	51.15	800.0

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

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