PREVIEW / etf_1hour / 2016-09-15

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-15.parquet
  size:    254 KB
  rows:    8,116

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-09-15 04:00:00	SPY	ETF	212.75	213.04	212.73	213.04	16629.0
2016-09-15 05:00:00	SPY	ETF	213.01	213.39	212.94	213.31	18585.0
2016-09-15 06:00:00	SPY	ETF	213.31	213.62	213.16	213.53	98760.0
2016-09-15 07:00:00	SPY	ETF	213.52	213.53	213.04	213.39	310022.0
2016-09-15 08:00:00	SPY	ETF	213.36	213.75	212.38	212.93	1524020.0
2016-09-15 09:00:00	SPY	ETF	212.94	213.6	212.63	213.39	17060774.0
2016-09-15 10:00:00	SPY	ETF	213.39	214.45	213.13	214.4392	18156121.0
2016-09-15 11:00:00	SPY	ETF	214.43	215.08	214.4	214.72	23276240.0
2016-09-15 12:00:00	SPY	ETF	214.71	214.96	214.33	214.5	9377834.0
2016-09-15 13:00:00	SPY	ETF	214.5	215.35	214.44	215.35	10980179.0
2016-09-15 14:00:00	SPY	ETF	215.35	215.73	215.28	215.52	18120799.0
2016-09-15 15:00:00	SPY	ETF	215.53	215.7	215.16	215.29	26446807.0
2016-09-15 16:00:00	SPY	ETF	215.29	215.55	214.7842	215.0	15784213.0
2016-09-15 17:00:00	SPY	ETF	214.97	215.3001	214.94	215.01	1274429.0
2016-09-15 18:00:00	SPY	ETF	215.01	215.05	213.1207	214.75	815507.0
2016-09-15 19:00:00	SPY	ETF	214.74	214.87	214.67	214.67	62518.0
2016-09-15 04:00:00	QQQ	ETF	115.68	115.68	115.68	115.68	2500.0
2016-09-15 05:00:00	QQQ	ETF	115.82	115.82	115.8	115.81	1700.0
2016-09-15 06:00:00	QQQ	ETF	115.91	115.96	115.88	115.96	30289.0
2016-09-15 07:00:00	QQQ	ETF	115.96	115.96	115.78	115.95	69967.0
2016-09-15 08:00:00	QQQ	ETF	115.95	116.17	115.78	115.89	330721.0
2016-09-15 09:00:00	QQQ	ETF	115.86	116.37	115.72	116.29	3724162.0
2016-09-15 10:00:00	QQQ	ETF	116.29	117.1139	116.13	117.1	4378678.0
2016-09-15 11:00:00	QQQ	ETF	117.1	117.3665	117.06	117.18	3417542.0
2016-09-15 12:00:00	QQQ	ETF	117.1723	117.41	117.09	117.15	2741464.0
2016-09-15 13:00:00	QQQ	ETF	117.16	117.6	117.1	117.589	3216976.0
2016-09-15 14:00:00	QQQ	ETF	117.59	117.78	117.53	117.72	2130589.0
2016-09-15 15:00:00	QQQ	ETF	117.73	117.815	117.54	117.66	5489095.0
2016-09-15 16:00:00	QQQ	ETF	117.6601	117.6601	117.47	117.54	1204927.0
2016-09-15 17:00:00	QQQ	ETF	117.5	117.74	117.5	117.54	622889.0
2016-09-15 18:00:00	QQQ	ETF	117.53	117.56	117.3	117.4	88586.0
2016-09-15 19:00:00	QQQ	ETF	117.4	117.46	117.34	117.34	21423.0
2016-09-15 05:00:00	IWM	ETF	120.71	120.71	120.71	120.71	1000.0
2016-09-15 07:00:00	IWM	ETF	120.88	120.89	120.71	120.89	7837.0
2016-09-15 08:00:00	IWM	ETF	120.86	121.13	120.66	120.67	153883.0
2016-09-15 09:00:00	IWM	ETF	120.65	121.13	120.44	120.99	3705220.0
2016-09-15 10:00:00	IWM	ETF	121.0	121.63	120.79	121.61	4522921.0
2016-09-15 11:00:00	IWM	ETF	121.62	121.98	121.54	121.69	3727569.0
2016-09-15 12:00:00	IWM	ETF	121.7	121.87	121.455	121.65	1935581.0
2016-09-15 13:00:00	IWM	ETF	121.65	122.02	121.52	122.0	2372289.0
2016-09-15 14:00:00	IWM	ETF	122.0	122.185	121.89	122.03	2837665.0
2016-09-15 15:00:00	IWM	ETF	122.04	122.13	121.79	122.07	5391223.0
2016-09-15 16:00:00	IWM	ETF	122.07	122.08	121.84	121.84	998720.0
2016-09-15 17:00:00	IWM	ETF	121.84	121.98	121.82	121.98	19881.0
2016-09-15 18:00:00	IWM	ETF	121.85	121.88	121.8	121.8	13688.0
2016-09-15 19:00:00	IWM	ETF	121.73	121.8	121.73	121.75	1350.0
2016-09-15 06:00:00	DIA	ETF	180.76	180.76	180.76	180.76	100.0
2016-09-15 08:00:00	DIA	ETF	180.76	180.92	180.46	180.46	7300.0
2016-09-15 09:00:00	DIA	ETF	180.49	180.84	180.23	180.65	678611.0
2016-09-15 10:00:00	DIA	ETF	180.66	181.47	180.49	181.44	547989.0

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

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