PREVIEW / stock_30min / 2015-11-18

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-11-18.parquet
  size:    1.6 MB
  rows:    82,929
  symbols: 3,437

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-11-18 04:00:00	AAPL	Stock	28.445	28.7525	28.445	28.6925	71848.0
2015-11-18 04:30:00	AAPL	Stock	28.6725	28.6725	28.625	28.6325	8196.0
2015-11-18 05:00:00	AAPL	Stock	28.6375	28.6725	28.6125	28.6125	7392.0
2015-11-18 05:30:00	AAPL	Stock	28.665	28.665	28.625	28.6625	13444.0
2015-11-18 06:00:00	AAPL	Stock	28.62	28.685	28.6175	28.6675	140912.0
2015-11-18 06:30:00	AAPL	Stock	28.685	28.6875	28.63	28.685	158812.0
2015-11-18 07:00:00	AAPL	Stock	28.685	28.9025	28.675	28.885	317512.0
2015-11-18 07:30:00	AAPL	Stock	28.8875	28.9	28.82	28.9	166972.0
2015-11-18 08:00:00	AAPL	Stock	28.9	28.925	28.65	28.845	530304.0
2015-11-18 08:30:00	AAPL	Stock	28.845	28.9225	28.83	28.91	419552.0
2015-11-18 09:00:00	AAPL	Stock	28.9	29.0225	28.875	28.95	1037860.0
2015-11-18 09:30:00	AAPL	Stock	28.9425	29.3725	28.92	29.2895	41357056.0
2015-11-18 10:00:00	AAPL	Stock	29.2888	29.3125	29.165	29.2375	18556424.0
2015-11-18 10:30:00	AAPL	Stock	29.2395	29.285	29.2025	29.25	10804420.0
2015-11-18 11:00:00	AAPL	Stock	29.2475	29.34	28.875	29.25	10720188.0
2015-11-18 11:30:00	AAPL	Stock	29.25	29.3125	29.21	29.225	7565412.0
2015-11-18 12:00:00	AAPL	Stock	29.2225	29.24	29.15	29.16	8481540.0
2015-11-18 12:30:00	AAPL	Stock	29.16	29.18	29.0925	29.125	8605184.0
2015-11-18 13:00:00	AAPL	Stock	29.125	29.1925	29.1125	29.1425	6521864.0
2015-11-18 13:30:00	AAPL	Stock	29.14	29.155	29.1	29.108	3905608.0
2015-11-18 14:00:00	AAPL	Stock	29.1075	29.2525	29.0525	29.1762	12306764.0
2015-11-18 14:30:00	AAPL	Stock	29.175	29.215	29.125	29.2128	7308500.0
2015-11-18 15:00:00	AAPL	Stock	29.2125	29.22	29.145	29.1985	7403580.0
2015-11-18 15:30:00	AAPL	Stock	29.1975	29.36	29.19	29.3202	20880268.0
2015-11-18 16:00:00	AAPL	Stock	29.3225	29.35	29.243	29.3475	6780580.0
2015-11-18 16:30:00	AAPL	Stock	29.33	29.35	29.3275	29.335	50800.0
2015-11-18 17:00:00	AAPL	Stock	29.335	29.37	29.3225	29.3575	702876.0
2015-11-18 17:30:00	AAPL	Stock	29.355	29.365	29.345	29.355	55184.0
2015-11-18 18:00:00	AAPL	Stock	29.3675	29.3725	29.3225	29.3575	165428.0
2015-11-18 18:30:00	AAPL	Stock	29.36	29.3725	29.36	29.3625	66644.0
2015-11-18 19:00:00	AAPL	Stock	29.3625	29.37	29.34	29.3575	25808.0
2015-11-18 19:30:00	AAPL	Stock	29.3575	29.375	29.3575	29.375	94104.0
2015-11-18 04:00:00	MSFT	Stock	52.95	52.95	52.95	52.95	100.0
2015-11-18 05:30:00	MSFT	Stock	52.87	52.87	52.87	52.87	100.0
2015-11-18 06:30:00	MSFT	Stock	52.95	52.95	52.94	52.94	3100.0
2015-11-18 07:00:00	MSFT	Stock	52.94	53.05	52.94	53.05	2243.0
2015-11-18 07:30:00	MSFT	Stock	53.0	53.0	52.95	52.95	2300.0
2015-11-18 08:00:00	MSFT	Stock	52.95	52.99	52.92	52.92	8723.0
2015-11-18 08:30:00	MSFT	Stock	52.99	53.1	52.99	53.07	27364.0
2015-11-18 09:00:00	MSFT	Stock	53.09	53.09	53.0	53.07	7100.0
2015-11-18 09:30:00	MSFT	Stock	53.0	53.32	52.98	53.169	3258123.0
2015-11-18 10:00:00	MSFT	Stock	53.17	53.425	53.16	53.262	1946620.0
2015-11-18 10:30:00	MSFT	Stock	53.27	53.335	53.165	53.315	1857875.0
2015-11-18 11:00:00	MSFT	Stock	53.3	53.52	53.19	53.52	1347382.0
2015-11-18 11:30:00	MSFT	Stock	53.52	53.55	53.23	53.42	2071175.0
2015-11-18 12:00:00	MSFT	Stock	53.42	53.46	53.35	53.405	1120299.0
2015-11-18 12:30:00	MSFT	Stock	53.41	53.51	53.38	53.43	801686.0
2015-11-18 13:00:00	MSFT	Stock	53.43	53.55	53.375	53.545	1003133.0
2015-11-18 13:30:00	MSFT	Stock	53.545	53.58	53.455	53.49	1045305.0
2015-11-18 14:00:00	MSFT	Stock	53.49	53.76	53.405	53.585	2411505.0

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

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