PREVIEW / etf_1hour / 2017-08-02

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-02.parquet
  size:    277 KB
  rows:    9,055

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	SPY	ETF	247.46	247.46	247.34	247.34	3190.0
2017-08-02 05:00:00	SPY	ETF	247.46	247.47	247.41	247.43	3701.0
2017-08-02 06:00:00	SPY	ETF	247.45	247.55	247.35	247.35	35973.0
2017-08-02 07:00:00	SPY	ETF	247.3	247.32	247.26	247.32	52639.0
2017-08-02 08:00:00	SPY	ETF	247.32	247.52	247.28	247.48	129431.0
2017-08-02 09:00:00	SPY	ETF	247.5	247.6	247.1276	247.18	4981222.0
2017-08-02 10:00:00	SPY	ETF	247.18	247.48	246.37	246.48	9443510.0
2017-08-02 11:00:00	SPY	ETF	246.48	247.0	246.39	246.805	5559317.0
2017-08-02 12:00:00	SPY	ETF	246.82	246.85	246.625	246.725	3030270.0
2017-08-02 13:00:00	SPY	ETF	246.73	247.21	246.6	247.17	4217907.0
2017-08-02 14:00:00	SPY	ETF	247.18	247.42	247.09	247.34	3509651.0
2017-08-02 15:00:00	SPY	ETF	247.34	247.5	247.14	247.44	8869291.0
2017-08-02 16:00:00	SPY	ETF	247.43	247.51	247.0881	247.4	6020713.0
2017-08-02 17:00:00	SPY	ETF	247.38	247.4882	247.31	247.32	320393.0
2017-08-02 18:00:00	SPY	ETF	247.31	247.36	247.3	247.32	30690.0
2017-08-02 19:00:00	SPY	ETF	247.32	247.35	247.23	247.27	26981.0
2017-08-02 04:00:00	QQQ	ETF	144.54	144.54	144.45	144.45	6800.0
2017-08-02 05:00:00	QQQ	ETF	144.49	144.55	144.49	144.55	650.0
2017-08-02 06:00:00	QQQ	ETF	144.52	144.66	144.48	144.48	8695.0
2017-08-02 07:00:00	QQQ	ETF	144.47	144.49	144.28	144.35	120990.0
2017-08-02 08:00:00	QQQ	ETF	144.34	144.52	144.3	144.47	209163.0
2017-08-02 09:00:00	QQQ	ETF	144.45	144.52	143.82	143.89	5386315.0
2017-08-02 10:00:00	QQQ	ETF	143.9017	144.15	142.72	142.85	9195016.0
2017-08-02 11:00:00	QQQ	ETF	142.86	143.33	142.61	143.18	5276819.0
2017-08-02 12:00:00	QQQ	ETF	143.19	143.32	143.03	143.15	2420435.0
2017-08-02 13:00:00	QQQ	ETF	143.15	143.9	142.93	143.825	3735720.0
2017-08-02 14:00:00	QQQ	ETF	143.83	144.1	143.71	144.05	3636874.0
2017-08-02 15:00:00	QQQ	ETF	144.05	144.21	143.74	143.95	5676940.0
2017-08-02 16:00:00	QQQ	ETF	143.96	144.07	143.2234	144.02	1677810.0
2017-08-02 17:00:00	QQQ	ETF	144.04	144.32	143.95	144.09	24807.0
2017-08-02 18:00:00	QQQ	ETF	143.99	144.04	143.97	144.02	11629.0
2017-08-02 19:00:00	QQQ	ETF	144.02	144.02	143.87	143.94	5976.0
2017-08-02 06:00:00	IWM	ETF	141.74	141.74	141.74	141.74	854.0
2017-08-02 07:00:00	IWM	ETF	141.68	141.68	141.55	141.57	5001.0
2017-08-02 08:00:00	IWM	ETF	141.59	141.69	141.57	141.62	17912.0
2017-08-02 09:00:00	IWM	ETF	141.69	141.82	141.17	141.19	1897423.0
2017-08-02 10:00:00	IWM	ETF	141.19	141.3	139.91	140.06	4185587.0
2017-08-02 11:00:00	IWM	ETF	140.06	140.4	139.725	140.09	3152614.0
2017-08-02 12:00:00	IWM	ETF	140.09	140.17	139.81	140.06	1412716.0
2017-08-02 13:00:00	IWM	ETF	140.06	140.39	139.97	140.35	1340424.0
2017-08-02 14:00:00	IWM	ETF	140.345	140.6	140.28	140.565	1171507.0
2017-08-02 15:00:00	IWM	ETF	140.57	140.57	140.16	140.26	3470082.0
2017-08-02 16:00:00	IWM	ETF	140.26	140.4071	140.11	140.32	934898.0
2017-08-02 17:00:00	IWM	ETF	140.3	140.3	140.26	140.3	2297.0
2017-08-02 18:00:00	IWM	ETF	140.23	140.33	140.23	140.33	608.0
2017-08-02 19:00:00	IWM	ETF	140.27	140.27	140.21	140.21	1142.0
2017-08-02 08:00:00	DIA	ETF	219.79	219.89	219.73	219.84	12622.0
2017-08-02 09:00:00	DIA	ETF	219.8	220.0873	219.68	219.78	376277.0
2017-08-02 10:00:00	DIA	ETF	219.79	220.13	219.44	219.49	616641.0
2017-08-02 11:00:00	DIA	ETF	219.49	219.9	219.49	219.76	363950.0

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

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