PREVIEW / stock_30min / 2017-11-09

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-09.parquet
  size:    1.7 MB
  rows:    85,459
  symbols: 2,929

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-09 04:00:00	AAPL	Stock	44.075	44.1725	44.075	44.145	9052.0
2017-11-09 05:00:00	AAPL	Stock	44.1125	44.1375	44.1125	44.1375	4924.0
2017-11-09 05:30:00	AAPL	Stock	44.1425	44.1425	44.1425	44.1425	652.0
2017-11-09 06:00:00	AAPL	Stock	44.08	44.15	44.015	44.015	40632.0
2017-11-09 06:30:00	AAPL	Stock	44.025	44.0275	43.95	43.9875	56128.0
2017-11-09 07:00:00	AAPL	Stock	44.0125	44.075	43.9625	43.9875	119468.0
2017-11-09 07:30:00	AAPL	Stock	43.995	44.0	43.875	43.875	138604.0
2017-11-09 08:00:00	AAPL	Stock	43.8925	44.05	43.7375	43.7475	558972.0
2017-11-09 08:30:00	AAPL	Stock	43.75	43.855	43.7275	43.7825	377904.0
2017-11-09 09:00:00	AAPL	Stock	43.8	43.85	43.775	43.82	254816.0
2017-11-09 09:30:00	AAPL	Stock	43.82	43.98	43.7	43.8425	16281952.0
2017-11-09 10:00:00	AAPL	Stock	43.845	44.0238	43.825	43.98	7835288.0
2017-11-09 10:30:00	AAPL	Stock	43.985	43.995	43.795	43.9275	5702188.0
2017-11-09 11:00:00	AAPL	Stock	43.93	43.9358	43.7625	43.8275	4521368.0
2017-11-09 11:30:00	AAPL	Stock	43.825	43.8525	43.6675	43.7162	7825292.0
2017-11-09 12:00:00	AAPL	Stock	43.71	43.7582	43.465	43.5325	11606776.0
2017-11-09 12:30:00	AAPL	Stock	43.525	43.5325	43.285	43.465	8733540.0
2017-11-09 13:00:00	AAPL	Stock	43.4625	43.6225	43.355	43.595	4532840.0
2017-11-09 13:30:00	AAPL	Stock	43.5962	43.7075	43.5875	43.7025	4646000.0
2017-11-09 14:00:00	AAPL	Stock	43.705	43.8125	43.6775	43.6925	5128608.0
2017-11-09 14:30:00	AAPL	Stock	43.6925	43.85	43.6875	43.825	4015416.0
2017-11-09 15:00:00	AAPL	Stock	43.825	43.8875	43.745	43.86	4376984.0
2017-11-09 15:30:00	AAPL	Stock	43.8625	43.98	43.86	43.9675	9996900.0
2017-11-09 16:00:00	AAPL	Stock	43.975	44.0	43.925	43.995	3553076.0
2017-11-09 16:30:00	AAPL	Stock	44.0025	44.0025	43.9625	43.9875	1735252.0
2017-11-09 17:00:00	AAPL	Stock	43.995	44.02	43.97	43.9925	116888.0
2017-11-09 17:30:00	AAPL	Stock	43.9925	43.9975	43.97	43.9875	25856.0
2017-11-09 18:00:00	AAPL	Stock	43.9875	43.995	43.9775	43.995	22672.0
2017-11-09 18:30:00	AAPL	Stock	43.995	43.9975	43.99	43.995	57632.0
2017-11-09 19:00:00	AAPL	Stock	43.995	43.995	43.975	43.9925	65312.0
2017-11-09 19:30:00	AAPL	Stock	43.9825	44.0	43.9525	44.0	53832.0
2017-11-09 04:30:00	MSFT	Stock	84.83	84.83	84.83	84.83	333.0
2017-11-09 07:30:00	MSFT	Stock	84.54	84.54	84.21	84.21	4652.0
2017-11-09 08:00:00	MSFT	Stock	84.31	84.54	84.01	84.03	20097.0
2017-11-09 08:30:00	MSFT	Stock	84.05	84.14	84.05	84.08	5474.0
2017-11-09 09:00:00	MSFT	Stock	84.2	84.27	84.06	84.09	10699.0
2017-11-09 09:30:00	MSFT	Stock	84.11	84.16	83.47	83.633	2007869.0
2017-11-09 10:00:00	MSFT	Stock	83.64	84.27	83.62	84.065	1552422.0
2017-11-09 10:30:00	MSFT	Stock	84.07	84.11	83.72	84.03	982747.0
2017-11-09 11:00:00	MSFT	Stock	84.02	84.025	83.5	83.61	1144473.0
2017-11-09 11:30:00	MSFT	Stock	83.605	83.66	83.09	83.33	1612226.0
2017-11-09 12:00:00	MSFT	Stock	83.326	83.39	82.98	83.061	1426630.0
2017-11-09 12:30:00	MSFT	Stock	83.06	83.357	82.9	83.29	1435356.0
2017-11-09 13:00:00	MSFT	Stock	83.3	83.62	83.14	83.59	876137.0
2017-11-09 13:30:00	MSFT	Stock	83.595	83.86	83.42	83.624	1023316.0
2017-11-09 14:00:00	MSFT	Stock	83.625	83.91	83.605	83.73	836856.0
2017-11-09 14:30:00	MSFT	Stock	83.73	83.89	83.68	83.84	796770.0
2017-11-09 15:00:00	MSFT	Stock	83.83	83.976	83.73	83.925	956951.0
2017-11-09 15:30:00	MSFT	Stock	83.925	84.17	83.9	84.09	2181278.0
2017-11-09 16:00:00	MSFT	Stock	84.1	84.1	84.05	84.06	2030565.0

> showing 50 of 85,459 rows — these rows as CSV

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