PREVIEW / etf_1hour / 2017-01-31

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-01-31.parquet
  size:    281 KB
  rows:    9,029

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-01-31 04:00:00	SPY	ETF	227.4	227.55	227.33	227.5	2632.0
2017-01-31 05:00:00	SPY	ETF	227.47	227.47	227.13	227.3	14377.0
2017-01-31 06:00:00	SPY	ETF	227.34	227.46	227.29	227.34	30699.0
2017-01-31 07:00:00	SPY	ETF	227.37	227.42	227.0	227.06	162678.0
2017-01-31 08:00:00	SPY	ETF	227.04	227.41	227.02	227.14	548577.0
2017-01-31 09:00:00	SPY	ETF	227.2	227.31	226.77	226.89	8383362.0
2017-01-31 10:00:00	SPY	ETF	226.89	227.05	226.51	226.615	11578453.0
2017-01-31 11:00:00	SPY	ETF	226.62	226.88	226.32	226.48	8126999.0
2017-01-31 12:00:00	SPY	ETF	226.49	226.93	226.47	226.8443	5126356.0
2017-01-31 13:00:00	SPY	ETF	226.85	226.88	226.44	226.5	4745718.0
2017-01-31 14:00:00	SPY	ETF	226.51	227.08	226.4201	227.03	9276292.0
2017-01-31 15:00:00	SPY	ETF	227.04	227.6	227.03	227.56	15616053.0
2017-01-31 16:00:00	SPY	ETF	227.57	227.87	227.5091	227.78	10164533.0
2017-01-31 17:00:00	SPY	ETF	227.79	227.85	227.53	227.83	256550.0
2017-01-31 18:00:00	SPY	ETF	227.81	227.88	227.53	227.68	412092.0
2017-01-31 19:00:00	SPY	ETF	227.68	227.81	227.63	227.81	19518.0
2017-01-31 04:00:00	QQQ	ETF	124.65	124.68	124.65	124.68	1893.0
2017-01-31 05:00:00	QQQ	ETF	124.54	124.6	124.52	124.6	8378.0
2017-01-31 06:00:00	QQQ	ETF	124.6	124.69	124.6	124.66	36104.0
2017-01-31 07:00:00	QQQ	ETF	124.63	124.69	124.47	124.49	28854.0
2017-01-31 08:00:00	QQQ	ETF	124.68	124.68	124.47	124.58	149919.0
2017-01-31 09:00:00	QQQ	ETF	124.57	124.58	124.151	124.29	2961976.0
2017-01-31 10:00:00	QQQ	ETF	124.285	124.48	124.02	124.1	3229257.0
2017-01-31 11:00:00	QQQ	ETF	124.11	124.2196	123.87	123.89	1925297.0
2017-01-31 12:00:00	QQQ	ETF	123.89	124.1493	123.85	124.07	1179788.0
2017-01-31 13:00:00	QQQ	ETF	124.07	124.17	123.921	123.96	1229643.0
2017-01-31 14:00:00	QQQ	ETF	123.96	124.33	123.9365	124.301	2073307.0
2017-01-31 15:00:00	QQQ	ETF	124.31	124.6	124.31	124.6	3563446.0
2017-01-31 16:00:00	QQQ	ETF	124.59	125.12	124.28	124.99	1158209.0
2017-01-31 17:00:00	QQQ	ETF	124.98	125.11	124.57	125.02	111978.0
2017-01-31 18:00:00	QQQ	ETF	125.08	125.09	124.9	124.91	70625.0
2017-01-31 19:00:00	QQQ	ETF	124.93	124.97	124.92	124.97	11239.0
2017-01-31 06:00:00	IWM	ETF	133.89	134.1	133.89	134.04	4900.0
2017-01-31 07:00:00	IWM	ETF	134.04	134.1	133.83	133.83	91819.0
2017-01-31 08:00:00	IWM	ETF	133.87	133.96	133.75	133.84	87214.0
2017-01-31 09:00:00	IWM	ETF	133.87	134.32	133.58	133.78	3654416.0
2017-01-31 10:00:00	IWM	ETF	133.775	134.42	133.48	134.24	4306557.0
2017-01-31 11:00:00	IWM	ETF	134.245	134.53	133.92	134.05	3391866.0
2017-01-31 12:00:00	IWM	ETF	134.06	134.46	134.04	134.39	1531062.0
2017-01-31 13:00:00	IWM	ETF	134.39	134.47	134.03	134.1973	1542563.0
2017-01-31 14:00:00	IWM	ETF	134.19	134.9	134.16	134.85	2666996.0
2017-01-31 15:00:00	IWM	ETF	134.86	135.56	134.86	135.18	7743623.0
2017-01-31 16:00:00	IWM	ETF	135.18	135.48	135.13	135.42	4542897.0
2017-01-31 17:00:00	IWM	ETF	135.41	135.41	135.23	135.23	125834.0
2017-01-31 18:00:00	IWM	ETF	135.37	135.4	135.33	135.33	8021.0
2017-01-31 19:00:00	IWM	ETF	135.39	135.48	135.35	135.48	2455.0
2017-01-31 07:00:00	DIA	ETF	199.01	199.01	198.91	198.91	600.0
2017-01-31 08:00:00	DIA	ETF	198.87	198.87	198.87	198.87	295.0
2017-01-31 09:00:00	DIA	ETF	198.96	198.96	198.4	198.51	530202.0
2017-01-31 10:00:00	DIA	ETF	198.5	198.53	197.79	197.88	989899.0

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

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