PREVIEW / stock_30min / 2017-05-25

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-25.parquet
  size:    1.6 MB
  rows:    81,253
  symbols: 3,037

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-05-25 04:30:00	AAPL	Stock	38.3575	38.3575	38.3575	38.3575	400.0
2017-05-25 05:00:00	AAPL	Stock	38.3925	38.3975	38.3925	38.3975	3544.0
2017-05-25 05:30:00	AAPL	Stock	38.41	38.4125	38.41	38.4125	800.0
2017-05-25 06:00:00	AAPL	Stock	38.4025	38.4225	38.3875	38.4225	4584.0
2017-05-25 06:30:00	AAPL	Stock	38.4325	38.4425	38.3875	38.425	29736.0
2017-05-25 07:00:00	AAPL	Stock	38.4125	38.4525	38.375	38.4275	63112.0
2017-05-25 07:30:00	AAPL	Stock	38.4275	38.4375	38.4125	38.4275	5556.0
2017-05-25 08:00:00	AAPL	Stock	38.4375	38.4425	38.4	38.435	97020.0
2017-05-25 08:30:00	AAPL	Stock	38.4375	38.475	38.425	38.4425	186988.0
2017-05-25 09:00:00	AAPL	Stock	38.4475	38.4475	38.375	38.4375	169648.0
2017-05-25 09:30:00	AAPL	Stock	38.4325	38.4675	38.2625	38.285	10098256.0
2017-05-25 10:00:00	AAPL	Stock	38.285	38.42	38.2575	38.375	6077224.0
2017-05-25 10:30:00	AAPL	Stock	38.3738	38.4512	38.3725	38.4275	4844812.0
2017-05-25 11:00:00	AAPL	Stock	38.4288	38.525	38.407	38.425	6281212.0
2017-05-25 11:30:00	AAPL	Stock	38.4238	38.48	38.395	38.4325	4677792.0
2017-05-25 12:00:00	AAPL	Stock	38.435	38.525	38.4225	38.485	3830616.0
2017-05-25 12:30:00	AAPL	Stock	38.4862	38.5875	38.4825	38.58	4072752.0
2017-05-25 13:00:00	AAPL	Stock	38.58	38.585	38.5315	38.5425	3346876.0
2017-05-25 13:30:00	AAPL	Stock	38.5425	38.5525	38.51	38.54	2429408.0
2017-05-25 14:00:00	AAPL	Stock	38.5375	38.55	38.5125	38.5348	2429964.0
2017-05-25 14:30:00	AAPL	Stock	38.5325	38.5505	38.52	38.5375	2630092.0
2017-05-25 15:00:00	AAPL	Stock	38.5388	38.5525	38.4675	38.4775	5230992.0
2017-05-25 15:30:00	AAPL	Stock	38.4775	38.5375	38.42	38.4775	8805032.0
2017-05-25 16:00:00	AAPL	Stock	38.4675	38.4675	38.435	38.465	2395868.0
2017-05-25 16:30:00	AAPL	Stock	38.4675	38.4675	38.455	38.4625	154108.0
2017-05-25 17:00:00	AAPL	Stock	38.4525	38.465	38.4525	38.465	4060.0
2017-05-25 17:30:00	AAPL	Stock	38.465	38.4675	38.4525	38.4675	2352.0
2017-05-25 18:00:00	AAPL	Stock	38.45	38.4725	38.45	38.4725	3484.0
2017-05-25 18:30:00	AAPL	Stock	38.4725	38.4725	38.44	38.44	18476.0
2017-05-25 19:00:00	AAPL	Stock	38.4675	38.4725	38.4525	38.4525	15204.0
2017-05-25 19:30:00	AAPL	Stock	38.4725	38.4725	38.45	38.45	12400.0
2017-05-25 04:00:00	MSFT	Stock	68.79	68.79	68.79	68.79	200.0
2017-05-25 06:00:00	MSFT	Stock	69.0	69.0	69.0	69.0	100.0
2017-05-25 07:30:00	MSFT	Stock	69.0	69.0	69.0	69.0	400.0
2017-05-25 08:00:00	MSFT	Stock	68.85	69.0	68.85	68.9	3140.0
2017-05-25 08:30:00	MSFT	Stock	68.9	69.0	68.9	68.9	4422.0
2017-05-25 09:00:00	MSFT	Stock	68.96	68.96	68.91	68.96	6716.0
2017-05-25 09:30:00	MSFT	Stock	68.97	69.1	68.91	69.08	1562371.0
2017-05-25 10:00:00	MSFT	Stock	69.084	69.3	69.055	69.296	1630034.0
2017-05-25 10:30:00	MSFT	Stock	69.294	69.45	69.293	69.43	1360631.0
2017-05-25 11:00:00	MSFT	Stock	69.424	69.48	69.34	69.36	1077018.0
2017-05-25 11:30:00	MSFT	Stock	69.361	69.38	69.2	69.275	1345805.0
2017-05-25 12:00:00	MSFT	Stock	69.275	69.46	69.253	69.41	905396.0
2017-05-25 12:30:00	MSFT	Stock	69.411	69.55	69.39	69.55	699782.0
2017-05-25 13:00:00	MSFT	Stock	69.55	69.55	69.42	69.475	746310.0
2017-05-25 13:30:00	MSFT	Stock	69.47	69.55	69.46	69.545	583678.0
2017-05-25 14:00:00	MSFT	Stock	69.54	69.65	69.49	69.635	868824.0
2017-05-25 14:30:00	MSFT	Stock	69.64	69.81	69.635	69.73	1413607.0
2017-05-25 15:00:00	MSFT	Stock	69.735	69.74	69.61	69.675	1215268.0
2017-05-25 15:30:00	MSFT	Stock	69.675	69.88	69.58	69.62	3682515.0

> showing 50 of 81,253 rows — these rows as CSV

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