PREVIEW / stock_30min / 2015-05-21

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-05-21.parquet
  size:    1.6 MB
  rows:    82,488
  symbols: 3,516

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-21 04:00:00	AAPL	Stock	32.3975	32.3975	32.3975	32.3975	8000.0
2015-05-21 04:30:00	AAPL	Stock	32.41	32.41	32.41	32.41	800.0
2015-05-21 05:30:00	AAPL	Stock	32.415	32.415	32.415	32.415	2000.0
2015-05-21 06:00:00	AAPL	Stock	32.4475	32.47	32.425	32.47	29144.0
2015-05-21 06:30:00	AAPL	Stock	32.47	32.4725	32.4575	32.4575	3480.0
2015-05-21 07:00:00	AAPL	Stock	32.4575	32.515	32.4575	32.51	43416.0
2015-05-21 07:30:00	AAPL	Stock	32.5025	32.5225	32.495	32.495	55716.0
2015-05-21 08:00:00	AAPL	Stock	32.5075	32.51	32.4625	32.4798	185948.0
2015-05-21 08:30:00	AAPL	Stock	32.48	32.5075	32.47	32.4875	130744.0
2015-05-21 09:00:00	AAPL	Stock	32.5	32.5575	32.5	32.525	360196.0
2015-05-21 09:30:00	AAPL	Stock	32.5175	32.6325	32.4575	32.5725	18526476.0
2015-05-21 10:00:00	AAPL	Stock	32.575	32.695	32.5675	32.677	14422420.0
2015-05-21 10:30:00	AAPL	Stock	32.6775	32.775	32.655	32.747	14404336.0
2015-05-21 11:00:00	AAPL	Stock	32.745	32.8388	32.74	32.82	14081904.0
2015-05-21 11:30:00	AAPL	Stock	32.821	32.8475	32.7678	32.822	9331164.0
2015-05-21 12:00:00	AAPL	Stock	32.82	32.8675	32.8025	32.845	7128988.0
2015-05-21 12:30:00	AAPL	Stock	32.845	32.8725	32.8228	32.855	6339568.0
2015-05-21 13:00:00	AAPL	Stock	32.8575	32.8725	32.8375	32.86	4948548.0
2015-05-21 13:30:00	AAPL	Stock	32.8575	32.875	32.7575	32.7925	8667644.0
2015-05-21 14:00:00	AAPL	Stock	32.79	32.865	32.78	32.8625	5494348.0
2015-05-21 14:30:00	AAPL	Stock	32.8625	32.875	32.8475	32.8575	5932328.0
2015-05-21 15:00:00	AAPL	Stock	32.8598	32.8675	32.7875	32.8325	7607900.0
2015-05-21 15:30:00	AAPL	Stock	32.8325	32.9075	32.8275	32.85	17691220.0
2015-05-21 16:00:00	AAPL	Stock	32.8475	32.8675	32.7108	32.8525	7181444.0
2015-05-21 16:30:00	AAPL	Stock	32.8525	32.8675	32.85	32.8575	76328.0
2015-05-21 17:00:00	AAPL	Stock	32.8675	32.8975	32.8675	32.8975	139844.0
2015-05-21 17:30:00	AAPL	Stock	32.8975	32.8975	32.8828	32.89	29080.0
2015-05-21 18:00:00	AAPL	Stock	32.8875	32.9	32.8825	32.8975	49472.0
2015-05-21 18:30:00	AAPL	Stock	32.8975	32.8975	32.885	32.895	46376.0
2015-05-21 19:00:00	AAPL	Stock	32.8975	32.9125	32.8928	32.9075	64916.0
2015-05-21 19:30:00	AAPL	Stock	32.9075	32.9625	32.9025	32.945	235404.0
2015-05-21 04:00:00	MSFT	Stock	47.55	47.55	47.55	47.55	1700.0
2015-05-21 05:30:00	MSFT	Stock	47.43	47.43	47.43	47.43	100.0
2015-05-21 06:00:00	MSFT	Stock	47.44	47.45	47.44	47.45	300.0
2015-05-21 07:30:00	MSFT	Stock	47.49	47.53	47.49	47.49	800.0
2015-05-21 08:00:00	MSFT	Stock	47.5	47.5	47.45	47.45	11267.0
2015-05-21 08:30:00	MSFT	Stock	47.4	47.47	47.4	47.4	1400.0
2015-05-21 09:00:00	MSFT	Stock	47.45	47.48	47.24	47.27	13476.0
2015-05-21 09:30:00	MSFT	Stock	47.31	47.41	47.005	47.1	3169298.0
2015-05-21 10:00:00	MSFT	Stock	47.1	47.25	47.06	47.183	2207032.0
2015-05-21 10:30:00	MSFT	Stock	47.18	47.32	47.11	47.27	1422765.0
2015-05-21 11:00:00	MSFT	Stock	47.28	47.47	47.27	47.47	1687318.0
2015-05-21 11:30:00	MSFT	Stock	47.47	47.56	47.41	47.445	1026641.0
2015-05-21 12:00:00	MSFT	Stock	47.45	47.54	47.38	47.514	1030959.0
2015-05-21 12:30:00	MSFT	Stock	47.515	47.6	47.49	47.575	717997.0
2015-05-21 13:00:00	MSFT	Stock	47.58	47.58	47.46	47.505	594447.0
2015-05-21 13:30:00	MSFT	Stock	47.5	47.6	47.47	47.48	780690.0
2015-05-21 14:00:00	MSFT	Stock	47.48	47.55	47.45	47.55	676177.0
2015-05-21 14:30:00	MSFT	Stock	47.55	47.59	47.49	47.538	1105757.0
2015-05-21 15:00:00	MSFT	Stock	47.53	47.55	47.39	47.45	1237499.0

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

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