PREVIEW / etf_1hour / 2017-11-01

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-01.parquet
  size:    292 KB
  rows:    9,599

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-01 04:00:00	SPY	ETF	257.6	257.94	257.6	257.94	43924.0
2017-11-01 05:00:00	SPY	ETF	257.96	258.07	257.95	258.07	12515.0
2017-11-01 06:00:00	SPY	ETF	258.21	258.31	258.2	258.22	7663.0
2017-11-01 07:00:00	SPY	ETF	258.22	258.28	258.06	258.1	149698.0
2017-11-01 08:00:00	SPY	ETF	257.15	258.22	257.15	258.11	244411.0
2017-11-01 09:00:00	SPY	ETF	258.07	258.43	257.925	258.29	6815856.0
2017-11-01 10:00:00	SPY	ETF	258.29	258.31	257.79	257.93	9528917.0
2017-11-01 11:00:00	SPY	ETF	257.93	258.04	257.43	257.53	7155183.0
2017-11-01 12:00:00	SPY	ETF	257.53	257.78	257.5	257.575	4131120.0
2017-11-01 13:00:00	SPY	ETF	257.57	257.57	257.07	257.42	5299829.0
2017-11-01 14:00:00	SPY	ETF	257.44	257.75	257.37	257.66	5014068.0
2017-11-01 15:00:00	SPY	ETF	257.66	257.76	257.42	257.51	9714767.0
2017-11-01 16:00:00	SPY	ETF	257.53	257.5742	257.16	257.18	4826603.0
2017-11-01 17:00:00	SPY	ETF	257.18	257.49	256.97	257.09	332509.0
2017-11-01 18:00:00	SPY	ETF	257.09	257.24	257.08	257.19	38460.0
2017-11-01 19:00:00	SPY	ETF	257.19	257.3	257.16	257.26	24091.0
2017-11-01 04:00:00	QQQ	ETF	152.56	152.84	152.56	152.81	11950.0
2017-11-01 05:00:00	QQQ	ETF	152.82	152.87	152.82	152.87	2074.0
2017-11-01 06:00:00	QQQ	ETF	152.93	153.0	152.82	152.84	4972.0
2017-11-01 07:00:00	QQQ	ETF	152.81	152.9	152.74	152.8	124565.0
2017-11-01 08:00:00	QQQ	ETF	152.75	152.86	152.72	152.76	71168.0
2017-11-01 09:00:00	QQQ	ETF	152.72	152.83	152.38	152.5199	2856431.0
2017-11-01 10:00:00	QQQ	ETF	152.5	152.58	152.115	152.16	4023285.0
2017-11-01 11:00:00	QQQ	ETF	152.17	152.45	151.95	151.98	1913496.0
2017-11-01 12:00:00	QQQ	ETF	151.99	152.29	151.98	152.09	1657820.0
2017-11-01 13:00:00	QQQ	ETF	152.08	152.13	151.5	151.8441	5140463.0
2017-11-01 14:00:00	QQQ	ETF	151.85	152.08	151.78	152.02	1548530.0
2017-11-01 15:00:00	QQQ	ETF	152.02	152.1751	151.91	152.09	3296080.0
2017-11-01 16:00:00	QQQ	ETF	152.09	152.29	151.6289	151.78	1198411.0
2017-11-01 17:00:00	QQQ	ETF	151.85	151.88	151.61	151.67	29702.0
2017-11-01 18:00:00	QQQ	ETF	151.67	151.73	151.6	151.69	30738.0
2017-11-01 19:00:00	QQQ	ETF	151.69	151.77	151.63	151.72	21398.0
2017-11-01 04:00:00	IWM	ETF	149.91	150.1	149.91	150.1	2165.0
2017-11-01 05:00:00	IWM	ETF	150.22	150.26	150.22	150.26	2800.0
2017-11-01 06:00:00	IWM	ETF	150.46	150.47	150.39	150.41	9279.0
2017-11-01 07:00:00	IWM	ETF	150.38	150.43	150.26	150.26	100457.0
2017-11-01 08:00:00	IWM	ETF	150.38	150.64	150.32	150.53	118291.0
2017-11-01 09:00:00	IWM	ETF	150.44	150.53	149.9	150.25	2322810.0
2017-11-01 10:00:00	IWM	ETF	150.25	150.27	149.04	149.1	3119929.0
2017-11-01 11:00:00	IWM	ETF	149.1	149.18	148.14	148.25	3265016.0
2017-11-01 12:00:00	IWM	ETF	148.26	148.47	147.91	147.93	3962322.0
2017-11-01 13:00:00	IWM	ETF	147.9399	148.14	147.44	148.0	4306349.0
2017-11-01 14:00:00	IWM	ETF	148.05	148.43	147.72	148.335	2872154.0
2017-11-01 15:00:00	IWM	ETF	148.33	148.57	148.2	148.32	3763082.0
2017-11-01 16:00:00	IWM	ETF	148.27	150.2545	147.6609	148.02	2306353.0
2017-11-01 17:00:00	IWM	ETF	148.02	148.15	147.58	148.05	14336.0
2017-11-01 18:00:00	IWM	ETF	148.02	148.06	148.0	148.02	13778.0
2017-11-01 19:00:00	IWM	ETF	148.13	148.15	148.05	148.15	1702.0
2017-11-01 06:00:00	DIA	ETF	234.7	235.06	234.7	234.86	2249.0
2017-11-01 07:00:00	DIA	ETF	234.86	234.99	234.86	234.86	2369.0

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

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