PREVIEW / etf_1hour / 2017-09-06

all etf 1-hour files

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

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-06 04:00:00	SPY	ETF	246.65	246.68	246.41	246.56	10973.0
2017-09-06 05:00:00	SPY	ETF	246.51	246.51	246.11	246.26	9505.0
2017-09-06 06:00:00	SPY	ETF	246.46	246.47	246.28	246.31	9113.0
2017-09-06 07:00:00	SPY	ETF	246.37	246.71	246.37	246.68	117413.0
2017-09-06 08:00:00	SPY	ETF	246.67	246.91	246.46	246.87	643747.0
2017-09-06 09:00:00	SPY	ETF	246.87	247.0	246.6	246.77	6319534.0
2017-09-06 10:00:00	SPY	ETF	246.765	247.08	246.24	246.69	10583601.0
2017-09-06 11:00:00	SPY	ETF	246.68	246.75	246.23	246.59	5075041.0
2017-09-06 12:00:00	SPY	ETF	246.59	246.86	246.42	246.82	3853510.0
2017-09-06 13:00:00	SPY	ETF	246.83	247.03	246.8	246.88	5139829.0
2017-09-06 14:00:00	SPY	ETF	246.87	247.19	246.855	247.0703	4275853.0
2017-09-06 15:00:00	SPY	ETF	247.08	247.28	246.8	246.91	13377098.0
2017-09-06 16:00:00	SPY	ETF	246.91	246.97	246.81	246.82	4366316.0
2017-09-06 17:00:00	SPY	ETF	246.84	246.84	246.6243	246.77	125101.0
2017-09-06 18:00:00	SPY	ETF	246.76	246.76	246.2	246.42	265851.0
2017-09-06 19:00:00	SPY	ETF	246.45	246.57	246.44	246.56	47209.0
2017-09-06 04:00:00	QQQ	ETF	145.17	145.2	145.07	145.07	4100.0
2017-09-06 05:00:00	QQQ	ETF	145.0	145.07	144.77	145.02	2984.0
2017-09-06 06:00:00	QQQ	ETF	145.07	145.08	144.92	144.92	15062.0
2017-09-06 07:00:00	QQQ	ETF	145.03	145.15	144.98	145.15	38288.0
2017-09-06 08:00:00	QQQ	ETF	145.14	145.22	144.69	145.17	81191.0
2017-09-06 09:00:00	QQQ	ETF	145.17	145.34	144.77	144.99	2808725.0
2017-09-06 10:00:00	QQQ	ETF	144.98	145.17	144.23	144.61	4946717.0
2017-09-06 11:00:00	QQQ	ETF	144.6	144.71	144.08	144.67	2355430.0
2017-09-06 12:00:00	QQQ	ETF	144.66	145.0	144.58	144.99	2298713.0
2017-09-06 13:00:00	QQQ	ETF	144.99	145.17	144.97	145.04	1864350.0
2017-09-06 14:00:00	QQQ	ETF	145.045	145.34	145.04	145.165	2467471.0
2017-09-06 15:00:00	QQQ	ETF	145.18	145.46	145.07	145.12	5980850.0
2017-09-06 16:00:00	QQQ	ETF	145.12	145.2117	144.9479	145.13	4116917.0
2017-09-06 17:00:00	QQQ	ETF	145.16	145.16	144.4408	145.12	45225.0
2017-09-06 18:00:00	QQQ	ETF	145.08	145.08	144.69	144.85	33626.0
2017-09-06 19:00:00	QQQ	ETF	144.88	144.99	144.88	144.9	19472.0
2017-09-06 04:00:00	IWM	ETF	139.39	139.39	139.39	139.39	1995.0
2017-09-06 05:00:00	IWM	ETF	139.3	139.44	139.12	139.44	5431.0
2017-09-06 06:00:00	IWM	ETF	139.3	139.3	139.29	139.29	1160.0
2017-09-06 07:00:00	IWM	ETF	139.33	139.63	139.33	139.6	26058.0
2017-09-06 08:00:00	IWM	ETF	139.33	139.84	139.33	139.83	37580.0
2017-09-06 09:00:00	IWM	ETF	139.82	140.0	139.45	139.68	1350754.0
2017-09-06 10:00:00	IWM	ETF	139.68	139.98	139.44	139.61	3172687.0
2017-09-06 11:00:00	IWM	ETF	139.61	139.61	139.08	139.27	1503471.0
2017-09-06 12:00:00	IWM	ETF	139.27	139.35	139.12	139.31	1388840.0
2017-09-06 13:00:00	IWM	ETF	139.31	139.85	139.31	139.63	2020757.0
2017-09-06 14:00:00	IWM	ETF	139.635	139.779	139.46	139.55	1435996.0
2017-09-06 15:00:00	IWM	ETF	139.56	139.8	139.39	139.45	2888781.0
2017-09-06 16:00:00	IWM	ETF	139.46	139.52	139.34	139.34	1602940.0
2017-09-06 17:00:00	IWM	ETF	139.5413	139.5413	139.5413	139.5413	16062.0
2017-09-06 18:00:00	IWM	ETF	139.31	139.31	139.1	139.1	1800.0
2017-09-06 19:00:00	IWM	ETF	139.15	139.15	139.15	139.15	200.0
2017-09-06 04:00:00	DIA	ETF	217.9	217.9	217.9	217.9	100.0
2017-09-06 07:00:00	DIA	ETF	218.08	218.11	218.08	218.11	200.0

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

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