PREVIEW / stock_30min / 2016-01-27

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-27.parquet
  size:    1.6 MB
  rows:    82,178
  symbols: 3,359

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-01-27 04:00:00	AAPL	Stock	24.2625	24.3125	24.2625	24.3125	800.0
2016-01-27 04:30:00	AAPL	Stock	24.32	24.325	24.275	24.325	30996.0
2016-01-27 05:00:00	AAPL	Stock	24.3025	24.325	24.2	24.25	76564.0
2016-01-27 05:30:00	AAPL	Stock	24.2475	24.3125	23.9425	24.125	126932.0
2016-01-27 06:00:00	AAPL	Stock	24.1525	24.195	23.4198	23.9975	303384.0
2016-01-27 06:30:00	AAPL	Stock	24.0475	24.1225	23.87	23.9725	556644.0
2016-01-27 07:00:00	AAPL	Stock	23.9675	24.0625	23.905	23.99	1058532.0
2016-01-27 07:30:00	AAPL	Stock	23.9775	24.1025	23.975	24.1025	1385904.0
2016-01-27 08:00:00	AAPL	Stock	24.0875	24.2475	23.925	24.22	3286920.0
2016-01-27 08:30:00	AAPL	Stock	24.22	24.295	24.145	24.1475	3016180.0
2016-01-27 09:00:00	AAPL	Stock	24.155	24.25	24.0	24.01	3304656.0
2016-01-27 09:30:00	AAPL	Stock	24.01	24.1572	23.665	23.832	96312840.0
2016-01-27 10:00:00	AAPL	Stock	23.83	23.8875	23.595	23.67	46990668.0
2016-01-27 10:30:00	AAPL	Stock	23.6725	23.735	23.555	23.5695	35372348.0
2016-01-27 11:00:00	AAPL	Stock	23.5675	23.6225	23.51	23.5508	31653420.0
2016-01-27 11:30:00	AAPL	Stock	23.55	23.855	23.55	23.8525	39115648.0
2016-01-27 12:00:00	AAPL	Stock	23.8525	24.0475	23.8225	23.8825	48691780.0
2016-01-27 12:30:00	AAPL	Stock	23.88	23.9	23.78	23.8275	19357576.0
2016-01-27 13:00:00	AAPL	Stock	23.8275	23.935	23.805	23.8562	22898692.0
2016-01-27 13:30:00	AAPL	Stock	23.855	23.8675	23.755	23.817	15273020.0
2016-01-27 14:00:00	AAPL	Stock	23.8175	23.8875	23.6275	23.685	33354300.0
2016-01-27 14:30:00	AAPL	Stock	23.685	23.695	23.4725	23.5298	25625860.0
2016-01-27 15:00:00	AAPL	Stock	23.52	23.545	23.38	23.475	28350652.0
2016-01-27 15:30:00	AAPL	Stock	23.4775	23.5325	23.335	23.3575	32280204.0
2016-01-27 16:00:00	AAPL	Stock	23.355	23.751	23.34	23.375	8912216.0
2016-01-27 16:30:00	AAPL	Stock	23.375	23.809	23.355	23.3875	619604.0
2016-01-27 17:00:00	AAPL	Stock	23.395	23.6785	23.365	23.3725	839984.0
2016-01-27 17:30:00	AAPL	Stock	23.3725	23.425	23.3725	23.4075	350528.0
2016-01-27 18:00:00	AAPL	Stock	23.3975	23.43	23.3975	23.4075	157028.0
2016-01-27 18:30:00	AAPL	Stock	23.425	23.475	23.4125	23.4425	271780.0
2016-01-27 19:00:00	AAPL	Stock	23.4575	23.4575	23.405	23.425	83188.0
2016-01-27 19:30:00	AAPL	Stock	23.4375	23.485	23.425	23.4775	119360.0
2016-01-27 04:30:00	MSFT	Stock	51.79	51.79	51.79	51.79	3897.0
2016-01-27 07:00:00	MSFT	Stock	51.78	51.78	51.77	51.77	900.0
2016-01-27 07:30:00	MSFT	Stock	51.88	51.88	51.85	51.88	730.0
2016-01-27 08:00:00	MSFT	Stock	51.8	51.95	51.8	51.95	2044.0
2016-01-27 08:30:00	MSFT	Stock	51.99	52.07	51.93	52.03	7722.0
2016-01-27 09:00:00	MSFT	Stock	52.05	52.17	51.96	52.0	19468.0
2016-01-27 09:30:00	MSFT	Stock	52.01	52.165	51.99	52.01	2819057.0
2016-01-27 10:00:00	MSFT	Stock	52.0	52.01	51.25	51.26	3017932.0
2016-01-27 10:30:00	MSFT	Stock	51.26	51.68	51.255	51.676	1731912.0
2016-01-27 11:00:00	MSFT	Stock	51.67	51.845	51.55	51.805	1365933.0
2016-01-27 11:30:00	MSFT	Stock	51.8	52.17	51.78	52.035	1708186.0
2016-01-27 12:00:00	MSFT	Stock	52.04	52.18	52.03	52.07	1472046.0
2016-01-27 12:30:00	MSFT	Stock	52.07	52.185	52.0	52.05	939034.0
2016-01-27 13:00:00	MSFT	Stock	52.05	52.12	51.9	52.02	1234467.0
2016-01-27 13:30:00	MSFT	Stock	52.02	52.09	51.91	52.07	1122457.0
2016-01-27 14:00:00	MSFT	Stock	52.08	52.2	51.61	51.82	3747764.0
2016-01-27 14:30:00	MSFT	Stock	51.82	51.88	51.28	51.395	2181875.0
2016-01-27 15:00:00	MSFT	Stock	51.393	51.396	51.07	51.165	4495490.0

> showing 50 of 82,178 rows — these rows as CSV

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