PREVIEW / etf_1hour / 2017-06-02

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-02.parquet
  size:    278 KB
  rows:    9,104

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-06-02 04:00:00	SPY	ETF	243.56	243.75	243.56	243.73	41560.0
2017-06-02 05:00:00	SPY	ETF	243.73	243.8	243.7	243.8	2338.0
2017-06-02 06:00:00	SPY	ETF	243.85	244.08	243.79	244.07	22296.0
2017-06-02 07:00:00	SPY	ETF	244.07	244.07	243.84	243.88	149170.0
2017-06-02 08:00:00	SPY	ETF	243.87	243.98	243.23	243.53	1418121.0
2017-06-02 09:00:00	SPY	ETF	243.535	243.69	243.08	243.25	9078457.0
2017-06-02 10:00:00	SPY	ETF	243.25	243.76	243.2	243.67	8051882.0
2017-06-02 11:00:00	SPY	ETF	243.675	244.06	243.6	244.03	5077733.0
2017-06-02 12:00:00	SPY	ETF	244.03	244.09	243.87	244.0	4600301.0
2017-06-02 13:00:00	SPY	ETF	244.005	244.29	243.92	244.21	4949791.0
2017-06-02 14:00:00	SPY	ETF	244.205	244.255	243.96	244.1	4556651.0
2017-06-02 15:00:00	SPY	ETF	244.115	244.35	243.93	244.13	19871673.0
2017-06-02 16:00:00	SPY	ETF	244.13	244.2215	243.87	244.17	29560195.0
2017-06-02 17:00:00	SPY	ETF	244.15	244.27	244.13	244.22	173033.0
2017-06-02 18:00:00	SPY	ETF	244.21	244.21	244.17	244.19	6247.0
2017-06-02 19:00:00	SPY	ETF	244.19	244.26	244.1	244.25	68800.0
2017-06-02 04:00:00	QQQ	ETF	142.33	142.36	142.3	142.36	3800.0
2017-06-02 05:00:00	QQQ	ETF	142.4	142.42	142.4	142.42	900.0
2017-06-02 06:00:00	QQQ	ETF	142.42	142.5	142.42	142.49	6700.0
2017-06-02 07:00:00	QQQ	ETF	142.51	142.52	142.43	142.45	92700.0
2017-06-02 08:00:00	QQQ	ETF	142.48	142.5	142.16	142.33	193566.0
2017-06-02 09:00:00	QQQ	ETF	142.35	142.48	142.11	142.2693	3206045.0
2017-06-02 10:00:00	QQQ	ETF	142.26	142.71	142.22	142.6354	3155911.0
2017-06-02 11:00:00	QQQ	ETF	142.6499	143.03	142.62	142.99	2773810.0
2017-06-02 12:00:00	QQQ	ETF	142.98	143.07	142.93	143.055	2359146.0
2017-06-02 13:00:00	QQQ	ETF	143.05	143.31	143.02	143.265	4845370.0
2017-06-02 14:00:00	QQQ	ETF	143.265	143.35	143.19	143.27	4344630.0
2017-06-02 15:00:00	QQQ	ETF	143.2799	143.49	143.25	143.46	8242260.0
2017-06-02 16:00:00	QQQ	ETF	143.45	143.57	143.42	143.53	1407215.0
2017-06-02 17:00:00	QQQ	ETF	143.52	143.55	143.41	143.51	30650.0
2017-06-02 18:00:00	QQQ	ETF	143.46	143.56	143.46	143.56	3038.0
2017-06-02 19:00:00	QQQ	ETF	143.57	143.57	143.54	143.57	4340.0
2017-06-02 04:00:00	IWM	ETF	139.35	139.54	139.35	139.54	2172.0
2017-06-02 05:00:00	IWM	ETF	139.47	139.5	139.47	139.5	900.0
2017-06-02 06:00:00	IWM	ETF	139.62	139.87	139.62	139.87	1803.0
2017-06-02 07:00:00	IWM	ETF	139.88	139.88	139.69	139.72	71412.0
2017-06-02 08:00:00	IWM	ETF	139.71	139.82	139.01	139.36	479076.0
2017-06-02 09:00:00	IWM	ETF	139.36	140.12	139.05	139.28	6620192.0
2017-06-02 10:00:00	IWM	ETF	139.27	140.32	139.1	140.08	5748405.0
2017-06-02 11:00:00	IWM	ETF	140.0873	141.02	139.88	140.99	5659934.0
2017-06-02 12:00:00	IWM	ETF	140.99	140.99	140.45	140.52	3188353.0
2017-06-02 13:00:00	IWM	ETF	140.52	140.6	140.322	140.39	2561425.0
2017-06-02 14:00:00	IWM	ETF	140.39	140.51	140.04	140.21	2773790.0
2017-06-02 15:00:00	IWM	ETF	140.21	140.45	139.78	139.86	6392482.0
2017-06-02 16:00:00	IWM	ETF	139.85	140.2289	139.4119	140.07	1832106.0
2017-06-02 17:00:00	IWM	ETF	140.06	140.09	140.0	140.0	5150.0
2017-06-02 18:00:00	IWM	ETF	140.04	140.04	140.04	140.04	300.0
2017-06-02 19:00:00	IWM	ETF	140.07	140.1	139.8978	140.1	754140.0
2017-06-02 04:00:00	DIA	ETF	211.6	211.73	211.6	211.73	400.0
2017-06-02 05:00:00	DIA	ETF	211.81	211.9	211.81	211.9	300.0

> showing 50 of 9,104 rows — these rows as CSV

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