PREVIEW / stock_30min / 2017-09-19

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-19.parquet
  size:    1.6 MB
  rows:    81,159
  symbols: 2,968

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-19 04:00:00	AAPL	Stock	39.7125	39.8	39.7125	39.7625	7724.0
2017-09-19 04:30:00	AAPL	Stock	39.745	39.8	39.745	39.755	17804.0
2017-09-19 05:00:00	AAPL	Stock	39.7525	39.775	39.725	39.775	3132.0
2017-09-19 05:30:00	AAPL	Stock	39.7875	39.85	39.785	39.8	19912.0
2017-09-19 06:00:00	AAPL	Stock	39.825	39.8425	39.8	39.8	9512.0
2017-09-19 06:30:00	AAPL	Stock	39.7925	39.8325	39.79	39.8325	11480.0
2017-09-19 07:00:00	AAPL	Stock	39.8075	39.825	39.7575	39.8025	137924.0
2017-09-19 07:30:00	AAPL	Stock	39.795	39.93	39.795	39.9	222336.0
2017-09-19 08:00:00	AAPL	Stock	39.81	39.9125	39.7775	39.865	247744.0
2017-09-19 08:30:00	AAPL	Stock	39.865	39.9025	39.865	39.8825	218256.0
2017-09-19 09:00:00	AAPL	Stock	39.89	39.905	39.8575	39.875	242100.0
2017-09-19 09:30:00	AAPL	Stock	39.8775	39.9425	39.61	39.635	14556152.0
2017-09-19 10:00:00	AAPL	Stock	39.64	39.8575	39.635	39.8162	8114424.0
2017-09-19 10:30:00	AAPL	Stock	39.815	39.85	39.7675	39.815	3679488.0
2017-09-19 11:00:00	AAPL	Stock	39.8175	39.8212	39.6625	39.798	4959672.0
2017-09-19 11:30:00	AAPL	Stock	39.7988	39.8175	39.77	39.771	2689596.0
2017-09-19 12:00:00	AAPL	Stock	39.7725	39.875	39.77	39.84	4134584.0
2017-09-19 12:30:00	AAPL	Stock	39.84	39.8725	39.7768	39.7775	2771724.0
2017-09-19 13:00:00	AAPL	Stock	39.78	39.81	39.7122	39.7275	2742232.0
2017-09-19 13:30:00	AAPL	Stock	39.7275	39.8	39.725	39.76	2793444.0
2017-09-19 14:00:00	AAPL	Stock	39.7588	39.7875	39.695	39.7275	2741712.0
2017-09-19 14:30:00	AAPL	Stock	39.7252	39.775	39.6725	39.6925	3165620.0
2017-09-19 15:00:00	AAPL	Stock	39.6912	39.72	39.675	39.705	3241524.0
2017-09-19 15:30:00	AAPL	Stock	39.7075	39.73	39.6425	39.68	6672892.0
2017-09-19 16:00:00	AAPL	Stock	39.6825	39.814	39.6725	39.68	10243536.0
2017-09-19 16:30:00	AAPL	Stock	39.6775	39.6825	39.6775	39.6775	9852.0
2017-09-19 17:00:00	AAPL	Stock	39.6775	39.6775	39.6375	39.6775	89152.0
2017-09-19 17:30:00	AAPL	Stock	39.6625	39.665	39.5775	39.6025	76144.0
2017-09-19 18:00:00	AAPL	Stock	39.6	39.6175	39.5875	39.6	46036.0
2017-09-19 18:30:00	AAPL	Stock	39.6	39.6825	39.5975	39.6025	738836.0
2017-09-19 19:00:00	AAPL	Stock	39.6	39.6175	39.59	39.6175	7304.0
2017-09-19 19:30:00	AAPL	Stock	39.6175	39.625	39.5975	39.605	25776.0
2017-09-19 07:00:00	MSFT	Stock	75.46	75.46	75.46	75.46	100.0
2017-09-19 08:00:00	MSFT	Stock	75.38	75.38	75.16	75.16	6955.0
2017-09-19 08:30:00	MSFT	Stock	75.28	75.28	75.25	75.25	600.0
2017-09-19 09:00:00	MSFT	Stock	75.25	75.39	75.24	75.39	1650.0
2017-09-19 09:30:00	MSFT	Stock	75.21	75.34	75.01	75.18	1684602.0
2017-09-19 10:00:00	MSFT	Stock	75.19	75.38	75.1	75.38	1072826.0
2017-09-19 10:30:00	MSFT	Stock	75.38	75.63	75.34	75.63	823747.0
2017-09-19 11:00:00	MSFT	Stock	75.64	75.64	75.46	75.515	887794.0
2017-09-19 11:30:00	MSFT	Stock	75.51	75.595	75.45	75.465	454678.0
2017-09-19 12:00:00	MSFT	Stock	75.469	75.71	75.464	75.575	813276.0
2017-09-19 12:30:00	MSFT	Stock	75.58	75.614	75.42	75.45	654118.0
2017-09-19 13:00:00	MSFT	Stock	75.445	75.5	75.41	75.48	379092.0
2017-09-19 13:30:00	MSFT	Stock	75.48	75.615	75.48	75.61	530067.0
2017-09-19 14:00:00	MSFT	Stock	75.605	75.69	75.58	75.585	685570.0
2017-09-19 14:30:00	MSFT	Stock	75.58	75.59	75.47	75.476	509969.0
2017-09-19 15:00:00	MSFT	Stock	75.475	75.48	75.37	75.41	1094695.0
2017-09-19 15:30:00	MSFT	Stock	75.41	75.45	75.36	75.44	1573224.0
2017-09-19 16:00:00	MSFT	Stock	75.45	75.485	75.44	75.45	3061612.0

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

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