PREVIEW / etf_1hour / 2017-06-07

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-07.parquet
  size:    277 KB
  rows:    8,946

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-07 04:00:00	SPY	ETF	243.5	243.5	243.33	243.33	2496.0
2017-06-07 05:00:00	SPY	ETF	243.41	243.42	243.41	243.41	1200.0
2017-06-07 06:00:00	SPY	ETF	243.54	243.66	243.48	243.48	19650.0
2017-06-07 07:00:00	SPY	ETF	243.54	243.67	243.46	243.67	107780.0
2017-06-07 08:00:00	SPY	ETF	243.5	243.71	243.5	243.62	88319.0
2017-06-07 09:00:00	SPY	ETF	243.61	243.79	243.48	243.735	4596284.0
2017-06-07 10:00:00	SPY	ETF	243.735	243.8555	243.1782	243.47	6624111.0
2017-06-07 11:00:00	SPY	ETF	243.47	243.62	243.28	243.44	4102023.0
2017-06-07 12:00:00	SPY	ETF	243.44	243.44	242.83	243.12	4639453.0
2017-06-07 13:00:00	SPY	ETF	243.12	243.56	243.06	243.485	4451670.0
2017-06-07 14:00:00	SPY	ETF	243.49	243.79	243.44	243.68	5174734.0
2017-06-07 15:00:00	SPY	ETF	243.67	243.92	243.52	243.65	12801400.0
2017-06-07 16:00:00	SPY	ETF	243.65	243.7087	243.08	243.62	9352646.0
2017-06-07 17:00:00	SPY	ETF	243.62	243.68	243.55	243.63	253103.0
2017-06-07 18:00:00	SPY	ETF	243.63	243.67	243.56	243.6	135194.0
2017-06-07 19:00:00	SPY	ETF	243.59	243.63	243.52	243.63	44986.0
2017-06-07 04:00:00	QQQ	ETF	143.0	143.05	142.99	143.05	2362.0
2017-06-07 05:00:00	QQQ	ETF	143.02	143.09	143.02	143.09	6200.0
2017-06-07 06:00:00	QQQ	ETF	143.17	143.2	143.11	143.12	20750.0
2017-06-07 07:00:00	QQQ	ETF	143.14	143.19	143.11	143.19	38800.0
2017-06-07 08:00:00	QQQ	ETF	143.21	143.23	143.16	143.22	83480.0
2017-06-07 09:00:00	QQQ	ETF	143.22	143.49	143.06	143.29	3245943.0
2017-06-07 10:00:00	QQQ	ETF	143.29	143.42	142.92	143.18	2699248.0
2017-06-07 11:00:00	QQQ	ETF	143.19	143.38	143.15	143.26	1165667.0
2017-06-07 12:00:00	QQQ	ETF	143.26	143.26	142.6	142.82	2037688.0
2017-06-07 13:00:00	QQQ	ETF	142.83	143.19	142.81	143.16	1665484.0
2017-06-07 14:00:00	QQQ	ETF	143.16	143.39	143.11	143.33	1950981.0
2017-06-07 15:00:00	QQQ	ETF	143.32	143.54	143.23	143.41	3047030.0
2017-06-07 16:00:00	QQQ	ETF	143.4	143.44	143.29	143.41	664813.0
2017-06-07 17:00:00	QQQ	ETF	143.42	143.45	143.33	143.45	1119.0
2017-06-07 18:00:00	QQQ	ETF	143.41	143.45	143.38	143.41	7362.0
2017-06-07 19:00:00	QQQ	ETF	143.41	143.42	143.33	143.4	9146.0
2017-06-07 04:00:00	IWM	ETF	138.91	138.91	138.91	138.91	200.0
2017-06-07 06:00:00	IWM	ETF	139.0	139.0	139.0	139.0	200.0
2017-06-07 07:00:00	IWM	ETF	138.94	138.94	138.83	138.94	8600.0
2017-06-07 08:00:00	IWM	ETF	138.98	139.04	138.89	139.03	26455.0
2017-06-07 09:00:00	IWM	ETF	139.05	139.33	138.71	139.315	1947255.0
2017-06-07 10:00:00	IWM	ETF	139.34	139.52	138.81	139.41	3235127.0
2017-06-07 11:00:00	IWM	ETF	139.42	139.53	139.105	139.19	1739347.0
2017-06-07 12:00:00	IWM	ETF	139.17	139.31	138.56	138.81	2397304.0
2017-06-07 13:00:00	IWM	ETF	138.8	138.93	138.49	138.735	1554134.0
2017-06-07 14:00:00	IWM	ETF	138.75	139.17	138.64	138.92	2268477.0
2017-06-07 15:00:00	IWM	ETF	138.925	139.165	138.78	139.0	3386681.0
2017-06-07 16:00:00	IWM	ETF	138.98	139.0611	138.8	138.85	1414815.0
2017-06-07 17:00:00	IWM	ETF	139.0422	139.0422	138.89	138.89	75600.0
2017-06-07 18:00:00	IWM	ETF	138.95	138.95	138.95	138.95	1000.0
2017-06-07 19:00:00	IWM	ETF	138.95	139.0482	138.89	138.93	153000.0
2017-06-07 06:00:00	DIA	ETF	211.5	211.6	211.5	211.6	200.0
2017-06-07 09:00:00	DIA	ETF	211.62	211.82	211.53	211.76	231949.0
2017-06-07 10:00:00	DIA	ETF	211.79	211.88	211.319	211.4995	247286.0

> showing 50 of 8,946 rows — these rows as CSV

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