PREVIEW / stock_30min / 2016-10-27

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-27.parquet
  size:    1.6 MB
  rows:    80,106
  symbols: 3,182

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-10-27 04:00:00	AAPL	Stock	28.925	28.935	28.925	28.935	4480.0
2016-10-27 04:30:00	AAPL	Stock	28.9125	28.9125	28.9125	28.9125	400.0
2016-10-27 05:00:00	AAPL	Stock	28.925	28.925	28.925	28.925	400.0
2016-10-27 05:30:00	AAPL	Stock	28.9325	28.9425	28.93	28.9375	4956.0
2016-10-27 06:00:00	AAPL	Stock	28.9425	28.97	28.9325	28.95	16920.0
2016-10-27 06:30:00	AAPL	Stock	28.9575	28.9875	28.9375	28.9375	8620.0
2016-10-27 07:00:00	AAPL	Stock	28.945	28.9725	28.945	28.9625	16112.0
2016-10-27 07:30:00	AAPL	Stock	28.96	28.96	28.905	28.9175	39980.0
2016-10-27 08:00:00	AAPL	Stock	28.92	28.95	28.9	28.9125	186588.0
2016-10-27 08:30:00	AAPL	Stock	28.9075	28.9125	28.865	28.895	86488.0
2016-10-27 09:00:00	AAPL	Stock	28.885	28.9175	28.795	28.845	398744.0
2016-10-27 09:30:00	AAPL	Stock	28.8475	28.965	28.75	28.855	16623188.0
2016-10-27 10:00:00	AAPL	Stock	28.855	28.865	28.69	28.735	11155072.0
2016-10-27 10:30:00	AAPL	Stock	28.7375	28.765	28.7	28.7525	6298520.0
2016-10-27 11:00:00	AAPL	Stock	28.75	28.7688	28.7185	28.7275	5037668.0
2016-10-27 11:30:00	AAPL	Stock	28.7275	28.8125	28.6925	28.789	6045692.0
2016-10-27 12:00:00	AAPL	Stock	28.79	28.8125	28.76	28.8	4877692.0
2016-10-27 12:30:00	AAPL	Stock	28.8	28.8075	28.725	28.7462	3976440.0
2016-10-27 13:00:00	AAPL	Stock	28.745	28.7565	28.7075	28.721	3743064.0
2016-10-27 13:30:00	AAPL	Stock	28.7212	28.76	28.7125	28.7425	2816184.0
2016-10-27 14:00:00	AAPL	Stock	28.7425	28.7875	28.74	28.7628	3397856.0
2016-10-27 14:30:00	AAPL	Stock	28.765	28.7725	28.7125	28.7175	4713472.0
2016-10-27 15:00:00	AAPL	Stock	28.7175	28.735	28.5725	28.6178	8292136.0
2016-10-27 15:30:00	AAPL	Stock	28.6175	28.64	28.525	28.625	13613748.0
2016-10-27 16:00:00	AAPL	Stock	28.625	28.7132	28.525	28.54	22470080.0
2016-10-27 16:30:00	AAPL	Stock	28.54	28.62	28.5375	28.57	160692.0
2016-10-27 17:00:00	AAPL	Stock	28.57	28.5875	28.5475	28.5475	49164.0
2016-10-27 17:30:00	AAPL	Stock	28.5425	28.5675	28.5275	28.5475	33032.0
2016-10-27 18:00:00	AAPL	Stock	28.54	28.55	28.5375	28.54	27772.0
2016-10-27 18:30:00	AAPL	Stock	28.54	28.55	28.53	28.545	35968.0
2016-10-27 19:00:00	AAPL	Stock	28.5425	28.5425	28.525	28.535	49600.0
2016-10-27 19:30:00	AAPL	Stock	28.535	28.5675	28.5325	28.5675	22900.0
2016-10-27 04:00:00	MSFT	Stock	60.73	60.73	60.73	60.73	180.0
2016-10-27 07:30:00	MSFT	Stock	60.8	60.8	60.8	60.8	300.0
2016-10-27 08:00:00	MSFT	Stock	60.83	60.83	60.75	60.8	3154.0
2016-10-27 08:30:00	MSFT	Stock	60.83	60.85	60.75	60.85	8900.0
2016-10-27 09:00:00	MSFT	Stock	60.8	60.84	60.61	60.61	50787.0
2016-10-27 09:30:00	MSFT	Stock	60.62	60.83	60.5	60.675	3685833.0
2016-10-27 10:00:00	MSFT	Stock	60.68	60.76	60.57	60.68	2220247.0
2016-10-27 10:30:00	MSFT	Stock	60.675	60.725	60.55	60.585	1533935.0
2016-10-27 11:00:00	MSFT	Stock	60.59	60.655	60.54	60.62	1451797.0
2016-10-27 11:30:00	MSFT	Stock	60.615	60.695	60.5	60.665	1392348.0
2016-10-27 12:00:00	MSFT	Stock	60.67	60.7	60.57	60.595	886841.0
2016-10-27 12:30:00	MSFT	Stock	60.585	60.605	60.48	60.515	1204955.0
2016-10-27 13:00:00	MSFT	Stock	60.512	60.56	60.45	60.545	782403.0
2016-10-27 13:30:00	MSFT	Stock	60.543	60.575	60.51	60.535	1015503.0
2016-10-27 14:00:00	MSFT	Stock	60.54	60.56	60.47	60.525	1125500.0
2016-10-27 14:30:00	MSFT	Stock	60.53	60.53	60.435	60.495	1439409.0
2016-10-27 15:00:00	MSFT	Stock	60.5	60.53	60.2	60.24	2366757.0
2016-10-27 15:30:00	MSFT	Stock	60.24	60.27	60.09	60.11	5427372.0

> showing 50 of 80,106 rows — these rows as CSV

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