PREVIEW / etf_1hour / 2017-06-05

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-05.parquet
  size:    274 KB
  rows:    9,064

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-05 04:00:00	SPY	ETF	243.97	244.09	243.93	244.05	15743.0
2017-06-05 05:00:00	SPY	ETF	244.05	244.15	244.02	244.02	3000.0
2017-06-05 06:00:00	SPY	ETF	244.03	244.05	243.92	243.95	17738.0
2017-06-05 07:00:00	SPY	ETF	243.93	244.01	243.84	243.91	115430.0
2017-06-05 08:00:00	SPY	ETF	243.88	243.96	243.86	243.91	85157.0
2017-06-05 09:00:00	SPY	ETF	243.91	244.13	243.76	244.1	4685215.0
2017-06-05 10:00:00	SPY	ETF	244.1	244.3	244.06	244.1	4954042.0
2017-06-05 11:00:00	SPY	ETF	244.1	244.14	243.86	244.105	4624696.0
2017-06-05 12:00:00	SPY	ETF	244.11	244.24	244.0144	244.115	4272255.0
2017-06-05 13:00:00	SPY	ETF	244.11	244.265	244.06	244.08	2479910.0
2017-06-05 14:00:00	SPY	ETF	244.08	244.16	244.02	244.085	2386434.0
2017-06-05 15:00:00	SPY	ETF	244.09	244.19	243.91	243.965	7248939.0
2017-06-05 16:00:00	SPY	ETF	243.97	244.21	243.82	243.9	9664766.0
2017-06-05 17:00:00	SPY	ETF	243.9	243.99	243.85	243.85	1089289.0
2017-06-05 18:00:00	SPY	ETF	243.85	243.89	243.82	243.89	19842.0
2017-06-05 19:00:00	SPY	ETF	243.89	243.89	243.86	243.88	13759.0
2017-06-05 04:00:00	QQQ	ETF	143.4	143.45	143.4	143.44	3155.0
2017-06-05 05:00:00	QQQ	ETF	143.44	143.52	143.44	143.52	350.0
2017-06-05 06:00:00	QQQ	ETF	143.44	143.44	143.4	143.42	8600.0
2017-06-05 07:00:00	QQQ	ETF	143.37	143.41	143.35	143.39	27234.0
2017-06-05 08:00:00	QQQ	ETF	143.37	143.42	143.35	143.39	51818.0
2017-06-05 09:00:00	QQQ	ETF	143.38	143.62	143.23	143.54	2078467.0
2017-06-05 10:00:00	QQQ	ETF	143.53	143.68	143.39	143.4	1595074.0
2017-06-05 11:00:00	QQQ	ETF	143.41	143.54	143.295	143.44	2476460.0
2017-06-05 12:00:00	QQQ	ETF	143.44	143.5	143.31	143.37	1316293.0
2017-06-05 13:00:00	QQQ	ETF	143.365	143.48	143.34	143.37	707255.0
2017-06-05 14:00:00	QQQ	ETF	143.36	143.49	143.35	143.42	720767.0
2017-06-05 15:00:00	QQQ	ETF	143.42	143.5	143.35	143.41	1930688.0
2017-06-05 16:00:00	QQQ	ETF	143.42	143.47	143.4	143.44	1055205.0
2017-06-05 17:00:00	QQQ	ETF	143.41	143.48	143.4	143.4	2881.0
2017-06-05 18:00:00	QQQ	ETF	143.42	143.47	143.41	143.46	3333.0
2017-06-05 19:00:00	QQQ	ETF	143.47	143.47	143.45	143.47	2597.0
2017-06-05 04:00:00	IWM	ETF	139.97	139.97	139.97	139.97	200.0
2017-06-05 07:00:00	IWM	ETF	139.86	139.86	139.81	139.84	8775.0
2017-06-05 08:00:00	IWM	ETF	139.79	139.92	139.79	139.88	36129.0
2017-06-05 09:00:00	IWM	ETF	139.85	140.11	139.53	139.66	2917248.0
2017-06-05 10:00:00	IWM	ETF	139.66	140.01	139.575	139.63	2852914.0
2017-06-05 11:00:00	IWM	ETF	139.63	139.63	138.95	139.29	2704645.0
2017-06-05 12:00:00	IWM	ETF	139.3	139.52	139.24	139.51	1426264.0
2017-06-05 13:00:00	IWM	ETF	139.5	139.64	139.375	139.46	1264301.0
2017-06-05 14:00:00	IWM	ETF	139.475	139.62	139.35	139.53	1173577.0
2017-06-05 15:00:00	IWM	ETF	139.52	139.5266	138.96	138.99	3685317.0
2017-06-05 16:00:00	IWM	ETF	139.0	139.0	138.66	138.73	816985.0
2017-06-05 17:00:00	IWM	ETF	138.71	138.71	138.71	138.71	1500.0
2017-06-05 18:00:00	IWM	ETF	138.72	138.82	138.71	138.8	2560.0
2017-06-05 19:00:00	IWM	ETF	138.76	138.76	138.74	138.74	1400.0
2017-06-05 07:00:00	DIA	ETF	211.85	211.87	211.85	211.87	200.0
2017-06-05 08:00:00	DIA	ETF	211.8	211.85	211.8	211.85	300.0
2017-06-05 09:00:00	DIA	ETF	211.85	212.07	211.64	212.01	211315.0
2017-06-05 10:00:00	DIA	ETF	212.03	212.205	211.9501	212.0384	174083.0

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

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