PREVIEW / stock_30min / 2016-10-26

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-26.parquet
  size:    1.5 MB
  rows:    79,532
  symbols: 3,194

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
2016-10-26 04:00:00	AAPL	Stock	28.5875	28.5875	28.4975	28.5	45740.0
2016-10-26 04:30:00	AAPL	Stock	28.525	28.56	28.5	28.56	11360.0
2016-10-26 05:00:00	AAPL	Stock	28.55	28.5825	28.515	28.575	31032.0
2016-10-26 05:30:00	AAPL	Stock	28.5825	28.6775	28.5825	28.6775	64496.0
2016-10-26 06:00:00	AAPL	Stock	28.675	28.675	28.565	28.6275	42248.0
2016-10-26 06:30:00	AAPL	Stock	28.6425	28.6875	28.625	28.655	64052.0
2016-10-26 07:00:00	AAPL	Stock	28.6775	28.7475	28.5625	28.7475	398808.0
2016-10-26 07:30:00	AAPL	Stock	28.75	28.75	28.6875	28.74	373692.0
2016-10-26 08:00:00	AAPL	Stock	28.7425	28.805	28.5875	28.675	2245324.0
2016-10-26 08:30:00	AAPL	Stock	28.6675	28.7425	28.58	28.6375	1753152.0
2016-10-26 09:00:00	AAPL	Stock	28.6275	28.6375	28.55	28.5625	1820040.0
2016-10-26 09:30:00	AAPL	Stock	28.5775	28.6	28.3275	28.4775	59710712.0
2016-10-26 10:00:00	AAPL	Stock	28.478	28.575	28.4025	28.535	29958724.0
2016-10-26 10:30:00	AAPL	Stock	28.535	28.7415	28.52	28.725	28283268.0
2016-10-26 11:00:00	AAPL	Stock	28.725	28.8125	28.695	28.7338	18405704.0
2016-10-26 11:30:00	AAPL	Stock	28.7325	28.7875	28.7025	28.7325	9620596.0
2016-10-26 12:00:00	AAPL	Stock	28.73	28.83	28.7175	28.8125	7552552.0
2016-10-26 12:30:00	AAPL	Stock	28.8125	28.925	28.8102	28.845	11769012.0
2016-10-26 13:00:00	AAPL	Stock	28.845	28.865	28.75	28.7662	8183956.0
2016-10-26 13:30:00	AAPL	Stock	28.765	28.7875	28.6525	28.655	10105032.0
2016-10-26 14:00:00	AAPL	Stock	28.66	28.745	28.6575	28.7285	7923756.0
2016-10-26 14:30:00	AAPL	Stock	28.7288	28.8525	28.725	28.835	8426896.0
2016-10-26 15:00:00	AAPL	Stock	28.8325	28.835	28.77	28.8025	8021284.0
2016-10-26 15:30:00	AAPL	Stock	28.8038	28.9125	28.7875	28.8975	16176188.0
2016-10-26 16:00:00	AAPL	Stock	28.8975	28.9125	28.8925	28.895	15314960.0
2016-10-26 16:30:00	AAPL	Stock	28.9025	28.9075	28.8875	28.8875	93464.0
2016-10-26 17:00:00	AAPL	Stock	28.8875	28.8975	28.8625	28.87	775136.0
2016-10-26 17:30:00	AAPL	Stock	28.865	28.8875	28.865	28.875	34848.0
2016-10-26 18:00:00	AAPL	Stock	28.8825	28.915	28.8675	28.87	270180.0
2016-10-26 18:30:00	AAPL	Stock	28.8875	28.8875	28.865	28.865	9036.0
2016-10-26 19:00:00	AAPL	Stock	28.865	28.88	28.865	28.875	32812.0
2016-10-26 19:30:00	AAPL	Stock	28.88	28.885	28.8675	28.885	10632.0
2016-10-26 07:30:00	MSFT	Stock	60.74	60.76	60.74	60.76	1400.0
2016-10-26 08:00:00	MSFT	Stock	60.78	60.88	60.7	60.76	5903.0
2016-10-26 08:30:00	MSFT	Stock	60.85	60.85	60.77	60.77	3402.0
2016-10-26 09:00:00	MSFT	Stock	60.77	60.8	60.67	60.77	14107.0
2016-10-26 09:30:00	MSFT	Stock	60.8	61.0	60.47	60.585	3785970.0
2016-10-26 10:00:00	MSFT	Stock	60.585	60.895	60.55	60.81	2199919.0
2016-10-26 10:30:00	MSFT	Stock	60.81	61.12	60.77	61.101	1971990.0
2016-10-26 11:00:00	MSFT	Stock	61.101	61.2	61.03	61.075	1773442.0
2016-10-26 11:30:00	MSFT	Stock	61.07	61.09	60.9	60.9	1164564.0
2016-10-26 12:00:00	MSFT	Stock	60.9	60.96	60.85	60.875	946672.0
2016-10-26 12:30:00	MSFT	Stock	60.88	60.98	60.86	60.87	1122223.0
2016-10-26 13:00:00	MSFT	Stock	60.875	60.92	60.78	60.82	1144168.0
2016-10-26 13:30:00	MSFT	Stock	60.815	60.82	60.66	60.7	1355914.0
2016-10-26 14:00:00	MSFT	Stock	60.701	60.76	60.61	60.69	1450903.0
2016-10-26 14:30:00	MSFT	Stock	60.69	60.75	60.6	60.71	1212810.0
2016-10-26 15:00:00	MSFT	Stock	60.71	60.77	60.58	60.715	1752782.0
2016-10-26 15:30:00	MSFT	Stock	60.71	60.75	60.62	60.63	3602042.0
2016-10-26 16:00:00	MSFT	Stock	60.63	60.71	60.5	60.71	2509938.0

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

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