PREVIEW / etf_1hour / 2016-07-26

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-26.parquet
  size:    251 KB
  rows:    8,085

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
2016-07-26 04:00:00	SPY	ETF	216.42	216.56	216.28	216.5	49069.0
2016-07-26 05:00:00	SPY	ETF	216.46	216.59	216.37	216.37	25934.0
2016-07-26 06:00:00	SPY	ETF	216.34	216.54	216.34	216.53	7826.0
2016-07-26 07:00:00	SPY	ETF	216.49	216.61	216.4	216.45	234450.0
2016-07-26 08:00:00	SPY	ETF	216.49	216.68	216.44	216.53	436893.0
2016-07-26 09:00:00	SPY	ETF	216.53	217.17	216.5	216.9411	7132718.0
2016-07-26 10:00:00	SPY	ETF	216.95	217.09	215.88	215.88	13739656.0
2016-07-26 11:00:00	SPY	ETF	215.885	216.56	215.76	216.47	12135047.0
2016-07-26 12:00:00	SPY	ETF	216.48	216.75	216.405	216.501	6667391.0
2016-07-26 13:00:00	SPY	ETF	216.5099	216.575	216.08	216.205	6738516.0
2016-07-26 14:00:00	SPY	ETF	216.205	216.56	216.0	216.34	7352765.0
2016-07-26 15:00:00	SPY	ETF	216.34	216.75	216.34	216.73	10368278.0
2016-07-26 16:00:00	SPY	ETF	216.73	217.01	216.54	217.0	3703506.0
2016-07-26 17:00:00	SPY	ETF	217.02	217.09	216.87	216.97	140810.0
2016-07-26 18:00:00	SPY	ETF	216.96	216.96	216.75	216.85	294082.0
2016-07-26 19:00:00	SPY	ETF	216.83	217.03	216.83	217.0	70586.0
2016-07-26 04:00:00	QQQ	ETF	113.53	113.53	113.45	113.53	500.0
2016-07-26 05:00:00	QQQ	ETF	113.57	113.58	113.57	113.58	300.0
2016-07-26 06:00:00	QQQ	ETF	113.56	113.56	113.56	113.56	100.0
2016-07-26 07:00:00	QQQ	ETF	113.56	113.63	113.56	113.63	56740.0
2016-07-26 08:00:00	QQQ	ETF	113.64	113.72	113.64	113.65	19545.0
2016-07-26 09:00:00	QQQ	ETF	113.65	114.129	113.61	114.11	2031014.0
2016-07-26 10:00:00	QQQ	ETF	114.115	114.2	113.29	113.29	3183816.0
2016-07-26 11:00:00	QQQ	ETF	113.28	113.69	113.22	113.65	2226258.0
2016-07-26 12:00:00	QQQ	ETF	113.65	113.83	113.6	113.7	1262403.0
2016-07-26 13:00:00	QQQ	ETF	113.69	113.73	113.38	113.5	1185142.0
2016-07-26 14:00:00	QQQ	ETF	113.5	113.84	113.355	113.6893	1824786.0
2016-07-26 15:00:00	QQQ	ETF	113.685	113.86	113.65	113.8	2651056.0
2016-07-26 16:00:00	QQQ	ETF	113.79	114.35	113.66	114.32	1439993.0
2016-07-26 17:00:00	QQQ	ETF	114.33	114.57	114.33	114.46	79755.0
2016-07-26 18:00:00	QQQ	ETF	114.46	114.46	114.32	114.41	93564.0
2016-07-26 19:00:00	QQQ	ETF	114.38	114.5	114.38	114.46	13726.0
2016-07-26 20:00:00	QQQ	ETF	113.7992	113.8002	113.7992	113.8002	292000.0
2016-07-26 07:00:00	IWM	ETF	120.2	120.2	120.16	120.2	51200.0
2016-07-26 08:00:00	IWM	ETF	120.17	120.29	120.17	120.19	64966.0
2016-07-26 09:00:00	IWM	ETF	120.18	120.92	120.17	120.78	2366136.0
2016-07-26 10:00:00	IWM	ETF	120.79	120.97	120.03	120.04	3308473.0
2016-07-26 11:00:00	IWM	ETF	120.045	120.81	119.92	120.67	3136358.0
2016-07-26 12:00:00	IWM	ETF	120.68	120.94	120.6041	120.72	1453991.0
2016-07-26 13:00:00	IWM	ETF	120.71	120.77	120.41	120.57	1474548.0
2016-07-26 14:00:00	IWM	ETF	120.57	120.785	120.425	120.655	1918531.0
2016-07-26 15:00:00	IWM	ETF	120.66	120.915	120.62	120.82	2989105.0
2016-07-26 16:00:00	IWM	ETF	120.82	121.09	120.73	121.05	1432682.0
2016-07-26 17:00:00	IWM	ETF	121.07	121.11	121.02	121.02	28747.0
2016-07-26 18:00:00	IWM	ETF	121.0	121.0	120.99	120.99	1100.0
2016-07-26 19:00:00	IWM	ETF	121.04	121.09	120.97	121.03	3480.0
2016-07-26 04:00:00	DIA	ETF	184.66	184.66	184.62	184.62	1242.0
2016-07-26 07:00:00	DIA	ETF	184.8	184.8	184.7	184.7	600.0
2016-07-26 08:00:00	DIA	ETF	184.58	184.6	184.56	184.56	1300.0
2016-07-26 09:00:00	DIA	ETF	184.68	185.02	184.56	184.84	377032.0

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

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