PREVIEW / stock_30min / 2016-12-07

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-07.parquet
  size:    1.7 MB
  rows:    83,851
  symbols: 3,168

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-12-07 04:00:00	AAPL	Stock	27.52	27.52	27.52	27.52	400.0
2016-12-07 04:30:00	AAPL	Stock	27.52	27.52	27.52	27.52	400.0
2016-12-07 05:00:00	AAPL	Stock	27.525	27.525	27.525	27.525	1596.0
2016-12-07 05:30:00	AAPL	Stock	27.56	27.5625	27.56	27.5625	900.0
2016-12-07 06:00:00	AAPL	Stock	27.525	27.5325	27.525	27.525	4992.0
2016-12-07 07:00:00	AAPL	Stock	27.5225	27.5225	27.485	27.4975	7876.0
2016-12-07 07:30:00	AAPL	Stock	27.51	27.51	27.2625	27.2625	141600.0
2016-12-07 08:00:00	AAPL	Stock	27.31	27.515	27.2075	27.3625	246964.0
2016-12-07 08:30:00	AAPL	Stock	27.325	27.3625	27.275	27.28	114372.0
2016-12-07 09:00:00	AAPL	Stock	27.2875	27.3575	27.2825	27.3	179340.0
2016-12-07 09:30:00	AAPL	Stock	27.3125	27.4725	27.29	27.3625	11158148.0
2016-12-07 10:00:00	AAPL	Stock	27.36	27.4738	27.345	27.42	7256172.0
2016-12-07 10:30:00	AAPL	Stock	27.4225	27.5225	27.3575	27.465	9053740.0
2016-12-07 11:00:00	AAPL	Stock	27.4675	27.5125	27.42	27.435	5059904.0
2016-12-07 11:30:00	AAPL	Stock	27.435	27.4675	27.354	27.4262	6726896.0
2016-12-07 12:00:00	AAPL	Stock	27.4275	27.5	27.3975	27.46	5237368.0
2016-12-07 12:30:00	AAPL	Stock	27.46	27.545	27.445	27.54	3976488.0
2016-12-07 13:00:00	AAPL	Stock	27.5418	27.6365	27.5375	27.575	6692040.0
2016-12-07 13:30:00	AAPL	Stock	27.5725	27.735	27.5675	27.71	8904476.0
2016-12-07 14:00:00	AAPL	Stock	27.71	27.755	27.6425	27.7088	7797072.0
2016-12-07 14:30:00	AAPL	Stock	27.7075	27.72	27.68	27.71	5124772.0
2016-12-07 15:00:00	AAPL	Stock	27.7125	27.7975	27.6912	27.7725	7589764.0
2016-12-07 15:30:00	AAPL	Stock	27.7725	27.795	27.7225	27.7525	13970448.0
2016-12-07 16:00:00	AAPL	Stock	27.7575	27.7625	27.725	27.725	11252508.0
2016-12-07 16:30:00	AAPL	Stock	27.725	27.7575	27.7125	27.725	34852.0
2016-12-07 17:00:00	AAPL	Stock	27.7125	27.7575	27.7125	27.73	116576.0
2016-12-07 17:30:00	AAPL	Stock	27.7225	27.73	27.7225	27.725	5592.0
2016-12-07 18:00:00	AAPL	Stock	27.725	27.725	27.7	27.7	8272.0
2016-12-07 18:30:00	AAPL	Stock	27.7	27.7125	27.7	27.7125	1400.0
2016-12-07 19:00:00	AAPL	Stock	27.7225	27.725	27.7125	27.725	5412.0
2016-12-07 19:30:00	AAPL	Stock	27.725	27.725	27.71	27.7125	22968.0
2016-12-07 06:30:00	MSFT	Stock	60.2	60.21	60.2	60.21	250.0
2016-12-07 07:30:00	MSFT	Stock	60.0	60.0	60.0	60.0	400.0
2016-12-07 08:00:00	MSFT	Stock	59.98	59.98	59.95	59.97	1300.0
2016-12-07 08:30:00	MSFT	Stock	59.9	59.94	59.9	59.94	528.0
2016-12-07 09:00:00	MSFT	Stock	59.96	59.96	59.96	59.96	4442.0
2016-12-07 09:30:00	MSFT	Stock	60.01	60.04	59.8	59.837	2040345.0
2016-12-07 10:00:00	MSFT	Stock	59.835	60.26	59.81	60.22	1473678.0
2016-12-07 10:30:00	MSFT	Stock	60.23	60.32	60.13	60.24	1039218.0
2016-12-07 11:00:00	MSFT	Stock	60.25	60.315	60.05	60.06	1573475.0
2016-12-07 11:30:00	MSFT	Stock	60.06	60.27	60.06	60.25	958114.0
2016-12-07 12:00:00	MSFT	Stock	60.25	60.34	60.22	60.32	784890.0
2016-12-07 12:30:00	MSFT	Stock	60.32	60.63	60.28	60.62	1279383.0
2016-12-07 13:00:00	MSFT	Stock	60.629	60.88	60.61	60.74	1619156.0
2016-12-07 13:30:00	MSFT	Stock	60.741	60.84	60.69	60.82	1426176.0
2016-12-07 14:00:00	MSFT	Stock	60.825	61.07	60.77	60.964	2120197.0
2016-12-07 14:30:00	MSFT	Stock	60.96	61.25	60.945	61.25	1867490.0
2016-12-07 15:00:00	MSFT	Stock	61.24	61.34	61.14	61.26	2697642.0
2016-12-07 15:30:00	MSFT	Stock	61.25	61.38	61.2	61.36	5008031.0
2016-12-07 16:00:00	MSFT	Stock	61.37	61.37	61.26	61.37	3918531.0

> showing 50 of 83,851 rows — these rows as CSV

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