PREVIEW / etf_1hour / 2016-11-01

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-01.parquet
  size:    264 KB
  rows:    8,487

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
2016-11-01 04:00:00	SPY	ETF	213.04	213.23	212.93	212.93	9527.0
2016-11-01 05:00:00	SPY	ETF	212.88	213.08	212.8	213.08	5964.0
2016-11-01 06:00:00	SPY	ETF	213.06	213.13	213.03	213.03	55061.0
2016-11-01 07:00:00	SPY	ETF	213.05	213.08	212.76	212.76	91711.0
2016-11-01 08:00:00	SPY	ETF	212.75	212.99	212.69	212.88	354312.0
2016-11-01 09:00:00	SPY	ETF	212.89	213.0	212.34	212.43	6950865.0
2016-11-01 10:00:00	SPY	ETF	212.425	212.55	211.77	212.16	14601307.0
2016-11-01 11:00:00	SPY	ETF	212.16	212.23	211.56	211.6251	10229241.0
2016-11-01 12:00:00	SPY	ETF	211.625	211.69	210.83	211.0746	12202403.0
2016-11-01 13:00:00	SPY	ETF	211.07	211.15	210.14	210.29	17974594.0
2016-11-01 14:00:00	SPY	ETF	210.29	210.76	209.6	210.29	25128513.0
2016-11-01 15:00:00	SPY	ETF	210.29	211.22	210.11	211.0	25553220.0
2016-11-01 16:00:00	SPY	ETF	211.0	211.29	210.67	210.69	7089221.0
2016-11-01 17:00:00	SPY	ETF	210.71	211.01	210.57	210.64	299998.0
2016-11-01 18:00:00	SPY	ETF	210.64	210.88	210.55	210.64	265597.0
2016-11-01 19:00:00	SPY	ETF	210.65	210.71	210.6	210.61	30443.0
2016-11-01 04:00:00	QQQ	ETF	117.24	117.24	117.24	117.24	100.0
2016-11-01 05:00:00	QQQ	ETF	117.15	117.15	117.15	117.15	800.0
2016-11-01 06:00:00	QQQ	ETF	117.27	117.31	117.27	117.3	2200.0
2016-11-01 07:00:00	QQQ	ETF	117.28	117.28	117.13	117.13	15245.0
2016-11-01 08:00:00	QQQ	ETF	117.11	117.19	117.08	117.19	28667.0
2016-11-01 09:00:00	QQQ	ETF	117.23	117.23	116.81	116.9098	2199631.0
2016-11-01 10:00:00	QQQ	ETF	116.91	117.01	116.45	116.71	3008337.0
2016-11-01 11:00:00	QQQ	ETF	116.71	116.835	116.5	116.54	1301002.0
2016-11-01 12:00:00	QQQ	ETF	116.55	116.57	116.01	116.12	1992413.0
2016-11-01 13:00:00	QQQ	ETF	116.11	116.14	115.47	115.59	2899492.0
2016-11-01 14:00:00	QQQ	ETF	115.581	115.86	115.1047	115.591	5792516.0
2016-11-01 15:00:00	QQQ	ETF	115.6	116.15	115.5	116.12	4204341.0
2016-11-01 16:00:00	QQQ	ETF	116.13	116.3	115.9228	116.0	694916.0
2016-11-01 17:00:00	QQQ	ETF	116.03	116.04	115.9	115.97	12621.0
2016-11-01 18:00:00	QQQ	ETF	116.0	116.09	115.94	115.96	7566.0
2016-11-01 19:00:00	QQQ	ETF	115.97	116.01	115.95	116.01	15725.0
2016-11-01 04:00:00	IWM	ETF	118.88	118.88	118.88	118.88	628.0
2016-11-01 06:00:00	IWM	ETF	118.9	118.9	118.9	118.9	162.0
2016-11-01 07:00:00	IWM	ETF	118.85	118.85	118.81	118.83	11994.0
2016-11-01 08:00:00	IWM	ETF	118.7	118.7	118.59	118.63	25700.0
2016-11-01 09:00:00	IWM	ETF	118.6	118.71	118.1575	118.28	1798446.0
2016-11-01 10:00:00	IWM	ETF	118.29	118.36	117.63	118.1	3506832.0
2016-11-01 11:00:00	IWM	ETF	118.1	118.16	117.46	117.53	2386190.0
2016-11-01 12:00:00	IWM	ETF	117.53	117.59	117.15	117.28	2771848.0
2016-11-01 13:00:00	IWM	ETF	117.28	117.37	116.67	116.695	3328166.0
2016-11-01 14:00:00	IWM	ETF	116.69	116.94	116.28	116.77	4573483.0
2016-11-01 15:00:00	IWM	ETF	116.76	117.34	116.63	117.07	7579183.0
2016-11-01 16:00:00	IWM	ETF	117.07	117.25	116.82	116.82	1056411.0
2016-11-01 17:00:00	IWM	ETF	116.82	116.9	116.78	116.78	2360.0
2016-11-01 18:00:00	IWM	ETF	116.86	116.9	116.8	116.9	4658.0
2016-11-01 19:00:00	IWM	ETF	116.89	116.9	116.85	116.88	2690.0
2016-11-01 06:00:00	DIA	ETF	181.6	181.6	181.6	181.6	100.0
2016-11-01 09:00:00	DIA	ETF	181.5	181.52	181.12	181.2	276596.0
2016-11-01 10:00:00	DIA	ETF	181.21	181.2759	180.65	181.0	348588.0

> showing 50 of 8,487 rows — these rows as CSV

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