PREVIEW / etf_1hour / 2017-06-15

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-15.parquet
  size:    277 KB
  rows:    9,072

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-06-15 04:00:00	SPY	ETF	243.29	243.32	242.94	242.94	30056.0
2017-06-15 05:00:00	SPY	ETF	242.95	243.2	242.76	242.77	55542.0
2017-06-15 06:00:00	SPY	ETF	242.71	242.75	242.35	242.75	146283.0
2017-06-15 07:00:00	SPY	ETF	242.74	242.84	242.62	242.7	672321.0
2017-06-15 08:00:00	SPY	ETF	244.24	244.24	242.47	242.83	756422.0
2017-06-15 09:00:00	SPY	ETF	242.83	243.13	242.52	243.0	9188077.0
2017-06-15 10:00:00	SPY	ETF	243.0	243.22	242.36	242.98	9671348.0
2017-06-15 11:00:00	SPY	ETF	242.9734	243.54	242.92	243.18	7816446.0
2017-06-15 12:00:00	SPY	ETF	243.18	243.44	243.04	243.408	4281139.0
2017-06-15 13:00:00	SPY	ETF	243.41	243.62	243.21	243.3299	5319893.0
2017-06-15 14:00:00	SPY	ETF	243.322	243.77	243.26	243.635	6784272.0
2017-06-15 15:00:00	SPY	ETF	243.63	243.91	243.42	243.79	13495814.0
2017-06-15 16:00:00	SPY	ETF	243.79	243.99	242.7327	243.88	5359323.0
2017-06-15 17:00:00	SPY	ETF	243.88	243.89	243.76	243.8	1433971.0
2017-06-15 18:00:00	SPY	ETF	243.83	243.84	243.74	243.74	48811.0
2017-06-15 19:00:00	SPY	ETF	243.73	243.95	243.72	243.92	37171.0
2017-06-15 04:00:00	QQQ	ETF	138.46	138.54	138.1	138.1	28375.0
2017-06-15 05:00:00	QQQ	ETF	138.14	138.36	138.04	138.16	35381.0
2017-06-15 06:00:00	QQQ	ETF	138.17	138.28	137.97	138.27	52909.0
2017-06-15 07:00:00	QQQ	ETF	138.29	138.4	138.25	138.28	315778.0
2017-06-15 08:00:00	QQQ	ETF	138.29	138.49	138.13	138.49	537712.0
2017-06-15 09:00:00	QQQ	ETF	138.48	138.64	137.63	138.12	8109581.0
2017-06-15 10:00:00	QQQ	ETF	138.11	138.28	137.49	138.232	11335470.0
2017-06-15 11:00:00	QQQ	ETF	138.23	138.6	138.115	138.2266	6617389.0
2017-06-15 12:00:00	QQQ	ETF	138.23	138.76	138.1757	138.7	2781225.0
2017-06-15 13:00:00	QQQ	ETF	138.7	138.8899	138.43	138.59	3611921.0
2017-06-15 14:00:00	QQQ	ETF	138.59	139.135	138.51	138.97	4333840.0
2017-06-15 15:00:00	QQQ	ETF	138.97	139.28	138.88	139.12	8441810.0
2017-06-15 16:00:00	QQQ	ETF	139.12	139.21	137.9125	139.19	1858084.0
2017-06-15 17:00:00	QQQ	ETF	139.15	139.17	139.1	139.12	863802.0
2017-06-15 18:00:00	QQQ	ETF	139.1	139.19	139.0	139.0	9117.0
2017-06-15 19:00:00	QQQ	ETF	139.03	139.19	139.03	139.1	10544.0
2017-06-15 04:00:00	IWM	ETF	140.41	140.41	139.8	139.8	9629.0
2017-06-15 05:00:00	IWM	ETF	139.84	140.03	139.72	139.72	13904.0
2017-06-15 06:00:00	IWM	ETF	139.7	139.7	139.56	139.56	7400.0
2017-06-15 07:00:00	IWM	ETF	139.77	139.86	139.66	139.71	85354.0
2017-06-15 08:00:00	IWM	ETF	141.26	141.26	139.55	139.83	80271.0
2017-06-15 09:00:00	IWM	ETF	139.77	140.78	139.69	140.74	5182937.0
2017-06-15 10:00:00	IWM	ETF	140.74	140.98	139.73	140.03	4943131.0
2017-06-15 11:00:00	IWM	ETF	140.03	140.39	140.0	140.07	1940357.0
2017-06-15 12:00:00	IWM	ETF	140.08	140.32	139.96	140.3	1303459.0
2017-06-15 13:00:00	IWM	ETF	140.3	140.54	140.12	140.2486	1524645.0
2017-06-15 14:00:00	IWM	ETF	140.24	140.36	140.1	140.23	1559236.0
2017-06-15 15:00:00	IWM	ETF	140.23	140.56	140.09	140.55	3891530.0
2017-06-15 16:00:00	IWM	ETF	140.54	140.79	140.3755	140.54	2600415.0
2017-06-15 17:00:00	IWM	ETF	140.6	140.6	140.6	140.6	100.0
2017-06-15 18:00:00	IWM	ETF	140.68	140.68	140.62	140.62	624.0
2017-06-15 19:00:00	IWM	ETF	140.65	140.68	140.64	140.68	1700.0
2017-06-15 04:00:00	DIA	ETF	213.37	213.37	213.21	213.21	5300.0
2017-06-15 05:00:00	DIA	ETF	213.24	213.31	213.24	213.31	300.0

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

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