PREVIEW / etf_1hour / 2017-07-10

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-10.parquet
  size:    272 KB
  rows:    9,026

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-10 04:00:00	SPY	ETF	242.41	242.53	242.32	242.5	10359.0
2017-07-10 05:00:00	SPY	ETF	242.41	242.41	242.31	242.31	7708.0
2017-07-10 06:00:00	SPY	ETF	242.4	242.48	242.36	242.36	24077.0
2017-07-10 07:00:00	SPY	ETF	242.35	242.36	242.1	242.16	31826.0
2017-07-10 08:00:00	SPY	ETF	242.16	242.25	242.04	242.04	141201.0
2017-07-10 09:00:00	SPY	ETF	242.04	242.22	241.76	241.85	5817118.0
2017-07-10 10:00:00	SPY	ETF	241.85	242.46	241.83	242.455	5313423.0
2017-07-10 11:00:00	SPY	ETF	242.45	242.5699	242.37	242.54	3721421.0
2017-07-10 12:00:00	SPY	ETF	242.54	242.68	242.51	242.66	3126287.0
2017-07-10 13:00:00	SPY	ETF	242.66	242.74	242.56	242.71	2691920.0
2017-07-10 14:00:00	SPY	ETF	242.705	242.73	242.54	242.5501	2458180.0
2017-07-10 15:00:00	SPY	ETF	242.56	242.8	242.35	242.36	9608689.0
2017-07-10 16:00:00	SPY	ETF	242.36	242.4	242.21	242.22	2879191.0
2017-07-10 17:00:00	SPY	ETF	242.23	242.25	242.18	242.22	56679.0
2017-07-10 18:00:00	SPY	ETF	242.21	242.22	242.08	242.22	69762.0
2017-07-10 19:00:00	SPY	ETF	242.21	242.25	242.2	242.25	28860.0
2017-07-10 04:00:00	QQQ	ETF	138.18	138.29	138.15	138.18	9700.0
2017-07-10 05:00:00	QQQ	ETF	138.11	138.11	138.02	138.06	5042.0
2017-07-10 06:00:00	QQQ	ETF	138.11	138.2	138.11	138.16	14522.0
2017-07-10 07:00:00	QQQ	ETF	138.15	138.15	137.82	137.97	129286.0
2017-07-10 08:00:00	QQQ	ETF	137.88	138.1	137.74	137.78	131953.0
2017-07-10 09:00:00	QQQ	ETF	137.77	138.26	137.5	137.61	3583696.0
2017-07-10 10:00:00	QQQ	ETF	137.61	138.36	137.57	138.34	3267069.0
2017-07-10 11:00:00	QQQ	ETF	138.345	138.42	138.245	138.401	2177169.0
2017-07-10 12:00:00	QQQ	ETF	138.405	138.58	138.4	138.54	1618554.0
2017-07-10 13:00:00	QQQ	ETF	138.54	138.79	138.52	138.77	1298364.0
2017-07-10 14:00:00	QQQ	ETF	138.77	138.83	138.65	138.7	1625240.0
2017-07-10 15:00:00	QQQ	ETF	138.7	138.985	138.61	138.65	4927379.0
2017-07-10 16:00:00	QQQ	ETF	138.65	138.7597	138.0012	138.55	1753645.0
2017-07-10 17:00:00	QQQ	ETF	138.53	138.62	138.52	138.59	17097.0
2017-07-10 18:00:00	QQQ	ETF	138.53	138.55	138.44	138.55	25437.0
2017-07-10 19:00:00	QQQ	ETF	138.55	138.66	138.54	138.66	6987.0
2017-07-10 04:00:00	IWM	ETF	140.45	140.6	140.45	140.6	1900.0
2017-07-10 05:00:00	IWM	ETF	140.42	140.42	140.36	140.36	344.0
2017-07-10 06:00:00	IWM	ETF	140.49	140.49	140.46	140.46	400.0
2017-07-10 07:00:00	IWM	ETF	140.34	140.34	140.24	140.26	4697.0
2017-07-10 08:00:00	IWM	ETF	140.34	140.34	140.06	140.09	45143.0
2017-07-10 09:00:00	IWM	ETF	140.04	140.17	139.57	139.6	2650942.0
2017-07-10 10:00:00	IWM	ETF	139.59	139.86	139.37	139.71	2907126.0
2017-07-10 11:00:00	IWM	ETF	139.71	140.24	139.66	140.24	2092361.0
2017-07-10 12:00:00	IWM	ETF	140.23	140.74	140.23	140.74	1571405.0
2017-07-10 13:00:00	IWM	ETF	140.74	140.89	140.415	140.521	1262718.0
2017-07-10 14:00:00	IWM	ETF	140.53	140.6	140.08	140.15	1096421.0
2017-07-10 15:00:00	IWM	ETF	140.14	140.2	139.74	139.87	2756417.0
2017-07-10 16:00:00	IWM	ETF	139.87	140.0609	139.78	139.88	1344107.0
2017-07-10 17:00:00	IWM	ETF	139.87	139.88	139.73	139.88	20097.0
2017-07-10 18:00:00	IWM	ETF	139.81	139.88	139.81	139.88	2774.0
2017-07-10 19:00:00	IWM	ETF	139.81	139.81	139.81	139.81	200.0
2017-07-10 05:00:00	DIA	ETF	214.1	214.1	214.1	214.1	157.0
2017-07-10 07:00:00	DIA	ETF	214.11	214.11	214.08	214.08	300.0

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

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