PREVIEW / stock_1min / 2017-07-21

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-07-21.parquet
  size:    13.7 MB
  rows:    996,229
  symbols: 2,477

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-07-21 04:35:00	AAPL	Stock	37.58	37.58	37.58	37.58	1292.0
2017-07-21 06:24:00	AAPL	Stock	37.6	37.6	37.6	37.6	400.0
2017-07-21 06:25:00	AAPL	Stock	37.5825	37.5825	37.58	37.58	4092.0
2017-07-21 06:26:00	AAPL	Stock	37.58	37.58	37.58	37.58	400.0
2017-07-21 06:29:00	AAPL	Stock	37.58	37.58	37.58	37.58	400.0
2017-07-21 06:38:00	AAPL	Stock	37.5625	37.5625	37.4625	37.4625	9324.0
2017-07-21 06:39:00	AAPL	Stock	37.525	37.525	37.525	37.525	400.0
2017-07-21 06:45:00	AAPL	Stock	37.525	37.525	37.525	37.525	800.0
2017-07-21 06:46:00	AAPL	Stock	37.525	37.525	37.525	37.525	800.0
2017-07-21 07:02:00	AAPL	Stock	37.55	37.55	37.55	37.55	400.0
2017-07-21 07:06:00	AAPL	Stock	37.525	37.525	37.525	37.525	400.0
2017-07-21 07:23:00	AAPL	Stock	37.5425	37.5425	37.5425	37.5425	488.0
2017-07-21 07:29:00	AAPL	Stock	37.5425	37.5425	37.5425	37.5425	400.0
2017-07-21 07:31:00	AAPL	Stock	37.5425	37.5425	37.5425	37.5425	400.0
2017-07-21 07:33:00	AAPL	Stock	37.54	37.54	37.5275	37.5275	1140.0
2017-07-21 07:42:00	AAPL	Stock	37.54	37.54	37.54	37.54	400.0
2017-07-21 07:44:00	AAPL	Stock	37.555	37.5575	37.555	37.5575	800.0
2017-07-21 07:55:00	AAPL	Stock	37.5425	37.5425	37.5375	37.5375	2800.0
2017-07-21 07:57:00	AAPL	Stock	37.5275	37.5275	37.5275	37.5275	400.0
2017-07-21 08:00:00	AAPL	Stock	37.55	37.55	37.5375	37.5375	8932.0
2017-07-21 08:02:00	AAPL	Stock	37.5375	37.5375	37.5375	37.5375	400.0
2017-07-21 08:05:00	AAPL	Stock	37.5275	37.5275	37.525	37.525	13756.0
2017-07-21 08:06:00	AAPL	Stock	37.525	37.525	37.525	37.525	400.0
2017-07-21 08:08:00	AAPL	Stock	37.5375	37.5375	37.5375	37.5375	400.0
2017-07-21 08:09:00	AAPL	Stock	37.5375	37.5375	37.525	37.525	800.0
2017-07-21 08:10:00	AAPL	Stock	37.5375	37.5375	37.5375	37.5375	2000.0
2017-07-21 08:12:00	AAPL	Stock	37.525	37.525	37.525	37.525	3552.0
2017-07-21 08:13:00	AAPL	Stock	37.53	37.53	37.525	37.525	1600.0
2017-07-21 08:14:00	AAPL	Stock	37.515	37.515	37.5125	37.5125	800.0
2017-07-21 08:15:00	AAPL	Stock	37.5375	37.5375	37.505	37.5125	3200.0
2017-07-21 08:16:00	AAPL	Stock	37.5375	37.5375	37.525	37.525	1952.0
2017-07-21 08:18:00	AAPL	Stock	37.545	37.545	37.545	37.545	1600.0
2017-07-21 08:20:00	AAPL	Stock	37.5175	37.5175	37.5175	37.5175	400.0
2017-07-21 08:23:00	AAPL	Stock	37.5275	37.5275	37.5275	37.5275	400.0
2017-07-21 08:25:00	AAPL	Stock	37.5325	37.5325	37.5325	37.5325	400.0
2017-07-21 08:26:00	AAPL	Stock	37.55	37.55	37.55	37.55	400.0
2017-07-21 08:29:00	AAPL	Stock	37.54	37.54	37.54	37.54	800.0
2017-07-21 08:31:00	AAPL	Stock	37.5425	37.5425	37.5425	37.5425	2000.0
2017-07-21 08:32:00	AAPL	Stock	37.5375	37.5375	37.5375	37.5375	400.0
2017-07-21 08:33:00	AAPL	Stock	37.55	37.55	37.5425	37.5425	800.0
2017-07-21 08:34:00	AAPL	Stock	37.56	37.56	37.56	37.56	4000.0
2017-07-21 08:36:00	AAPL	Stock	37.54	37.54	37.5375	37.5375	2412.0
2017-07-21 08:39:00	AAPL	Stock	37.5375	37.5425	37.5375	37.5425	4160.0
2017-07-21 08:40:00	AAPL	Stock	37.5425	37.5425	37.535	37.54	4640.0
2017-07-21 08:47:00	AAPL	Stock	37.5425	37.5425	37.5275	37.5275	14768.0
2017-07-21 08:49:00	AAPL	Stock	37.5275	37.5275	37.525	37.525	2000.0
2017-07-21 08:51:00	AAPL	Stock	37.525	37.525	37.525	37.525	2400.0
2017-07-21 08:58:00	AAPL	Stock	37.53	37.5425	37.53	37.5425	3600.0
2017-07-21 09:03:00	AAPL	Stock	37.52	37.535	37.52	37.535	3740.0
2017-07-21 09:05:00	AAPL	Stock	37.535	37.535	37.5125	37.5125	920.0

> showing 50 of 996,229 rows — these rows as CSV

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