PREVIEW / etf_1hour / 2017-04-25

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-04-25.parquet
  size:    283 KB
  rows:    9,168

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-04-25 04:00:00	SPY	ETF	237.26	237.36	237.21	237.33	3180.0
2017-04-25 05:00:00	SPY	ETF	237.33	237.35	237.26	237.28	4636.0
2017-04-25 06:00:00	SPY	ETF	237.3	237.43	237.28	237.4	84742.0
2017-04-25 07:00:00	SPY	ETF	237.41	237.5	237.41	237.46	148343.0
2017-04-25 08:00:00	SPY	ETF	237.45	237.88	237.43	237.84	812213.0
2017-04-25 09:00:00	SPY	ETF	237.84	238.43	237.81	238.39	9383987.0
2017-04-25 10:00:00	SPY	ETF	238.39	238.75	238.3201	238.38	10543576.0
2017-04-25 11:00:00	SPY	ETF	238.38	238.62	238.335	238.565	8211137.0
2017-04-25 12:00:00	SPY	ETF	238.57	238.66	238.29	238.39	5809194.0
2017-04-25 13:00:00	SPY	ETF	238.4	238.71	238.36	238.64	7686779.0
2017-04-25 14:00:00	SPY	ETF	238.64	238.82	238.57	238.6247	7047342.0
2017-04-25 15:00:00	SPY	ETF	238.625	238.95	238.53	238.53	17001304.0
2017-04-25 16:00:00	SPY	ETF	238.53	238.61	238.37	238.42	6637662.0
2017-04-25 17:00:00	SPY	ETF	238.4	238.577	238.36	238.36	794147.0
2017-04-25 18:00:00	SPY	ETF	238.36	238.547	238.3	238.34	638813.0
2017-04-25 19:00:00	SPY	ETF	238.35	238.39	238.34	238.36	48057.0
2017-04-25 20:00:00	SPY	ETF	238.55	238.55	238.5461	238.5461	233000.0
2017-04-25 04:00:00	QQQ	ETF	134.27	134.27	134.21	134.21	949.0
2017-04-25 05:00:00	QQQ	ETF	134.23	134.27	134.23	134.27	600.0
2017-04-25 06:00:00	QQQ	ETF	134.3	134.31	134.28	134.3	900.0
2017-04-25 07:00:00	QQQ	ETF	134.32	134.38	134.32	134.38	36924.0
2017-04-25 08:00:00	QQQ	ETF	134.34	134.55	134.31	134.55	78488.0
2017-04-25 09:00:00	QQQ	ETF	134.53	134.69	134.48	134.63	3417999.0
2017-04-25 10:00:00	QQQ	ETF	134.62	134.91	134.61	134.79	3438366.0
2017-04-25 11:00:00	QQQ	ETF	134.785	135.04	134.75	135.03	1201943.0
2017-04-25 12:00:00	QQQ	ETF	135.025	135.13	134.96	135.0	1359604.0
2017-04-25 13:00:00	QQQ	ETF	135.0056	135.2	134.99	135.12	1028756.0
2017-04-25 14:00:00	QQQ	ETF	135.12	135.22	135.09	135.14	1077365.0
2017-04-25 15:00:00	QQQ	ETF	135.1341	135.3664	135.11	135.13	3901199.0
2017-04-25 16:00:00	QQQ	ETF	135.12	135.19	135.05	135.15	547223.0
2017-04-25 17:00:00	QQQ	ETF	135.12	135.14	135.09	135.13	8249.0
2017-04-25 18:00:00	QQQ	ETF	135.1	135.11	135.07	135.09	9892.0
2017-04-25 19:00:00	QQQ	ETF	135.1	135.13	135.1	135.1	3966.0
2017-04-25 04:00:00	IWM	ETF	139.12	139.35	139.12	139.35	885.0
2017-04-25 05:00:00	IWM	ETF	139.28	139.32	139.28	139.32	300.0
2017-04-25 06:00:00	IWM	ETF	139.31	139.35	139.31	139.35	400.0
2017-04-25 07:00:00	IWM	ETF	139.38	139.56	139.38	139.56	74799.0
2017-04-25 08:00:00	IWM	ETF	139.55	139.97	139.52	139.91	566268.0
2017-04-25 09:00:00	IWM	ETF	139.9	140.63	139.9	140.5	6092189.0
2017-04-25 10:00:00	IWM	ETF	140.49	140.88	140.25	140.26	5120475.0
2017-04-25 11:00:00	IWM	ETF	140.265	140.66	140.21	140.63	2229997.0
2017-04-25 12:00:00	IWM	ETF	140.635	140.6764	140.39	140.42	1631805.0
2017-04-25 13:00:00	IWM	ETF	140.42	140.69	140.37	140.63	1536677.0
2017-04-25 14:00:00	IWM	ETF	140.62	140.81	140.51	140.57	2105768.0
2017-04-25 15:00:00	IWM	ETF	140.5666	140.75	140.2	140.24	5248957.0
2017-04-25 16:00:00	IWM	ETF	140.27	140.4	140.13	140.21	993684.0
2017-04-25 17:00:00	IWM	ETF	140.21	140.33	140.2	140.23	5326.0
2017-04-25 18:00:00	IWM	ETF	140.22	140.27	140.2	140.26	1138568.0
2017-04-25 19:00:00	IWM	ETF	140.27	140.27	140.25	140.25	855.0
2017-04-25 07:00:00	DIA	ETF	207.82	208.56	207.82	208.56	11427.0

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

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