PREVIEW / stock_30min / 2015-10-27

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-10-27.parquet
  size:    1.6 MB
  rows:    82,046
  symbols: 3,428

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
2015-10-27 04:00:00	AAPL	Stock	28.7975	28.81	28.75	28.75	14500.0
2015-10-27 04:30:00	AAPL	Stock	28.71	28.74	28.6075	28.6075	5224.0
2015-10-27 05:00:00	AAPL	Stock	28.65	28.65	28.61	28.6375	2796.0
2015-10-27 05:30:00	AAPL	Stock	28.725	28.725	28.725	28.725	800.0
2015-10-27 06:00:00	AAPL	Stock	28.735	28.7475	28.7125	28.7475	15160.0
2015-10-27 06:30:00	AAPL	Stock	28.75	28.82	28.7325	28.8175	17664.0
2015-10-27 07:00:00	AAPL	Stock	28.8225	28.935	28.75	28.925	45980.0
2015-10-27 07:30:00	AAPL	Stock	28.94	28.9875	28.94	28.9875	159404.0
2015-10-27 08:00:00	AAPL	Stock	28.98	28.99	28.72	28.9325	720224.0
2015-10-27 08:30:00	AAPL	Stock	28.9425	28.95	28.88	28.8875	448996.0
2015-10-27 09:00:00	AAPL	Stock	28.8925	28.905	28.825	28.85	445320.0
2015-10-27 09:30:00	AAPL	Stock	28.85	29.07	28.7	29.0232	28946172.0
2015-10-27 10:00:00	AAPL	Stock	29.0225	29.045	28.9025	29.0075	13633792.0
2015-10-27 10:30:00	AAPL	Stock	29.005	29.135	28.925	29.05	16454968.0
2015-10-27 11:00:00	AAPL	Stock	29.05	29.125	28.93	28.9362	11912040.0
2015-10-27 11:30:00	AAPL	Stock	28.9362	28.9725	28.8375	28.92	12666160.0
2015-10-27 12:00:00	AAPL	Stock	28.9175	28.94	28.7225	28.725	14309392.0
2015-10-27 12:30:00	AAPL	Stock	28.7275	28.815	28.685	28.8125	10619152.0
2015-10-27 13:00:00	AAPL	Stock	28.815	28.9325	28.7652	28.7925	11087892.0
2015-10-27 13:30:00	AAPL	Stock	28.7925	28.9025	28.77	28.7775	10494652.0
2015-10-27 14:00:00	AAPL	Stock	28.775	28.8275	28.7475	28.8058	8970336.0
2015-10-27 14:30:00	AAPL	Stock	28.806	28.825	28.725	28.7295	9758756.0
2015-10-27 15:00:00	AAPL	Stock	28.7278	28.7725	28.625	28.679	18604104.0
2015-10-27 15:30:00	AAPL	Stock	28.68	28.7205	28.4975	28.645	37492256.0
2015-10-27 16:00:00	AAPL	Stock	28.6375	28.725	28.46	28.5175	8974396.0
2015-10-27 16:30:00	AAPL	Stock	28.5875	29.5825	27.7025	29.1525	27206764.0
2015-10-27 17:00:00	AAPL	Stock	29.145	29.2125	28.645	28.775	7640716.0
2015-10-27 17:30:00	AAPL	Stock	28.775	28.85	28.455	28.585	4386456.0
2015-10-27 18:00:00	AAPL	Stock	28.5825	28.7125	28.5175	28.6975	1098072.0
2015-10-27 18:30:00	AAPL	Stock	28.675	28.755	28.6	28.745	650548.0
2015-10-27 19:00:00	AAPL	Stock	28.74	28.7875	28.7	28.775	417472.0
2015-10-27 19:30:00	AAPL	Stock	28.775	28.8375	28.7725	28.8125	377584.0
2015-10-27 04:00:00	MSFT	Stock	54.0	54.0	54.0	54.0	600.0
2015-10-27 04:30:00	MSFT	Stock	54.0	54.0	53.95	53.95	1496.0
2015-10-27 05:00:00	MSFT	Stock	53.97	53.97	53.85	53.85	4952.0
2015-10-27 05:30:00	MSFT	Stock	53.88	53.92	53.88	53.92	96794.0
2015-10-27 06:00:00	MSFT	Stock	53.94	53.97	53.91	53.97	3990.0
2015-10-27 06:30:00	MSFT	Stock	53.97	53.99	53.97	53.98	1500.0
2015-10-27 07:00:00	MSFT	Stock	53.96	54.0	53.92	53.98	9053.0
2015-10-27 07:30:00	MSFT	Stock	53.98	54.04	53.98	54.03	1450.0
2015-10-27 08:00:00	MSFT	Stock	53.99	54.08	53.87	53.98	24956.0
2015-10-27 08:30:00	MSFT	Stock	53.98	53.99	53.9	53.93	14081.0
2015-10-27 09:00:00	MSFT	Stock	53.93	54.08	53.81	53.98	64488.0
2015-10-27 09:30:00	MSFT	Stock	53.99	54.23	53.83	54.01	7130108.0
2015-10-27 10:00:00	MSFT	Stock	54.01	54.08	53.91	54.06	3580953.0
2015-10-27 10:30:00	MSFT	Stock	54.05	54.08	53.92	54.07	3150861.0
2015-10-27 11:00:00	MSFT	Stock	54.065	54.37	54.045	54.08	3578112.0
2015-10-27 11:30:00	MSFT	Stock	54.075	54.21	53.975	54.005	3112772.0
2015-10-27 12:00:00	MSFT	Stock	54.0	54.14	53.91	54.066	2313875.0
2015-10-27 12:30:00	MSFT	Stock	54.06	54.14	54.01	54.011	2775388.0

> showing 50 of 82,046 rows — these rows as CSV

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