PREVIEW / stock_30min / 2016-11-29

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-29.parquet
  size:    1.6 MB
  rows:    82,056
  symbols: 3,184

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-11-29 04:00:00	AAPL	Stock	27.8825	27.8825	27.875	27.875	2000.0
2016-11-29 05:00:00	AAPL	Stock	27.9	27.9	27.85	27.85	7680.0
2016-11-29 05:30:00	AAPL	Stock	27.9	27.9	27.9	27.9	400.0
2016-11-29 06:00:00	AAPL	Stock	27.85	27.85	27.825	27.8375	15704.0
2016-11-29 06:30:00	AAPL	Stock	27.8375	27.8375	27.8125	27.8375	25248.0
2016-11-29 07:00:00	AAPL	Stock	27.825	27.8375	27.7675	27.7675	67436.0
2016-11-29 07:30:00	AAPL	Stock	27.77	27.77	27.65	27.725	89648.0
2016-11-29 08:00:00	AAPL	Stock	27.745	27.8025	27.665	27.745	141200.0
2016-11-29 08:30:00	AAPL	Stock	27.75	27.7625	27.6875	27.7125	178176.0
2016-11-29 09:00:00	AAPL	Stock	27.7125	27.7125	27.65	27.68	286464.0
2016-11-29 09:30:00	AAPL	Stock	27.695	27.7625	27.5525	27.575	20346568.0
2016-11-29 10:00:00	AAPL	Stock	27.5775	27.6625	27.5175	27.66	11296356.0
2016-11-29 10:30:00	AAPL	Stock	27.6625	27.7525	27.6575	27.7	8573848.0
2016-11-29 11:00:00	AAPL	Stock	27.7	27.8088	27.6975	27.8	5804228.0
2016-11-29 11:30:00	AAPL	Stock	27.8012	28.0075	27.7975	28.0038	11145924.0
2016-11-29 12:00:00	AAPL	Stock	28.0038	28.005	27.9025	27.925	4921808.0
2016-11-29 12:30:00	AAPL	Stock	27.9238	27.9675	27.905	27.9425	3339020.0
2016-11-29 13:00:00	AAPL	Stock	27.9435	27.9575	27.92	27.94	3101008.0
2016-11-29 13:30:00	AAPL	Stock	27.94	27.985	27.9352	27.9675	3026652.0
2016-11-29 14:00:00	AAPL	Stock	27.9675	27.9775	27.93	27.9425	2843368.0
2016-11-29 14:30:00	AAPL	Stock	27.9388	27.97	27.885	27.8875	3949124.0
2016-11-29 15:00:00	AAPL	Stock	27.8882	27.8925	27.765	27.77	5934204.0
2016-11-29 15:30:00	AAPL	Stock	27.7712	27.865	27.735	27.865	12355296.0
2016-11-29 16:00:00	AAPL	Stock	27.875	27.875	27.8325	27.865	8158920.0
2016-11-29 16:30:00	AAPL	Stock	27.865	27.87	27.865	27.865	151096.0
2016-11-29 17:00:00	AAPL	Stock	27.8675	27.875	27.8625	27.8625	24000.0
2016-11-29 17:30:00	AAPL	Stock	27.86	27.8625	27.86	27.8625	10000.0
2016-11-29 18:00:00	AAPL	Stock	27.87	27.87	27.86	27.86	2500.0
2016-11-29 18:30:00	AAPL	Stock	27.8625	27.8725	27.8625	27.8675	11672.0
2016-11-29 19:00:00	AAPL	Stock	27.86	27.86	27.855	27.855	2368.0
2016-11-29 19:30:00	AAPL	Stock	27.85	27.8675	27.85	27.865	4404.0
2016-11-29 04:30:00	MSFT	Stock	60.68	60.68	60.68	60.68	100.0
2016-11-29 08:00:00	MSFT	Stock	60.87	60.87	60.55	60.83	365.0
2016-11-29 08:30:00	MSFT	Stock	60.75	60.75	60.75	60.75	150.0
2016-11-29 09:00:00	MSFT	Stock	60.69	60.7	60.69	60.7	4615.0
2016-11-29 09:30:00	MSFT	Stock	60.65	60.83	60.52	60.57	1488859.0
2016-11-29 10:00:00	MSFT	Stock	60.57	60.7	60.53	60.65	721880.0
2016-11-29 10:30:00	MSFT	Stock	60.65	60.92	60.65	60.91	811924.0
2016-11-29 11:00:00	MSFT	Stock	60.92	61.0	60.82	60.99	4014590.0
2016-11-29 11:30:00	MSFT	Stock	60.999	61.29	60.99	61.29	1411237.0
2016-11-29 12:00:00	MSFT	Stock	61.29	61.37	61.16	61.255	1243853.0
2016-11-29 12:30:00	MSFT	Stock	61.255	61.325	61.165	61.3	948243.0
2016-11-29 13:00:00	MSFT	Stock	61.3	61.34	61.29	61.325	622285.0
2016-11-29 13:30:00	MSFT	Stock	61.32	61.41	61.32	61.37	686877.0
2016-11-29 14:00:00	MSFT	Stock	61.38	61.4	61.315	61.36	844954.0
2016-11-29 14:30:00	MSFT	Stock	61.356	61.405	61.3	61.3	1086795.0
2016-11-29 15:00:00	MSFT	Stock	61.3	61.32	61.13	61.175	1464101.0
2016-11-29 15:30:00	MSFT	Stock	61.175	61.2	61.03	61.11	2452005.0
2016-11-29 16:00:00	MSFT	Stock	61.09	61.09	61.09	61.09	2926653.0
2016-11-29 16:30:00	MSFT	Stock	61.02	61.09	61.0	61.0	344258.0

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

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