PREVIEW / etf_1hour / 2017-06-13

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-13.parquet
  size:    273 KB
  rows:    8,926

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-06-13 04:00:00	SPY	ETF	243.77	243.97	243.77	243.86	25830.0
2017-06-13 05:00:00	SPY	ETF	243.83	243.83	243.68	243.68	6500.0
2017-06-13 06:00:00	SPY	ETF	243.75	243.79	243.68	243.72	4640.0
2017-06-13 07:00:00	SPY	ETF	243.68	243.75	243.68	243.7	73036.0
2017-06-13 08:00:00	SPY	ETF	243.7	243.89	243.64	243.85	252248.0
2017-06-13 09:00:00	SPY	ETF	243.89	244.28	243.87	244.06	7126615.0
2017-06-13 10:00:00	SPY	ETF	244.065	244.16	243.66	243.68	8381785.0
2017-06-13 11:00:00	SPY	ETF	243.68	244.211	243.5799	244.15	6894114.0
2017-06-13 12:00:00	SPY	ETF	244.145	244.38	244.05	244.35	4297573.0
2017-06-13 13:00:00	SPY	ETF	244.355	244.45	244.14	244.31	3814921.0
2017-06-13 14:00:00	SPY	ETF	244.315	244.53	244.245	244.32	6531585.0
2017-06-13 15:00:00	SPY	ETF	244.325	244.61	244.23	244.52	14788753.0
2017-06-13 16:00:00	SPY	ETF	244.51	244.56	244.4	244.5	6104180.0
2017-06-13 17:00:00	SPY	ETF	244.5	244.64	243.795	244.62	360454.0
2017-06-13 18:00:00	SPY	ETF	244.56	244.56	244.5	244.52	172980.0
2017-06-13 19:00:00	SPY	ETF	244.53	244.55	244.48	244.54	65214.0
2017-06-13 04:00:00	QQQ	ETF	139.6	139.74	139.6	139.73	7384.0
2017-06-13 05:00:00	QQQ	ETF	139.67	139.69	139.53	139.57	12458.0
2017-06-13 06:00:00	QQQ	ETF	139.59	139.67	139.59	139.65	8404.0
2017-06-13 07:00:00	QQQ	ETF	139.63	139.77	139.57	139.77	85917.0
2017-06-13 08:00:00	QQQ	ETF	139.78	139.96	139.61	139.89	353126.0
2017-06-13 09:00:00	QQQ	ETF	139.89	140.55	139.87	140.3	8746085.0
2017-06-13 10:00:00	QQQ	ETF	140.31	140.3256	139.43	139.46	8230292.0
2017-06-13 11:00:00	QQQ	ETF	139.465	140.1	139.28	140.09	5271626.0
2017-06-13 12:00:00	QQQ	ETF	140.085	140.29	139.92	140.27	4266133.0
2017-06-13 13:00:00	QQQ	ETF	140.27	140.29	139.9	140.12	3772843.0
2017-06-13 14:00:00	QQQ	ETF	140.12	140.25	140.03	140.2	3196467.0
2017-06-13 15:00:00	QQQ	ETF	140.19	140.56	140.15	140.35	6869805.0
2017-06-13 16:00:00	QQQ	ETF	140.34	140.42	140.28	140.42	2508611.0
2017-06-13 17:00:00	QQQ	ETF	140.44	140.5036	140.29	140.45	85713.0
2017-06-13 18:00:00	QQQ	ETF	140.42	140.42	140.38	140.38	13854.0
2017-06-13 19:00:00	QQQ	ETF	140.39	140.42	140.36	140.42	11657.0
2017-06-13 04:00:00	IWM	ETF	141.9	141.9	141.74	141.74	1400.0
2017-06-13 05:00:00	IWM	ETF	141.72	141.72	141.61	141.63	700.0
2017-06-13 06:00:00	IWM	ETF	141.6	141.6	141.56	141.59	6100.0
2017-06-13 07:00:00	IWM	ETF	141.58	141.64	141.55	141.59	17627.0
2017-06-13 08:00:00	IWM	ETF	141.61	141.76	141.5	141.73	79903.0
2017-06-13 09:00:00	IWM	ETF	141.69	141.9556	141.47	141.69	2736964.0
2017-06-13 10:00:00	IWM	ETF	141.69	141.87	141.48	141.581	3221976.0
2017-06-13 11:00:00	IWM	ETF	141.58	142.31	141.53	141.97	2888622.0
2017-06-13 12:00:00	IWM	ETF	141.97	142.0	141.59	141.83	1848718.0
2017-06-13 13:00:00	IWM	ETF	141.83	142.0057	141.64	141.94	1677411.0
2017-06-13 14:00:00	IWM	ETF	141.94	142.1	141.73	141.835	1577668.0
2017-06-13 15:00:00	IWM	ETF	141.83	142.1	141.78	142.09	3146780.0
2017-06-13 16:00:00	IWM	ETF	142.08	142.2	142.06	142.19	924750.0
2017-06-13 17:00:00	IWM	ETF	142.18	142.18	141.8999	142.15	30050.0
2017-06-13 18:00:00	IWM	ETF	142.1	142.19	142.1	142.19	1522.0
2017-06-13 19:00:00	IWM	ETF	142.1	142.15	142.1	142.15	800.0
2017-06-13 04:00:00	DIA	ETF	212.7	212.7	212.62	212.62	1100.0
2017-06-13 05:00:00	DIA	ETF	212.62	212.62	212.62	212.62	100.0

> showing 50 of 8,926 rows — these rows as CSV

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