PREVIEW / etf_1hour / 2017-11-06

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-06.parquet
  size:    290 KB
  rows:    9,545

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-06 04:00:00	SPY	ETF	258.1	258.12	258.0	258.06	13200.0
2017-11-06 05:00:00	SPY	ETF	258.13	258.13	258.04	258.07	10300.0
2017-11-06 06:00:00	SPY	ETF	258.02	258.2	258.01	258.16	7105.0
2017-11-06 07:00:00	SPY	ETF	258.2	258.28	258.17	258.22	97477.0
2017-11-06 08:00:00	SPY	ETF	258.45	258.45	257.651	258.28	121009.0
2017-11-06 09:00:00	SPY	ETF	258.28	258.59	258.22	258.58	4742545.0
2017-11-06 10:00:00	SPY	ETF	258.585	258.78	258.4401	258.62	4511064.0
2017-11-06 11:00:00	SPY	ETF	258.61	258.8	258.52	258.56	4269282.0
2017-11-06 12:00:00	SPY	ETF	258.57	258.825	258.53	258.78	3900339.0
2017-11-06 13:00:00	SPY	ETF	258.79	258.89	258.73	258.84	3925623.0
2017-11-06 14:00:00	SPY	ETF	258.83	258.94	258.75	258.94	2913140.0
2017-11-06 15:00:00	SPY	ETF	258.93	259.0	258.78	258.82	14088242.0
2017-11-06 16:00:00	SPY	ETF	258.83	258.87	258.68	258.83	9604411.0
2017-11-06 17:00:00	SPY	ETF	258.82	258.83	258.75	258.77	101963.0
2017-11-06 18:00:00	SPY	ETF	258.79	258.83	258.75	258.8	60258.0
2017-11-06 19:00:00	SPY	ETF	258.77	258.85	258.75	258.85	40019.0
2017-11-06 04:00:00	QQQ	ETF	153.11	153.2	153.11	153.2	12899.0
2017-11-06 05:00:00	QQQ	ETF	153.17	153.18	153.15	153.15	2400.0
2017-11-06 06:00:00	QQQ	ETF	153.07	153.22	153.07	153.22	12227.0
2017-11-06 07:00:00	QQQ	ETF	153.24	153.3	153.21	153.25	18868.0
2017-11-06 08:00:00	QQQ	ETF	153.255	153.27	153.16	153.27	56888.0
2017-11-06 09:00:00	QQQ	ETF	153.29	153.64	153.1	153.61	3195348.0
2017-11-06 10:00:00	QQQ	ETF	153.61	153.8	153.45	153.64	1994569.0
2017-11-06 11:00:00	QQQ	ETF	153.63	153.66	153.28	153.3927	1797364.0
2017-11-06 12:00:00	QQQ	ETF	153.4	153.64	153.38	153.59	1052143.0
2017-11-06 13:00:00	QQQ	ETF	153.6	153.75	153.55	153.7101	1101648.0
2017-11-06 14:00:00	QQQ	ETF	153.72	153.78	153.62	153.77	1048655.0
2017-11-06 15:00:00	QQQ	ETF	153.76	153.85	153.7	153.77	2961344.0
2017-11-06 16:00:00	QQQ	ETF	153.76	153.8037	153.6	153.77	823493.0
2017-11-06 17:00:00	QQQ	ETF	153.77	153.77	153.62	153.72	23900.0
2017-11-06 18:00:00	QQQ	ETF	153.69	153.73	153.67	153.73	4045.0
2017-11-06 19:00:00	QQQ	ETF	153.71	153.77	153.71	153.76	2950.0
2017-11-06 04:00:00	IWM	ETF	148.49	148.49	148.29	148.29	2051.0
2017-11-06 05:00:00	IWM	ETF	148.38	148.38	148.38	148.38	100.0
2017-11-06 06:00:00	IWM	ETF	148.39	148.48	148.39	148.42	2100.0
2017-11-06 07:00:00	IWM	ETF	148.47	148.48	148.47	148.48	2590.0
2017-11-06 08:00:00	IWM	ETF	148.61	148.61	148.48	148.56	22970.0
2017-11-06 09:00:00	IWM	ETF	148.61	148.96	148.51	148.95	1451097.0
2017-11-06 10:00:00	IWM	ETF	148.95	149.22	148.54	148.62	2158010.0
2017-11-06 11:00:00	IWM	ETF	148.61	148.8	148.39	148.64	1368267.0
2017-11-06 12:00:00	IWM	ETF	148.64	149.0656	148.54	149.04	683679.0
2017-11-06 13:00:00	IWM	ETF	149.05	149.38	148.78	148.87	1034925.0
2017-11-06 14:00:00	IWM	ETF	148.877	148.905	148.735	148.76	731350.0
2017-11-06 15:00:00	IWM	ETF	148.77	149.11	148.77	148.81	2949316.0
2017-11-06 16:00:00	IWM	ETF	148.81	148.91	148.64	148.84	1503571.0
2017-11-06 17:00:00	IWM	ETF	148.78	148.875	148.78	148.83	40126.0
2017-11-06 18:00:00	IWM	ETF	148.76	148.76	148.76	148.76	200.0
2017-11-06 19:00:00	IWM	ETF	148.78	148.8654	148.78	148.8654	101500.0
2017-11-06 07:00:00	DIA	ETF	235.3	235.3	235.1	235.2	18789.0
2017-11-06 08:00:00	DIA	ETF	235.15	235.24	235.1	235.24	2573.0

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

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