PREVIEW / stock_30min / 2017-11-30

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-30.parquet
  size:    1.7 MB
  rows:    86,741
  symbols: 2,957

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-30 04:00:00	AAPL	Stock	42.3	42.425	42.3	42.4225	19800.0
2017-11-30 04:30:00	AAPL	Stock	42.4425	42.4425	42.4275	42.4275	3200.0
2017-11-30 05:00:00	AAPL	Stock	42.4725	42.525	42.45	42.525	23712.0
2017-11-30 05:30:00	AAPL	Stock	42.5475	42.55	42.5475	42.55	3992.0
2017-11-30 06:00:00	AAPL	Stock	42.57	42.5775	42.545	42.5775	16108.0
2017-11-30 06:30:00	AAPL	Stock	42.595	42.595	42.54	42.5625	8584.0
2017-11-30 07:00:00	AAPL	Stock	42.575	42.6	42.505	42.595	74200.0
2017-11-30 07:30:00	AAPL	Stock	42.6	42.605	42.55	42.6	186400.0
2017-11-30 08:00:00	AAPL	Stock	42.605	42.7	42.515	42.7	329024.0
2017-11-30 08:30:00	AAPL	Stock	42.71	42.71	42.6375	42.685	231780.0
2017-11-30 09:00:00	AAPL	Stock	42.68	42.91	42.5975	42.62	1021320.0
2017-11-30 09:30:00	AAPL	Stock	42.6075	42.67	42.11	42.5	22581924.0
2017-11-30 10:00:00	AAPL	Stock	42.5075	42.73	42.4888	42.7	10208924.0
2017-11-30 10:30:00	AAPL	Stock	42.7	42.7725	42.5925	42.61	7573204.0
2017-11-30 11:00:00	AAPL	Stock	42.61	42.875	42.585	42.7065	7394996.0
2017-11-30 11:30:00	AAPL	Stock	42.7125	42.7855	42.68	42.7425	4034104.0
2017-11-30 12:00:00	AAPL	Stock	42.7425	42.8225	42.6925	42.815	3982008.0
2017-11-30 12:30:00	AAPL	Stock	42.8125	42.875	42.7125	42.8235	5010000.0
2017-11-30 13:00:00	AAPL	Stock	42.8225	42.97	42.8075	42.96	6145432.0
2017-11-30 13:30:00	AAPL	Stock	42.96	42.9675	42.8512	42.955	4588492.0
2017-11-30 14:00:00	AAPL	Stock	42.955	42.9878	42.9	42.9575	3536232.0
2017-11-30 14:30:00	AAPL	Stock	42.9575	42.9825	42.8825	42.9335	3741384.0
2017-11-30 15:00:00	AAPL	Stock	42.935	42.9465	42.8125	42.92	5134296.0
2017-11-30 15:30:00	AAPL	Stock	42.9225	43.035	42.86	42.9375	14136216.0
2017-11-30 16:00:00	AAPL	Stock	42.9425	42.9755	42.775	42.9475	23159060.0
2017-11-30 16:30:00	AAPL	Stock	42.94	42.9625	42.925	42.945	26068.0
2017-11-30 17:00:00	AAPL	Stock	42.93	42.9475	42.9275	42.9275	9784.0
2017-11-30 17:30:00	AAPL	Stock	42.9275	42.95	42.9275	42.94	21600.0
2017-11-30 18:00:00	AAPL	Stock	42.95	42.9625	42.9425	42.9425	13168.0
2017-11-30 18:30:00	AAPL	Stock	42.9425	42.95	42.925	42.925	22460.0
2017-11-30 19:00:00	AAPL	Stock	42.925	42.925	42.9	42.9125	15224.0
2017-11-30 19:30:00	AAPL	Stock	42.9225	42.93	42.8725	42.8725	75036.0
2017-11-30 07:00:00	MSFT	Stock	83.51	83.94	83.51	83.85	1518.0
2017-11-30 07:30:00	MSFT	Stock	83.76	83.76	83.44	83.5	11317.0
2017-11-30 08:00:00	MSFT	Stock	83.7	83.7	83.35	83.45	16876.0
2017-11-30 08:30:00	MSFT	Stock	83.43	83.53	83.32	83.5	22583.0
2017-11-30 09:00:00	MSFT	Stock	83.49	83.65	83.37	83.62	7545.0
2017-11-30 09:30:00	MSFT	Stock	83.61	84.03	83.34	83.87	3108110.0
2017-11-30 10:00:00	MSFT	Stock	83.88	84.02	83.61	83.65	1540939.0
2017-11-30 10:30:00	MSFT	Stock	83.66	83.88	83.555	83.64	1415382.0
2017-11-30 11:00:00	MSFT	Stock	83.64	83.94	83.59	83.68	1120357.0
2017-11-30 11:30:00	MSFT	Stock	83.675	83.92	83.61	83.91	752240.0
2017-11-30 12:00:00	MSFT	Stock	83.91	84.26	83.87	84.21	1187572.0
2017-11-30 12:30:00	MSFT	Stock	84.21	84.52	84.05	84.28	1440935.0
2017-11-30 13:00:00	MSFT	Stock	84.28	84.41	84.12	84.35	1086245.0
2017-11-30 13:30:00	MSFT	Stock	84.35	84.35	84.1	84.25	1124082.0
2017-11-30 14:00:00	MSFT	Stock	84.24	84.27	84.01	84.27	1007122.0
2017-11-30 14:30:00	MSFT	Stock	84.26	84.275	84.084	84.195	1017931.0
2017-11-30 15:00:00	MSFT	Stock	84.2	84.209	83.9	84.135	1383183.0
2017-11-30 15:30:00	MSFT	Stock	84.135	84.26	83.976	84.09	3785882.0

> showing 50 of 86,741 rows — these rows as CSV

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