PREVIEW / etf_1hour / 2017-05-31

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-31.parquet
  size:    274 KB
  rows:    8,946

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-05-31 04:00:00	SPY	ETF	241.66	241.66	241.53	241.56	500.0
2017-05-31 05:00:00	SPY	ETF	241.43	241.52	241.42	241.52	500.0
2017-05-31 06:00:00	SPY	ETF	241.54	241.71	241.54	241.69	12100.0
2017-05-31 07:00:00	SPY	ETF	241.74	241.93	241.7	241.86	211960.0
2017-05-31 08:00:00	SPY	ETF	241.85	242.04	241.73	241.95	603911.0
2017-05-31 09:00:00	SPY	ETF	241.95	241.99	240.91	240.97	6464827.0
2017-05-31 10:00:00	SPY	ETF	240.98	241.38	240.64	241.35	12488526.0
2017-05-31 11:00:00	SPY	ETF	241.35	241.4	240.79	241.09	8833924.0
2017-05-31 12:00:00	SPY	ETF	241.09	241.28	240.96	241.005	3333030.0
2017-05-31 13:00:00	SPY	ETF	241.005	241.32	240.93	241.02	5184470.0
2017-05-31 14:00:00	SPY	ETF	241.02	241.25	240.77	241.085	8430039.0
2017-05-31 15:00:00	SPY	ETF	241.095	241.52	241.02	241.42	21380312.0
2017-05-31 16:00:00	SPY	ETF	241.43	241.84	241.3903	241.79	19730471.0
2017-05-31 17:00:00	SPY	ETF	241.76	241.77	241.39	241.65	3252585.0
2017-05-31 18:00:00	SPY	ETF	241.65	241.74	241.6	241.61	252030.0
2017-05-31 19:00:00	SPY	ETF	241.61	241.66	241.56	241.57	105420.0
2017-05-31 04:00:00	QQQ	ETF	141.31	141.43	141.31	141.39	1520.0
2017-05-31 05:00:00	QQQ	ETF	141.36	141.4	141.36	141.4	400.0
2017-05-31 06:00:00	QQQ	ETF	141.45	141.56	141.45	141.56	2310.0
2017-05-31 07:00:00	QQQ	ETF	141.56	141.74	141.56	141.71	185564.0
2017-05-31 08:00:00	QQQ	ETF	141.64	141.91	141.61	141.83	299262.0
2017-05-31 09:00:00	QQQ	ETF	141.83	141.91	140.88	140.9101	5785332.0
2017-05-31 10:00:00	QQQ	ETF	140.91	141.196	140.57	141.16	5453482.0
2017-05-31 11:00:00	QQQ	ETF	141.15	141.26	140.87	141.12	2530963.0
2017-05-31 12:00:00	QQQ	ETF	141.1264	141.245	140.93	140.9499	1463553.0
2017-05-31 13:00:00	QQQ	ETF	140.95	141.195	140.95	141.03	1506249.0
2017-05-31 14:00:00	QQQ	ETF	141.03	141.065	140.72	140.93	1357120.0
2017-05-31 15:00:00	QQQ	ETF	140.94	141.3	140.91	141.25	4284194.0
2017-05-31 16:00:00	QQQ	ETF	141.25	141.6	141.2192	141.55	710845.0
2017-05-31 17:00:00	QQQ	ETF	141.53	141.53	141.26	141.52	1356531.0
2017-05-31 18:00:00	QQQ	ETF	141.52	141.54	141.45	141.46	11082.0
2017-05-31 19:00:00	QQQ	ETF	141.47	141.5	141.46	141.48	8800.0
2017-05-31 05:00:00	IWM	ETF	136.55	136.55	136.51	136.51	500.0
2017-05-31 06:00:00	IWM	ETF	136.46	136.66	136.46	136.66	1090.0
2017-05-31 07:00:00	IWM	ETF	136.74	136.9	136.74	136.84	17357.0
2017-05-31 08:00:00	IWM	ETF	136.84	137.06	136.84	136.96	272799.0
2017-05-31 09:00:00	IWM	ETF	136.95	136.99	135.09	135.11	4062530.0
2017-05-31 10:00:00	IWM	ETF	135.11	135.86	134.64	135.84	7556788.0
2017-05-31 11:00:00	IWM	ETF	135.84	135.9	135.36	135.82	3589721.0
2017-05-31 12:00:00	IWM	ETF	135.83	136.035	135.74	135.81	2516622.0
2017-05-31 13:00:00	IWM	ETF	135.82	136.125	135.6	135.67	2682557.0
2017-05-31 14:00:00	IWM	ETF	135.6601	136.03	135.52	135.82	2380843.0
2017-05-31 15:00:00	IWM	ETF	135.8234	136.46	135.8234	136.35	4589648.0
2017-05-31 16:00:00	IWM	ETF	136.34	136.63	136.24	136.6	1614391.0
2017-05-31 17:00:00	IWM	ETF	136.59	136.59	136.32	136.32	425829.0
2017-05-31 18:00:00	IWM	ETF	136.52	136.56	136.52	136.52	2810.0
2017-05-31 19:00:00	IWM	ETF	136.52	136.55	136.47	136.48	1490.0
2017-05-31 05:00:00	DIA	ETF	210.08	210.08	210.08	210.08	100.0
2017-05-31 07:00:00	DIA	ETF	210.29	210.44	210.29	210.44	900.0
2017-05-31 08:00:00	DIA	ETF	210.49	210.64	210.49	210.64	2500.0

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

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