PREVIEW / etf_1hour / 2016-03-16

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-16.parquet
  size:    246 KB
  rows:    7,897

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-03-16 04:00:00	SPY	ETF	202.27	202.52	202.27	202.51	8937.0
2016-03-16 05:00:00	SPY	ETF	202.49	202.49	202.42	202.43	4426.0
2016-03-16 06:00:00	SPY	ETF	202.46	202.48	202.18	202.23	32776.0
2016-03-16 07:00:00	SPY	ETF	202.15	202.23	201.98	202.04	112316.0
2016-03-16 08:00:00	SPY	ETF	202.05	202.15	201.41	201.47	886847.0
2016-03-16 09:00:00	SPY	ETF	201.47	202.41	201.28	202.19	8900608.0
2016-03-16 10:00:00	SPY	ETF	202.19	202.5	202.1	202.325	10479104.0
2016-03-16 11:00:00	SPY	ETF	202.33	202.4861	202.2	202.24	8408940.0
2016-03-16 12:00:00	SPY	ETF	202.25	202.405	201.845	201.92	6537254.0
2016-03-16 13:00:00	SPY	ETF	201.92	202.01	201.55	201.77	8158968.0
2016-03-16 14:00:00	SPY	ETF	201.77	203.72	201.765	202.83	42208079.0
2016-03-16 15:00:00	SPY	ETF	202.83	203.82	202.79	203.4	28926477.0
2016-03-16 16:00:00	SPY	ETF	203.4	203.41	202.1738	203.3	7858550.0
2016-03-16 17:00:00	SPY	ETF	203.3	203.34	203.13	203.2	1314174.0
2016-03-16 18:00:00	SPY	ETF	203.21	203.32	203.15	203.3	157176.0
2016-03-16 19:00:00	SPY	ETF	203.25	203.55	203.22	203.5	224338.0
2016-03-16 04:00:00	QQQ	ETF	106.81	106.83	106.81	106.83	200.0
2016-03-16 07:00:00	QQQ	ETF	106.63	106.63	106.56	106.56	9618.0
2016-03-16 08:00:00	QQQ	ETF	106.62	106.67	106.29	106.31	218590.0
2016-03-16 09:00:00	QQQ	ETF	106.3	106.82	106.23	106.76	2053336.0
2016-03-16 10:00:00	QQQ	ETF	106.76	106.92	106.6999	106.84	1645524.0
2016-03-16 11:00:00	QQQ	ETF	106.83	107.0339	106.7701	106.9599	1450831.0
2016-03-16 12:00:00	QQQ	ETF	106.96	107.08	106.61	106.645	1325973.0
2016-03-16 13:00:00	QQQ	ETF	106.64	106.71	106.46	106.69	1670063.0
2016-03-16 14:00:00	QQQ	ETF	106.7	107.68	106.7	107.26	8454117.0
2016-03-16 15:00:00	QQQ	ETF	107.25	107.86	107.24	107.58	7020767.0
2016-03-16 16:00:00	QQQ	ETF	107.58	107.75	106.6504	107.43	1495719.0
2016-03-16 17:00:00	QQQ	ETF	107.43	107.58	107.3	107.58	1045652.0
2016-03-16 18:00:00	QQQ	ETF	107.35	107.42	107.14	107.4	74260.0
2016-03-16 19:00:00	QQQ	ETF	107.44	107.51	107.43	107.51	27100.0
2016-03-16 07:00:00	IWM	ETF	106.0	106.0	105.9	105.9	698.0
2016-03-16 08:00:00	IWM	ETF	105.92	105.97	105.6	105.63	264943.0
2016-03-16 09:00:00	IWM	ETF	105.58	106.54	105.58	106.45	2454146.0
2016-03-16 10:00:00	IWM	ETF	106.45	106.99	106.44	106.84	3625099.0
2016-03-16 11:00:00	IWM	ETF	106.84	106.9	106.18	106.24	2562764.0
2016-03-16 12:00:00	IWM	ETF	106.24	106.59	106.23	106.37	2544983.0
2016-03-16 13:00:00	IWM	ETF	106.36	106.42	106.1299	106.3	2525282.0
2016-03-16 14:00:00	IWM	ETF	106.32	107.33	106.06	106.55	8887183.0
2016-03-16 15:00:00	IWM	ETF	106.55	107.17	106.54	106.97	7375150.0
2016-03-16 16:00:00	IWM	ETF	106.99	106.99	106.78	106.82	1844919.0
2016-03-16 17:00:00	IWM	ETF	106.85	106.85	106.79	106.79	1190.0
2016-03-16 19:00:00	IWM	ETF	106.85	106.99	106.81	106.92	11400.0
2016-03-16 08:00:00	DIA	ETF	172.5	172.55	172.2	172.2	1301.0
2016-03-16 09:00:00	DIA	ETF	172.23	172.74	172.15	172.55	255634.0
2016-03-16 10:00:00	DIA	ETF	172.55	172.82	172.48	172.75	234037.0
2016-03-16 11:00:00	DIA	ETF	172.76	172.88	172.65	172.7	164022.0
2016-03-16 12:00:00	DIA	ETF	172.73	172.79	172.368	172.41	161095.0
2016-03-16 13:00:00	DIA	ETF	172.4	172.56	172.165	172.56	190864.0
2016-03-16 14:00:00	DIA	ETF	172.54	173.94	172.36	173.24	1451570.0
2016-03-16 15:00:00	DIA	ETF	173.24	173.89	173.23	173.46	914609.0

> showing 50 of 7,897 rows — these rows as CSV

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