PREVIEW / stock_1min / 2015-07-31

all stock 1-min files

  file:    by_date/stock_1min/2015/2015-07-31.parquet
  size:    14.7 MB
  rows:    1,071,902
  symbols: 2,844

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:48:00	AAPL	Stock	30.655	30.655	30.655	30.655	800.0
2015-07-31 05:08:00	AAPL	Stock	30.6625	30.6625	30.6625	30.6625	800.0
2015-07-31 05:48:00	AAPL	Stock	30.6625	30.67	30.6575	30.67	11800.0
2015-07-31 06:33:00	AAPL	Stock	30.6475	30.6475	30.6475	30.6475	4000.0
2015-07-31 06:49:00	AAPL	Stock	30.615	30.615	30.615	30.615	800.0
2015-07-31 06:51:00	AAPL	Stock	30.615	30.615	30.615	30.615	800.0
2015-07-31 06:52:00	AAPL	Stock	30.615	30.615	30.615	30.615	400.0
2015-07-31 06:57:00	AAPL	Stock	30.5975	30.5975	30.5975	30.5975	2800.0
2015-07-31 07:00:00	AAPL	Stock	30.5975	30.5975	30.5975	30.5975	400.0
2015-07-31 07:02:00	AAPL	Stock	30.5825	30.5825	30.5825	30.5825	400.0
2015-07-31 07:06:00	AAPL	Stock	30.55	30.5625	30.55	30.5625	1092.0
2015-07-31 07:07:00	AAPL	Stock	30.5625	30.5625	30.5625	30.5625	3648.0
2015-07-31 07:11:00	AAPL	Stock	30.525	30.525	30.51	30.51	39640.0
2015-07-31 07:14:00	AAPL	Stock	30.525	30.525	30.525	30.525	800.0
2015-07-31 07:16:00	AAPL	Stock	30.5375	30.5375	30.5375	30.5375	400.0
2015-07-31 07:18:00	AAPL	Stock	30.5375	30.5375	30.5375	30.5375	5200.0
2015-07-31 07:22:00	AAPL	Stock	30.5275	30.5275	30.5275	30.5275	3980.0
2015-07-31 07:23:00	AAPL	Stock	30.5275	30.535	30.5275	30.535	4780.0
2015-07-31 07:24:00	AAPL	Stock	30.535	30.535	30.535	30.535	800.0
2015-07-31 07:25:00	AAPL	Stock	30.535	30.535	30.535	30.535	400.0
2015-07-31 07:27:00	AAPL	Stock	30.5275	30.5275	30.5275	30.5275	1600.0
2015-07-31 07:31:00	AAPL	Stock	30.535	30.55	30.535	30.55	8928.0
2015-07-31 07:33:00	AAPL	Stock	30.55	30.55	30.55	30.55	4000.0
2015-07-31 07:37:00	AAPL	Stock	30.5375	30.5375	30.5375	30.5375	800.0
2015-07-31 07:38:00	AAPL	Stock	30.5325	30.5375	30.5275	30.5375	7200.0
2015-07-31 07:40:00	AAPL	Stock	30.5275	30.5275	30.5275	30.5275	400.0
2015-07-31 07:41:00	AAPL	Stock	30.5375	30.5375	30.5375	30.5375	3116.0
2015-07-31 07:42:00	AAPL	Stock	30.55	30.55	30.55	30.55	400.0
2015-07-31 07:45:00	AAPL	Stock	30.5375	30.5375	30.5375	30.5375	4000.0
2015-07-31 07:46:00	AAPL	Stock	30.5375	30.55	30.5375	30.545	15200.0
2015-07-31 07:48:00	AAPL	Stock	30.55	30.5725	30.55	30.5725	4000.0
2015-07-31 08:00:00	AAPL	Stock	30.5375	30.55	30.53	30.55	17508.0
2015-07-31 08:01:00	AAPL	Stock	30.5375	30.5375	30.5375	30.5375	9480.0
2015-07-31 08:02:00	AAPL	Stock	30.5375	30.5475	30.5375	30.5375	9200.0
2015-07-31 08:03:00	AAPL	Stock	30.5375	30.5375	30.5375	30.5375	4000.0
2015-07-31 08:04:00	AAPL	Stock	30.5375	30.5375	30.5375	30.5375	1840.0
2015-07-31 08:05:00	AAPL	Stock	30.5475	30.5475	30.5375	30.5375	4400.0
2015-07-31 08:06:00	AAPL	Stock	30.55	30.55	30.5375	30.5375	6280.0
2015-07-31 08:07:00	AAPL	Stock	30.5475	30.5475	30.5375	30.5375	5712.0
2015-07-31 08:08:00	AAPL	Stock	30.5375	30.5375	30.5375	30.5375	10000.0
2015-07-31 08:09:00	AAPL	Stock	30.5475	30.5475	30.5375	30.5375	3200.0
2015-07-31 08:10:00	AAPL	Stock	30.5475	30.5475	30.5375	30.5375	800.0
2015-07-31 08:11:00	AAPL	Stock	30.5475	30.55	30.5475	30.55	1600.0
2015-07-31 08:14:00	AAPL	Stock	30.55	30.55	30.5375	30.5375	20400.0
2015-07-31 08:16:00	AAPL	Stock	30.5375	30.5375	30.5375	30.5375	3460.0
2015-07-31 08:17:00	AAPL	Stock	30.5425	30.5425	30.5382	30.5382	5200.0
2015-07-31 08:20:00	AAPL	Stock	30.5375	30.5375	30.5375	30.5375	43656.0
2015-07-31 08:21:00	AAPL	Stock	30.5275	30.5275	30.5275	30.5275	1200.0
2015-07-31 08:22:00	AAPL	Stock	30.525	30.525	30.525	30.525	400.0

> showing 50 of 1,071,902 rows — these rows as CSV

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