PREVIEW / stock_30min / 2016-10-07

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-07.parquet
  size:    1.5 MB
  rows:    79,010
  symbols: 3,186

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-07 06:00:00	AAPL	Stock	28.4525	28.4525	28.4525	28.4525	400.0
2016-10-07 06:30:00	AAPL	Stock	28.4075	28.445	28.385	28.445	3800.0
2016-10-07 07:00:00	AAPL	Stock	28.46	28.4725	28.46	28.4725	24400.0
2016-10-07 07:30:00	AAPL	Stock	28.4625	28.4625	28.4475	28.4625	20680.0
2016-10-07 08:00:00	AAPL	Stock	28.4625	28.49	28.4	28.46	122128.0
2016-10-07 08:30:00	AAPL	Stock	28.46	28.565	28.46	28.5575	355360.0
2016-10-07 09:00:00	AAPL	Stock	28.5575	28.605	28.5175	28.57	512176.0
2016-10-07 09:30:00	AAPL	Stock	28.57	28.64	28.455	28.5325	18880864.0
2016-10-07 10:00:00	AAPL	Stock	28.535	28.595	28.4975	28.585	7905784.0
2016-10-07 10:30:00	AAPL	Stock	28.5848	28.585	28.485	28.49	5490208.0
2016-10-07 11:00:00	AAPL	Stock	28.49	28.575	28.4775	28.539	5168952.0
2016-10-07 11:30:00	AAPL	Stock	28.5375	28.5425	28.3775	28.4288	8661176.0
2016-10-07 12:00:00	AAPL	Stock	28.4275	28.48	28.4275	28.4725	4557652.0
2016-10-07 12:30:00	AAPL	Stock	28.4725	28.4875	28.415	28.4875	3766604.0
2016-10-07 13:00:00	AAPL	Stock	28.485	28.5175	28.4575	28.51	3974016.0
2016-10-07 13:30:00	AAPL	Stock	28.5135	28.565	28.51	28.5475	6190424.0
2016-10-07 14:00:00	AAPL	Stock	28.5475	28.57	28.5275	28.5375	3891536.0
2016-10-07 14:30:00	AAPL	Stock	28.535	28.575	28.535	28.5425	3500740.0
2016-10-07 15:00:00	AAPL	Stock	28.5425	28.562	28.505	28.5275	3989212.0
2016-10-07 15:30:00	AAPL	Stock	28.53	28.5425	28.5025	28.5075	8365464.0
2016-10-07 16:00:00	AAPL	Stock	28.515	28.5315	28.5125	28.5125	6189344.0
2016-10-07 16:30:00	AAPL	Stock	28.51	28.51	28.5	28.5075	19304.0
2016-10-07 17:00:00	AAPL	Stock	28.5025	28.5125	28.5025	28.5125	5804.0
2016-10-07 18:00:00	AAPL	Stock	28.5	28.5	28.4925	28.4925	7516.0
2016-10-07 18:30:00	AAPL	Stock	28.5	28.5	28.4925	28.4925	4000.0
2016-10-07 19:00:00	AAPL	Stock	28.4875	28.4875	28.4675	28.4675	18672.0
2016-10-07 19:30:00	AAPL	Stock	28.4725	28.4825	28.4725	28.4825	25248.0
2016-10-07 08:00:00	MSFT	Stock	57.7	57.7	57.7	57.7	1000.0
2016-10-07 09:00:00	MSFT	Stock	57.82	57.93	57.74	57.87	85081.0
2016-10-07 09:30:00	MSFT	Stock	57.88	57.95	57.545	57.7	2830036.0
2016-10-07 10:00:00	MSFT	Stock	57.7	57.97	57.67	57.905	1384914.0
2016-10-07 10:30:00	MSFT	Stock	57.903	57.909	57.74	57.74	986865.0
2016-10-07 11:00:00	MSFT	Stock	57.74	57.86	57.71	57.78	868819.0
2016-10-07 11:30:00	MSFT	Stock	57.785	57.8	57.42	57.505	1246665.0
2016-10-07 12:00:00	MSFT	Stock	57.505	57.63	57.46	57.51	929221.0
2016-10-07 12:30:00	MSFT	Stock	57.51	57.57	57.455	57.565	660121.0
2016-10-07 13:00:00	MSFT	Stock	57.57	57.661	57.515	57.66	822451.0
2016-10-07 13:30:00	MSFT	Stock	57.66	57.86	57.66	57.825	1250085.0
2016-10-07 14:00:00	MSFT	Stock	57.826	57.94	57.77	57.89	926225.0
2016-10-07 14:30:00	MSFT	Stock	57.89	57.98	57.89	57.96	957844.0
2016-10-07 15:00:00	MSFT	Stock	57.95	57.97	57.82	57.865	900903.0
2016-10-07 15:30:00	MSFT	Stock	57.865	57.89	57.75	57.79	3428178.0
2016-10-07 16:00:00	MSFT	Stock	57.8	57.805	57.728	57.805	1942521.0
2016-10-07 16:30:00	MSFT	Stock	57.8	57.85	57.76	57.76	3300.0
2016-10-07 17:00:00	MSFT	Stock	57.72	57.72	57.72	57.72	1000.0
2016-10-07 17:30:00	MSFT	Stock	57.78	57.78	57.78	57.78	300.0
2016-10-07 19:30:00	MSFT	Stock	57.8	57.8	57.8	57.8	200.0
2016-10-07 06:30:00	NVDA	Stock	1.6875	1.6875	1.6875	1.6875	16000.0
2016-10-07 08:30:00	NVDA	Stock	1.6863	1.6935	1.685	1.6935	39680.0
2016-10-07 09:00:00	NVDA	Stock	1.6898	1.6962	1.6898	1.6945	449840.0

> showing 50 of 79,010 rows — these rows as CSV

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