PREVIEW / etf_1hour / 2017-05-18

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-18.parquet
  size:    285 KB
  rows:    9,265

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-18 04:00:00	SPY	ETF	236.11	236.29	235.9	236.29	117952.0
2017-05-18 05:00:00	SPY	ETF	236.15	236.26	234.75	234.79	195433.0
2017-05-18 06:00:00	SPY	ETF	234.81	235.34	234.81	235.06	111832.0
2017-05-18 07:00:00	SPY	ETF	235.06	235.73	234.94	235.59	417064.0
2017-05-18 08:00:00	SPY	ETF	235.6	236.69	234.86	235.16	2310033.0
2017-05-18 09:00:00	SPY	ETF	235.16	236.15	235.08	235.68	13756334.0
2017-05-18 10:00:00	SPY	ETF	235.69	237.02	235.6808	236.6351	17825148.0
2017-05-18 11:00:00	SPY	ETF	236.64	236.88	236.15	236.18	8520271.0
2017-05-18 12:00:00	SPY	ETF	236.18	236.68	235.97	236.39	8995384.0
2017-05-18 13:00:00	SPY	ETF	236.39	236.91	236.081	236.73	6933798.0
2017-05-18 14:00:00	SPY	ETF	236.73	237.75	236.73	237.2	14998912.0
2017-05-18 15:00:00	SPY	ETF	237.2	237.37	236.64	236.67	22643782.0
2017-05-18 16:00:00	SPY	ETF	236.74	237.09	236.49	236.62	8224943.0
2017-05-18 17:00:00	SPY	ETF	236.68	236.75	236.4249	236.7	235092.0
2017-05-18 18:00:00	SPY	ETF	236.7	236.82	236.69	236.81	87667.0
2017-05-18 19:00:00	SPY	ETF	236.79	236.82	236.7	236.76	48651.0
2017-05-18 04:00:00	QQQ	ETF	136.29	136.29	136.05	136.13	34305.0
2017-05-18 05:00:00	QQQ	ETF	136.15	136.15	135.32	135.32	71943.0
2017-05-18 06:00:00	QQQ	ETF	135.48	135.71	135.48	135.64	18894.0
2017-05-18 07:00:00	QQQ	ETF	135.58	135.96	135.51	135.89	76225.0
2017-05-18 08:00:00	QQQ	ETF	135.53	136.0	135.53	135.88	338723.0
2017-05-18 09:00:00	QQQ	ETF	135.87	136.74	135.55	136.52	5712398.0
2017-05-18 10:00:00	QQQ	ETF	136.53	137.44	136.52	137.13	9228038.0
2017-05-18 11:00:00	QQQ	ETF	137.13	137.33	136.69	136.7084	3503065.0
2017-05-18 12:00:00	QQQ	ETF	136.71	137.11	136.56	136.89	3965647.0
2017-05-18 13:00:00	QQQ	ETF	136.9	137.32	136.73	137.19	2844020.0
2017-05-18 14:00:00	QQQ	ETF	137.19	137.72	137.17	137.32	5550729.0
2017-05-18 15:00:00	QQQ	ETF	137.33	137.555	137.16	137.26	6023830.0
2017-05-18 16:00:00	QQQ	ETF	137.24	137.34	137.1743	137.34	2356417.0
2017-05-18 17:00:00	QQQ	ETF	137.34	137.35	137.29	137.3	6283.0
2017-05-18 18:00:00	QQQ	ETF	137.35	137.47	137.26	137.47	16473.0
2017-05-18 19:00:00	QQQ	ETF	137.46	137.46	137.31	137.33	8573.0
2017-05-18 04:00:00	IWM	ETF	134.76	135.05	134.75	135.05	4865.0
2017-05-18 05:00:00	IWM	ETF	134.64	134.64	133.89	133.96	11854.0
2017-05-18 06:00:00	IWM	ETF	134.12	134.28	134.0	134.02	8879.0
2017-05-18 07:00:00	IWM	ETF	133.99	134.58	133.97	134.46	99133.0
2017-05-18 08:00:00	IWM	ETF	134.46	134.63	133.9	134.28	295812.0
2017-05-18 09:00:00	IWM	ETF	134.23	135.015	134.23	134.61	5238373.0
2017-05-18 10:00:00	IWM	ETF	134.61	135.39	134.61	135.17	7247235.0
2017-05-18 11:00:00	IWM	ETF	135.18	135.6234	135.01	135.08	3685201.0
2017-05-18 12:00:00	IWM	ETF	135.08	135.37	134.87	135.19	3088463.0
2017-05-18 13:00:00	IWM	ETF	135.2	135.52	134.99	135.37	2844222.0
2017-05-18 14:00:00	IWM	ETF	135.37	135.9	134.8988	135.39	5354304.0
2017-05-18 15:00:00	IWM	ETF	135.4	135.78	135.3	135.34	6107339.0
2017-05-18 16:00:00	IWM	ETF	135.38	135.52	135.16	135.24	857684.0
2017-05-18 17:00:00	IWM	ETF	135.38	135.38	134.6441	135.34	161520.0
2017-05-18 18:00:00	IWM	ETF	135.38	135.38	135.37	135.38	600.0
2017-05-18 19:00:00	IWM	ETF	135.39	135.42	135.34	135.34	241789.0
2017-05-18 05:00:00	DIA	ETF	206.04	206.04	205.45	205.45	8400.0
2017-05-18 06:00:00	DIA	ETF	205.37	205.68	205.37	205.6	500.0

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

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