PREVIEW / etf_1hour / 2017-11-09

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-09.parquet
  size:    294 KB
  rows:    9,643

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-09 04:00:00	SPY	ETF	258.85	258.85	258.72	258.78	49998.0
2017-11-09 05:00:00	SPY	ETF	258.79	258.79	258.55	258.73	11320.0
2017-11-09 06:00:00	SPY	ETF	258.65	258.67	258.16	258.34	319430.0
2017-11-09 07:00:00	SPY	ETF	258.34	258.35	257.85	257.92	730696.0
2017-11-09 08:00:00	SPY	ETF	258.15	258.34	257.57	257.86	1137110.0
2017-11-09 09:00:00	SPY	ETF	257.87	258.08	257.435	257.75	9314724.0
2017-11-09 10:00:00	SPY	ETF	257.755	258.39	257.745	258.36	9770978.0
2017-11-09 11:00:00	SPY	ETF	258.365	258.38	257.04	257.35	13746901.0
2017-11-09 12:00:00	SPY	ETF	257.355	257.36	256.36	257.04	16391784.0
2017-11-09 13:00:00	SPY	ETF	257.04	257.65	256.77	257.54	9980507.0
2017-11-09 14:00:00	SPY	ETF	257.54	257.885	257.52	257.65	12108696.0
2017-11-09 15:00:00	SPY	ETF	257.65	258.38	257.58	258.2	16145038.0
2017-11-09 16:00:00	SPY	ETF	258.22	258.44	257.7309	258.33	3070335.0
2017-11-09 17:00:00	SPY	ETF	258.33	258.33	258.17	258.18	753180.0
2017-11-09 18:00:00	SPY	ETF	258.2	258.28	258.08	258.2	281735.0
2017-11-09 19:00:00	SPY	ETF	258.18	258.36	258.11	258.22	72641.0
2017-11-09 04:00:00	QQQ	ETF	154.28	154.3	154.25	154.3	22200.0
2017-11-09 05:00:00	QQQ	ETF	154.27	154.27	154.13	154.22	18300.0
2017-11-09 06:00:00	QQQ	ETF	154.18	154.18	153.81	153.94	110503.0
2017-11-09 07:00:00	QQQ	ETF	153.97	153.97	153.5	153.5	241637.0
2017-11-09 08:00:00	QQQ	ETF	153.91	154.5	153.13	153.28	718828.0
2017-11-09 09:00:00	QQQ	ETF	153.28	153.49	152.79	153.12	6720263.0
2017-11-09 10:00:00	QQQ	ETF	153.13	153.77	153.105	153.73	5654812.0
2017-11-09 11:00:00	QQQ	ETF	153.73	153.74	152.69	152.87	3923185.0
2017-11-09 12:00:00	QQQ	ETF	152.87	152.93	152.11	152.56	6309367.0
2017-11-09 13:00:00	QQQ	ETF	152.55	153.045	152.26	152.98	3154083.0
2017-11-09 14:00:00	QQQ	ETF	152.98	153.33	152.98	153.2392	2656731.0
2017-11-09 15:00:00	QQQ	ETF	153.2334	153.76	153.14	153.68	4679186.0
2017-11-09 16:00:00	QQQ	ETF	153.68	153.86	153.2416	153.77	2197191.0
2017-11-09 17:00:00	QQQ	ETF	153.75	153.85	153.7	153.76	36138.0
2017-11-09 18:00:00	QQQ	ETF	153.76	153.78	153.64	153.73	22146.0
2017-11-09 19:00:00	QQQ	ETF	153.75	153.8	153.67	153.74	8139.0
2017-11-09 04:00:00	IWM	ETF	147.06	147.18	147.04	147.18	6216.0
2017-11-09 05:00:00	IWM	ETF	147.09	147.12	147.08	147.12	5442.0
2017-11-09 06:00:00	IWM	ETF	147.08	147.1	146.75	146.89	11103.0
2017-11-09 07:00:00	IWM	ETF	146.86	146.86	146.41	146.41	146487.0
2017-11-09 08:00:00	IWM	ETF	146.41	146.55	146.17	146.28	162871.0
2017-11-09 09:00:00	IWM	ETF	146.38	146.485	145.76	146.09	3670350.0
2017-11-09 10:00:00	IWM	ETF	146.09	147.39	146.085	147.36	4606834.0
2017-11-09 11:00:00	IWM	ETF	147.35	147.36	145.935	146.15	4779733.0
2017-11-09 12:00:00	IWM	ETF	146.14	146.23	145.28	145.84	6631814.0
2017-11-09 13:00:00	IWM	ETF	145.84	146.625	145.73	146.425	3662000.0
2017-11-09 14:00:00	IWM	ETF	146.42	146.7	146.16	146.23	2265550.0
2017-11-09 15:00:00	IWM	ETF	146.23	146.69	146.135	146.66	3526320.0
2017-11-09 16:00:00	IWM	ETF	146.66	146.9	146.5384	146.85	1859298.0
2017-11-09 17:00:00	IWM	ETF	146.88	146.97	146.68	146.83	69215.0
2017-11-09 18:00:00	IWM	ETF	146.74	146.86	146.627	146.86	194897.0
2017-11-09 19:00:00	IWM	ETF	146.82	146.89	146.75	146.79	10015.0
2017-11-09 06:00:00	DIA	ETF	234.88	234.96	234.88	234.96	549.0
2017-11-09 07:00:00	DIA	ETF	234.78	234.8	234.48	234.48	7666.0

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

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