PREVIEW / stock_30min / 2016-06-29

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-29.parquet
  size:    1.6 MB
  rows:    83,422
  symbols: 3,297

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-06-29 04:00:00	AAPL	Stock	23.45	23.45	23.45	23.45	400.0
2016-06-29 04:30:00	AAPL	Stock	23.45	23.46	23.45	23.46	4400.0
2016-06-29 05:30:00	AAPL	Stock	23.495	23.495	23.495	23.495	640.0
2016-06-29 06:00:00	AAPL	Stock	23.4875	23.52	23.4875	23.5	7840.0
2016-06-29 06:30:00	AAPL	Stock	23.4875	23.495	23.475	23.495	7512.0
2016-06-29 07:00:00	AAPL	Stock	23.475	23.495	23.4675	23.485	18456.0
2016-06-29 07:30:00	AAPL	Stock	23.485	23.5075	23.485	23.5075	43996.0
2016-06-29 08:00:00	AAPL	Stock	23.5075	23.525	23.465	23.5125	139836.0
2016-06-29 08:30:00	AAPL	Stock	23.5125	23.5325	23.5025	23.5275	144680.0
2016-06-29 09:00:00	AAPL	Stock	23.52	23.535	23.475	23.4925	123380.0
2016-06-29 09:30:00	AAPL	Stock	23.4925	23.6275	23.455	23.6075	19297024.0
2016-06-29 10:00:00	AAPL	Stock	23.6075	23.615	23.4625	23.52	14459780.0
2016-06-29 10:30:00	AAPL	Stock	23.5225	23.5575	23.4075	23.435	10380612.0
2016-06-29 11:00:00	AAPL	Stock	23.4332	23.55	23.4325	23.535	8799760.0
2016-06-29 11:30:00	AAPL	Stock	23.5375	23.58	23.4875	23.5775	7283052.0
2016-06-29 12:00:00	AAPL	Stock	23.575	23.625	23.5675	23.6097	7790692.0
2016-06-29 12:30:00	AAPL	Stock	23.6097	23.6097	23.53	23.5525	5378476.0
2016-06-29 13:00:00	AAPL	Stock	23.5525	23.5825	23.5325	23.5652	4910284.0
2016-06-29 13:30:00	AAPL	Stock	23.5668	23.6075	23.56	23.5925	4904136.0
2016-06-29 14:00:00	AAPL	Stock	23.592	23.62	23.575	23.605	6421308.0
2016-06-29 14:30:00	AAPL	Stock	23.6062	23.635	23.5825	23.595	7827284.0
2016-06-29 15:00:00	AAPL	Stock	23.595	23.6375	23.585	23.6338	8142228.0
2016-06-29 15:30:00	AAPL	Stock	23.635	23.6375	23.58	23.6	15510716.0
2016-06-29 16:00:00	AAPL	Stock	23.6	23.62	23.55	23.5675	12784820.0
2016-06-29 16:30:00	AAPL	Stock	23.6	23.6175	23.575	23.61	263928.0
2016-06-29 17:00:00	AAPL	Stock	23.6175	23.6175	23.6025	23.6025	35020.0
2016-06-29 17:30:00	AAPL	Stock	23.605	23.61	23.6	23.605	35244.0
2016-06-29 18:00:00	AAPL	Stock	23.6075	23.6075	23.6	23.605	9112.0
2016-06-29 18:30:00	AAPL	Stock	23.5975	23.6025	23.5975	23.5975	3432.0
2016-06-29 19:00:00	AAPL	Stock	23.595	23.595	23.5525	23.5575	25388.0
2016-06-29 19:30:00	AAPL	Stock	23.5625	23.5875	23.5625	23.5875	15856.0
2016-06-29 04:00:00	MSFT	Stock	49.56	49.56	49.56	49.56	100.0
2016-06-29 04:30:00	MSFT	Stock	49.82	49.82	49.82	49.82	200.0
2016-06-29 06:00:00	MSFT	Stock	49.75	49.75	49.75	49.75	400.0
2016-06-29 06:30:00	MSFT	Stock	49.88	49.9	49.88	49.9	1499.0
2016-06-29 07:00:00	MSFT	Stock	49.8	49.9	49.8	49.9	1200.0
2016-06-29 07:30:00	MSFT	Stock	49.85	49.85	49.77	49.77	452.0
2016-06-29 08:00:00	MSFT	Stock	49.77	49.94	49.77	49.9	6390.0
2016-06-29 08:30:00	MSFT	Stock	49.9	49.95	49.85	49.95	4617.0
2016-06-29 09:00:00	MSFT	Stock	49.95	50.06	49.86	49.91	46143.0
2016-06-29 09:30:00	MSFT	Stock	49.91	50.1	49.8	50.02	3106795.0
2016-06-29 10:00:00	MSFT	Stock	50.02	50.14	49.96	50.115	1605199.0
2016-06-29 10:30:00	MSFT	Stock	50.115	50.16	49.92	50.015	1411541.0
2016-06-29 11:00:00	MSFT	Stock	50.015	50.23	50.005	50.23	1494558.0
2016-06-29 11:30:00	MSFT	Stock	50.23	50.35	50.21	50.34	1446569.0
2016-06-29 12:00:00	MSFT	Stock	50.34	50.49	50.3	50.49	1574741.0
2016-06-29 12:30:00	MSFT	Stock	50.485	50.53	50.39	50.51	1372234.0
2016-06-29 13:00:00	MSFT	Stock	50.515	50.54	50.4	50.52	1049016.0
2016-06-29 13:30:00	MSFT	Stock	50.525	50.55	50.45	50.545	1453338.0
2016-06-29 14:00:00	MSFT	Stock	50.548	50.64	50.5	50.575	1570137.0

> showing 50 of 83,422 rows — these rows as CSV

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