PREVIEW / stock_30min / 2017-11-28

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-28.parquet
  size:    1.7 MB
  rows:    84,494
  symbols: 2,958

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-11-28 05:30:00	AAPL	Stock	43.4875	43.495	43.4875	43.495	1200.0
2017-11-28 06:00:00	AAPL	Stock	43.4875	43.505	43.4875	43.5	2400.0
2017-11-28 06:30:00	AAPL	Stock	43.5	43.5725	43.5	43.5725	2800.0
2017-11-28 07:00:00	AAPL	Stock	43.525	43.625	43.525	43.595	65132.0
2017-11-28 07:30:00	AAPL	Stock	43.6125	43.625	43.6025	43.6125	12316.0
2017-11-28 08:00:00	AAPL	Stock	43.5225	43.6875	43.5225	43.5975	1720932.0
2017-11-28 08:30:00	AAPL	Stock	43.6	43.605	43.5275	43.605	188436.0
2017-11-28 09:00:00	AAPL	Stock	43.585	43.6375	43.525	43.545	375908.0
2017-11-28 09:30:00	AAPL	Stock	43.5625	43.7175	43.45	43.4725	11941992.0
2017-11-28 10:00:00	AAPL	Stock	43.47	43.5	43.4025	43.47	4624872.0
2017-11-28 10:30:00	AAPL	Stock	43.4725	43.55	43.27	43.3275	7226392.0
2017-11-28 11:00:00	AAPL	Stock	43.3288	43.365	43.205	43.24	7183708.0
2017-11-28 11:30:00	AAPL	Stock	43.2382	43.3075	43.175	43.2438	4916016.0
2017-11-28 12:00:00	AAPL	Stock	43.2425	43.2715	43.1375	43.264	4862260.0
2017-11-28 12:30:00	AAPL	Stock	43.265	43.345	43.2125	43.22	3687284.0
2017-11-28 13:00:00	AAPL	Stock	43.2225	43.3	43.1875	43.227	4610556.0
2017-11-28 13:30:00	AAPL	Stock	43.2275	43.2575	43.095	43.1158	5186128.0
2017-11-28 14:00:00	AAPL	Stock	43.1175	43.2125	42.965	43.195	7233024.0
2017-11-28 14:30:00	AAPL	Stock	43.1927	43.275	43.1592	43.21	4101584.0
2017-11-28 15:00:00	AAPL	Stock	43.2125	43.2975	43.19	43.2275	6504216.0
2017-11-28 15:30:00	AAPL	Stock	43.2275	43.27	43.1825	43.25	8432096.0
2017-11-28 16:00:00	AAPL	Stock	43.2675	43.275	43.225	43.26	5307896.0
2017-11-28 16:30:00	AAPL	Stock	43.2675	43.2925	43.265	43.265	83624.0
2017-11-28 17:00:00	AAPL	Stock	43.265	43.2675	43.23	43.23	35888.0
2017-11-28 17:30:00	AAPL	Stock	43.2475	43.2675	43.1525	43.1575	101020.0
2017-11-28 18:00:00	AAPL	Stock	43.2375	43.25	43.2	43.2425	16892.0
2017-11-28 18:30:00	AAPL	Stock	43.24	43.24	43.225	43.24	15400.0
2017-11-28 19:00:00	AAPL	Stock	43.25	43.25	43.25	43.25	2264.0
2017-11-28 19:30:00	AAPL	Stock	43.245	43.265	43.245	43.265	16488.0
2017-11-28 07:00:00	MSFT	Stock	83.87	83.87	83.87	83.87	300.0
2017-11-28 07:30:00	MSFT	Stock	83.98	84.01	83.95	83.95	4180.0
2017-11-28 08:00:00	MSFT	Stock	83.87	84.08	83.87	84.05	608005.0
2017-11-28 08:30:00	MSFT	Stock	84.06	84.09	84.06	84.09	6193.0
2017-11-28 09:00:00	MSFT	Stock	84.09	84.09	83.97	84.04	7207.0
2017-11-28 09:30:00	MSFT	Stock	84.06	84.87	84.02	84.745	2165774.0
2017-11-28 10:00:00	MSFT	Stock	84.75	85.06	84.605	84.656	2355182.0
2017-11-28 10:30:00	MSFT	Stock	84.655	84.73	84.46	84.535	1333331.0
2017-11-28 11:00:00	MSFT	Stock	84.54	84.74	84.535	84.72	685856.0
2017-11-28 11:30:00	MSFT	Stock	84.72	84.815	84.624	84.665	1110905.0
2017-11-28 12:00:00	MSFT	Stock	84.67	84.83	84.665	84.79	907535.0
2017-11-28 12:30:00	MSFT	Stock	84.785	84.8	84.715	84.774	652864.0
2017-11-28 13:00:00	MSFT	Stock	84.775	84.92	84.72	84.795	741427.0
2017-11-28 13:30:00	MSFT	Stock	84.795	84.84	84.44	84.5	914180.0
2017-11-28 14:00:00	MSFT	Stock	84.51	84.69	84.38	84.69	767583.0
2017-11-28 14:30:00	MSFT	Stock	84.69	84.95	84.686	84.815	765932.0
2017-11-28 15:00:00	MSFT	Stock	84.81	84.92	84.73	84.75	1123180.0
2017-11-28 15:30:00	MSFT	Stock	84.76	84.89	84.67	84.88	2415681.0
2017-11-28 16:00:00	MSFT	Stock	84.88	84.88	84.76	84.88	1758049.0
2017-11-28 16:30:00	MSFT	Stock	84.87	84.88	84.78	84.78	2798.0
2017-11-28 17:00:00	MSFT	Stock	84.88	84.88	84.88	84.88	562.0

> showing 50 of 84,494 rows — these rows as CSV

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