PREVIEW / stock_30min / 2016-12-09

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-09.parquet
  size:    1.6 MB
  rows:    83,111
  symbols: 3,167

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-12-09 04:00:00	AAPL	Stock	28.0	28.0	28.0	28.0	5600.0
2016-12-09 04:30:00	AAPL	Stock	27.9125	27.9125	27.9125	27.9125	1200.0
2016-12-09 05:00:00	AAPL	Stock	27.905	27.905	27.905	27.905	800.0
2016-12-09 05:30:00	AAPL	Stock	27.95	27.95	27.95	27.95	400.0
2016-12-09 06:30:00	AAPL	Stock	27.9375	27.9375	27.9375	27.9375	1248.0
2016-12-09 07:00:00	AAPL	Stock	27.995	28.01	27.99	28.005	35056.0
2016-12-09 07:30:00	AAPL	Stock	27.9925	28.0225	27.9925	28.0075	13372.0
2016-12-09 08:00:00	AAPL	Stock	28.025	28.0275	27.975	28.025	53508.0
2016-12-09 08:30:00	AAPL	Stock	28.02	28.1	28.02	28.0875	52572.0
2016-12-09 09:00:00	AAPL	Stock	28.0875	28.1525	28.0875	28.13	178048.0
2016-12-09 09:30:00	AAPL	Stock	28.0775	28.3775	28.0775	28.3575	20199724.0
2016-12-09 10:00:00	AAPL	Stock	28.3575	28.5	28.29	28.4925	13565012.0
2016-12-09 10:30:00	AAPL	Stock	28.495	28.675	28.47	28.52	18075336.0
2016-12-09 11:00:00	AAPL	Stock	28.5225	28.6375	28.52	28.5675	9535080.0
2016-12-09 11:30:00	AAPL	Stock	28.57	28.5775	28.5125	28.56	6970424.0
2016-12-09 12:00:00	AAPL	Stock	28.565	28.575	28.5238	28.535	4637208.0
2016-12-09 12:30:00	AAPL	Stock	28.5328	28.55	28.445	28.45	4711968.0
2016-12-09 13:00:00	AAPL	Stock	28.4525	28.4875	28.3975	28.4675	4975136.0
2016-12-09 13:30:00	AAPL	Stock	28.465	28.5325	28.4375	28.5228	3589836.0
2016-12-09 14:00:00	AAPL	Stock	28.5225	28.5375	28.4675	28.4938	4621816.0
2016-12-09 14:30:00	AAPL	Stock	28.4935	28.5152	28.47	28.5132	3508108.0
2016-12-09 15:00:00	AAPL	Stock	28.515	28.575	28.511	28.5312	7206168.0
2016-12-09 15:30:00	AAPL	Stock	28.5338	28.56	28.445	28.49	14373056.0
2016-12-09 16:00:00	AAPL	Stock	28.46	28.4875	28.4575	28.4875	8464008.0
2016-12-09 16:30:00	AAPL	Stock	28.48	28.4875	28.47	28.47	182932.0
2016-12-09 17:00:00	AAPL	Stock	28.475	28.4925	28.47	28.4875	23852.0
2016-12-09 17:30:00	AAPL	Stock	28.4875	28.4875	28.4775	28.4775	194800.0
2016-12-09 18:00:00	AAPL	Stock	28.485	28.4875	28.4475	28.4625	43804.0
2016-12-09 18:30:00	AAPL	Stock	28.455	28.4725	28.455	28.4725	3612.0
2016-12-09 19:00:00	AAPL	Stock	28.4625	28.4725	28.4525	28.4525	4820.0
2016-12-09 19:30:00	AAPL	Stock	28.45	28.47	28.4475	28.4475	35080.0
2016-12-09 06:00:00	MSFT	Stock	61.04	61.04	61.04	61.04	500.0
2016-12-09 07:00:00	MSFT	Stock	60.91	60.91	60.85	60.85	10920.0
2016-12-09 08:00:00	MSFT	Stock	60.85	61.15	60.85	61.02	21554.0
2016-12-09 08:30:00	MSFT	Stock	61.01	61.02	61.01	61.02	1826.0
2016-12-09 09:00:00	MSFT	Stock	61.02	61.26	61.02	61.16	21524.0
2016-12-09 09:30:00	MSFT	Stock	61.18	61.62	61.125	61.43	2720253.0
2016-12-09 10:00:00	MSFT	Stock	61.43	61.75	61.31	61.67	1992698.0
2016-12-09 10:30:00	MSFT	Stock	61.67	61.8	61.575	61.68	1086383.0
2016-12-09 11:00:00	MSFT	Stock	61.68	61.726	61.59	61.67	1376166.0
2016-12-09 11:30:00	MSFT	Stock	61.67	61.845	61.64	61.78	2020559.0
2016-12-09 12:00:00	MSFT	Stock	61.79	61.83	61.72	61.79	967713.0
2016-12-09 12:30:00	MSFT	Stock	61.795	61.87	61.77	61.8	1110571.0
2016-12-09 13:00:00	MSFT	Stock	61.8	61.93	61.8	61.92	889650.0
2016-12-09 13:30:00	MSFT	Stock	61.92	61.93	61.8	61.93	1032663.0
2016-12-09 14:00:00	MSFT	Stock	61.93	61.93	61.79	61.81	967708.0
2016-12-09 14:30:00	MSFT	Stock	61.81	61.875	61.79	61.86	1001861.0
2016-12-09 15:00:00	MSFT	Stock	61.87	61.97	61.83	61.965	1608260.0
2016-12-09 15:30:00	MSFT	Stock	61.969	61.99	61.86	61.98	3511249.0
2016-12-09 16:00:00	MSFT	Stock	61.97	62.03	61.92	61.97	5020874.0

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

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