PREVIEW / stock_1min / 2017-11-02

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-11-02.parquet
  size:    15.1 MB
  rows:    1,082,233
  symbols: 2,445

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-02 04:01:00	AAPL	Stock	41.7	41.7	41.7	41.7	400.0
2017-11-02 04:11:00	AAPL	Stock	41.72	41.72	41.72	41.72	400.0
2017-11-02 04:31:00	AAPL	Stock	41.7375	41.7375	41.7375	41.7375	400.0
2017-11-02 04:39:00	AAPL	Stock	41.7375	41.7375	41.7375	41.7375	928.0
2017-11-02 04:46:00	AAPL	Stock	41.7375	41.7375	41.7375	41.7375	800.0
2017-11-02 04:49:00	AAPL	Stock	41.745	41.745	41.745	41.745	1600.0
2017-11-02 04:55:00	AAPL	Stock	41.75	41.75	41.7375	41.7375	3616.0
2017-11-02 04:57:00	AAPL	Stock	41.7375	41.7375	41.7375	41.7375	2400.0
2017-11-02 05:30:00	AAPL	Stock	41.7275	41.7275	41.7275	41.7275	400.0
2017-11-02 05:36:00	AAPL	Stock	41.6975	41.6975	41.6975	41.6975	400.0
2017-11-02 06:11:00	AAPL	Stock	41.7275	41.7275	41.7275	41.7275	400.0
2017-11-02 06:12:00	AAPL	Stock	41.73	41.7375	41.73	41.7375	800.0
2017-11-02 06:25:00	AAPL	Stock	41.7425	41.7425	41.7425	41.7425	400.0
2017-11-02 06:26:00	AAPL	Stock	41.7425	41.7425	41.7425	41.7425	408.0
2017-11-02 06:27:00	AAPL	Stock	41.745	41.745	41.745	41.745	800.0
2017-11-02 06:28:00	AAPL	Stock	41.7375	41.7375	41.7375	41.7375	420.0
2017-11-02 06:29:00	AAPL	Stock	41.7375	41.7375	41.7375	41.7375	400.0
2017-11-02 06:30:00	AAPL	Stock	41.745	41.745	41.745	41.745	1860.0
2017-11-02 06:31:00	AAPL	Stock	41.745	41.745	41.745	41.745	1128.0
2017-11-02 06:38:00	AAPL	Stock	41.78	41.78	41.78	41.78	1064.0
2017-11-02 06:39:00	AAPL	Stock	41.77	41.77	41.7375	41.7375	800.0
2017-11-02 06:40:00	AAPL	Stock	41.7425	41.7425	41.7425	41.7425	400.0
2017-11-02 06:43:00	AAPL	Stock	41.765	41.7875	41.765	41.775	4632.0
2017-11-02 06:47:00	AAPL	Stock	41.7875	41.7875	41.7875	41.7875	1424.0
2017-11-02 06:48:00	AAPL	Stock	41.7875	41.7875	41.7875	41.7875	3920.0
2017-11-02 06:49:00	AAPL	Stock	41.7875	41.7875	41.7875	41.7875	400.0
2017-11-02 06:53:00	AAPL	Stock	41.7625	41.7625	41.75	41.75	5580.0
2017-11-02 06:54:00	AAPL	Stock	41.7525	41.7525	41.6975	41.6975	6196.0
2017-11-02 06:56:00	AAPL	Stock	41.775	41.775	41.775	41.775	640.0
2017-11-02 06:59:00	AAPL	Stock	41.705	41.705	41.6975	41.705	5032.0
2017-11-02 07:00:00	AAPL	Stock	41.7625	41.775	41.6925	41.725	14328.0
2017-11-02 07:01:00	AAPL	Stock	41.75	41.75	41.75	41.75	480.0
2017-11-02 07:03:00	AAPL	Stock	41.75	41.75	41.75	41.75	2000.0
2017-11-02 07:05:00	AAPL	Stock	41.775	41.775	41.775	41.775	3600.0
2017-11-02 07:09:00	AAPL	Stock	41.7625	41.7625	41.7625	41.7625	552.0
2017-11-02 07:11:00	AAPL	Stock	41.7625	41.7625	41.7625	41.7625	452.0
2017-11-02 07:12:00	AAPL	Stock	41.775	41.7825	41.775	41.7825	3284.0
2017-11-02 07:13:00	AAPL	Stock	41.7775	41.7775	41.775	41.775	6000.0
2017-11-02 07:14:00	AAPL	Stock	41.7825	41.7825	41.775	41.775	2560.0
2017-11-02 07:16:00	AAPL	Stock	41.775	41.8125	41.775	41.8125	19832.0
2017-11-02 07:17:00	AAPL	Stock	41.825	41.825	41.825	41.825	4252.0
2017-11-02 07:18:00	AAPL	Stock	41.825	41.825	41.825	41.825	2600.0
2017-11-02 07:19:00	AAPL	Stock	41.845	41.845	41.845	41.845	1908.0
2017-11-02 07:20:00	AAPL	Stock	41.8425	41.8425	41.8375	41.8375	1240.0
2017-11-02 07:21:00	AAPL	Stock	41.8275	41.8375	41.825	41.8375	1916.0
2017-11-02 07:22:00	AAPL	Stock	41.8275	41.8375	41.825	41.8375	3600.0
2017-11-02 07:23:00	AAPL	Stock	41.815	41.815	41.815	41.815	1400.0
2017-11-02 07:25:00	AAPL	Stock	41.8175	41.8175	41.8175	41.8175	400.0
2017-11-02 07:26:00	AAPL	Stock	41.8225	41.8225	41.8225	41.8225	2000.0
2017-11-02 07:27:00	AAPL	Stock	41.8175	41.8175	41.8125	41.8125	1600.0

> showing 50 of 1,082,233 rows — these rows as CSV

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