PREVIEW / etf_1hour / 2013-01-31

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-31.parquet
  size:    199 KB
  rows:    6,225

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
2013-01-31 04:00:00	SPY	ETF	149.8	149.89	149.75	149.84	1401.0
2013-01-31 05:00:00	SPY	ETF	149.86	149.98	149.75	149.75	34700.0
2013-01-31 06:00:00	SPY	ETF	149.76	149.78	149.6	149.78	50007.0
2013-01-31 07:00:00	SPY	ETF	149.74	149.96	149.73	149.87	546521.0
2013-01-31 08:00:00	SPY	ETF	149.86	150.01	149.54	149.87	3052868.0
2013-01-31 09:00:00	SPY	ETF	149.87	150.38	149.71	150.25	19752832.0
2013-01-31 10:00:00	SPY	ETF	150.25	150.27	149.89	149.89	16313301.0
2013-01-31 11:00:00	SPY	ETF	149.9	149.93	149.6	149.69	13948193.0
2013-01-31 12:00:00	SPY	ETF	149.69	150.06	149.69	150.03	9972766.0
2013-01-31 13:00:00	SPY	ETF	150.03	150.12	149.9	150.075	5464593.0
2013-01-31 14:00:00	SPY	ETF	150.08	150.22	149.93	150.105	6626442.0
2013-01-31 15:00:00	SPY	ETF	150.1	150.16	149.71	149.81	23571758.0
2013-01-31 16:00:00	SPY	ETF	149.83	150.1442	149.7	149.97	7609052.0
2013-01-31 17:00:00	SPY	ETF	149.96	150.01	149.89	149.93	274559.0
2013-01-31 18:00:00	SPY	ETF	149.94	150.15	149.94	150.12	400308.0
2013-01-31 19:00:00	SPY	ETF	150.12	150.19	150.09	150.15	101302.0
2013-01-31 04:00:00	QQQ	ETF	66.94	66.94	66.94	66.94	202.0
2013-01-31 05:00:00	QQQ	ETF	66.99	66.99	66.93	66.93	13600.0
2013-01-31 06:00:00	QQQ	ETF	66.84	66.92	66.84	66.89	32900.0
2013-01-31 07:00:00	QQQ	ETF	66.89	66.96	66.88	66.93	9207.0
2013-01-31 08:00:00	QQQ	ETF	66.89	66.93	66.83	66.89	1265044.0
2013-01-31 09:00:00	QQQ	ETF	66.92	67.35	66.91	67.3	5421643.0
2013-01-31 10:00:00	QQQ	ETF	67.29	67.315	67.01	67.01	3706791.0
2013-01-31 11:00:00	QQQ	ETF	67.02	67.03	66.81	66.89	4179262.0
2013-01-31 12:00:00	QQQ	ETF	66.89	67.05	66.8715	67.02	2981637.0
2013-01-31 13:00:00	QQQ	ETF	67.03	67.0399	66.93	67.0	848482.0
2013-01-31 14:00:00	QQQ	ETF	67.0	67.09	66.93	67.03	1871811.0
2013-01-31 15:00:00	QQQ	ETF	67.03	67.03	66.83	66.884	4859885.0
2013-01-31 16:00:00	QQQ	ETF	66.89	67.0338	66.8584	66.97	3634502.0
2013-01-31 17:00:00	QQQ	ETF	66.97	67.01	66.89	66.94	25912.0
2013-01-31 18:00:00	QQQ	ETF	66.98	67.06	66.87	67.06	30407.0
2013-01-31 19:00:00	QQQ	ETF	67.07	67.07	67.06	67.07	7000.0
2013-01-31 07:00:00	IWM	ETF	88.79	88.88	88.79	88.86	24399.0
2013-01-31 08:00:00	IWM	ETF	88.82	88.82	88.66	88.8	782687.0
2013-01-31 09:00:00	IWM	ETF	88.81	89.35	88.76	89.205	5445454.0
2013-01-31 10:00:00	IWM	ETF	89.2	89.5	89.045	89.38	4890321.0
2013-01-31 11:00:00	IWM	ETF	89.37	89.39	89.1	89.18	4565269.0
2013-01-31 12:00:00	IWM	ETF	89.18	89.6	89.18	89.53	3784538.0
2013-01-31 13:00:00	IWM	ETF	89.54	89.62	89.46	89.54	2041720.0
2013-01-31 14:00:00	IWM	ETF	89.54	89.6	89.455	89.515	1576713.0
2013-01-31 15:00:00	IWM	ETF	89.51	89.68	89.29	89.56	8333166.0
2013-01-31 16:00:00	IWM	ETF	89.55	89.77	89.22	89.69	2726997.0
2013-01-31 17:00:00	IWM	ETF	89.76	89.78	89.7	89.7	17500.0
2013-01-31 18:00:00	IWM	ETF	89.72	89.77	89.58	89.73	19833.0
2013-01-31 19:00:00	IWM	ETF	89.79	89.79	89.79	89.79	100.0
2013-01-31 08:00:00	DIA	ETF	138.68	138.68	138.44	138.66	59194.0
2013-01-31 09:00:00	DIA	ETF	138.69	140.22	138.51	139.08	680878.0
2013-01-31 10:00:00	DIA	ETF	139.06	139.12	138.73	138.73	832938.0
2013-01-31 11:00:00	DIA	ETF	138.73	138.73	138.41	138.43	680107.0
2013-01-31 12:00:00	DIA	ETF	138.42	138.68	138.42	138.65	333111.0

> showing 50 of 6,225 rows — these rows as CSV

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