PREVIEW / etf_1hour / 2017-08-17

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-17.parquet
  size:    285 KB
  rows:    9,270

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-08-17 04:00:00	SPY	ETF	246.77	246.83	246.57	246.63	26956.0
2017-08-17 05:00:00	SPY	ETF	246.67	246.69	246.62	246.69	4600.0
2017-08-17 06:00:00	SPY	ETF	246.73	246.73	246.62	246.63	35658.0
2017-08-17 07:00:00	SPY	ETF	246.62	246.69	246.26	246.38	233183.0
2017-08-17 08:00:00	SPY	ETF	246.39	246.68	246.11	246.4	500555.0
2017-08-17 09:00:00	SPY	ETF	246.37	246.6	246.06	246.07	6569963.0
2017-08-17 10:00:00	SPY	ETF	246.07	246.1682	245.17	245.52	24722896.0
2017-08-17 11:00:00	SPY	ETF	245.52	246.0	245.18	245.34	11736226.0
2017-08-17 12:00:00	SPY	ETF	245.34	245.49	244.44	244.6	16172295.0
2017-08-17 13:00:00	SPY	ETF	244.6	244.8	244.2925	244.59	9903598.0
2017-08-17 14:00:00	SPY	ETF	244.59	244.645	244.06	244.28	9898325.0
2017-08-17 15:00:00	SPY	ETF	244.27	244.28	243.1	243.13	32961512.0
2017-08-17 16:00:00	SPY	ETF	243.13	243.3	242.61	242.99	12153532.0
2017-08-17 17:00:00	SPY	ETF	242.92	245.528	242.8	242.83	593249.0
2017-08-17 18:00:00	SPY	ETF	242.85	243.05	242.81	243.01	297963.0
2017-08-17 19:00:00	SPY	ETF	243.04	243.1	242.83	242.91	66780.0
2017-08-17 04:00:00	QQQ	ETF	144.1	144.18	143.96	144.02	2131.0
2017-08-17 05:00:00	QQQ	ETF	143.94	143.94	143.91	143.91	742.0
2017-08-17 06:00:00	QQQ	ETF	143.93	143.97	143.93	143.93	14070.0
2017-08-17 07:00:00	QQQ	ETF	143.91	144.05	143.65	143.75	61854.0
2017-08-17 08:00:00	QQQ	ETF	143.75	143.94	143.55	143.7	283055.0
2017-08-17 09:00:00	QQQ	ETF	143.68	143.94	143.54	143.58	3766841.0
2017-08-17 10:00:00	QQQ	ETF	143.57	143.57	142.6	142.82	12087933.0
2017-08-17 11:00:00	QQQ	ETF	142.83	143.18	142.71	142.85	4965850.0
2017-08-17 12:00:00	QQQ	ETF	142.85	142.96	142.06	142.17	6254143.0
2017-08-17 13:00:00	QQQ	ETF	142.17	142.45	141.95	142.33	4705857.0
2017-08-17 14:00:00	QQQ	ETF	142.33	142.37	141.85	142.0	4310502.0
2017-08-17 15:00:00	QQQ	ETF	142.005	142.02	141.33	141.33	11744597.0
2017-08-17 16:00:00	QQQ	ETF	141.33	142.455	141.0	141.2	3197341.0
2017-08-17 17:00:00	QQQ	ETF	141.27	142.8487	141.13	141.26	475666.0
2017-08-17 18:00:00	QQQ	ETF	141.19	141.27	141.1	141.2	31634.0
2017-08-17 19:00:00	QQQ	ETF	141.21	141.29	141.13	141.2	18794.0
2017-08-17 04:00:00	IWM	ETF	137.19	137.19	137.15	137.15	213.0
2017-08-17 05:00:00	IWM	ETF	137.15	137.18	137.14	137.18	3997.0
2017-08-17 06:00:00	IWM	ETF	137.24	137.25	137.2	137.2	7392.0
2017-08-17 07:00:00	IWM	ETF	137.16	137.29	136.94	137.02	15862.0
2017-08-17 08:00:00	IWM	ETF	137.04	137.14	136.85	137.11	64708.0
2017-08-17 09:00:00	IWM	ETF	137.1	137.69	136.76	137.26	2702251.0
2017-08-17 10:00:00	IWM	ETF	137.28	137.58	136.06	137.08	5277821.0
2017-08-17 11:00:00	IWM	ETF	137.09	137.45	136.85	136.9648	1762360.0
2017-08-17 12:00:00	IWM	ETF	136.96	137.1	136.2	136.31	2203701.0
2017-08-17 13:00:00	IWM	ETF	136.29	136.33	135.915	136.15	3677208.0
2017-08-17 14:00:00	IWM	ETF	136.15	136.3	135.84	136.07	2268992.0
2017-08-17 15:00:00	IWM	ETF	136.06	136.06	134.9199	134.93	9556926.0
2017-08-17 16:00:00	IWM	ETF	134.94	137.557	134.41	134.68	1425188.0
2017-08-17 17:00:00	IWM	ETF	134.63	135.134	134.62	134.65	213560.0
2017-08-17 18:00:00	IWM	ETF	134.57	134.7	134.52	134.65	8974.0
2017-08-17 19:00:00	IWM	ETF	134.65	134.75	134.5	134.55	22677.0
2017-08-17 08:00:00	DIA	ETF	220.1	220.1	219.97	220.0	1300.0
2017-08-17 09:00:00	DIA	ETF	219.97	220.12	219.63	219.63	308903.0

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

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