PREVIEW / stock_1min / 2017-11-27

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-11-27.parquet
  size:    14.7 MB
  rows:    1,057,818
  symbols: 2,444

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-11-27 04:00:00	AAPL	Stock	43.715	43.715	43.715	43.715	400.0
2017-11-27 04:21:00	AAPL	Stock	43.75	43.75	43.75	43.75	400.0
2017-11-27 04:30:00	AAPL	Stock	43.725	43.725	43.725	43.725	400.0
2017-11-27 04:31:00	AAPL	Stock	43.7175	43.7175	43.7175	43.7175	600.0
2017-11-27 04:32:00	AAPL	Stock	43.725	43.725	43.725	43.725	400.0
2017-11-27 05:11:00	AAPL	Stock	43.725	43.725	43.725	43.725	668.0
2017-11-27 05:19:00	AAPL	Stock	43.77	43.77	43.77	43.77	484.0
2017-11-27 05:52:00	AAPL	Stock	43.7975	43.8	43.7975	43.8	1276.0
2017-11-27 06:07:00	AAPL	Stock	43.81	43.81	43.81	43.81	400.0
2017-11-27 06:09:00	AAPL	Stock	43.845	43.845	43.845	43.845	800.0
2017-11-27 06:32:00	AAPL	Stock	43.81	43.81	43.81	43.81	400.0
2017-11-27 06:37:00	AAPL	Stock	43.81	43.81	43.81	43.81	1040.0
2017-11-27 06:40:00	AAPL	Stock	43.81	43.81	43.81	43.81	400.0
2017-11-27 06:43:00	AAPL	Stock	43.8	43.8	43.8	43.8	2000.0
2017-11-27 06:45:00	AAPL	Stock	43.7925	43.7925	43.7925	43.7925	800.0
2017-11-27 06:55:00	AAPL	Stock	43.795	43.795	43.795	43.795	400.0
2017-11-27 06:56:00	AAPL	Stock	43.775	43.775	43.7525	43.7525	5056.0
2017-11-27 06:57:00	AAPL	Stock	43.77	43.77	43.77	43.77	800.0
2017-11-27 06:58:00	AAPL	Stock	43.7525	43.7525	43.75	43.75	1628.0
2017-11-27 06:59:00	AAPL	Stock	43.775	43.775	43.775	43.775	2000.0
2017-11-27 07:00:00	AAPL	Stock	43.755	43.77	43.75	43.77	5832.0
2017-11-27 07:02:00	AAPL	Stock	43.77	43.77	43.77	43.77	400.0
2017-11-27 07:03:00	AAPL	Stock	43.775	43.775	43.775	43.775	1648.0
2017-11-27 07:04:00	AAPL	Stock	43.78	43.78	43.78	43.78	400.0
2017-11-27 07:05:00	AAPL	Stock	43.7875	43.7875	43.7875	43.7875	2264.0
2017-11-27 07:07:00	AAPL	Stock	43.7825	43.785	43.7825	43.785	2000.0
2017-11-27 07:08:00	AAPL	Stock	43.765	43.765	43.7625	43.7625	10200.0
2017-11-27 07:10:00	AAPL	Stock	43.7525	43.7525	43.75	43.75	3200.0
2017-11-27 07:11:00	AAPL	Stock	43.75	43.75	43.75	43.75	1200.0
2017-11-27 07:20:00	AAPL	Stock	43.7375	43.7375	43.7325	43.7325	5860.0
2017-11-27 07:25:00	AAPL	Stock	43.7325	43.7325	43.7325	43.7325	800.0
2017-11-27 07:26:00	AAPL	Stock	43.7325	43.7325	43.7325	43.7325	400.0
2017-11-27 07:27:00	AAPL	Stock	43.7375	43.7375	43.7375	43.7375	3600.0
2017-11-27 07:29:00	AAPL	Stock	43.7325	43.7325	43.73	43.73	7888.0
2017-11-27 07:30:00	AAPL	Stock	43.73	43.73	43.7175	43.7175	5732.0
2017-11-27 07:31:00	AAPL	Stock	43.725	43.725	43.725	43.725	4468.0
2017-11-27 07:32:00	AAPL	Stock	43.725	43.725	43.725	43.725	1200.0
2017-11-27 07:34:00	AAPL	Stock	43.715	43.715	43.715	43.715	400.0
2017-11-27 07:35:00	AAPL	Stock	43.705	43.705	43.7	43.7	2000.0
2017-11-27 07:36:00	AAPL	Stock	43.6925	43.6925	43.6725	43.6725	7744.0
2017-11-27 07:37:00	AAPL	Stock	43.6525	43.6525	43.6525	43.6525	1512.0
2017-11-27 07:38:00	AAPL	Stock	43.65	43.6625	43.64	43.64	8188.0
2017-11-27 07:39:00	AAPL	Stock	43.63	43.635	43.625	43.6325	17820.0
2017-11-27 07:40:00	AAPL	Stock	43.625	43.625	43.625	43.625	620.0
2017-11-27 07:41:00	AAPL	Stock	43.625	43.625	43.625	43.625	1600.0
2017-11-27 07:43:00	AAPL	Stock	43.625	43.6375	43.615	43.625	3732.0
2017-11-27 07:44:00	AAPL	Stock	43.6125	43.6125	43.61	43.6125	2924.0
2017-11-27 07:48:00	AAPL	Stock	43.6125	43.625	43.6125	43.625	4644.0
2017-11-27 07:50:00	AAPL	Stock	43.6375	43.6375	43.6375	43.6375	2000.0
2017-11-27 07:56:00	AAPL	Stock	43.6475	43.6475	43.6475	43.6475	400.0

> showing 50 of 1,057,818 rows — these rows as CSV

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