PREVIEW / stock_30min / 2017-11-14

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-14.parquet
  size:    1.7 MB
  rows:    83,400
  symbols: 2,952

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-11-14 04:00:00	AAPL	Stock	43.545	43.545	43.545	43.545	492.0
2017-11-14 05:00:00	AAPL	Stock	43.45	43.45	43.45	43.45	1188.0
2017-11-14 05:30:00	AAPL	Stock	43.45	43.45	43.45	43.45	1800.0
2017-11-14 06:00:00	AAPL	Stock	43.4725	43.4725	43.4725	43.4725	1644.0
2017-11-14 06:30:00	AAPL	Stock	43.45	43.47	43.45	43.47	4740.0
2017-11-14 07:00:00	AAPL	Stock	43.47	43.5	43.45	43.45	51116.0
2017-11-14 07:30:00	AAPL	Stock	43.4375	43.4625	43.425	43.4625	12084.0
2017-11-14 08:00:00	AAPL	Stock	43.475	43.475	43.4	43.4375	63584.0
2017-11-14 08:30:00	AAPL	Stock	43.4375	43.45	43.3525	43.375	121744.0
2017-11-14 09:00:00	AAPL	Stock	43.3825	43.42	43.2525	43.2525	197824.0
2017-11-14 09:30:00	AAPL	Stock	43.26	43.37	43.1325	43.1875	12806792.0
2017-11-14 10:00:00	AAPL	Stock	43.19	43.2125	43.0275	43.1525	9501216.0
2017-11-14 10:30:00	AAPL	Stock	43.155	43.3125	43.1	43.22	6391404.0
2017-11-14 11:00:00	AAPL	Stock	43.2188	43.3125	43.2025	43.2275	4371724.0
2017-11-14 11:30:00	AAPL	Stock	43.23	43.2675	43.1825	43.2475	3198812.0
2017-11-14 12:00:00	AAPL	Stock	43.2475	43.25	43.1392	43.155	3631244.0
2017-11-14 12:30:00	AAPL	Stock	43.1575	43.1975	43.045	43.0942	4005156.0
2017-11-14 13:00:00	AAPL	Stock	43.0875	43.0875	42.8675	43.0	7993924.0
2017-11-14 13:30:00	AAPL	Stock	43.0007	43.015	42.9375	42.9575	3561600.0
2017-11-14 14:00:00	AAPL	Stock	42.9575	42.995	42.9375	42.98	3384588.0
2017-11-14 14:30:00	AAPL	Stock	42.98	43.0012	42.945	42.9862	3592204.0
2017-11-14 15:00:00	AAPL	Stock	42.9858	43.0325	42.9025	42.9025	5181436.0
2017-11-14 15:30:00	AAPL	Stock	42.905	42.9175	42.795	42.835	13248872.0
2017-11-14 16:00:00	AAPL	Stock	42.835	43.1008	42.75	42.8075	3888252.0
2017-11-14 16:30:00	AAPL	Stock	42.8	42.81	42.625	42.8	176124.0
2017-11-14 17:00:00	AAPL	Stock	42.7975	42.8275	42.775	42.8275	46852.0
2017-11-14 17:30:00	AAPL	Stock	42.825	42.87	42.825	42.87	30880.0
2017-11-14 18:00:00	AAPL	Stock	42.8725	42.92	42.8625	42.92	91256.0
2017-11-14 18:30:00	AAPL	Stock	42.9175	42.96	42.915	42.925	46172.0
2017-11-14 19:00:00	AAPL	Stock	42.9175	42.9175	42.86	42.865	83940.0
2017-11-14 19:30:00	AAPL	Stock	42.8525	42.875	42.815	42.875	80644.0
2017-11-14 05:00:00	MSFT	Stock	84.0	84.0	84.0	84.0	1500.0
2017-11-14 07:00:00	MSFT	Stock	84.0	84.0	83.96	83.96	1100.0
2017-11-14 07:30:00	MSFT	Stock	83.92	83.92	83.85	83.85	1400.0
2017-11-14 08:00:00	MSFT	Stock	83.9	84.0	83.83	84.0	350.0
2017-11-14 08:30:00	MSFT	Stock	83.85	83.9	83.8	83.8	2665.0
2017-11-14 09:00:00	MSFT	Stock	83.8	83.94	83.49	83.49	20361.0
2017-11-14 09:30:00	MSFT	Stock	83.5	83.7	83.18	83.22	2338093.0
2017-11-14 10:00:00	MSFT	Stock	83.215	83.44	82.98	83.44	1770119.0
2017-11-14 10:30:00	MSFT	Stock	83.44	83.85	83.35	83.73	1282934.0
2017-11-14 11:00:00	MSFT	Stock	83.73	83.79	83.525	83.605	932517.0
2017-11-14 11:30:00	MSFT	Stock	83.61	83.68	83.52	83.6	701666.0
2017-11-14 12:00:00	MSFT	Stock	83.61	83.64	83.56	83.63	531255.0
2017-11-14 12:30:00	MSFT	Stock	83.63	83.72	83.35	83.425	718058.0
2017-11-14 13:00:00	MSFT	Stock	83.42	83.47	83.24	83.43	1292210.0
2017-11-14 13:30:00	MSFT	Stock	83.44	83.72	83.41	83.69	613376.0
2017-11-14 14:00:00	MSFT	Stock	83.69	83.73	83.59	83.665	544838.0
2017-11-14 14:30:00	MSFT	Stock	83.66	83.7	83.54	83.585	867601.0
2017-11-14 15:00:00	MSFT	Stock	83.585	83.76	83.585	83.69	874016.0
2017-11-14 15:30:00	MSFT	Stock	83.69	84.1	83.69	84.05	2780088.0

> showing 50 of 83,400 rows — these rows as CSV

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