PREVIEW / stock_30min / 2017-03-28

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-28.parquet
  size:    1.6 MB
  rows:    82,527
  symbols: 3,080

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-03-28 05:00:00	AAPL	Stock	35.285	35.285	35.24	35.24	3836.0
2017-03-28 05:30:00	AAPL	Stock	35.24	35.255	35.24	35.25	6156.0
2017-03-28 06:00:00	AAPL	Stock	35.23	35.255	35.225	35.255	6756.0
2017-03-28 06:30:00	AAPL	Stock	35.2525	35.285	35.2525	35.2675	16908.0
2017-03-28 07:00:00	AAPL	Stock	35.2675	35.2975	35.2625	35.2625	26800.0
2017-03-28 07:30:00	AAPL	Stock	35.2625	35.2625	35.225	35.24	23600.0
2017-03-28 08:00:00	AAPL	Stock	35.2875	35.2875	35.2075	35.2075	59008.0
2017-03-28 08:30:00	AAPL	Stock	35.2125	35.2225	35.1875	35.1875	46420.0
2017-03-28 09:00:00	AAPL	Stock	35.18	35.2375	35.18	35.22	127064.0
2017-03-28 09:30:00	AAPL	Stock	35.2275	35.3475	35.155	35.2675	12462784.0
2017-03-28 10:00:00	AAPL	Stock	35.265	35.38	35.26	35.3375	7191920.0
2017-03-28 10:30:00	AAPL	Stock	35.34	35.4625	35.3288	35.46	5641140.0
2017-03-28 11:00:00	AAPL	Stock	35.4568	35.6175	35.4475	35.56	12260968.0
2017-03-28 11:30:00	AAPL	Stock	35.5612	35.6875	35.5612	35.645	8136244.0
2017-03-28 12:00:00	AAPL	Stock	35.6425	35.72	35.6375	35.7025	6558060.0
2017-03-28 12:30:00	AAPL	Stock	35.7075	35.7675	35.6552	35.7125	9066928.0
2017-03-28 13:00:00	AAPL	Stock	35.7115	35.7975	35.71	35.7925	5659660.0
2017-03-28 13:30:00	AAPL	Stock	35.7925	35.8975	35.78	35.8838	6858124.0
2017-03-28 14:00:00	AAPL	Stock	35.885	36.0075	35.885	35.9625	9792600.0
2017-03-28 14:30:00	AAPL	Stock	35.965	36.005	35.9575	35.99	6902460.0
2017-03-28 15:00:00	AAPL	Stock	35.995	36.01	35.9325	35.975	7266396.0
2017-03-28 15:30:00	AAPL	Stock	35.9772	36.0	35.9425	35.9525	13896888.0
2017-03-28 16:00:00	AAPL	Stock	35.95	35.9725	35.9075	35.93	11724500.0
2017-03-28 16:30:00	AAPL	Stock	35.93	35.95	35.9125	35.915	67052.0
2017-03-28 17:00:00	AAPL	Stock	35.915	35.925	35.9125	35.925	23072.0
2017-03-28 17:30:00	AAPL	Stock	35.9175	35.93	35.9175	35.93	29800.0
2017-03-28 18:00:00	AAPL	Stock	35.93	35.9325	35.925	35.9275	14536.0
2017-03-28 18:30:00	AAPL	Stock	35.9375	35.9425	35.9275	35.9275	9684.0
2017-03-28 19:00:00	AAPL	Stock	35.9375	35.9425	35.9375	35.9425	2480.0
2017-03-28 19:30:00	AAPL	Stock	35.9375	35.9475	35.915	35.925	23848.0
2017-03-28 07:00:00	MSFT	Stock	65.19	65.19	65.19	65.19	1100.0
2017-03-28 07:30:00	MSFT	Stock	65.19	65.19	65.19	65.19	1800.0
2017-03-28 08:00:00	MSFT	Stock	65.1	65.1	65.1	65.1	130.0
2017-03-28 08:30:00	MSFT	Stock	65.09	65.1	65.09	65.1	231.0
2017-03-28 09:00:00	MSFT	Stock	65.1	65.12	64.97	64.99	6512.0
2017-03-28 09:30:00	MSFT	Stock	64.96	65.02	64.65	64.71	2034332.0
2017-03-28 10:00:00	MSFT	Stock	64.7	64.97	64.68	64.765	1223773.0
2017-03-28 10:30:00	MSFT	Stock	64.77	64.87	64.705	64.775	915598.0
2017-03-28 11:00:00	MSFT	Stock	64.77	64.91	64.765	64.855	1001586.0
2017-03-28 11:30:00	MSFT	Stock	64.86	64.93	64.77	64.905	760218.0
2017-03-28 12:00:00	MSFT	Stock	64.905	65.075	64.9	65.01	1043113.0
2017-03-28 12:30:00	MSFT	Stock	65.01	65.1	64.94	65.07	667588.0
2017-03-28 13:00:00	MSFT	Stock	65.07	65.185	65.06	65.16	843683.0
2017-03-28 13:30:00	MSFT	Stock	65.16	65.34	65.13	65.325	1046900.0
2017-03-28 14:00:00	MSFT	Stock	65.33	65.47	65.275	65.44	1109313.0
2017-03-28 14:30:00	MSFT	Stock	65.44	65.45	65.305	65.315	1102435.0
2017-03-28 15:00:00	MSFT	Stock	65.31	65.42	65.295	65.4	1501401.0
2017-03-28 15:30:00	MSFT	Stock	65.4	65.45	65.27	65.29	2525709.0
2017-03-28 16:00:00	MSFT	Stock	65.29	65.314	64.895	65.314	2449639.0
2017-03-28 16:30:00	MSFT	Stock	65.29	65.29	65.29	65.29	24305.0

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

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