PREVIEW / stock_30min / 2017-05-01

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-01.parquet
  size:    1.6 MB
  rows:    80,679
  symbols: 3,052

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
2017-05-01 04:00:00	AAPL	Stock	36.0025	36.0025	36.0025	36.0025	400.0
2017-05-01 06:00:00	AAPL	Stock	36.035	36.04	36.035	36.04	4100.0
2017-05-01 06:30:00	AAPL	Stock	36.0325	36.035	36.0325	36.035	8380.0
2017-05-01 07:00:00	AAPL	Stock	36.0575	36.1125	36.0475	36.1125	48684.0
2017-05-01 07:30:00	AAPL	Stock	36.0875	36.12	36.0775	36.0875	39064.0
2017-05-01 08:00:00	AAPL	Stock	36.075	36.1375	35.9125	36.135	198424.0
2017-05-01 08:30:00	AAPL	Stock	36.135	36.1925	36.11	36.155	203760.0
2017-05-01 09:00:00	AAPL	Stock	36.1675	36.25	36.165	36.25	554984.0
2017-05-01 09:30:00	AAPL	Stock	36.275	36.4675	36.24	36.4475	19567996.0
2017-05-01 10:00:00	AAPL	Stock	36.4475	36.4925	36.3925	36.4235	9182812.0
2017-05-01 10:30:00	AAPL	Stock	36.4248	36.5325	36.42	36.52	7561428.0
2017-05-01 11:00:00	AAPL	Stock	36.519	36.5737	36.5075	36.5125	5662004.0
2017-05-01 11:30:00	AAPL	Stock	36.5145	36.575	36.4875	36.5625	5405824.0
2017-05-01 12:00:00	AAPL	Stock	36.5625	36.585	36.51	36.578	4268908.0
2017-05-01 12:30:00	AAPL	Stock	36.58	36.67	36.5675	36.6402	6053716.0
2017-05-01 13:00:00	AAPL	Stock	36.6425	36.6838	36.6075	36.6825	4281080.0
2017-05-01 13:30:00	AAPL	Stock	36.6812	36.74	36.655	36.74	5850436.0
2017-05-01 14:00:00	AAPL	Stock	36.74	36.7475	36.68	36.6825	6343568.0
2017-05-01 14:30:00	AAPL	Stock	36.685	36.72	36.6375	36.679	4751264.0
2017-05-01 15:00:00	AAPL	Stock	36.6775	36.725	36.6525	36.7238	5811192.0
2017-05-01 15:30:00	AAPL	Stock	36.7232	36.8	36.63	36.64	18012904.0
2017-05-01 16:00:00	AAPL	Stock	36.6525	36.7	36.6425	36.67	10958364.0
2017-05-01 16:30:00	AAPL	Stock	36.67	36.705	36.6625	36.7	157000.0
2017-05-01 17:00:00	AAPL	Stock	36.675	36.7	36.675	36.7	69288.0
2017-05-01 17:30:00	AAPL	Stock	36.705	36.705	36.6875	36.6925	60716.0
2017-05-01 18:00:00	AAPL	Stock	36.7	36.7125	36.6875	36.705	27872.0
2017-05-01 18:30:00	AAPL	Stock	36.71	36.7125	36.6875	36.7075	62036.0
2017-05-01 19:00:00	AAPL	Stock	36.6925	36.7075	36.675	36.6975	67684.0
2017-05-01 19:30:00	AAPL	Stock	36.7	36.7175	36.69	36.7	46044.0
2017-05-01 07:00:00	MSFT	Stock	68.74	68.74	68.6	68.6	350.0
2017-05-01 08:00:00	MSFT	Stock	68.5	68.6	68.45	68.45	15874.0
2017-05-01 08:30:00	MSFT	Stock	68.5	68.56	68.46	68.46	7630.0
2017-05-01 09:00:00	MSFT	Stock	68.56	68.68	68.52	68.67	12110.0
2017-05-01 09:30:00	MSFT	Stock	68.67	68.735	68.5	68.699	2795621.0
2017-05-01 10:00:00	MSFT	Stock	68.69	68.73	68.61	68.73	1952730.0
2017-05-01 10:30:00	MSFT	Stock	68.73	68.82	68.65	68.785	2252852.0
2017-05-01 11:00:00	MSFT	Stock	68.78	68.89	68.74	68.875	1401295.0
2017-05-01 11:30:00	MSFT	Stock	68.88	69.08	68.87	69.02	1785629.0
2017-05-01 12:00:00	MSFT	Stock	69.014	69.4	69.0	69.385	2202700.0
2017-05-01 12:30:00	MSFT	Stock	69.38	69.42	69.23	69.305	1519086.0
2017-05-01 13:00:00	MSFT	Stock	69.305	69.445	69.29	69.42	1145874.0
2017-05-01 13:30:00	MSFT	Stock	69.425	69.46	69.29	69.35	1310545.0
2017-05-01 14:00:00	MSFT	Stock	69.35	69.4	69.295	69.375	1378207.0
2017-05-01 14:30:00	MSFT	Stock	69.37	69.405	69.32	69.36	1044434.0
2017-05-01 15:00:00	MSFT	Stock	69.355	69.36	69.24	69.3	1536423.0
2017-05-01 15:30:00	MSFT	Stock	69.3	69.55	69.3	69.43	6794239.0
2017-05-01 16:00:00	MSFT	Stock	69.42	69.6	69.41	69.51	2628220.0
2017-05-01 16:30:00	MSFT	Stock	69.41	69.57	69.41	69.55	54283.0
2017-05-01 17:00:00	MSFT	Stock	69.53	69.57	69.53	69.57	3500.0
2017-05-01 17:30:00	MSFT	Stock	69.55	69.58	69.55	69.58	900.0

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

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