PREVIEW / etf_1hour / 2017-09-26

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-26.parquet
  size:    279 KB
  rows:    9,203

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-09-26 04:00:00	SPY	ETF	249.26	249.26	249.05	249.14	18100.0
2017-09-26 05:00:00	SPY	ETF	249.17	249.23	249.17	249.23	1000.0
2017-09-26 06:00:00	SPY	ETF	249.22	249.27	249.2	249.21	13173.0
2017-09-26 07:00:00	SPY	ETF	249.13	249.23	249.02	249.15	102716.0
2017-09-26 08:00:00	SPY	ETF	249.14	249.39	249.01	249.37	262505.0
2017-09-26 09:00:00	SPY	ETF	249.36	249.7	249.31	249.57	4968021.0
2017-09-26 10:00:00	SPY	ETF	249.58	249.67	249.11	249.14	5959137.0
2017-09-26 11:00:00	SPY	ETF	249.14	249.195	248.805	249.15	4724855.0
2017-09-26 12:00:00	SPY	ETF	249.15	249.3256	248.99	249.19	5557655.0
2017-09-26 13:00:00	SPY	ETF	249.18	249.49	249.16	249.42	3901895.0
2017-09-26 14:00:00	SPY	ETF	249.42	249.48	249.17	249.24	5939215.0
2017-09-26 15:00:00	SPY	ETF	249.24	249.44	248.9	249.05	10846907.0
2017-09-26 16:00:00	SPY	ETF	249.07	249.2893	248.97	249.04	8378370.0
2017-09-26 17:00:00	SPY	ETF	249.01	249.06	248.98	249.01	46410.0
2017-09-26 18:00:00	SPY	ETF	249.01	249.05	248.96	249.0	30602.0
2017-09-26 19:00:00	SPY	ETF	249.01	249.08	249.01	249.08	17352.0
2017-09-26 04:00:00	QQQ	ETF	141.86	143.01	141.86	143.01	15450.0
2017-09-26 05:00:00	QQQ	ETF	143.04	143.14	143.03	143.09	20000.0
2017-09-26 06:00:00	QQQ	ETF	143.2	143.21	143.12	143.12	16398.0
2017-09-26 07:00:00	QQQ	ETF	143.12	143.29	143.08	143.2	169771.0
2017-09-26 08:00:00	QQQ	ETF	143.26	143.51	143.19	143.51	200628.0
2017-09-26 09:00:00	QQQ	ETF	143.5	143.8	143.37	143.48	4190164.0
2017-09-26 10:00:00	QQQ	ETF	143.49	143.75	143.02	143.11	4308447.0
2017-09-26 11:00:00	QQQ	ETF	143.11	143.11	142.67	142.99	3890607.0
2017-09-26 12:00:00	QQQ	ETF	142.99	143.29	142.86	143.17	2750207.0
2017-09-26 13:00:00	QQQ	ETF	143.19	143.69	143.17	143.55	2960763.0
2017-09-26 14:00:00	QQQ	ETF	143.55	143.6055	143.28	143.34	1264056.0
2017-09-26 15:00:00	QQQ	ETF	143.3499	143.5	143.06	143.18	3590638.0
2017-09-26 16:00:00	QQQ	ETF	143.2	143.6738	143.14	143.23	739355.0
2017-09-26 17:00:00	QQQ	ETF	143.2	143.27	143.18	143.22	5369.0
2017-09-26 18:00:00	QQQ	ETF	143.22	143.3	143.22	143.24	10573.0
2017-09-26 19:00:00	QQQ	ETF	143.23	143.28	143.23	143.26	3300.0
2017-09-26 04:00:00	IWM	ETF	144.26	144.26	144.14	144.14	700.0
2017-09-26 05:00:00	IWM	ETF	144.25	144.25	144.22	144.22	1300.0
2017-09-26 06:00:00	IWM	ETF	144.28	144.28	144.21	144.21	4300.0
2017-09-26 07:00:00	IWM	ETF	144.17	144.24	144.06	144.2	26466.0
2017-09-26 08:00:00	IWM	ETF	144.23	144.4	144.15	144.36	39959.0
2017-09-26 09:00:00	IWM	ETF	144.4	144.6099	144.18	144.41	2620376.0
2017-09-26 10:00:00	IWM	ETF	144.41	144.78	144.4	144.5942	3518269.0
2017-09-26 11:00:00	IWM	ETF	144.6	144.74	144.545	144.71	3231308.0
2017-09-26 12:00:00	IWM	ETF	144.71	144.82	144.52	144.585	1285011.0
2017-09-26 13:00:00	IWM	ETF	144.589	145.13	144.54	145.12	2277451.0
2017-09-26 14:00:00	IWM	ETF	145.11	145.15	144.81	144.89	2368464.0
2017-09-26 15:00:00	IWM	ETF	144.89	145.01	144.59	144.61	4042092.0
2017-09-26 16:00:00	IWM	ETF	144.61	145.0	144.54	144.75	1054246.0
2017-09-26 17:00:00	IWM	ETF	144.74	144.77	144.7	144.7	20884.0
2017-09-26 18:00:00	IWM	ETF	144.78	144.78	144.7	144.7	9500.0
2017-09-26 19:00:00	IWM	ETF	144.69	144.79	144.69	144.79	6865.0
2017-09-26 08:00:00	DIA	ETF	222.85	223.17	222.81	223.17	2195.0
2017-09-26 09:00:00	DIA	ETF	223.16	223.49	223.05	223.47	184658.0

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

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