PREVIEW / stock_1min / 2017-08-02

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-08-02.parquet
  size:    14.5 MB
  rows:    1,053,990
  symbols: 2,475

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-08-02 04:00:00	AAPL	Stock	39.805	39.825	39.7975	39.8	15112.0
2017-08-02 04:01:00	AAPL	Stock	39.77	39.77	39.7625	39.7625	9720.0
2017-08-02 04:02:00	AAPL	Stock	39.775	39.8	39.775	39.8	12024.0
2017-08-02 04:03:00	AAPL	Stock	39.775	39.775	39.775	39.775	3148.0
2017-08-02 04:06:00	AAPL	Stock	39.775	39.775	39.775	39.775	632.0
2017-08-02 04:07:00	AAPL	Stock	39.795	39.8	39.7775	39.8	4872.0
2017-08-02 04:08:00	AAPL	Stock	39.785	39.7875	39.785	39.7875	1004.0
2017-08-02 04:09:00	AAPL	Stock	39.8	39.8	39.78	39.8	12156.0
2017-08-02 04:10:00	AAPL	Stock	39.8	39.8	39.8	39.8	400.0
2017-08-02 04:11:00	AAPL	Stock	39.8125	39.82	39.8125	39.82	9616.0
2017-08-02 04:12:00	AAPL	Stock	39.8225	39.825	39.8225	39.825	15484.0
2017-08-02 04:13:00	AAPL	Stock	39.8375	39.8525	39.8275	39.8525	32096.0
2017-08-02 04:14:00	AAPL	Stock	39.8625	39.875	39.8625	39.875	19328.0
2017-08-02 04:15:00	AAPL	Stock	39.865	39.865	39.865	39.865	400.0
2017-08-02 04:17:00	AAPL	Stock	39.8725	39.8825	39.8725	39.8825	9764.0
2017-08-02 04:18:00	AAPL	Stock	39.875	39.875	39.875	39.875	800.0
2017-08-02 04:20:00	AAPL	Stock	39.875	39.875	39.875	39.875	8556.0
2017-08-02 04:23:00	AAPL	Stock	39.8875	39.8875	39.8875	39.8875	800.0
2017-08-02 04:24:00	AAPL	Stock	39.8775	39.8775	39.8775	39.8775	400.0
2017-08-02 04:25:00	AAPL	Stock	39.8875	39.8875	39.8775	39.8875	6888.0
2017-08-02 04:26:00	AAPL	Stock	39.855	39.855	39.855	39.855	400.0
2017-08-02 04:27:00	AAPL	Stock	39.8575	39.8575	39.8575	39.8575	400.0
2017-08-02 04:31:00	AAPL	Stock	39.835	39.835	39.835	39.835	400.0
2017-08-02 04:35:00	AAPL	Stock	39.835	39.835	39.835	39.835	580.0
2017-08-02 04:37:00	AAPL	Stock	39.8	39.8	39.8	39.8	400.0
2017-08-02 04:40:00	AAPL	Stock	39.7975	39.7975	39.7925	39.7925	800.0
2017-08-02 04:41:00	AAPL	Stock	39.7925	39.7925	39.775	39.7925	17868.0
2017-08-02 04:42:00	AAPL	Stock	39.8	39.875	39.8	39.875	16148.0
2017-08-02 04:43:00	AAPL	Stock	39.875	39.875	39.875	39.875	6952.0
2017-08-02 04:44:00	AAPL	Stock	39.8025	39.8875	39.8025	39.8875	13776.0
2017-08-02 04:45:00	AAPL	Stock	39.895	39.9375	39.8625	39.8625	41636.0
2017-08-02 04:46:00	AAPL	Stock	39.8225	39.8225	39.8225	39.8225	7804.0
2017-08-02 04:55:00	AAPL	Stock	39.8275	39.8275	39.8275	39.8275	600.0
2017-08-02 05:01:00	AAPL	Stock	39.8275	39.8275	39.825	39.825	10364.0
2017-08-02 05:03:00	AAPL	Stock	39.8	39.8	39.8	39.8	400.0
2017-08-02 05:05:00	AAPL	Stock	39.8375	39.8375	39.825	39.825	1880.0
2017-08-02 05:07:00	AAPL	Stock	39.825	39.825	39.8025	39.8025	2464.0
2017-08-02 05:08:00	AAPL	Stock	39.8175	39.8175	39.8175	39.8175	5944.0
2017-08-02 05:09:00	AAPL	Stock	39.8125	39.8375	39.8125	39.8375	9648.0
2017-08-02 05:10:00	AAPL	Stock	39.825	39.825	39.825	39.825	1200.0
2017-08-02 05:11:00	AAPL	Stock	39.8175	39.8175	39.8175	39.8175	400.0
2017-08-02 05:15:00	AAPL	Stock	39.8175	39.8175	39.8175	39.8175	400.0
2017-08-02 05:16:00	AAPL	Stock	39.8375	39.8375	39.8375	39.8375	400.0
2017-08-02 05:17:00	AAPL	Stock	39.8375	39.8375	39.8375	39.8375	1700.0
2017-08-02 05:19:00	AAPL	Stock	39.825	39.825	39.8175	39.8175	2400.0
2017-08-02 05:20:00	AAPL	Stock	39.8125	39.8175	39.8125	39.8175	1616.0
2017-08-02 05:22:00	AAPL	Stock	39.8175	39.8175	39.8175	39.8175	400.0
2017-08-02 05:23:00	AAPL	Stock	39.8125	39.85	39.8125	39.85	13588.0
2017-08-02 05:24:00	AAPL	Stock	39.8325	39.8325	39.8325	39.8325	400.0
2017-08-02 05:27:00	AAPL	Stock	39.87	39.875	39.87	39.875	5004.0

> showing 50 of 1,053,990 rows — these rows as CSV

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