PREVIEW / etf_1hour / 2017-07-11

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-11.parquet
  size:    274 KB
  rows:    9,063

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-11 04:00:00	SPY	ETF	242.15	242.15	242.15	242.15	150.0
2017-07-11 05:00:00	SPY	ETF	242.24	242.25	242.14	242.15	2983.0
2017-07-11 06:00:00	SPY	ETF	242.06	242.15	242.02	242.14	10432.0
2017-07-11 07:00:00	SPY	ETF	242.1	242.1	241.99	242.02	44155.0
2017-07-11 08:00:00	SPY	ETF	242.01	242.13	242.0	242.12	90548.0
2017-07-11 09:00:00	SPY	ETF	242.09	242.265	241.89	242.0211	3263463.0
2017-07-11 10:00:00	SPY	ETF	242.03	242.4	241.96	242.37	4728213.0
2017-07-11 11:00:00	SPY	ETF	242.37	242.4	240.85	241.81	14033677.0
2017-07-11 12:00:00	SPY	ETF	241.81	241.95	241.47	241.82	4087852.0
2017-07-11 13:00:00	SPY	ETF	241.825	242.2799	241.63	242.22	2996186.0
2017-07-11 14:00:00	SPY	ETF	242.23	242.375	242.06	242.145	4862494.0
2017-07-11 15:00:00	SPY	ETF	242.15	242.55	242.04	242.16	11491735.0
2017-07-11 16:00:00	SPY	ETF	242.17	242.35	242.1402	242.35	4076210.0
2017-07-11 17:00:00	SPY	ETF	242.34	242.36	242.3	242.32	59031.0
2017-07-11 18:00:00	SPY	ETF	242.31	242.42	242.3	242.42	54259.0
2017-07-11 19:00:00	SPY	ETF	242.42	242.48	242.33	242.35	51125.0
2017-07-11 04:00:00	QQQ	ETF	138.51	138.53	138.49	138.53	1898.0
2017-07-11 05:00:00	QQQ	ETF	138.45	138.55	138.45	138.5	4100.0
2017-07-11 06:00:00	QQQ	ETF	138.43	138.53	138.4	138.53	4030.0
2017-07-11 07:00:00	QQQ	ETF	138.53	138.53	138.31	138.33	35962.0
2017-07-11 08:00:00	QQQ	ETF	138.35	138.41	138.31	138.33	99127.0
2017-07-11 09:00:00	QQQ	ETF	138.3	138.7	138.23	138.6768	2118409.0
2017-07-11 10:00:00	QQQ	ETF	138.68	139.15	138.57	138.94	3133469.0
2017-07-11 11:00:00	QQQ	ETF	138.94	139.0401	137.94	138.61	5923226.0
2017-07-11 12:00:00	QQQ	ETF	138.615	138.69	138.26	138.6	2495364.0
2017-07-11 13:00:00	QQQ	ETF	138.61	138.96	138.52	138.94	1992121.0
2017-07-11 14:00:00	QQQ	ETF	138.9446	139.11	138.88	138.92	2233996.0
2017-07-11 15:00:00	QQQ	ETF	138.91	139.22	138.88	139.03	4197194.0
2017-07-11 16:00:00	QQQ	ETF	139.03	139.26	138.9951	139.05	4992258.0
2017-07-11 17:00:00	QQQ	ETF	139.17	139.24	139.15	139.17	3716.0
2017-07-11 18:00:00	QQQ	ETF	139.17	139.25	139.17	139.25	5717.0
2017-07-11 19:00:00	QQQ	ETF	139.25	139.25	139.17	139.17	1202.0
2017-07-11 04:00:00	IWM	ETF	139.76	139.76	139.76	139.76	100.0
2017-07-11 05:00:00	IWM	ETF	139.77	139.78	139.58	139.58	5883.0
2017-07-11 06:00:00	IWM	ETF	139.54	139.63	139.54	139.63	8819.0
2017-07-11 07:00:00	IWM	ETF	139.5	139.51	139.41	139.43	13245.0
2017-07-11 08:00:00	IWM	ETF	139.45	139.66	139.43	139.66	57436.0
2017-07-11 09:00:00	IWM	ETF	139.7	140.04	139.5	139.91	1237291.0
2017-07-11 10:00:00	IWM	ETF	139.92	140.37	139.78	140.35	1626761.0
2017-07-11 11:00:00	IWM	ETF	140.35	140.38	138.98	140.03	3994390.0
2017-07-11 12:00:00	IWM	ETF	140.04	140.22	139.86	140.033	1743358.0
2017-07-11 13:00:00	IWM	ETF	140.04	140.14	139.765	140.04	942030.0
2017-07-11 14:00:00	IWM	ETF	140.035	140.14	139.9	140.07	1289858.0
2017-07-11 15:00:00	IWM	ETF	140.07	140.35	140.05	140.29	2607020.0
2017-07-11 16:00:00	IWM	ETF	140.29	140.33	140.19	140.32	367522.0
2017-07-11 17:00:00	IWM	ETF	139.8113	140.34	139.8113	140.34	505870.0
2017-07-11 19:00:00	IWM	ETF	140.33	140.37	140.32	140.36	5225.0
2017-07-11 08:00:00	DIA	ETF	213.85	213.85	213.84	213.84	200.0
2017-07-11 09:00:00	DIA	ETF	213.91	214.09	213.87	213.91	87452.0
2017-07-11 10:00:00	DIA	ETF	213.9	214.28	213.83	214.26	163467.0

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

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