PREVIEW / etf_1hour / 2017-07-31

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-31.parquet
  size:    274 KB
  rows:    9,049

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-31 04:00:00	SPY	ETF	247.12	247.25	247.1	247.16	9079.0
2017-07-31 05:00:00	SPY	ETF	247.18	247.32	247.06	247.26	73474.0
2017-07-31 06:00:00	SPY	ETF	247.22	247.22	247.1	247.18	16538.0
2017-07-31 07:00:00	SPY	ETF	247.17	247.33	247.17	247.29	120251.0
2017-07-31 08:00:00	SPY	ETF	247.31	247.48	247.18	247.36	392377.0
2017-07-31 09:00:00	SPY	ETF	247.33	247.48	247.0	247.02	4440538.0
2017-07-31 10:00:00	SPY	ETF	247.02	247.07	246.53	246.68	7590113.0
2017-07-31 11:00:00	SPY	ETF	246.68	247.03	246.68	246.9908	3672655.0
2017-07-31 12:00:00	SPY	ETF	246.995	247.1	246.8	247.0501	2531233.0
2017-07-31 13:00:00	SPY	ETF	247.06	247.17	246.87	247.05	2825727.0
2017-07-31 14:00:00	SPY	ETF	247.04	247.08	246.83	246.8665	6017870.0
2017-07-31 15:00:00	SPY	ETF	246.87	247.24	246.71	246.74	13169572.0
2017-07-31 16:00:00	SPY	ETF	246.78	247.01	246.7161	246.84	22002443.0
2017-07-31 17:00:00	SPY	ETF	246.81	247.3757	246.77	246.8	385679.0
2017-07-31 18:00:00	SPY	ETF	246.8	246.8	246.62	246.72	97638.0
2017-07-31 19:00:00	SPY	ETF	246.72	246.75	246.71	246.72	15076.0
2017-07-31 04:00:00	QQQ	ETF	144.13	144.25	144.13	144.2	2157.0
2017-07-31 05:00:00	QQQ	ETF	144.13	144.2	143.99	144.2	11100.0
2017-07-31 06:00:00	QQQ	ETF	144.12	144.17	144.07	144.07	6430.0
2017-07-31 07:00:00	QQQ	ETF	144.14	144.27	144.14	144.2	41904.0
2017-07-31 08:00:00	QQQ	ETF	144.15	144.32	144.11	144.24	98365.0
2017-07-31 09:00:00	QQQ	ETF	144.21	144.43	143.73	143.75	4374969.0
2017-07-31 10:00:00	QQQ	ETF	143.76	143.83	142.92	143.18	7282859.0
2017-07-31 11:00:00	QQQ	ETF	143.2	143.57	143.15	143.51	3040777.0
2017-07-31 12:00:00	QQQ	ETF	143.51	143.545	143.17	143.43	2752572.0
2017-07-31 13:00:00	QQQ	ETF	143.44	143.48	142.98	143.2	2866114.0
2017-07-31 14:00:00	QQQ	ETF	143.21	143.31	143.0	143.1101	2316386.0
2017-07-31 15:00:00	QQQ	ETF	143.115	143.42	143.1	143.19	5703448.0
2017-07-31 16:00:00	QQQ	ETF	143.2	144.24	143.1558	143.25	1518006.0
2017-07-31 17:00:00	QQQ	ETF	143.25	143.34	143.16	143.22	497846.0
2017-07-31 18:00:00	QQQ	ETF	143.2	143.2	143.08	143.14	46520.0
2017-07-31 19:00:00	QQQ	ETF	143.14	143.2	143.14	143.16	14456.0
2017-07-31 04:00:00	IWM	ETF	142.0	142.07	142.0	142.07	1080.0
2017-07-31 05:00:00	IWM	ETF	142.09	142.09	142.09	142.09	2000.0
2017-07-31 06:00:00	IWM	ETF	142.08	142.08	142.06	142.06	1450.0
2017-07-31 07:00:00	IWM	ETF	142.1	142.15	142.1	142.15	1613.0
2017-07-31 08:00:00	IWM	ETF	142.14	142.28	142.12	142.21	25578.0
2017-07-31 09:00:00	IWM	ETF	142.21	142.38	141.38	141.43	1241231.0
2017-07-31 10:00:00	IWM	ETF	141.42	141.5367	140.97	141.15	2360188.0
2017-07-31 11:00:00	IWM	ETF	141.15	141.6	141.12	141.33	1762778.0
2017-07-31 12:00:00	IWM	ETF	141.33	141.553	141.14	141.49	1040250.0
2017-07-31 13:00:00	IWM	ETF	141.49	141.78	141.445	141.74	1052175.0
2017-07-31 14:00:00	IWM	ETF	141.73	141.82	141.63	141.65	1061796.0
2017-07-31 15:00:00	IWM	ETF	141.65	141.83	141.41	141.5	3704737.0
2017-07-31 16:00:00	IWM	ETF	141.51	141.6	141.37	141.47	743862.0
2017-07-31 17:00:00	IWM	ETF	141.8155	141.8155	141.41	141.41	18100.0
2017-07-31 18:00:00	IWM	ETF	141.51	141.51	141.41	141.45	1576217.0
2017-07-31 19:00:00	IWM	ETF	141.49	141.51	141.43	141.43	8628.0
2017-07-31 08:00:00	DIA	ETF	218.49	218.74	218.49	218.74	2637.0
2017-07-31 09:00:00	DIA	ETF	218.68	218.9	218.52	218.69	198654.0

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

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