PREVIEW / stock_30min / 2016-10-25

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-25.parquet
  size:    1.6 MB
  rows:    80,321
  symbols: 3,206

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-10-25 04:00:00	AAPL	Stock	29.49	29.49	29.48	29.48	3124.0
2016-10-25 04:30:00	AAPL	Stock	29.48	29.55	29.4625	29.525	55904.0
2016-10-25 05:00:00	AAPL	Stock	29.5375	29.5375	29.5	29.5025	6984.0
2016-10-25 05:30:00	AAPL	Stock	29.5	29.5	29.5	29.5	1600.0
2016-10-25 06:00:00	AAPL	Stock	29.5	29.5625	29.5	29.5625	16876.0
2016-10-25 06:30:00	AAPL	Stock	29.55	29.575	29.55	29.5525	103376.0
2016-10-25 07:00:00	AAPL	Stock	29.5525	29.56	29.5125	29.5125	94248.0
2016-10-25 07:30:00	AAPL	Stock	29.52	29.5375	29.5	29.5	56164.0
2016-10-25 08:00:00	AAPL	Stock	29.5	29.5625	29.4775	29.51	423780.0
2016-10-25 08:30:00	AAPL	Stock	29.5175	31.58	29.5	29.5175	162792.0
2016-10-25 09:00:00	AAPL	Stock	29.52	29.5325	29.4775	29.5	344712.0
2016-10-25 09:30:00	AAPL	Stock	29.49	29.5025	29.425	29.444	19910940.0
2016-10-25 10:00:00	AAPL	Stock	29.445	29.4575	29.3875	29.4462	12758284.0
2016-10-25 10:30:00	AAPL	Stock	29.4475	29.46	29.3605	29.3808	10080536.0
2016-10-25 11:00:00	AAPL	Stock	29.3825	29.4125	29.3575	29.4125	7186284.0
2016-10-25 11:30:00	AAPL	Stock	29.4125	29.4325	29.3525	29.36	8462856.0
2016-10-25 12:00:00	AAPL	Stock	29.3608	29.38	29.3275	29.3685	7341844.0
2016-10-25 12:30:00	AAPL	Stock	29.3675	29.425	29.3525	29.4125	7253452.0
2016-10-25 13:00:00	AAPL	Stock	29.4125	29.4675	29.3875	29.4625	6401320.0
2016-10-25 13:30:00	AAPL	Stock	29.4625	29.5	29.4525	29.4908	9036404.0
2016-10-25 14:00:00	AAPL	Stock	29.4912	29.5075	29.4712	29.49	8059608.0
2016-10-25 14:30:00	AAPL	Stock	29.4912	29.495	29.4375	29.4525	7747136.0
2016-10-25 15:00:00	AAPL	Stock	29.4525	29.4875	29.435	29.4838	8731100.0
2016-10-25 15:30:00	AAPL	Stock	29.485	29.59	29.4825	29.565	24161920.0
2016-10-25 16:00:00	AAPL	Stock	29.5625	29.625	29.355	29.625	6145436.0
2016-10-25 16:30:00	AAPL	Stock	29.5975	30.46	28.79	28.9725	22141076.0
2016-10-25 17:00:00	AAPL	Stock	28.975	29.15	28.6425	28.825	7131044.0
2016-10-25 17:30:00	AAPL	Stock	28.82	29.5625	28.6875	28.8125	3097660.0
2016-10-25 18:00:00	AAPL	Stock	28.8025	28.8375	28.7125	28.745	880148.0
2016-10-25 18:30:00	AAPL	Stock	28.745	28.75	28.7	28.735	579932.0
2016-10-25 19:00:00	AAPL	Stock	28.7375	28.795	28.73	28.7575	230856.0
2016-10-25 19:30:00	AAPL	Stock	28.76	28.7725	28.7275	28.7375	294300.0
2016-10-25 04:00:00	MSFT	Stock	61.23	61.23	61.17	61.17	1640.0
2016-10-25 04:30:00	MSFT	Stock	61.12	61.12	61.12	61.12	158.0
2016-10-25 05:00:00	MSFT	Stock	61.12	61.12	61.12	61.12	500.0
2016-10-25 05:30:00	MSFT	Stock	61.14	61.17	61.01	61.01	1500.0
2016-10-25 06:00:00	MSFT	Stock	61.1	61.1	61.0	61.08	1500.0
2016-10-25 06:30:00	MSFT	Stock	61.08	61.09	61.0	61.0	730.0
2016-10-25 07:00:00	MSFT	Stock	60.98	61.0	60.95	60.96	2580.0
2016-10-25 07:30:00	MSFT	Stock	60.96	61.07	60.95	61.0	7647.0
2016-10-25 08:00:00	MSFT	Stock	61.0	61.04	60.85	60.95	13555.0
2016-10-25 08:30:00	MSFT	Stock	60.95	62.0	60.95	61.05	27008.0
2016-10-25 09:00:00	MSFT	Stock	61.08	61.11	60.85	60.87	23305.0
2016-10-25 09:30:00	MSFT	Stock	60.86	61.37	60.83	61.3	6411715.0
2016-10-25 10:00:00	MSFT	Stock	61.295	61.36	61.0	61.01	4216316.0
2016-10-25 10:30:00	MSFT	Stock	61.01	61.03	60.85	60.953	2415358.0
2016-10-25 11:00:00	MSFT	Stock	60.955	61.045	60.89	60.966	1786950.0
2016-10-25 11:30:00	MSFT	Stock	60.955	60.99	60.88	60.9	1927478.0
2016-10-25 12:00:00	MSFT	Stock	60.9	60.92	60.8	60.915	1332040.0
2016-10-25 12:30:00	MSFT	Stock	60.91	61.02	60.88	61.015	1271471.0

> showing 50 of 80,321 rows — these rows as CSV

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