PREVIEW / etf_1hour / 2017-07-26

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-26.parquet
  size:    278 KB
  rows:    9,104

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-07-26 04:00:00	SPY	ETF	247.46	247.68	247.46	247.49	3090.0
2017-07-26 05:00:00	SPY	ETF	247.49	247.68	247.47	247.6	6800.0
2017-07-26 06:00:00	SPY	ETF	247.54	247.63	247.5	247.63	9335.0
2017-07-26 07:00:00	SPY	ETF	247.57	247.78	247.54	247.78	146886.0
2017-07-26 08:00:00	SPY	ETF	247.75	247.86	247.6	247.81	285808.0
2017-07-26 09:00:00	SPY	ETF	247.83	247.88	247.47	247.63	4714777.0
2017-07-26 10:00:00	SPY	ETF	247.63	247.79	247.43	247.4799	5870741.0
2017-07-26 11:00:00	SPY	ETF	247.47	247.595	247.46	247.56	5349307.0
2017-07-26 12:00:00	SPY	ETF	247.56	247.66	247.49	247.535	2515634.0
2017-07-26 13:00:00	SPY	ETF	247.53	247.53	247.35	247.36	4016708.0
2017-07-26 14:00:00	SPY	ETF	247.375	247.68	247.28	247.395	5713953.0
2017-07-26 15:00:00	SPY	ETF	247.39	247.51	247.13	247.45	11704855.0
2017-07-26 16:00:00	SPY	ETF	247.43	247.5976	247.28	247.4319	6321892.0
2017-07-26 17:00:00	SPY	ETF	247.38	247.46	247.36	247.44	74105.0
2017-07-26 18:00:00	SPY	ETF	247.44	247.64	247.44	247.61	191631.0
2017-07-26 19:00:00	SPY	ETF	247.6	247.69	247.6	247.63	58765.0
2017-07-26 04:00:00	QQQ	ETF	144.49	144.49	144.39	144.45	5200.0
2017-07-26 05:00:00	QQQ	ETF	144.43	144.55	144.43	144.46	13400.0
2017-07-26 06:00:00	QQQ	ETF	144.46	144.6	144.45	144.6	6262.0
2017-07-26 07:00:00	QQQ	ETF	144.58	144.63	144.55	144.62	7445.0
2017-07-26 08:00:00	QQQ	ETF	144.61	144.88	144.38	144.85	254971.0
2017-07-26 09:00:00	QQQ	ETF	144.88	144.89	144.64	144.83	2401019.0
2017-07-26 10:00:00	QQQ	ETF	144.83	144.95	144.63	144.66	2314614.0
2017-07-26 11:00:00	QQQ	ETF	144.66	144.76	144.56	144.64	1166385.0
2017-07-26 12:00:00	QQQ	ETF	144.65	144.8	144.64	144.71	1479464.0
2017-07-26 13:00:00	QQQ	ETF	144.7	144.81	144.6	144.67	1049052.0
2017-07-26 14:00:00	QQQ	ETF	144.67	144.83	144.53	144.67	1707245.0
2017-07-26 15:00:00	QQQ	ETF	144.67	144.885	144.64	144.87	3291249.0
2017-07-26 16:00:00	QQQ	ETF	144.87	145.04	144.56	144.94	1320037.0
2017-07-26 17:00:00	QQQ	ETF	144.94	145.07	144.87	145.03	61554.0
2017-07-26 18:00:00	QQQ	ETF	145.06	145.28	145.05	145.23	47825.0
2017-07-26 19:00:00	QQQ	ETF	145.2	145.3	145.2	145.28	17843.0
2017-07-26 04:00:00	IWM	ETF	144.05	144.05	144.0	144.0	7000.0
2017-07-26 07:00:00	IWM	ETF	144.1	144.24	144.03	144.24	14051.0
2017-07-26 08:00:00	IWM	ETF	144.19	144.27	144.13	144.19	28319.0
2017-07-26 09:00:00	IWM	ETF	144.15	144.21	143.65	143.74	1908864.0
2017-07-26 10:00:00	IWM	ETF	143.75	143.91	143.48	143.75	1855514.0
2017-07-26 11:00:00	IWM	ETF	143.73	143.85	143.66	143.81	948540.0
2017-07-26 12:00:00	IWM	ETF	143.82	143.83	143.61	143.61	674044.0
2017-07-26 13:00:00	IWM	ETF	143.61	143.62	143.45	143.48	958867.0
2017-07-26 14:00:00	IWM	ETF	143.5	143.64	143.19	143.25	2171863.0
2017-07-26 15:00:00	IWM	ETF	143.24	143.4	143.0483	143.26	3711847.0
2017-07-26 16:00:00	IWM	ETF	143.25	143.31	143.16	143.28	475765.0
2017-07-26 17:00:00	IWM	ETF	143.25	143.39	143.25	143.39	2596.0
2017-07-26 18:00:00	IWM	ETF	143.28	143.33	143.28	143.33	454.0
2017-07-26 19:00:00	IWM	ETF	143.32	143.33	143.3	143.33	2100.0
2017-07-26 08:00:00	DIA	ETF	216.35	216.64	216.35	216.64	11214.0
2017-07-26 09:00:00	DIA	ETF	216.7	217.07	216.7	216.96	336605.0
2017-07-26 10:00:00	DIA	ETF	216.97	217.16	216.74	216.83	813482.0
2017-07-26 11:00:00	DIA	ETF	216.84	217.04	216.84	216.9	115286.0

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

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