PREVIEW / stock_30min / 2017-11-17

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-17.parquet
  size:    1.7 MB
  rows:    84,057
  symbols: 2,946

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-11-17 04:00:00	AAPL	Stock	42.8225	42.8225	42.81	42.81	1600.0
2017-11-17 04:30:00	AAPL	Stock	42.815	42.8275	42.815	42.8275	800.0
2017-11-17 06:00:00	AAPL	Stock	42.8375	42.8425	42.8375	42.8425	1304.0
2017-11-17 06:30:00	AAPL	Stock	42.825	42.825	42.825	42.825	9600.0
2017-11-17 07:00:00	AAPL	Stock	42.825	42.825	42.795	42.825	94336.0
2017-11-17 07:30:00	AAPL	Stock	42.825	42.825	42.8	42.8025	37732.0
2017-11-17 08:00:00	AAPL	Stock	42.8125	42.825	42.715	42.7425	157380.0
2017-11-17 08:30:00	AAPL	Stock	42.745	42.7925	42.715	42.7725	87192.0
2017-11-17 09:00:00	AAPL	Stock	42.74	42.7625	42.6875	42.7625	206620.0
2017-11-17 09:30:00	AAPL	Stock	42.76	42.7625	42.4575	42.5225	16199840.0
2017-11-17 10:00:00	AAPL	Stock	42.5212	42.6475	42.4575	42.64	6665420.0
2017-11-17 10:30:00	AAPL	Stock	42.64	42.8475	42.6175	42.7205	8406324.0
2017-11-17 11:00:00	AAPL	Stock	42.72	42.73	42.565	42.6725	5249732.0
2017-11-17 11:30:00	AAPL	Stock	42.67	42.7225	42.645	42.685	2888788.0
2017-11-17 12:00:00	AAPL	Stock	42.6818	42.685	42.623	42.665	2512584.0
2017-11-17 12:30:00	AAPL	Stock	42.6625	42.675	42.59	42.6465	2293596.0
2017-11-17 13:00:00	AAPL	Stock	42.648	42.65	42.5775	42.6175	2306992.0
2017-11-17 13:30:00	AAPL	Stock	42.615	42.6375	42.555	42.5948	1936580.0
2017-11-17 14:00:00	AAPL	Stock	42.595	42.6072	42.505	42.5625	2747516.0
2017-11-17 14:30:00	AAPL	Stock	42.5575	42.5952	42.54	42.55	2486924.0
2017-11-17 15:00:00	AAPL	Stock	42.55	42.5675	42.5025	42.56	3436252.0
2017-11-17 15:30:00	AAPL	Stock	42.56	42.56	42.41	42.5275	11310848.0
2017-11-17 16:00:00	AAPL	Stock	42.5375	42.5375	42.475	42.5	6347684.0
2017-11-17 16:30:00	AAPL	Stock	42.5075	42.5375	42.4875	42.4925	40504.0
2017-11-17 17:00:00	AAPL	Stock	42.5025	42.5025	42.49	42.4975	73468.0
2017-11-17 17:30:00	AAPL	Stock	42.5	42.5	42.495	42.5	6832.0
2017-11-17 18:00:00	AAPL	Stock	42.5	42.5	42.49	42.4975	8600.0
2017-11-17 18:30:00	AAPL	Stock	42.5	42.5	42.49	42.49	14000.0
2017-11-17 19:00:00	AAPL	Stock	42.4925	42.4925	42.4875	42.49	13224.0
2017-11-17 19:30:00	AAPL	Stock	42.4975	42.4975	42.48	42.485	8304.0
2017-11-17 07:00:00	MSFT	Stock	83.19	83.2	83.19	83.2	1080.0
2017-11-17 07:30:00	MSFT	Stock	83.26	83.27	83.15	83.18	6511.0
2017-11-17 08:00:00	MSFT	Stock	83.17	83.17	82.98	82.98	8121.0
2017-11-17 08:30:00	MSFT	Stock	82.98	83.2	82.98	83.02	5506.0
2017-11-17 09:00:00	MSFT	Stock	83.12	83.2	83.0	83.18	30630.0
2017-11-17 09:30:00	MSFT	Stock	83.12	83.12	82.48	82.61	3532583.0
2017-11-17 10:00:00	MSFT	Stock	82.605	82.87	82.52	82.53	1357926.0
2017-11-17 10:30:00	MSFT	Stock	82.53	82.591	82.37	82.42	1494864.0
2017-11-17 11:00:00	MSFT	Stock	82.42	82.55	82.24	82.52	1446617.0
2017-11-17 11:30:00	MSFT	Stock	82.52	82.55	82.35	82.502	1055797.0
2017-11-17 12:00:00	MSFT	Stock	82.505	82.51	82.39	82.495	816071.0
2017-11-17 12:30:00	MSFT	Stock	82.5	82.52	82.41	82.43	511871.0
2017-11-17 13:00:00	MSFT	Stock	82.43	82.44	82.32	82.37	773617.0
2017-11-17 13:30:00	MSFT	Stock	82.365	82.45	82.35	82.45	787928.0
2017-11-17 14:00:00	MSFT	Stock	82.45	82.47	82.37	82.405	1009390.0
2017-11-17 14:30:00	MSFT	Stock	82.405	82.47	82.36	82.43	783537.0
2017-11-17 15:00:00	MSFT	Stock	82.43	82.445	82.36	82.365	916937.0
2017-11-17 15:30:00	MSFT	Stock	82.37	82.55	82.34	82.37	2940268.0
2017-11-17 16:00:00	MSFT	Stock	82.4	82.44	82.32	82.32	2183055.0
2017-11-17 16:30:00	MSFT	Stock	82.36	82.36	82.34	82.34	729.0

> showing 50 of 84,057 rows — these rows as CSV

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