PREVIEW / stock_30min / 2016-11-23

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-23.parquet
  size:    1.6 MB
  rows:    81,343
  symbols: 3,170

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-23 04:00:00	AAPL	Stock	27.9475	27.9475	27.9175	27.93	3600.0
2016-11-23 04:30:00	AAPL	Stock	27.93	27.95	27.925	27.925	4936.0
2016-11-23 05:00:00	AAPL	Stock	27.925	27.925	27.925	27.925	3440.0
2016-11-23 05:30:00	AAPL	Stock	27.9	27.9	27.9	27.9	548.0
2016-11-23 07:00:00	AAPL	Stock	27.9475	27.975	27.9475	27.95	3676.0
2016-11-23 07:30:00	AAPL	Stock	27.93	27.93	27.93	27.93	2000.0
2016-11-23 08:00:00	AAPL	Stock	27.95	27.9525	27.9	27.9	52076.0
2016-11-23 08:30:00	AAPL	Stock	27.885	27.9125	27.8625	27.875	62684.0
2016-11-23 09:00:00	AAPL	Stock	27.8875	27.915	27.8375	27.845	196468.0
2016-11-23 09:30:00	AAPL	Stock	27.84	27.8775	27.6825	27.735	14552532.0
2016-11-23 10:00:00	AAPL	Stock	27.735	27.7675	27.6412	27.6595	10062380.0
2016-11-23 10:30:00	AAPL	Stock	27.66	27.69	27.5825	27.5975	7180120.0
2016-11-23 11:00:00	AAPL	Stock	27.5988	27.675	27.5975	27.67	6594124.0
2016-11-23 11:30:00	AAPL	Stock	27.6675	27.7175	27.6275	27.7175	5693544.0
2016-11-23 12:00:00	AAPL	Stock	27.7175	27.75	27.6925	27.725	4577196.0
2016-11-23 12:30:00	AAPL	Stock	27.725	27.77	27.7125	27.7375	4569188.0
2016-11-23 13:00:00	AAPL	Stock	27.7375	27.75	27.6725	27.6988	3709572.0
2016-11-23 13:30:00	AAPL	Stock	27.7	27.7938	27.6975	27.7625	3666236.0
2016-11-23 14:00:00	AAPL	Stock	27.7625	27.8425	27.7575	27.8175	5032164.0
2016-11-23 14:30:00	AAPL	Stock	27.8168	27.8262	27.7525	27.7625	3462964.0
2016-11-23 15:00:00	AAPL	Stock	27.7602	27.785	27.73	27.7375	4751792.0
2016-11-23 15:30:00	AAPL	Stock	27.7375	27.81	27.725	27.8062	9685560.0
2016-11-23 16:00:00	AAPL	Stock	27.8075	27.835	27.7825	27.7825	17688608.0
2016-11-23 16:30:00	AAPL	Stock	27.8	27.805	27.79	27.805	15828.0
2016-11-23 17:30:00	AAPL	Stock	27.8125	27.8125	27.8125	27.8125	444.0
2016-11-23 18:00:00	AAPL	Stock	27.8	27.8	27.8	27.8	1760.0
2016-11-23 18:30:00	AAPL	Stock	27.81	27.81	27.8	27.8	4208.0
2016-11-23 19:00:00	AAPL	Stock	27.8	27.8125	27.8	27.8	7620.0
2016-11-23 19:30:00	AAPL	Stock	27.81	27.81	27.7875	27.7875	3940.0
2016-11-23 05:30:00	MSFT	Stock	61.14	61.14	61.07	61.07	1516.0
2016-11-23 06:30:00	MSFT	Stock	61.06	61.06	61.06	61.06	240.0
2016-11-23 07:30:00	MSFT	Stock	61.17	61.17	61.17	61.17	414.0
2016-11-23 08:00:00	MSFT	Stock	61.15	61.15	61.13	61.13	470.0
2016-11-23 08:30:00	MSFT	Stock	61.13	61.13	60.95	61.1	2616.0
2016-11-23 09:00:00	MSFT	Stock	61.12	61.12	60.95	60.99	3697.0
2016-11-23 09:30:00	MSFT	Stock	61.01	61.1	60.46	60.615	2831956.0
2016-11-23 10:00:00	MSFT	Stock	60.61	60.73	60.535	60.58	1202936.0
2016-11-23 10:30:00	MSFT	Stock	60.59	60.63	60.37	60.435	1232345.0
2016-11-23 11:00:00	MSFT	Stock	60.449	60.47	60.3	60.31	1022778.0
2016-11-23 11:30:00	MSFT	Stock	60.318	60.365	60.25	60.345	832029.0
2016-11-23 12:00:00	MSFT	Stock	60.34	60.48	60.32	60.355	683579.0
2016-11-23 12:30:00	MSFT	Stock	60.36	60.44	60.27	60.29	674187.0
2016-11-23 13:00:00	MSFT	Stock	60.3	60.38	60.29	60.336	583747.0
2016-11-23 13:30:00	MSFT	Stock	60.336	60.36	60.25	60.26	563465.0
2016-11-23 14:00:00	MSFT	Stock	60.26	60.46	60.26	60.39	874340.0
2016-11-23 14:30:00	MSFT	Stock	60.39	60.42	60.305	60.344	1015618.0
2016-11-23 15:00:00	MSFT	Stock	60.35	60.4	60.32	60.34	1021229.0
2016-11-23 15:30:00	MSFT	Stock	60.345	60.4	60.3	60.4	2834443.0
2016-11-23 16:00:00	MSFT	Stock	60.4	60.45	60.38	60.4	4765593.0
2016-11-23 17:00:00	MSFT	Stock	60.42	60.42	60.42	60.42	300.0

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

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