PREVIEW / stock_30min / 2016-09-13

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-13.parquet
  size:    1.6 MB
  rows:    82,168
  symbols: 3,245

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-09-13 04:00:00	AAPL	Stock	26.32	26.32	26.2525	26.2525	4000.0
2016-09-13 04:30:00	AAPL	Stock	26.2525	26.2525	26.25	26.25	4200.0
2016-09-13 05:00:00	AAPL	Stock	26.245	26.26	26.225	26.26	6844.0
2016-09-13 05:30:00	AAPL	Stock	26.26	26.26	26.26	26.26	1668.0
2016-09-13 06:00:00	AAPL	Stock	26.25	26.275	26.25	26.275	5944.0
2016-09-13 06:30:00	AAPL	Stock	26.3	26.35	26.3	26.31	25552.0
2016-09-13 07:00:00	AAPL	Stock	26.3	26.35	26.3	26.35	87236.0
2016-09-13 07:30:00	AAPL	Stock	26.35	26.7475	26.35	26.73	968044.0
2016-09-13 08:00:00	AAPL	Stock	26.73	26.75	26.3275	26.6275	850492.0
2016-09-13 08:30:00	AAPL	Stock	26.625	26.9025	26.625	26.84	3573188.0
2016-09-13 09:00:00	AAPL	Stock	26.845	26.895	26.79	26.8775	1964432.0
2016-09-13 09:30:00	AAPL	Stock	26.8725	27.1975	26.81	27.0325	61141124.0
2016-09-13 10:00:00	AAPL	Stock	27.035	27.11	26.9225	27.0512	23956108.0
2016-09-13 10:30:00	AAPL	Stock	27.045	27.1375	26.9875	27.0675	15340268.0
2016-09-13 11:00:00	AAPL	Stock	27.0675	27.0825	27.005	27.015	13585320.0
2016-09-13 11:30:00	AAPL	Stock	27.016	27.0625	27.0088	27.025	9718300.0
2016-09-13 12:00:00	AAPL	Stock	27.0212	27.1	26.36	27.045	10622616.0
2016-09-13 12:30:00	AAPL	Stock	27.045	27.1	27.0238	27.046	7467396.0
2016-09-13 13:00:00	AAPL	Stock	27.0462	27.1125	26.965	27.1025	9128816.0
2016-09-13 13:30:00	AAPL	Stock	27.1002	27.12	27.0	27.0075	8209908.0
2016-09-13 14:00:00	AAPL	Stock	27.0075	27.0425	26.9548	26.9625	8924128.0
2016-09-13 14:30:00	AAPL	Stock	26.9635	27.05	26.9575	26.965	11348180.0
2016-09-13 15:00:00	AAPL	Stock	26.965	27.0425	26.93	27.035	10055616.0
2016-09-13 15:30:00	AAPL	Stock	27.0338	27.08	26.9875	27.005	26152684.0
2016-09-13 16:00:00	AAPL	Stock	26.9875	27.04	26.975	26.975	8562648.0
2016-09-13 16:30:00	AAPL	Stock	26.975	27.0	26.975	26.9925	196716.0
2016-09-13 17:00:00	AAPL	Stock	26.995	27.0	26.95	26.98	313000.0
2016-09-13 17:30:00	AAPL	Stock	26.9775	26.9925	26.9725	26.98	72420.0
2016-09-13 18:00:00	AAPL	Stock	26.9825	26.985	26.97	26.97	21648.0
2016-09-13 18:30:00	AAPL	Stock	26.9675	26.98	26.9675	26.98	32404.0
2016-09-13 19:00:00	AAPL	Stock	26.985	26.985	26.9725	26.9825	15276.0
2016-09-13 19:30:00	AAPL	Stock	26.9775	26.98	26.9525	26.9525	60340.0
2016-09-13 08:00:00	MSFT	Stock	56.73	56.73	56.71	56.71	600.0
2016-09-13 08:30:00	MSFT	Stock	56.78	56.78	56.57	56.62	2975.0
2016-09-13 09:00:00	MSFT	Stock	56.57	56.57	56.51	56.51	7200.0
2016-09-13 09:30:00	MSFT	Stock	56.49	56.64	56.25	56.375	3466690.0
2016-09-13 10:00:00	MSFT	Stock	56.38	56.425	56.18	56.32	2254371.0
2016-09-13 10:30:00	MSFT	Stock	56.32	56.485	56.19	56.23	1476159.0
2016-09-13 11:00:00	MSFT	Stock	56.22	56.26	56.05	56.09	1195463.0
2016-09-13 11:30:00	MSFT	Stock	56.09	56.3	56.06	56.264	1255914.0
2016-09-13 12:00:00	MSFT	Stock	56.26	57.05	56.19	56.21	1739302.0
2016-09-13 12:30:00	MSFT	Stock	56.21	56.32	56.1	56.185	1130011.0
2016-09-13 13:00:00	MSFT	Stock	56.18	56.392	56.07	56.37	1043104.0
2016-09-13 13:30:00	MSFT	Stock	56.37	56.455	56.22	56.31	1505068.0
2016-09-13 14:00:00	MSFT	Stock	56.305	56.39	56.19	56.2	1529375.0
2016-09-13 14:30:00	MSFT	Stock	56.2	56.4	56.17	56.22	1507219.0
2016-09-13 15:00:00	MSFT	Stock	56.22	56.38	56.12	56.31	1513916.0
2016-09-13 15:30:00	MSFT	Stock	56.32	56.65	56.28	56.53	5883715.0
2016-09-13 16:00:00	MSFT	Stock	56.53	56.55	56.49	56.53	2359143.0
2016-09-13 16:30:00	MSFT	Stock	56.55	56.57	56.55	56.57	2900.0

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

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