PREVIEW / stock_30min / 2016-07-01

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-01.parquet
  size:    1.6 MB
  rows:    81,156
  symbols: 3,251

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-07-01 04:00:00	AAPL	Stock	23.8475	23.9	23.825	23.825	4400.0
2016-07-01 04:30:00	AAPL	Stock	23.8325	23.845	23.8325	23.845	3200.0
2016-07-01 05:30:00	AAPL	Stock	23.7875	23.7875	23.7875	23.7875	3112.0
2016-07-01 06:00:00	AAPL	Stock	23.7875	23.7875	23.7875	23.7875	1752.0
2016-07-01 06:30:00	AAPL	Stock	23.79	23.79	23.79	23.79	800.0
2016-07-01 07:00:00	AAPL	Stock	23.8225	23.8375	23.8225	23.8375	9360.0
2016-07-01 07:30:00	AAPL	Stock	23.8375	23.875	23.8375	23.875	30264.0
2016-07-01 08:00:00	AAPL	Stock	23.79	23.9	23.79	23.895	110152.0
2016-07-01 08:30:00	AAPL	Stock	23.89	23.9	23.8875	23.89	45252.0
2016-07-01 09:00:00	AAPL	Stock	23.8875	23.9	23.8525	23.865	140940.0
2016-07-01 09:30:00	AAPL	Stock	23.87	23.97	23.8325	23.9325	12701604.0
2016-07-01 10:00:00	AAPL	Stock	23.935	24.01	23.93	23.9975	9734268.0
2016-07-01 10:30:00	AAPL	Stock	23.9975	24.0875	23.9875	24.0825	8815708.0
2016-07-01 11:00:00	AAPL	Stock	24.08	24.1162	24.0575	24.0625	8433648.0
2016-07-01 11:30:00	AAPL	Stock	24.06	24.0725	24.0075	24.061	6960840.0
2016-07-01 12:00:00	AAPL	Stock	24.06	24.0775	24.02	24.0425	4062152.0
2016-07-01 12:30:00	AAPL	Stock	24.04	24.0575	24.0275	24.035	3825236.0
2016-07-01 13:00:00	AAPL	Stock	24.0338	24.055	23.9775	23.9838	4014988.0
2016-07-01 13:30:00	AAPL	Stock	23.9825	24.0075	23.96	23.975	4266052.0
2016-07-01 14:00:00	AAPL	Stock	23.975	23.9875	23.9575	23.97	3589228.0
2016-07-01 14:30:00	AAPL	Stock	23.97	23.995	23.945	23.9762	3939524.0
2016-07-01 15:00:00	AAPL	Stock	23.9762	24.0375	23.9725	24.015	5412240.0
2016-07-01 15:30:00	AAPL	Stock	24.0125	24.025	23.9725	23.975	10942436.0
2016-07-01 16:00:00	AAPL	Stock	23.9775	23.9975	23.9625	23.985	6143388.0
2016-07-01 16:30:00	AAPL	Stock	23.9875	23.9975	23.9725	23.9925	353232.0
2016-07-01 17:00:00	AAPL	Stock	23.985	23.9975	23.975	23.975	51016.0
2016-07-01 17:30:00	AAPL	Stock	23.9775	23.9875	23.9775	23.9875	6460.0
2016-07-01 18:00:00	AAPL	Stock	23.9825	23.9825	23.97	23.97	17860.0
2016-07-01 18:30:00	AAPL	Stock	23.975	23.9875	23.9725	23.9875	134800.0
2016-07-01 19:00:00	AAPL	Stock	23.9875	23.995	23.975	23.995	11060.0
2016-07-01 19:30:00	AAPL	Stock	23.9875	23.99	23.9875	23.99	3588.0
2016-07-01 04:30:00	MSFT	Stock	51.19	51.19	51.19	51.19	1100.0
2016-07-01 07:00:00	MSFT	Stock	51.16	51.21	51.16	51.21	2500.0
2016-07-01 08:00:00	MSFT	Stock	51.21	51.21	51.21	51.21	200.0
2016-07-01 08:30:00	MSFT	Stock	51.22	51.22	51.21	51.21	1100.0
2016-07-01 09:00:00	MSFT	Stock	51.2	51.25	51.1	51.12	17249.0
2016-07-01 09:30:00	MSFT	Stock	51.13	51.57	51.07	51.49	2329592.0
2016-07-01 10:00:00	MSFT	Stock	51.5	51.72	51.445	51.6	1743057.0
2016-07-01 10:30:00	MSFT	Stock	51.61	51.71	51.55	51.625	1192423.0
2016-07-01 11:00:00	MSFT	Stock	51.62	51.7	51.59	51.63	1374923.0
2016-07-01 11:30:00	MSFT	Stock	51.63	51.64	51.48	51.55	1359595.0
2016-07-01 12:00:00	MSFT	Stock	51.55	51.57	51.42	51.46	955636.0
2016-07-01 12:30:00	MSFT	Stock	51.45	51.54	51.41	51.435	740795.0
2016-07-01 13:00:00	MSFT	Stock	51.435	51.46	51.26	51.275	1059295.0
2016-07-01 13:30:00	MSFT	Stock	51.27	51.285	51.2	51.225	1060191.0
2016-07-01 14:00:00	MSFT	Stock	51.23	51.315	51.16	51.19	1001919.0
2016-07-01 14:30:00	MSFT	Stock	51.19	51.22	51.1	51.21	921024.0
2016-07-01 15:00:00	MSFT	Stock	51.215	51.34	51.19	51.27	1323282.0
2016-07-01 15:30:00	MSFT	Stock	51.275	51.32	51.16	51.16	2893025.0
2016-07-01 16:00:00	MSFT	Stock	51.16	51.436	51.13	51.13	1978368.0

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

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