PREVIEW / etf_1hour / 2017-08-11

all etf 1-hour files

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

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-08-11 04:00:00	SPY	ETF	243.75	243.75	243.22	243.45	43923.0
2017-08-11 05:00:00	SPY	ETF	243.45	243.57	243.24	243.47	18660.0
2017-08-11 06:00:00	SPY	ETF	243.55	243.63	243.39	243.4	59000.0
2017-08-11 07:00:00	SPY	ETF	243.43	243.59	243.16	243.44	282560.0
2017-08-11 08:00:00	SPY	ETF	243.34	244.36	243.34	244.19	2140183.0
2017-08-11 09:00:00	SPY	ETF	244.15	244.6	243.75	244.17	11969799.0
2017-08-11 10:00:00	SPY	ETF	244.17	244.8	244.045	244.61	10860193.0
2017-08-11 11:00:00	SPY	ETF	244.61	244.62	244.03	244.25	6561726.0
2017-08-11 12:00:00	SPY	ETF	244.25	244.52	244.18	244.335	3960347.0
2017-08-11 13:00:00	SPY	ETF	244.335	244.55	244.25	244.42	3955226.0
2017-08-11 14:00:00	SPY	ETF	244.42	244.7	243.87	243.9363	6783941.0
2017-08-11 15:00:00	SPY	ETF	243.94	244.4	243.78	244.11	17631250.0
2017-08-11 16:00:00	SPY	ETF	244.1	244.6101	244.03	244.19	9701890.0
2017-08-11 17:00:00	SPY	ETF	244.19	244.33	244.19	244.28	87867.0
2017-08-11 18:00:00	SPY	ETF	244.28	244.28	244.09	244.14	102010.0
2017-08-11 19:00:00	SPY	ETF	244.15	244.2	244.14	244.16	22250.0
2017-08-11 04:00:00	QQQ	ETF	140.8	140.86	140.35	140.56	30771.0
2017-08-11 05:00:00	QQQ	ETF	140.51	140.75	140.5	140.75	29799.0
2017-08-11 06:00:00	QQQ	ETF	140.7	140.8	140.62	140.62	15171.0
2017-08-11 07:00:00	QQQ	ETF	140.63	140.78	140.47	140.66	49505.0
2017-08-11 08:00:00	QQQ	ETF	140.63	141.21	140.54	141.17	772010.0
2017-08-11 09:00:00	QQQ	ETF	141.14	141.61	140.9	141.57	8423250.0
2017-08-11 10:00:00	QQQ	ETF	141.57	142.09	141.44	141.9	7515882.0
2017-08-11 11:00:00	QQQ	ETF	141.89	141.955	141.46	141.76	3681071.0
2017-08-11 12:00:00	QQQ	ETF	141.755	142.2	141.725	142.05	2247468.0
2017-08-11 13:00:00	QQQ	ETF	142.055	142.2475	141.96	142.17	2545500.0
2017-08-11 14:00:00	QQQ	ETF	142.16	142.41	141.84	141.89	4328519.0
2017-08-11 15:00:00	QQQ	ETF	141.9	142.205	141.75	142.09	8485553.0
2017-08-11 16:00:00	QQQ	ETF	142.09	142.27	141.83	142.21	2726316.0
2017-08-11 17:00:00	QQQ	ETF	142.23	142.23	142.1	142.14	144448.0
2017-08-11 18:00:00	QQQ	ETF	142.15	142.16	142.14	142.15	4571.0
2017-08-11 19:00:00	QQQ	ETF	142.19	142.2	142.1	142.19	4937.0
2017-08-11 04:00:00	IWM	ETF	135.95	135.95	135.57	135.61	4930.0
2017-08-11 05:00:00	IWM	ETF	135.72	135.93	135.72	135.83	1003.0
2017-08-11 06:00:00	IWM	ETF	135.91	135.95	135.84	135.84	15600.0
2017-08-11 07:00:00	IWM	ETF	135.9	136.03	135.77	135.92	46977.0
2017-08-11 08:00:00	IWM	ETF	135.77	136.42	135.77	136.32	265512.0
2017-08-11 09:00:00	IWM	ETF	136.31	136.58	135.91	136.36	3637712.0
2017-08-11 10:00:00	IWM	ETF	136.35	136.74	136.27	136.44	2986138.0
2017-08-11 11:00:00	IWM	ETF	136.43	136.45	135.77	135.96	3090770.0
2017-08-11 12:00:00	IWM	ETF	135.96	136.29	135.9	136.08	1607326.0
2017-08-11 13:00:00	IWM	ETF	136.08	136.43	136.03	136.29	1689515.0
2017-08-11 14:00:00	IWM	ETF	136.28	136.46	136.02	136.13	2044388.0
2017-08-11 15:00:00	IWM	ETF	136.14	136.69	136.07	136.46	4681794.0
2017-08-11 16:00:00	IWM	ETF	136.46	136.5254	136.29	136.41	1463838.0
2017-08-11 17:00:00	IWM	ETF	136.47	136.57	136.43	136.54	8300.0
2017-08-11 18:00:00	IWM	ETF	136.5205	136.55	136.5	136.5	100703.0
2017-08-11 19:00:00	IWM	ETF	136.55	136.59	136.54	136.54	595.0
2017-08-11 07:00:00	DIA	ETF	218.5	218.5	218.38	218.38	400.0
2017-08-11 08:00:00	DIA	ETF	218.38	218.97	218.38	218.71	14630.0

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

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