PREVIEW / stock_30min / 2016-04-05

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-05.parquet
  size:    1.5 MB
  rows:    80,828
  symbols: 3,325

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-04-05 04:00:00	AAPL	Stock	27.625	27.625	27.5575	27.5875	5120.0
2016-04-05 04:30:00	AAPL	Stock	27.5575	27.5575	27.4975	27.5	9848.0
2016-04-05 05:00:00	AAPL	Stock	27.5	27.5	27.5	27.5	1600.0
2016-04-05 05:30:00	AAPL	Stock	27.565	27.565	27.565	27.565	400.0
2016-04-05 06:00:00	AAPL	Stock	27.5325	27.575	27.5	27.575	3812.0
2016-04-05 06:30:00	AAPL	Stock	27.5175	27.545	27.5125	27.53	6000.0
2016-04-05 07:00:00	AAPL	Stock	27.5475	27.5825	27.36	27.365	261176.0
2016-04-05 07:30:00	AAPL	Stock	27.37	27.41	27.2825	27.37	304896.0
2016-04-05 08:00:00	AAPL	Stock	27.3725	27.61	27.2975	27.425	465012.0
2016-04-05 08:30:00	AAPL	Stock	27.425	27.4375	27.4025	27.4375	159708.0
2016-04-05 09:00:00	AAPL	Stock	27.4375	27.4375	27.375	27.38	282256.0
2016-04-05 09:30:00	AAPL	Stock	27.4125	27.6075	27.355	27.44	16642872.0
2016-04-05 10:00:00	AAPL	Stock	27.445	27.65	27.4375	27.6375	10064700.0
2016-04-05 10:30:00	AAPL	Stock	27.6355	27.6825	27.5612	27.5775	8261116.0
2016-04-05 11:00:00	AAPL	Stock	27.576	27.61	27.53	27.5425	6589908.0
2016-04-05 11:30:00	AAPL	Stock	27.5402	27.5725	27.4575	27.4942	6143928.0
2016-04-05 12:00:00	AAPL	Stock	27.4925	27.5438	27.425	27.43	4563176.0
2016-04-05 12:30:00	AAPL	Stock	27.4325	27.4988	27.415	27.4925	4558872.0
2016-04-05 13:00:00	AAPL	Stock	27.4925	27.4925	27.4275	27.4745	4728548.0
2016-04-05 13:30:00	AAPL	Stock	27.4738	27.56	27.4625	27.5375	5513348.0
2016-04-05 14:00:00	AAPL	Stock	27.5375	27.55	27.4778	27.54	4711288.0
2016-04-05 14:30:00	AAPL	Stock	27.54	27.58	27.5225	27.5562	4191576.0
2016-04-05 15:00:00	AAPL	Stock	27.5575	27.565	27.4575	27.485	4872200.0
2016-04-05 15:30:00	AAPL	Stock	27.485	27.5138	27.3975	27.4508	9387920.0
2016-04-05 16:00:00	AAPL	Stock	27.4525	27.78	27.4475	27.4575	4784616.0
2016-04-05 16:30:00	AAPL	Stock	27.46	27.5725	27.3525	27.5625	113400.0
2016-04-05 17:00:00	AAPL	Stock	27.5375	27.54	27.5025	27.515	64948.0
2016-04-05 17:30:00	AAPL	Stock	27.535	27.535	27.5	27.5225	15600.0
2016-04-05 18:00:00	AAPL	Stock	27.5225	27.5225	27.5125	27.52	4660.0
2016-04-05 18:30:00	AAPL	Stock	27.525	27.5325	27.5025	27.5325	9908.0
2016-04-05 19:00:00	AAPL	Stock	27.5325	27.54	27.5125	27.54	4700.0
2016-04-05 19:30:00	AAPL	Stock	27.5375	27.5625	27.5275	27.5275	30240.0
2016-04-05 07:30:00	MSFT	Stock	54.9	54.92	54.86	54.86	300.0
2016-04-05 08:00:00	MSFT	Stock	54.85	55.0	54.85	54.9	3188.0
2016-04-05 08:30:00	MSFT	Stock	54.9	55.0	54.9	55.0	2462.0
2016-04-05 09:00:00	MSFT	Stock	54.97	55.2	54.97	55.2	6520.0
2016-04-05 09:30:00	MSFT	Stock	55.19	55.3	54.71	54.808	2424202.0
2016-04-05 10:00:00	MSFT	Stock	54.805	55.25	54.805	55.22	1354080.0
2016-04-05 10:30:00	MSFT	Stock	55.21	55.225	54.9	54.945	1158161.0
2016-04-05 11:00:00	MSFT	Stock	54.94	55.07	54.93	54.976	910483.0
2016-04-05 11:30:00	MSFT	Stock	54.975	55.07	54.79	54.85	788239.0
2016-04-05 12:00:00	MSFT	Stock	54.845	54.91	54.56	54.56	888522.0
2016-04-05 12:30:00	MSFT	Stock	54.56	54.67	54.46	54.5	1411154.0
2016-04-05 13:00:00	MSFT	Stock	54.5	54.79	54.49	54.78	840097.0
2016-04-05 13:30:00	MSFT	Stock	54.79	54.88	54.7	54.8	693942.0
2016-04-05 14:00:00	MSFT	Stock	54.81	54.92	54.73	54.91	1005319.0
2016-04-05 14:30:00	MSFT	Stock	54.9	54.944	54.86	54.87	629621.0
2016-04-05 15:00:00	MSFT	Stock	54.874	54.89	54.71	54.746	852818.0
2016-04-05 15:30:00	MSFT	Stock	54.75	54.8	54.47	54.56	3088139.0
2016-04-05 16:00:00	MSFT	Stock	54.57	55.43	54.55	55.43	1578611.0

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

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