PREVIEW / stock_30min / 2017-09-07

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-07.parquet
  size:    1.6 MB
  rows:    81,843
  symbols: 2,978

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-09-07 04:30:00	AAPL	Stock	40.5	40.5	40.5	40.5	592.0
2017-09-07 05:00:00	AAPL	Stock	40.5	40.5	40.4875	40.4875	23796.0
2017-09-07 05:30:00	AAPL	Stock	40.4875	40.55	40.4875	40.5	12040.0
2017-09-07 06:00:00	AAPL	Stock	40.515	40.55	40.515	40.55	10680.0
2017-09-07 06:30:00	AAPL	Stock	40.55	40.56	40.55	40.56	7524.0
2017-09-07 07:00:00	AAPL	Stock	40.5325	40.5425	40.5075	40.5125	28096.0
2017-09-07 07:30:00	AAPL	Stock	40.5	40.515	40.4875	40.4875	14080.0
2017-09-07 08:00:00	AAPL	Stock	40.5125	40.535	40.4375	40.47	139380.0
2017-09-07 08:30:00	AAPL	Stock	40.465	40.525	40.44	40.5125	65056.0
2017-09-07 09:00:00	AAPL	Stock	40.5125	40.545	40.5125	40.515	59340.0
2017-09-07 09:30:00	AAPL	Stock	40.525	40.56	40.3462	40.3725	9089940.0
2017-09-07 10:00:00	AAPL	Stock	40.37	40.4	40.255	40.3225	7496548.0
2017-09-07 10:30:00	AAPL	Stock	40.3225	40.55	40.3	40.509	6774208.0
2017-09-07 11:00:00	AAPL	Stock	40.5075	40.536	40.4288	40.4625	4399404.0
2017-09-07 11:30:00	AAPL	Stock	40.4625	40.4975	40.4175	40.4625	2744352.0
2017-09-07 12:00:00	AAPL	Stock	40.465	40.5225	40.26	40.2948	5012948.0
2017-09-07 12:30:00	AAPL	Stock	40.295	40.4025	40.09	40.2612	14804768.0
2017-09-07 13:00:00	AAPL	Stock	40.26	40.375	40.235	40.335	4950488.0
2017-09-07 13:30:00	AAPL	Stock	40.335	40.369	40.2875	40.3125	3146700.0
2017-09-07 14:00:00	AAPL	Stock	40.3125	40.355	40.2875	40.3425	2403772.0
2017-09-07 14:30:00	AAPL	Stock	40.342	40.3475	40.2978	40.3325	2656924.0
2017-09-07 15:00:00	AAPL	Stock	40.3325	40.3625	40.2575	40.28	4018260.0
2017-09-07 15:30:00	AAPL	Stock	40.28	40.325	40.255	40.3175	6828860.0
2017-09-07 16:00:00	AAPL	Stock	40.3175	40.325	40.3	40.3125	3961680.0
2017-09-07 16:30:00	AAPL	Stock	40.3175	40.3175	40.3	40.3	36128.0
2017-09-07 17:00:00	AAPL	Stock	40.3	40.315	40.2925	40.315	78540.0
2017-09-07 17:30:00	AAPL	Stock	40.31	40.315	40.2925	40.2925	23156.0
2017-09-07 18:00:00	AAPL	Stock	40.2975	40.315	40.2975	40.2975	5572.0
2017-09-07 18:30:00	AAPL	Stock	40.3125	40.315	40.3	40.3	6384.0
2017-09-07 19:00:00	AAPL	Stock	40.315	40.33	40.315	40.315	13640.0
2017-09-07 19:30:00	AAPL	Stock	40.315	40.32	40.3	40.32	13660.0
2017-09-07 05:00:00	MSFT	Stock	73.77	73.8	73.77	73.8	3755.0
2017-09-07 08:00:00	MSFT	Stock	73.55	73.55	73.39	73.55	1000.0
2017-09-07 08:30:00	MSFT	Stock	73.55	73.57	73.4	73.57	34010.0
2017-09-07 09:00:00	MSFT	Stock	73.57	73.71	73.57	73.69	23462.0
2017-09-07 09:30:00	MSFT	Stock	73.68	73.98	73.6	73.845	1547355.0
2017-09-07 10:00:00	MSFT	Stock	73.84	73.96	73.68	73.901	1601707.0
2017-09-07 10:30:00	MSFT	Stock	73.91	74.5	73.88	74.435	1740046.0
2017-09-07 11:00:00	MSFT	Stock	74.42	74.49	74.3	74.44	985041.0
2017-09-07 11:30:00	MSFT	Stock	74.43	74.6	74.36	74.37	848422.0
2017-09-07 12:00:00	MSFT	Stock	74.37	74.51	74.36	74.37	681268.0
2017-09-07 12:30:00	MSFT	Stock	74.38	74.44	74.23	74.35	852068.0
2017-09-07 13:00:00	MSFT	Stock	74.34	74.53	74.337	74.522	513554.0
2017-09-07 13:30:00	MSFT	Stock	74.522	74.58	74.5	74.57	655422.0
2017-09-07 14:00:00	MSFT	Stock	74.565	74.6	74.52	74.555	625445.0
2017-09-07 14:30:00	MSFT	Stock	74.55	74.6	74.51	74.585	593395.0
2017-09-07 15:00:00	MSFT	Stock	74.59	74.6	74.47	74.49	927005.0
2017-09-07 15:30:00	MSFT	Stock	74.49	74.535	74.28	74.36	2759546.0
2017-09-07 16:00:00	MSFT	Stock	74.34	74.49	74.288	74.35	1364683.0
2017-09-07 16:30:00	MSFT	Stock	74.38	74.45	74.38	74.45	1305.0

> showing 50 of 81,843 rows — these rows as CSV

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