PREVIEW / stock_1min / 2016-09-21

all stock 1-min files

  file:    by_date/stock_1min/2016/2016-09-21.parquet
  size:    14.4 MB
  rows:    1,051,499
  symbols: 2,645

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-09-21 04:00:00	AAPL	Stock	28.505	28.505	28.505	28.505	3360.0
2016-09-21 04:18:00	AAPL	Stock	28.53	28.53	28.53	28.53	400.0
2016-09-21 04:20:00	AAPL	Stock	28.53	28.53	28.53	28.53	1640.0
2016-09-21 04:44:00	AAPL	Stock	28.53	28.53	28.53	28.53	960.0
2016-09-21 04:45:00	AAPL	Stock	28.53	28.53	28.53	28.53	436.0
2016-09-21 04:53:00	AAPL	Stock	28.55	28.55	28.55	28.55	400.0
2016-09-21 04:55:00	AAPL	Stock	28.55	28.5725	28.55	28.5725	1032.0
2016-09-21 05:18:00	AAPL	Stock	28.53	28.53	28.53	28.53	400.0
2016-09-21 05:37:00	AAPL	Stock	28.5525	28.5525	28.5525	28.5525	400.0
2016-09-21 05:55:00	AAPL	Stock	28.5625	28.6	28.5625	28.6	16516.0
2016-09-21 05:56:00	AAPL	Stock	28.6075	28.6075	28.6075	28.6075	4488.0
2016-09-21 05:59:00	AAPL	Stock	28.6125	28.65	28.6125	28.65	11764.0
2016-09-21 06:00:00	AAPL	Stock	28.665	28.735	28.3075	28.525	50932.0
2016-09-21 06:02:00	AAPL	Stock	28.6025	28.6025	28.6025	28.6025	400.0
2016-09-21 06:03:00	AAPL	Stock	28.605	28.605	28.605	28.605	400.0
2016-09-21 06:05:00	AAPL	Stock	28.575	28.575	28.575	28.575	2000.0
2016-09-21 06:06:00	AAPL	Stock	28.575	28.575	28.575	28.575	800.0
2016-09-21 06:31:00	AAPL	Stock	28.5675	28.5675	28.5675	28.5675	1956.0
2016-09-21 06:52:00	AAPL	Stock	28.565	28.565	28.565	28.565	1200.0
2016-09-21 07:01:00	AAPL	Stock	28.555	28.5625	28.555	28.5625	3200.0
2016-09-21 07:03:00	AAPL	Stock	28.56	28.56	28.56	28.56	1600.0
2016-09-21 07:06:00	AAPL	Stock	28.56	28.56	28.56	28.56	4000.0
2016-09-21 07:16:00	AAPL	Stock	28.56	28.56	28.56	28.56	800.0
2016-09-21 07:17:00	AAPL	Stock	28.5375	28.5375	28.5375	28.5375	2300.0
2016-09-21 07:18:00	AAPL	Stock	28.53	28.53	28.53	28.53	1700.0
2016-09-21 07:20:00	AAPL	Stock	28.5375	28.5375	28.5375	28.5375	800.0
2016-09-21 07:23:00	AAPL	Stock	28.5475	28.5475	28.5475	28.5475	800.0
2016-09-21 07:24:00	AAPL	Stock	28.5475	28.5475	28.5475	28.5475	5200.0
2016-09-21 07:29:00	AAPL	Stock	28.56	28.56	28.5575	28.5575	4400.0
2016-09-21 07:32:00	AAPL	Stock	28.5475	28.5475	28.5475	28.5475	800.0
2016-09-21 07:33:00	AAPL	Stock	28.5575	28.5625	28.5575	28.5625	3600.0
2016-09-21 07:34:00	AAPL	Stock	28.5725	28.605	28.5725	28.5875	5552.0
2016-09-21 07:35:00	AAPL	Stock	28.6175	28.63	28.6175	28.63	9400.0
2016-09-21 07:37:00	AAPL	Stock	28.6	28.6	28.6	28.6	1800.0
2016-09-21 07:38:00	AAPL	Stock	28.575	28.575	28.575	28.575	2400.0
2016-09-21 07:39:00	AAPL	Stock	28.575	28.575	28.575	28.575	400.0
2016-09-21 07:41:00	AAPL	Stock	28.575	28.575	28.5625	28.5625	4200.0
2016-09-21 07:42:00	AAPL	Stock	28.5525	28.5525	28.5525	28.5525	2000.0
2016-09-21 07:45:00	AAPL	Stock	28.5525	28.5525	28.5525	28.5525	5600.0
2016-09-21 07:48:00	AAPL	Stock	28.5525	28.5525	28.5525	28.5525	400.0
2016-09-21 07:49:00	AAPL	Stock	28.55	28.55	28.55	28.55	3280.0
2016-09-21 07:50:00	AAPL	Stock	28.55	28.55	28.535	28.535	5000.0
2016-09-21 07:52:00	AAPL	Stock	28.575	28.575	28.575	28.575	1200.0
2016-09-21 07:53:00	AAPL	Stock	28.575	28.575	28.55	28.55	8000.0
2016-09-21 07:56:00	AAPL	Stock	28.55	28.55	28.55	28.55	800.0
2016-09-21 08:00:00	AAPL	Stock	28.545	28.5625	28.525	28.525	69988.0
2016-09-21 08:01:00	AAPL	Stock	28.5175	28.525	28.5175	28.525	2400.0
2016-09-21 08:02:00	AAPL	Stock	28.5225	28.5225	28.5	28.5	20400.0
2016-09-21 08:03:00	AAPL	Stock	28.505	28.505	28.505	28.505	600.0
2016-09-21 08:04:00	AAPL	Stock	28.505	28.505	28.505	28.505	800.0

> showing 50 of 1,051,499 rows — these rows as CSV

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