PREVIEW / etf_1hour / 2017-05-17

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-17.parquet
  size:    294 KB
  rows:    9,552

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-05-17 04:00:00	SPY	ETF	238.81	238.95	238.65	238.9	37284.0
2017-05-17 05:00:00	SPY	ETF	238.75	238.77	238.6	238.65	25840.0
2017-05-17 06:00:00	SPY	ETF	238.74	239.02	238.7	239.02	151188.0
2017-05-17 07:00:00	SPY	ETF	239.0	239.15	238.94	238.95	290404.0
2017-05-17 08:00:00	SPY	ETF	239.0	239.12	238.28	238.28	2150807.0
2017-05-17 09:00:00	SPY	ETF	238.28	238.64	237.68	237.765	16363265.0
2017-05-17 10:00:00	SPY	ETF	237.76	237.97	236.96	237.045	27157919.0
2017-05-17 11:00:00	SPY	ETF	237.05	237.76	236.91	237.73	20411092.0
2017-05-17 12:00:00	SPY	ETF	237.74	237.74	237.23	237.65	10079495.0
2017-05-17 13:00:00	SPY	ETF	237.65	237.65	236.86	236.975	11017401.0
2017-05-17 14:00:00	SPY	ETF	236.97	237.22	236.07	236.52	25037435.0
2017-05-17 15:00:00	SPY	ETF	236.525	236.91	235.75	235.85	33628017.0
2017-05-17 16:00:00	SPY	ETF	235.85	237.457	235.82	235.93	21943980.0
2017-05-17 17:00:00	SPY	ETF	235.94	238.6	235.78	235.78	636168.0
2017-05-17 18:00:00	SPY	ETF	235.78	236.3	235.75	236.24	496966.0
2017-05-17 19:00:00	SPY	ETF	236.25	236.38	236.2	236.34	87252.0
2017-05-17 04:00:00	QQQ	ETF	139.01	139.14	139.01	139.08	5550.0
2017-05-17 05:00:00	QQQ	ETF	139.02	139.02	138.94	138.97	7000.0
2017-05-17 06:00:00	QQQ	ETF	139.05	139.15	139.05	139.13	53550.0
2017-05-17 07:00:00	QQQ	ETF	139.14	139.21	139.06	139.06	63680.0
2017-05-17 08:00:00	QQQ	ETF	139.05	139.2	138.66	138.66	381867.0
2017-05-17 09:00:00	QQQ	ETF	138.65	138.77	138.09	138.13	6468084.0
2017-05-17 10:00:00	QQQ	ETF	138.12	138.2	137.18	137.25	9513268.0
2017-05-17 11:00:00	QQQ	ETF	137.26	137.68	137.03	137.66	5318298.0
2017-05-17 12:00:00	QQQ	ETF	137.655	137.66	137.34	137.64	1942966.0
2017-05-17 13:00:00	QQQ	ETF	137.63	137.665	137.09	137.16	2799469.0
2017-05-17 14:00:00	QQQ	ETF	137.15	137.32	136.41	136.7009	6205053.0
2017-05-17 15:00:00	QQQ	ETF	136.71	136.91	136.05	136.08	12875049.0
2017-05-17 16:00:00	QQQ	ETF	136.08	136.31	135.94	135.94	4096150.0
2017-05-17 17:00:00	QQQ	ETF	135.97	136.11	135.95	136.11	1522222.0
2017-05-17 18:00:00	QQQ	ETF	135.94	136.25	135.91	136.24	90900.0
2017-05-17 19:00:00	QQQ	ETF	136.26	136.32	136.2	136.28	33228.0
2017-05-17 04:00:00	IWM	ETF	137.4	137.45	137.2	137.2	17107.0
2017-05-17 05:00:00	IWM	ETF	137.21	137.22	137.0	137.06	33695.0
2017-05-17 06:00:00	IWM	ETF	137.35	137.41	137.3	137.41	11800.0
2017-05-17 07:00:00	IWM	ETF	137.41	137.57	137.37	137.39	91845.0
2017-05-17 08:00:00	IWM	ETF	137.54	137.54	136.76	136.76	460972.0
2017-05-17 09:00:00	IWM	ETF	136.77	137.04	136.17	136.25	6162871.0
2017-05-17 10:00:00	IWM	ETF	136.25	136.69	135.78	135.86	7606289.0
2017-05-17 11:00:00	IWM	ETF	135.8599	136.08	135.48	136.06	7237993.0
2017-05-17 12:00:00	IWM	ETF	136.07	136.07	135.51	135.88	3301556.0
2017-05-17 13:00:00	IWM	ETF	135.875	135.9	135.47	135.5065	2863474.0
2017-05-17 14:00:00	IWM	ETF	135.5	135.64	134.75	135.24	5855570.0
2017-05-17 15:00:00	IWM	ETF	135.24	135.75	134.825	134.9	9425517.0
2017-05-17 16:00:00	IWM	ETF	134.89	135.3468	134.68	134.72	1674179.0
2017-05-17 17:00:00	IWM	ETF	134.8	134.89	134.78	134.89	24104.0
2017-05-17 18:00:00	IWM	ETF	134.75	135.05	134.75	135.05	53957.0
2017-05-17 19:00:00	IWM	ETF	134.94	135.14	134.94	135.04	10348.0
2017-05-17 04:00:00	DIA	ETF	209.0	209.05	208.91	209.01	788.0
2017-05-17 05:00:00	DIA	ETF	208.92	208.92	208.79	208.79	300.0

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

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