PREVIEW / etf_1hour / 2017-11-17

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-17.parquet
  size:    287 KB
  rows:    9,421

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-17 04:00:00	SPY	ETF	258.22	258.25	258.14	258.2	6704.0
2017-11-17 05:00:00	SPY	ETF	258.2	258.31	258.04	258.3	10500.0
2017-11-17 06:00:00	SPY	ETF	258.28	258.45	258.25	258.45	23270.0
2017-11-17 07:00:00	SPY	ETF	258.45	258.66	258.43	258.64	162018.0
2017-11-17 08:00:00	SPY	ETF	258.51	258.62	258.33	258.43	599515.0
2017-11-17 09:00:00	SPY	ETF	258.45	258.46	257.97	258.27	8379007.0
2017-11-17 10:00:00	SPY	ETF	258.275	258.44	258.03	258.25	8750316.0
2017-11-17 11:00:00	SPY	ETF	258.25	258.29	257.89	258.23	5653119.0
2017-11-17 12:00:00	SPY	ETF	258.22	258.36	258.09	258.295	4239008.0
2017-11-17 13:00:00	SPY	ETF	258.29	258.33	258.09	258.215	3815249.0
2017-11-17 14:00:00	SPY	ETF	258.21	258.5882	258.04	258.205	5275074.0
2017-11-17 15:00:00	SPY	ETF	258.2	258.21	257.77	257.89	24686076.0
2017-11-17 16:00:00	SPY	ETF	257.86	258.01	257.62	257.71	11343013.0
2017-11-17 17:00:00	SPY	ETF	257.75	257.86	257.61	257.61	517980.0
2017-11-17 18:00:00	SPY	ETF	257.61	257.67	257.56	257.66	44979.0
2017-11-17 19:00:00	SPY	ETF	257.66	257.9208	257.6	257.64	1224015.0
2017-11-17 05:00:00	QQQ	ETF	154.46	154.51	154.45	154.51	10680.0
2017-11-17 06:00:00	QQQ	ETF	154.54	154.6	154.54	154.59	34600.0
2017-11-17 07:00:00	QQQ	ETF	154.58	154.7	154.58	154.68	45442.0
2017-11-17 08:00:00	QQQ	ETF	154.61	154.68	154.45	154.56	194765.0
2017-11-17 09:00:00	QQQ	ETF	154.56	154.69	154.32	154.42	3040387.0
2017-11-17 10:00:00	QQQ	ETF	154.43	154.48	154.24	154.455	3102457.0
2017-11-17 11:00:00	QQQ	ETF	154.455	154.505	154.09	154.34	2274486.0
2017-11-17 12:00:00	QQQ	ETF	154.34	154.43	154.215	154.29	1510607.0
2017-11-17 13:00:00	QQQ	ETF	154.29	154.32	154.1901	154.24	1538461.0
2017-11-17 14:00:00	QQQ	ETF	154.24	154.27	154.03	154.1	1409468.0
2017-11-17 15:00:00	QQQ	ETF	154.105	154.105	153.8	153.94	5781857.0
2017-11-17 16:00:00	QQQ	ETF	153.94	153.98	153.7	153.74	2432437.0
2017-11-17 17:00:00	QQQ	ETF	153.73	153.75	153.67	153.7	51827.0
2017-11-17 18:00:00	QQQ	ETF	153.7	153.76	153.7	153.76	3120.0
2017-11-17 19:00:00	QQQ	ETF	153.74	153.8	153.65	153.75	6720.0
2017-11-17 04:00:00	IWM	ETF	147.38	147.38	147.36	147.36	269.0
2017-11-17 06:00:00	IWM	ETF	147.57	147.58	147.49	147.58	3609.0
2017-11-17 07:00:00	IWM	ETF	147.68	147.7	147.63	147.63	2087.0
2017-11-17 08:00:00	IWM	ETF	147.6	147.65	147.32	147.4	73294.0
2017-11-17 09:00:00	IWM	ETF	147.4	147.78	147.171	147.75	2104118.0
2017-11-17 10:00:00	IWM	ETF	147.74	147.93	147.46	147.72	1761560.0
2017-11-17 11:00:00	IWM	ETF	147.73	148.47	147.51	148.44	2050156.0
2017-11-17 12:00:00	IWM	ETF	148.46	148.83	148.33	148.76	2290212.0
2017-11-17 13:00:00	IWM	ETF	148.755	149.03	148.54	148.545	2302373.0
2017-11-17 14:00:00	IWM	ETF	148.545	148.64	148.33	148.545	1695918.0
2017-11-17 15:00:00	IWM	ETF	148.55	148.62	148.4	148.43	4263509.0
2017-11-17 16:00:00	IWM	ETF	148.41	148.85	148.34	148.44	1942294.0
2017-11-17 17:00:00	IWM	ETF	148.3026	148.3026	148.3026	148.3026	41768.0
2017-11-17 18:00:00	IWM	ETF	148.36	148.4	148.36	148.4	391.0
2017-11-17 19:00:00	IWM	ETF	148.4513	148.4513	148.4513	148.4513	205000.0
2017-11-17 04:00:00	DIA	ETF	234.32	234.32	234.32	234.32	200.0
2017-11-17 07:00:00	DIA	ETF	234.32	234.32	234.18	234.31	3000.0
2017-11-17 08:00:00	DIA	ETF	234.23	234.23	233.82	233.91	59550.0
2017-11-17 09:00:00	DIA	ETF	233.95	233.95	233.42	233.71	748129.0

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

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