PREVIEW / etf_1hour / 2017-09-14

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-14.parquet
  size:    276 KB
  rows:    9,120

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-09-14 04:00:00	SPY	ETF	249.98	250.08	249.95	250.08	11720.0
2017-09-14 05:00:00	SPY	ETF	250.05	250.08	250.02	250.08	6840.0
2017-09-14 06:00:00	SPY	ETF	250.09	250.12	250.01	250.03	3181.0
2017-09-14 07:00:00	SPY	ETF	250.04	250.1	249.98	250.05	185237.0
2017-09-14 08:00:00	SPY	ETF	250.02	250.09	249.45	249.6	1536467.0
2017-09-14 09:00:00	SPY	ETF	249.6	249.98	249.55	249.95	8500533.0
2017-09-14 10:00:00	SPY	ETF	249.95	250.15	249.82	250.07	5942006.0
2017-09-14 11:00:00	SPY	ETF	250.06	250.32	250.02	250.12	4989807.0
2017-09-14 12:00:00	SPY	ETF	250.125	250.24	249.98	250.19	8473062.0
2017-09-14 13:00:00	SPY	ETF	250.19	250.19	250.01	250.02	3423445.0
2017-09-14 14:00:00	SPY	ETF	250.025	250.2	249.96	250.11	8161268.0
2017-09-14 15:00:00	SPY	ETF	250.105	250.15	249.94	250.1	26003855.0
2017-09-14 16:00:00	SPY	ETF	250.1	250.2963	250.02	250.07	26138118.0
2017-09-14 17:00:00	SPY	ETF	250.04	250.08	249.96	250.02	150395.0
2017-09-14 18:00:00	SPY	ETF	250.02	250.04	249.42	249.45	837357.0
2017-09-14 19:00:00	SPY	ETF	249.47	249.58	249.42	249.47	109916.0
2017-09-14 04:00:00	QQQ	ETF	146.25	146.31	146.23	146.31	13232.0
2017-09-14 05:00:00	QQQ	ETF	146.27	146.3	146.25	146.3	1600.0
2017-09-14 06:00:00	QQQ	ETF	146.29	146.29	146.22	146.22	4100.0
2017-09-14 07:00:00	QQQ	ETF	146.25	146.27	146.2	146.23	17030.0
2017-09-14 08:00:00	QQQ	ETF	146.23	146.23	145.66	145.79	357782.0
2017-09-14 09:00:00	QQQ	ETF	145.78	145.97	145.48	145.87	4463802.0
2017-09-14 10:00:00	QQQ	ETF	145.88	146.1	145.719	146.06	2834263.0
2017-09-14 11:00:00	QQQ	ETF	146.07	146.2869	145.9799	146.0301	2138269.0
2017-09-14 12:00:00	QQQ	ETF	146.04	146.06	145.69	145.93	1915725.0
2017-09-14 13:00:00	QQQ	ETF	145.93	145.95	145.71	145.7275	1505335.0
2017-09-14 14:00:00	QQQ	ETF	145.73	145.86	145.68	145.8	1743017.0
2017-09-14 15:00:00	QQQ	ETF	145.8	145.86	145.47	145.56	6167603.0
2017-09-14 16:00:00	QQQ	ETF	145.57	145.62	145.45	145.51	4444397.0
2017-09-14 17:00:00	QQQ	ETF	145.56	145.56	145.46	145.56	26768.0
2017-09-14 18:00:00	QQQ	ETF	145.53	145.5782	145.06	145.09	1731826.0
2017-09-14 19:00:00	QQQ	ETF	145.09	145.18	145.08	145.09	55893.0
2017-09-14 04:00:00	IWM	ETF	141.85	141.92	141.85	141.91	4822.0
2017-09-14 05:00:00	IWM	ETF	141.93	141.93	141.93	141.93	503.0
2017-09-14 06:00:00	IWM	ETF	141.98	141.98	141.92	141.92	1742.0
2017-09-14 07:00:00	IWM	ETF	141.92	142.0	141.89	141.89	17162.0
2017-09-14 08:00:00	IWM	ETF	141.95	141.98	141.57	141.65	130748.0
2017-09-14 09:00:00	IWM	ETF	141.65	141.9	141.42	141.9	2960658.0
2017-09-14 10:00:00	IWM	ETF	141.9	142.05	141.8	141.96	1972891.0
2017-09-14 11:00:00	IWM	ETF	141.97	142.16	141.85	141.9301	848550.0
2017-09-14 12:00:00	IWM	ETF	141.93	142.04	141.83	141.845	670396.0
2017-09-14 13:00:00	IWM	ETF	141.84	141.85	141.65	141.715	977976.0
2017-09-14 14:00:00	IWM	ETF	141.72	141.79	141.69	141.75	847532.0
2017-09-14 15:00:00	IWM	ETF	141.755	141.84	141.55	141.84	2976306.0
2017-09-14 16:00:00	IWM	ETF	141.84	142.01	141.7484	141.83	3030484.0
2017-09-14 17:00:00	IWM	ETF	141.85	141.93	141.84	141.85	3711.0
2017-09-14 18:00:00	IWM	ETF	141.85	141.94	141.37	141.42	27032.0
2017-09-14 19:00:00	IWM	ETF	141.44	141.7678	141.37	141.37	506871.0
2017-09-14 08:00:00	DIA	ETF	221.5	221.5	221.41	221.41	2950.0
2017-09-14 09:00:00	DIA	ETF	221.55	222.09	221.55	222.0	236478.0

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

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