PREVIEW / etf_1hour / 2017-11-29

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-29.parquet
  size:    294 KB
  rows:    9,603

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
2017-11-29 04:00:00	SPY	ETF	262.75	262.9	262.75	262.86	4519.0
2017-11-29 05:00:00	SPY	ETF	262.88	262.98	262.79	262.98	11662.0
2017-11-29 06:00:00	SPY	ETF	262.94	263.15	262.94	263.12	19394.0
2017-11-29 07:00:00	SPY	ETF	263.12	263.16	263.04	263.05	159534.0
2017-11-29 08:00:00	SPY	ETF	263.09	263.13	262.87	263.04	406412.0
2017-11-29 09:00:00	SPY	ETF	263.04	263.63	262.96	263.51	8015355.0
2017-11-29 10:00:00	SPY	ETF	263.5101	263.52	262.72	262.85	11879060.0
2017-11-29 11:00:00	SPY	ETF	262.85	262.96	262.28	262.31	10506228.0
2017-11-29 12:00:00	SPY	ETF	262.31	262.84	262.2	262.715	13002940.0
2017-11-29 13:00:00	SPY	ETF	262.715	262.8166	262.4	262.4751	6614059.0
2017-11-29 14:00:00	SPY	ETF	262.47	262.78	262.47	262.58	7171384.0
2017-11-29 15:00:00	SPY	ETF	262.585	262.88	262.365	262.73	11903412.0
2017-11-29 16:00:00	SPY	ETF	262.73	262.7981	262.54	262.73	5463685.0
2017-11-29 17:00:00	SPY	ETF	262.72	262.8	262.69	262.74	694412.0
2017-11-29 18:00:00	SPY	ETF	262.74	262.84	262.63	262.64	112683.0
2017-11-29 19:00:00	SPY	ETF	262.64	262.67	262.51	262.57	175975.0
2017-11-29 04:00:00	QQQ	ETF	156.45	156.45	156.28	156.45	70400.0
2017-11-29 05:00:00	QQQ	ETF	156.39	156.5	156.39	156.5	7400.0
2017-11-29 06:00:00	QQQ	ETF	156.56	156.65	156.56	156.6	11900.0
2017-11-29 07:00:00	QQQ	ETF	156.61	156.64	156.53	156.55	69136.0
2017-11-29 08:00:00	QQQ	ETF	156.61	156.61	156.31	156.46	155398.0
2017-11-29 09:00:00	QQQ	ETF	156.46	156.5	155.51	155.53	6306237.0
2017-11-29 10:00:00	QQQ	ETF	155.53	155.66	153.95	154.06	17059179.0
2017-11-29 11:00:00	QQQ	ETF	154.05	154.3448	153.31	153.34	9684988.0
2017-11-29 12:00:00	QQQ	ETF	153.34	154.206	153.12	153.92	9320572.0
2017-11-29 13:00:00	QQQ	ETF	153.925	154.41	153.75	153.89	4411957.0
2017-11-29 14:00:00	QQQ	ETF	153.89	154.06	153.55	153.73	3585319.0
2017-11-29 15:00:00	QQQ	ETF	153.74	154.05	153.39	153.88	7592599.0
2017-11-29 16:00:00	QQQ	ETF	153.88	153.9044	153.61	153.65	1600540.0
2017-11-29 17:00:00	QQQ	ETF	153.66	155.5296	153.63	153.71	84232.0
2017-11-29 18:00:00	QQQ	ETF	153.72	153.83	153.71	153.73	51975.0
2017-11-29 19:00:00	QQQ	ETF	153.72	153.75	153.69	153.74	9275.0
2017-11-29 04:00:00	IWM	ETF	152.85	152.85	152.85	152.85	200.0
2017-11-29 05:00:00	IWM	ETF	152.85	152.96	152.85	152.96	4703.0
2017-11-29 06:00:00	IWM	ETF	153.0	153.15	153.0	153.15	11720.0
2017-11-29 07:00:00	IWM	ETF	153.14	153.32	153.12	153.25	94687.0
2017-11-29 08:00:00	IWM	ETF	153.25	153.42	153.22	153.3	178730.0
2017-11-29 09:00:00	IWM	ETF	153.3	154.21	153.3	154.16	5920770.0
2017-11-29 10:00:00	IWM	ETF	154.16	154.17	153.38	153.85	6316459.0
2017-11-29 11:00:00	IWM	ETF	153.84	153.95	153.24	153.265	4464677.0
2017-11-29 12:00:00	IWM	ETF	153.27	153.74	153.19	153.52	2891256.0
2017-11-29 13:00:00	IWM	ETF	153.52	153.54	152.95	153.12	2248554.0
2017-11-29 14:00:00	IWM	ETF	153.12	153.53	153.115	153.21	1994902.0
2017-11-29 15:00:00	IWM	ETF	153.22	153.51	153.22	153.38	3783647.0
2017-11-29 16:00:00	IWM	ETF	153.403	153.45	152.8118	153.25	2713187.0
2017-11-29 17:00:00	IWM	ETF	153.32	153.7232	153.25	153.34	1553307.0
2017-11-29 18:00:00	IWM	ETF	153.32	153.32	153.25	153.25	4370.0
2017-11-29 19:00:00	IWM	ETF	153.21	153.3	153.2	153.2	8332.0
2017-11-29 06:00:00	DIA	ETF	238.99	239.0	238.88	238.88	6600.0
2017-11-29 07:00:00	DIA	ETF	238.9	239.04	238.81	239.04	3370.0

> showing 50 of 9,603 rows — these rows as CSV

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