PREVIEW / etf_1hour / 2017-09-20

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-20.parquet
  size:    279 KB
  rows:    9,159

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-20 04:00:00	SPY	ETF	249.97	250.05	249.85	250.05	12341.0
2017-09-20 05:00:00	SPY	ETF	250.0	250.02	250.0	250.02	7100.0
2017-09-20 06:00:00	SPY	ETF	250.0	250.03	249.97	250.01	20700.0
2017-09-20 07:00:00	SPY	ETF	250.02	250.08	249.97	249.97	80227.0
2017-09-20 08:00:00	SPY	ETF	249.96	250.05	249.95	250.04	70522.0
2017-09-20 09:00:00	SPY	ETF	250.03	250.19	249.93	250.02	3652940.0
2017-09-20 10:00:00	SPY	ETF	250.02	250.03	249.75	249.79	4928105.0
2017-09-20 11:00:00	SPY	ETF	249.79	250.06	249.72	250.025	4899314.0
2017-09-20 12:00:00	SPY	ETF	250.03	250.16	249.98	250.075	3443857.0
2017-09-20 13:00:00	SPY	ETF	250.08	250.09	249.775	249.89	3323934.0
2017-09-20 14:00:00	SPY	ETF	249.89	249.89	248.92	249.62	16094551.0
2017-09-20 15:00:00	SPY	ETF	249.62	250.15	249.43	250.09	13764454.0
2017-09-20 16:00:00	SPY	ETF	250.09	250.1	249.97	249.98	8002717.0
2017-09-20 17:00:00	SPY	ETF	250.0	250.06	249.94	250.0	505448.0
2017-09-20 18:00:00	SPY	ETF	249.98	250.01	249.93	250.01	83219.0
2017-09-20 19:00:00	SPY	ETF	249.97	250.08	249.97	250.06	28881.0
2017-09-20 06:00:00	QQQ	ETF	145.83	145.84	145.81	145.81	30000.0
2017-09-20 07:00:00	QQQ	ETF	145.85	145.88	145.78	145.78	13300.0
2017-09-20 08:00:00	QQQ	ETF	145.85	145.85	145.76	145.76	37369.0
2017-09-20 09:00:00	QQQ	ETF	145.8	145.91	145.55	145.64	2292137.0
2017-09-20 10:00:00	QQQ	ETF	145.65	145.73	144.93	144.93	3316516.0
2017-09-20 11:00:00	QQQ	ETF	144.935	145.205	144.79	145.18	3906960.0
2017-09-20 12:00:00	QQQ	ETF	145.185	145.52	145.16	145.42	2065664.0
2017-09-20 13:00:00	QQQ	ETF	145.41	145.44	145.15	145.27	1467332.0
2017-09-20 14:00:00	QQQ	ETF	145.26	145.27	144.23	144.86	8434296.0
2017-09-20 15:00:00	QQQ	ETF	144.85	145.47	144.725	145.36	5629633.0
2017-09-20 16:00:00	QQQ	ETF	145.36	145.45	145.1576	145.36	1065403.0
2017-09-20 17:00:00	QQQ	ETF	145.3	145.43	145.009	145.27	109593.0
2017-09-20 18:00:00	QQQ	ETF	145.28	145.33	145.27	145.3	19865.0
2017-09-20 19:00:00	QQQ	ETF	145.29	145.42	145.29	145.35	21749.0
2017-09-20 04:00:00	IWM	ETF	143.45	143.5	143.45	143.48	1129.0
2017-09-20 07:00:00	IWM	ETF	143.47	143.51	143.34	143.41	19516.0
2017-09-20 08:00:00	IWM	ETF	143.35	143.45	143.35	143.45	28169.0
2017-09-20 09:00:00	IWM	ETF	143.48	143.54	143.26	143.5	1172422.0
2017-09-20 10:00:00	IWM	ETF	143.49	143.75	143.4	143.6	2219302.0
2017-09-20 11:00:00	IWM	ETF	143.59	143.8156	143.59	143.75	1902263.0
2017-09-20 12:00:00	IWM	ETF	143.75	144.0	143.74	143.97	1498222.0
2017-09-20 13:00:00	IWM	ETF	143.97	144.0	143.77	143.87	1385332.0
2017-09-20 14:00:00	IWM	ETF	143.86	144.02	143.42	143.91	4082986.0
2017-09-20 15:00:00	IWM	ETF	143.9	144.0	143.59	143.86	3278663.0
2017-09-20 16:00:00	IWM	ETF	143.86	144.06	143.83	143.97	1917357.0
2017-09-20 17:00:00	IWM	ETF	143.96	143.96	143.84	143.95	114969.0
2017-09-20 18:00:00	IWM	ETF	143.9	143.9	143.88	143.9	1005.0
2017-09-20 19:00:00	IWM	ETF	143.94	144.04	143.94	143.99	9690.0
2017-09-20 07:00:00	DIA	ETF	223.5	223.5	223.5	223.5	100.0
2017-09-20 08:00:00	DIA	ETF	223.5	223.5	223.49	223.49	600.0
2017-09-20 09:00:00	DIA	ETF	223.57	223.68	223.4529	223.51	110540.0
2017-09-20 10:00:00	DIA	ETF	223.52	223.6125	223.39	223.5	81197.0
2017-09-20 11:00:00	DIA	ETF	223.51	223.73	223.45	223.7155	91082.0
2017-09-20 12:00:00	DIA	ETF	223.7162	223.8	223.685	223.7332	91393.0

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

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