PREVIEW / etf_1hour / 2016-11-08

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-08.parquet
  size:    264 KB
  rows:    8,438

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-11-08 04:00:00	SPY	ETF	213.25	213.37	213.19	213.28	7419.0
2016-11-08 05:00:00	SPY	ETF	213.28	213.28	212.82	213.09	28364.0
2016-11-08 06:00:00	SPY	ETF	213.07	213.09	212.85	212.9	148555.0
2016-11-08 07:00:00	SPY	ETF	212.96	213.15	212.91	213.08	151691.0
2016-11-08 08:00:00	SPY	ETF	213.0	213.08	212.83	212.86	473291.0
2016-11-08 09:00:00	SPY	ETF	212.86	212.91	212.38	212.555	9523802.0
2016-11-08 10:00:00	SPY	ETF	212.555	213.02	212.48	212.99	9046046.0
2016-11-08 11:00:00	SPY	ETF	212.99	214.2	212.95	214.19	14193811.0
2016-11-08 12:00:00	SPY	ETF	214.19	214.75	214.14	214.7	14056749.0
2016-11-08 13:00:00	SPY	ETF	214.7	214.77	214.21	214.34	11766186.0
2016-11-08 14:00:00	SPY	ETF	214.34	214.35	213.57	213.87	12261839.0
2016-11-08 15:00:00	SPY	ETF	213.86	214.53	213.8	214.07	25939412.0
2016-11-08 16:00:00	SPY	ETF	214.07	214.3742	212.9408	214.03	5322147.0
2016-11-08 17:00:00	SPY	ETF	214.1	214.21	213.82	214.15	387590.0
2016-11-08 18:00:00	SPY	ETF	214.21	214.83	214.21	214.69	464563.0
2016-11-08 19:00:00	SPY	ETF	214.63	215.54	213.28	215.48	1404965.0
2016-11-08 20:00:00	SPY	ETF	214.11	214.11	214.0012	214.0052	1245000.0
2016-11-08 04:00:00	QQQ	ETF	116.4	116.44	116.4	116.44	399.0
2016-11-08 05:00:00	QQQ	ETF	116.3	116.3	116.26	116.26	748.0
2016-11-08 06:00:00	QQQ	ETF	116.33	116.33	116.28	116.28	1200.0
2016-11-08 07:00:00	QQQ	ETF	116.29	116.39	116.29	116.38	7140.0
2016-11-08 08:00:00	QQQ	ETF	116.37	116.38	116.25	116.27	72051.0
2016-11-08 09:00:00	QQQ	ETF	116.23	116.31	115.96	116.06	2630085.0
2016-11-08 10:00:00	QQQ	ETF	116.05	116.37	116.03	116.37	2245670.0
2016-11-08 11:00:00	QQQ	ETF	116.37	117.13	116.33	117.12	3006240.0
2016-11-08 12:00:00	QQQ	ETF	117.12	117.64	117.12	117.6	2222572.0
2016-11-08 13:00:00	QQQ	ETF	117.6	117.64	117.255	117.27	1813424.0
2016-11-08 14:00:00	QQQ	ETF	117.27	117.3	116.84	117.075	2020249.0
2016-11-08 15:00:00	QQQ	ETF	117.07	117.47	117.0101	117.14	3926651.0
2016-11-08 16:00:00	QQQ	ETF	117.11	117.23	117.06	117.15	524996.0
2016-11-08 17:00:00	QQQ	ETF	117.14	117.36	117.14	117.3	80972.0
2016-11-08 18:00:00	QQQ	ETF	117.34	117.59	117.3	117.51	48858.0
2016-11-08 19:00:00	QQQ	ETF	117.46	117.89	116.73	117.86	118707.0
2016-11-08 05:00:00	IWM	ETF	118.43	118.43	118.36	118.36	1260.0
2016-11-08 06:00:00	IWM	ETF	118.39	118.4	118.38	118.38	3982.0
2016-11-08 07:00:00	IWM	ETF	118.39	118.5	118.36	118.49	22617.0
2016-11-08 08:00:00	IWM	ETF	118.43	118.44	118.26	118.26	74845.0
2016-11-08 09:00:00	IWM	ETF	118.24	118.43	117.78	117.927	2690395.0
2016-11-08 10:00:00	IWM	ETF	117.92	118.34	117.71	118.255	2856551.0
2016-11-08 11:00:00	IWM	ETF	118.25	118.91	118.22	118.89	3296577.0
2016-11-08 12:00:00	IWM	ETF	118.88	119.46	118.855	119.37	3140797.0
2016-11-08 13:00:00	IWM	ETF	119.38	119.43	119.04	119.225	2201673.0
2016-11-08 14:00:00	IWM	ETF	119.22	119.24	118.64	118.76	2639346.0
2016-11-08 15:00:00	IWM	ETF	118.74	119.35	118.66	118.84	6705801.0
2016-11-08 16:00:00	IWM	ETF	118.85	118.97	118.7	118.8	770960.0
2016-11-08 17:00:00	IWM	ETF	118.8	118.99	118.64	118.99	36406.0
2016-11-08 18:00:00	IWM	ETF	118.88	119.23	118.88	119.2	49426.0
2016-11-08 19:00:00	IWM	ETF	119.2	119.4	118.51	119.4	29679.0
2016-11-08 07:00:00	DIA	ETF	182.45	182.45	182.45	182.45	300.0
2016-11-08 08:00:00	DIA	ETF	182.36	182.36	182.2	182.3	5755.0

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

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