PREVIEW / stock_30min / 2015-07-31

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-31.parquet
  size:    1.6 MB
  rows:    81,079
  symbols: 3,485

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-07-31 04:00:00	AAPL	Stock	30.615	30.615	30.615	30.615	800.0
2015-07-31 04:30:00	AAPL	Stock	30.655	30.655	30.655	30.655	800.0
2015-07-31 05:00:00	AAPL	Stock	30.6625	30.6625	30.6625	30.6625	800.0
2015-07-31 05:30:00	AAPL	Stock	30.6625	30.67	30.6575	30.67	11800.0
2015-07-31 06:30:00	AAPL	Stock	30.6475	30.6475	30.5975	30.5975	8800.0
2015-07-31 07:00:00	AAPL	Stock	30.5975	30.5975	30.51	30.5275	63140.0
2015-07-31 07:30:00	AAPL	Stock	30.535	30.5725	30.5275	30.5725	48044.0
2015-07-31 08:00:00	AAPL	Stock	30.5375	30.55	30.51	30.5225	179792.0
2015-07-31 08:30:00	AAPL	Stock	30.525	30.625	30.525	30.6225	230304.0
2015-07-31 09:00:00	AAPL	Stock	30.6375	30.6975	30.625	30.6275	286372.0
2015-07-31 09:30:00	AAPL	Stock	30.65	30.6605	30.375	30.3862	23566176.0
2015-07-31 10:00:00	AAPL	Stock	30.385	30.405	30.2275	30.3225	23715060.0
2015-07-31 10:30:00	AAPL	Stock	30.325	30.4075	30.285	30.37	10732812.0
2015-07-31 11:00:00	AAPL	Stock	30.3675	30.3675	30.275	30.3362	9706472.0
2015-07-31 11:30:00	AAPL	Stock	30.3375	30.3875	30.3075	30.355	6760860.0
2015-07-31 12:00:00	AAPL	Stock	30.354	30.435	30.3475	30.3825	6151248.0
2015-07-31 12:30:00	AAPL	Stock	30.3805	30.385	30.315	30.3268	6007248.0
2015-07-31 13:00:00	AAPL	Stock	30.321	30.375	30.32	30.3425	4754264.0
2015-07-31 13:30:00	AAPL	Stock	30.3412	30.3515	30.295	30.3175	5197988.0
2015-07-31 14:00:00	AAPL	Stock	30.3175	30.345	30.3	30.3275	7599784.0
2015-07-31 14:30:00	AAPL	Stock	30.3275	30.355	30.265	30.2775	7505156.0
2015-07-31 15:00:00	AAPL	Stock	30.2775	30.3325	30.2662	30.27	8537644.0
2015-07-31 15:30:00	AAPL	Stock	30.27	30.3925	30.2675	30.365	22381380.0
2015-07-31 16:00:00	AAPL	Stock	30.325	30.395	30.325	30.3775	9320344.0
2015-07-31 16:30:00	AAPL	Stock	30.3775	30.385	30.325	30.375	447104.0
2015-07-31 17:00:00	AAPL	Stock	30.37	30.375	30.35	30.3525	60384.0
2015-07-31 17:30:00	AAPL	Stock	30.36	30.37	30.325	30.36	65516.0
2015-07-31 18:00:00	AAPL	Stock	30.36	30.37	30.3525	30.3575	17320.0
2015-07-31 18:30:00	AAPL	Stock	30.3575	30.375	30.3525	30.3625	45160.0
2015-07-31 19:00:00	AAPL	Stock	30.3525	30.3725	30.3525	30.3725	28212.0
2015-07-31 19:30:00	AAPL	Stock	30.3725	30.3725	30.35	30.3625	16236.0
2015-07-31 05:30:00	MSFT	Stock	46.9	46.9	46.9	46.9	200.0
2015-07-31 06:00:00	MSFT	Stock	46.95	46.95	46.95	46.95	100.0
2015-07-31 07:00:00	MSFT	Stock	46.9	46.9	46.89	46.89	300.0
2015-07-31 08:00:00	MSFT	Stock	46.95	46.95	46.86	46.86	7150.0
2015-07-31 08:30:00	MSFT	Stock	46.97	47.053	46.97	47.053	6925.0
2015-07-31 09:00:00	MSFT	Stock	47.1	47.39	47.1	47.39	23829.0
2015-07-31 09:30:00	MSFT	Stock	47.29	47.37	46.74	47.01	3542839.0
2015-07-31 10:00:00	MSFT	Stock	47.02	47.13	46.89	47.04	2587541.0
2015-07-31 10:30:00	MSFT	Stock	47.04	47.14	46.98	47.06	1386852.0
2015-07-31 11:00:00	MSFT	Stock	47.05	47.09	46.88	46.92	1899991.0
2015-07-31 11:30:00	MSFT	Stock	46.916	46.96	46.75	46.75	1092216.0
2015-07-31 12:00:00	MSFT	Stock	46.76	46.82	46.7	46.775	1673984.0
2015-07-31 12:30:00	MSFT	Stock	46.778	46.79	46.65	46.665	657658.0
2015-07-31 13:00:00	MSFT	Stock	46.665	46.72	46.57	46.6	1067768.0
2015-07-31 13:30:00	MSFT	Stock	46.6	46.6	46.5	46.56	1438727.0
2015-07-31 14:00:00	MSFT	Stock	46.56	46.67	46.51	46.61	1376460.0
2015-07-31 14:30:00	MSFT	Stock	46.6	46.65	46.53	46.56	1384409.0
2015-07-31 15:00:00	MSFT	Stock	46.57	46.64	46.56	46.6	1465125.0
2015-07-31 15:30:00	MSFT	Stock	46.61	46.82	46.605	46.7	6224887.0

> showing 50 of 81,079 rows — these rows as CSV

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