PREVIEW / etf_1hour / 2017-11-10

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-10.parquet
  size:    281 KB
  rows:    9,178

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-11-10 04:00:00	SPY	ETF	257.73	257.79	257.16	257.23	45929.0
2017-11-10 05:00:00	SPY	ETF	257.31	257.49	257.31	257.49	7115.0
2017-11-10 06:00:00	SPY	ETF	257.58	257.63	257.37	257.47	21440.0
2017-11-10 07:00:00	SPY	ETF	257.42	257.7	257.32	257.66	283660.0
2017-11-10 08:00:00	SPY	ETF	257.65	257.85	257.38	257.76	388538.0
2017-11-10 09:00:00	SPY	ETF	257.75	257.96	257.57	257.72	5540738.0
2017-11-10 10:00:00	SPY	ETF	257.7101	257.93	257.37	257.73	8654565.0
2017-11-10 11:00:00	SPY	ETF	257.74	257.86	257.5	257.84	3374705.0
2017-11-10 12:00:00	SPY	ETF	257.835	257.98	257.68	257.7	2645853.0
2017-11-10 13:00:00	SPY	ETF	257.71	257.92	257.63	257.83	2371881.0
2017-11-10 14:00:00	SPY	ETF	257.83	258.19	257.83	258.15	8525587.0
2017-11-10 15:00:00	SPY	ETF	258.15	258.2926	258.01	258.08	13668162.0
2017-11-10 16:00:00	SPY	ETF	258.09	258.1	257.92	257.94	12425262.0
2017-11-10 17:00:00	SPY	ETF	257.96	258.15	257.94	257.99	351518.0
2017-11-10 18:00:00	SPY	ETF	257.98	258.05	257.98	258.02	29136.0
2017-11-10 19:00:00	SPY	ETF	258.02	258.02	257.96	258.02	20452.0
2017-11-10 04:00:00	QQQ	ETF	153.58	153.58	153.01	153.02	53687.0
2017-11-10 05:00:00	QQQ	ETF	153.15	153.2	153.1	153.18	3697.0
2017-11-10 06:00:00	QQQ	ETF	153.29	153.32	153.2	153.28	71557.0
2017-11-10 07:00:00	QQQ	ETF	153.35	153.5	153.18	153.5	84558.0
2017-11-10 08:00:00	QQQ	ETF	153.5	153.55	153.38	153.46	139692.0
2017-11-10 09:00:00	QQQ	ETF	153.43	153.61	153.22	153.391	2989064.0
2017-11-10 10:00:00	QQQ	ETF	153.39	153.48	153.06	153.38	2302550.0
2017-11-10 11:00:00	QQQ	ETF	153.381	153.46	153.19	153.44	1106490.0
2017-11-10 12:00:00	QQQ	ETF	153.45	153.68	153.3749	153.39	1221280.0
2017-11-10 13:00:00	QQQ	ETF	153.39	153.61	153.35	153.5439	1215275.0
2017-11-10 14:00:00	QQQ	ETF	153.55	153.77	153.54	153.73	1651877.0
2017-11-10 15:00:00	QQQ	ETF	153.73	153.8	153.58	153.6625	2852761.0
2017-11-10 16:00:00	QQQ	ETF	153.68	153.75	153.61	153.64	1014239.0
2017-11-10 17:00:00	QQQ	ETF	153.62	153.7	153.58	153.68	195435.0
2017-11-10 18:00:00	QQQ	ETF	153.6	153.6	153.55	153.6	2782.0
2017-11-10 19:00:00	QQQ	ETF	153.65	153.65	153.56	153.56	1700.0
2017-11-10 04:00:00	IWM	ETF	146.63	146.65	146.23	146.24	9423.0
2017-11-10 05:00:00	IWM	ETF	146.25	146.46	146.24	146.39	12673.0
2017-11-10 06:00:00	IWM	ETF	146.5	146.55	146.38	146.38	3963.0
2017-11-10 07:00:00	IWM	ETF	146.4	146.66	146.3	146.62	19057.0
2017-11-10 08:00:00	IWM	ETF	146.59	146.77	146.55	146.64	24622.0
2017-11-10 09:00:00	IWM	ETF	146.64	147.1	146.59	146.9941	2320571.0
2017-11-10 10:00:00	IWM	ETF	147.0	147.09	146.41	146.91	2493644.0
2017-11-10 11:00:00	IWM	ETF	146.91	147.1	146.775	147.04	1636057.0
2017-11-10 12:00:00	IWM	ETF	147.04	147.1	146.51	146.56	943006.0
2017-11-10 13:00:00	IWM	ETF	146.56	146.755	146.345	146.71	1786563.0
2017-11-10 14:00:00	IWM	ETF	146.71	146.975	146.67	146.93	1438676.0
2017-11-10 15:00:00	IWM	ETF	146.93	147.02	138.54	146.57	3600656.0
2017-11-10 16:00:00	IWM	ETF	146.58	146.6392	146.42	146.46	954362.0
2017-11-10 17:00:00	IWM	ETF	146.44	146.57	146.44	146.49	96740.0
2017-11-10 18:00:00	IWM	ETF	146.5	146.5	146.5	146.5	700.0
2017-11-10 19:00:00	IWM	ETF	146.5	146.5	146.41	146.41	2858.0
2017-11-10 04:00:00	DIA	ETF	234.32	234.32	234.32	234.32	200.0
2017-11-10 05:00:00	DIA	ETF	234.2	234.2	234.2	234.2	700.0

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

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