PREVIEW / etf_1hour / 2016-06-22

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-22.parquet
  size:    247 KB
  rows:    7,934

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-06-22 04:00:00	SPY	ETF	208.26	208.44	208.23	208.4	9680.0
2016-06-22 05:00:00	SPY	ETF	208.4	208.68	208.36	208.68	1825.0
2016-06-22 06:00:00	SPY	ETF	208.65	208.68	208.54	208.68	9880.0
2016-06-22 07:00:00	SPY	ETF	208.69	208.83	208.44	208.57	99937.0
2016-06-22 08:00:00	SPY	ETF	208.57	208.69	208.5	208.6	236011.0
2016-06-22 09:00:00	SPY	ETF	208.6	208.9	208.57	208.69	6147963.0
2016-06-22 10:00:00	SPY	ETF	208.69	209.5	208.57	209.3	12260452.0
2016-06-22 11:00:00	SPY	ETF	209.31	209.48	208.82	209.075	12516189.0
2016-06-22 12:00:00	SPY	ETF	209.075	209.14	208.36	208.62	13242791.0
2016-06-22 13:00:00	SPY	ETF	208.63	208.72	208.04	208.63	12011878.0
2016-06-22 14:00:00	SPY	ETF	208.63	208.78	208.29	208.48	10415802.0
2016-06-22 15:00:00	SPY	ETF	208.48	208.715	207.93	208.05	21149366.0
2016-06-22 16:00:00	SPY	ETF	208.05	209.0806	207.98	208.09	4216844.0
2016-06-22 17:00:00	SPY	ETF	208.09	208.68	208.09	208.68	1343977.0
2016-06-22 18:00:00	SPY	ETF	208.68	209.36	208.67	209.01	302875.0
2016-06-22 19:00:00	SPY	ETF	209.01	209.08	208.87	209.01	69281.0
2016-06-22 04:00:00	QQQ	ETF	107.25	107.34	107.25	107.34	7899.0
2016-06-22 05:00:00	QQQ	ETF	107.35	107.52	107.35	107.52	4605.0
2016-06-22 06:00:00	QQQ	ETF	107.56	107.58	107.49	107.58	1818.0
2016-06-22 07:00:00	QQQ	ETF	107.57	107.66	107.53	107.57	28250.0
2016-06-22 08:00:00	QQQ	ETF	107.58	107.59	107.54	107.58	14095.0
2016-06-22 09:00:00	QQQ	ETF	107.62	107.63	107.37	107.38	1487961.0
2016-06-22 10:00:00	QQQ	ETF	107.38	108.04	107.33	107.95	2597852.0
2016-06-22 11:00:00	QQQ	ETF	107.95	108.19	107.84	107.94	2623705.0
2016-06-22 12:00:00	QQQ	ETF	107.93	107.97	107.4	107.59	1673652.0
2016-06-22 13:00:00	QQQ	ETF	107.59	107.71	107.19	107.64	2884873.0
2016-06-22 14:00:00	QQQ	ETF	107.65	107.74	107.34	107.48	1465273.0
2016-06-22 15:00:00	QQQ	ETF	107.47	107.62	107.15	107.25	5010865.0
2016-06-22 16:00:00	QQQ	ETF	107.24	107.32	107.2	107.22	2476546.0
2016-06-22 17:00:00	QQQ	ETF	107.25	107.5	107.25	107.5	7022.0
2016-06-22 18:00:00	QQQ	ETF	107.5	107.8	107.37	107.72	76896.0
2016-06-22 19:00:00	QQQ	ETF	107.72	107.75	107.65	107.7	5539.0
2016-06-22 05:00:00	IWM	ETF	115.17	115.17	115.17	115.17	700.0
2016-06-22 06:00:00	IWM	ETF	115.19	115.2	115.19	115.2	399.0
2016-06-22 07:00:00	IWM	ETF	115.25	115.25	115.22	115.22	1500.0
2016-06-22 08:00:00	IWM	ETF	115.29	115.3	115.08	115.08	11015.0
2016-06-22 09:00:00	IWM	ETF	115.29	115.32	114.83	114.915	2026106.0
2016-06-22 10:00:00	IWM	ETF	114.915	115.78	114.7	115.59	4881849.0
2016-06-22 11:00:00	IWM	ETF	115.59	115.88	115.42	115.63	3167056.0
2016-06-22 12:00:00	IWM	ETF	115.62	115.67	114.82	115.02	3290172.0
2016-06-22 13:00:00	IWM	ETF	115.01	115.03	114.6	114.92	3381751.0
2016-06-22 14:00:00	IWM	ETF	114.91	114.94	114.63	114.83	2479932.0
2016-06-22 15:00:00	IWM	ETF	114.83	114.98	114.49	114.6	5451158.0
2016-06-22 16:00:00	IWM	ETF	114.61	114.9326	114.44	114.57	801780.0
2016-06-22 17:00:00	IWM	ETF	114.54	114.95	114.54	114.95	28681.0
2016-06-22 18:00:00	IWM	ETF	114.99	115.08	114.99	115.02	5063.0
2016-06-22 19:00:00	IWM	ETF	115.02	115.04	114.98	115.04	3593.0
2016-06-22 09:00:00	DIA	ETF	178.23	178.57	178.16	178.46	204594.0
2016-06-22 10:00:00	DIA	ETF	178.45	178.948	178.35	178.83	381071.0
2016-06-22 11:00:00	DIA	ETF	178.83	178.86	178.19	178.28	448788.0

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

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