PREVIEW / stock_30min / 2015-05-20

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-05-20.parquet
  size:    1.6 MB
  rows:    82,062
  symbols: 3,517

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
2015-05-20 04:00:00	AAPL	Stock	32.575	32.61	32.565	32.565	4200.0
2015-05-20 04:30:00	AAPL	Stock	32.5575	32.5625	32.5575	32.5625	16452.0
2015-05-20 05:00:00	AAPL	Stock	32.575	32.5825	32.5725	32.5825	2800.0
2015-05-20 05:30:00	AAPL	Stock	32.575	32.575	32.5575	32.5575	8064.0
2015-05-20 06:00:00	AAPL	Stock	32.58	32.5875	32.56	32.5875	4400.0
2015-05-20 06:30:00	AAPL	Stock	32.5875	32.6225	32.5775	32.6	25924.0
2015-05-20 07:00:00	AAPL	Stock	32.6	32.6	32.5375	32.565	32696.0
2015-05-20 07:30:00	AAPL	Stock	32.5675	32.5875	32.5675	32.575	13124.0
2015-05-20 08:00:00	AAPL	Stock	32.575	32.6	32.545	32.55	147872.0
2015-05-20 08:30:00	AAPL	Stock	32.55	32.5775	32.515	32.565	161556.0
2015-05-20 09:00:00	AAPL	Stock	32.56	32.5825	32.5	32.5	220572.0
2015-05-20 09:30:00	AAPL	Stock	32.5	32.5475	32.335	32.4275	19076172.0
2015-05-20 10:00:00	AAPL	Stock	32.43	32.57	32.405	32.5075	12897232.0
2015-05-20 10:30:00	AAPL	Stock	32.5075	32.5625	32.5025	32.5075	8086604.0
2015-05-20 11:00:00	AAPL	Stock	32.5062	32.555	32.4725	32.475	5901288.0
2015-05-20 11:30:00	AAPL	Stock	32.4725	32.505	32.4252	32.49	5882164.0
2015-05-20 12:00:00	AAPL	Stock	32.4925	32.5175	32.4775	32.489	2801780.0
2015-05-20 12:30:00	AAPL	Stock	32.4875	32.495	32.4275	32.47	3455200.0
2015-05-20 13:00:00	AAPL	Stock	32.47	32.4875	32.4325	32.475	2687660.0
2015-05-20 13:30:00	AAPL	Stock	32.4725	32.4975	32.4275	32.483	4515640.0
2015-05-20 14:00:00	AAPL	Stock	32.485	32.735	32.47	32.7275	16814144.0
2015-05-20 14:30:00	AAPL	Stock	32.7275	32.745	32.62	32.6625	13288484.0
2015-05-20 15:00:00	AAPL	Stock	32.6625	32.6925	32.4875	32.5525	13412904.0
2015-05-20 15:30:00	AAPL	Stock	32.555	32.5725	32.5025	32.5175	13115672.0
2015-05-20 16:00:00	AAPL	Stock	32.515	32.53	32.4478	32.52	14116936.0
2015-05-20 16:30:00	AAPL	Stock	32.52	32.5225	32.5125	32.5125	80212.0
2015-05-20 17:00:00	AAPL	Stock	32.515	32.52	32.5125	32.52	69468.0
2015-05-20 17:30:00	AAPL	Stock	32.5125	32.5225	32.5075	32.515	167652.0
2015-05-20 18:00:00	AAPL	Stock	32.51	32.5125	32.4625	32.5	267480.0
2015-05-20 18:30:00	AAPL	Stock	32.48	32.5125	32.4775	32.4825	62272.0
2015-05-20 19:00:00	AAPL	Stock	32.48	32.4925	32.4778	32.485	45180.0
2015-05-20 19:30:00	AAPL	Stock	32.485	32.485	32.43	32.445	143148.0
2015-05-20 08:00:00	MSFT	Stock	47.49	47.56	47.49	47.49	500.0
2015-05-20 08:30:00	MSFT	Stock	47.47	47.5	47.47	47.49	1750.0
2015-05-20 09:00:00	MSFT	Stock	47.49	47.62	47.38	47.38	20468.0
2015-05-20 09:30:00	MSFT	Stock	47.4	47.52	47.27	47.38	2527429.0
2015-05-20 10:00:00	MSFT	Stock	47.385	47.555	47.34	47.49	1497180.0
2015-05-20 10:30:00	MSFT	Stock	47.49	47.62	47.48	47.55	918244.0
2015-05-20 11:00:00	MSFT	Stock	47.545	47.58	47.49	47.545	1115783.0
2015-05-20 11:30:00	MSFT	Stock	47.54	47.57	47.43	47.48	1096792.0
2015-05-20 12:00:00	MSFT	Stock	47.49	47.64	47.47	47.6	595233.0
2015-05-20 12:30:00	MSFT	Stock	47.6	47.628	47.54	47.597	657173.0
2015-05-20 13:00:00	MSFT	Stock	47.59	47.64	47.482	47.525	1051768.0
2015-05-20 13:30:00	MSFT	Stock	47.53	47.63	47.495	47.615	1016653.0
2015-05-20 14:00:00	MSFT	Stock	47.61	47.875	47.49	47.84	2674132.0
2015-05-20 14:30:00	MSFT	Stock	47.84	47.93	47.74	47.8	1267557.0
2015-05-20 15:00:00	MSFT	Stock	47.8	47.82	47.5	47.625	1564283.0
2015-05-20 15:30:00	MSFT	Stock	47.62	47.64	47.515	47.58	2431942.0
2015-05-20 16:00:00	MSFT	Stock	47.58	47.6	47.58	47.6	4115741.0
2015-05-20 16:30:00	MSFT	Stock	47.54	47.54	47.54	47.54	400.0

> showing 50 of 82,062 rows — these rows as CSV

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