PREVIEW / stock_30min / 2017-08-16

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-16.parquet
  size:    1.6 MB
  rows:    79,918
  symbols: 2,984

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
2017-08-16 04:00:00	AAPL	Stock	40.4625	40.485	40.4625	40.475	13132.0
2017-08-16 04:30:00	AAPL	Stock	40.475	40.5225	40.475	40.5	13108.0
2017-08-16 05:00:00	AAPL	Stock	40.5	40.5075	40.5	40.5075	1200.0
2017-08-16 05:30:00	AAPL	Stock	40.51	40.55	40.5075	40.525	30044.0
2017-08-16 06:00:00	AAPL	Stock	40.5	40.5	40.47	40.475	23496.0
2017-08-16 06:30:00	AAPL	Stock	40.48	40.48	40.4575	40.4575	12336.0
2017-08-16 07:00:00	AAPL	Stock	40.4525	40.475	40.3925	40.4625	100964.0
2017-08-16 07:30:00	AAPL	Stock	40.4625	40.4625	40.42	40.4325	42820.0
2017-08-16 08:00:00	AAPL	Stock	40.45	40.475	40.3025	40.4325	420188.0
2017-08-16 08:30:00	AAPL	Stock	40.4325	40.4725	40.4325	40.455	129608.0
2017-08-16 09:00:00	AAPL	Stock	40.4625	40.5175	40.45	40.485	468208.0
2017-08-16 09:30:00	AAPL	Stock	40.495	40.5375	40.2325	40.3625	13985120.0
2017-08-16 10:00:00	AAPL	Stock	40.3625	40.43	40.2775	40.425	4856892.0
2017-08-16 10:30:00	AAPL	Stock	40.425	40.5975	40.395	40.5575	8210944.0
2017-08-16 11:00:00	AAPL	Stock	40.5562	40.5825	40.4425	40.4598	5727432.0
2017-08-16 11:30:00	AAPL	Stock	40.459	40.534	40.4475	40.5025	4729420.0
2017-08-16 12:00:00	AAPL	Stock	40.505	40.6275	40.5037	40.5975	6642824.0
2017-08-16 12:30:00	AAPL	Stock	40.5995	40.6162	40.406	40.4325	5015256.0
2017-08-16 13:00:00	AAPL	Stock	40.4325	40.4475	40.24	40.2812	7689444.0
2017-08-16 13:30:00	AAPL	Stock	40.28	40.28	40.1725	40.215	6598932.0
2017-08-16 14:00:00	AAPL	Stock	40.215	40.34	40.09	40.1448	8192620.0
2017-08-16 14:30:00	AAPL	Stock	40.145	40.2225	40.0375	40.19	5699740.0
2017-08-16 15:00:00	AAPL	Stock	40.1882	40.2675	40.16	40.205	4344364.0
2017-08-16 15:30:00	AAPL	Stock	40.2025	40.255	40.145	40.23	9135572.0
2017-08-16 16:00:00	AAPL	Stock	40.2375	40.615	40.225	40.2375	4828296.0
2017-08-16 16:30:00	AAPL	Stock	40.2475	40.2475	40.23	40.2425	21756.0
2017-08-16 17:00:00	AAPL	Stock	40.2325	40.2375	40.225	40.225	53412.0
2017-08-16 17:30:00	AAPL	Stock	40.22	40.22	40.1625	40.1875	55196.0
2017-08-16 18:00:00	AAPL	Stock	40.1625	40.1975	40.125	40.15	29268.0
2017-08-16 18:30:00	AAPL	Stock	40.135	40.1775	40.135	40.1775	31912.0
2017-08-16 19:00:00	AAPL	Stock	40.165	40.2	40.1625	40.185	29224.0
2017-08-16 19:30:00	AAPL	Stock	40.1875	40.195	40.1625	40.195	15280.0
2017-08-16 08:00:00	MSFT	Stock	73.41	73.41	73.41	73.41	2188.0
2017-08-16 08:30:00	MSFT	Stock	73.45	73.45	73.41	73.45	2999.0
2017-08-16 09:00:00	MSFT	Stock	73.41	73.49	73.31	73.33	67290.0
2017-08-16 09:30:00	MSFT	Stock	73.34	73.49	73.17	73.432	1815476.0
2017-08-16 10:00:00	MSFT	Stock	73.44	73.47	73.32	73.445	1003539.0
2017-08-16 10:30:00	MSFT	Stock	73.45	73.64	73.42	73.615	1183799.0
2017-08-16 11:00:00	MSFT	Stock	73.61	73.67	73.518	73.53	983781.0
2017-08-16 11:30:00	MSFT	Stock	73.53	73.699	73.53	73.69	572019.0
2017-08-16 12:00:00	MSFT	Stock	73.69	73.97	73.675	73.97	902694.0
2017-08-16 12:30:00	MSFT	Stock	73.98	74.1	73.82	73.83	1579856.0
2017-08-16 13:00:00	MSFT	Stock	73.82	73.85	73.46	73.55	1116126.0
2017-08-16 13:30:00	MSFT	Stock	73.54	73.667	73.46	73.54	752528.0
2017-08-16 14:00:00	MSFT	Stock	73.55	73.71	73.42	73.585	1352837.0
2017-08-16 14:30:00	MSFT	Stock	73.59	73.81	73.515	73.775	945620.0
2017-08-16 15:00:00	MSFT	Stock	73.78	73.8	73.585	73.62	1053247.0
2017-08-16 15:30:00	MSFT	Stock	73.625	73.68	73.54	73.66	1898412.0
2017-08-16 16:00:00	MSFT	Stock	73.65	73.939	73.65	73.65	1683841.0
2017-08-16 16:30:00	MSFT	Stock	73.57	73.65	73.57	73.65	301.0

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

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