PREVIEW / etf_1hour / 2017-08-15

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-15.parquet
  size:    277 KB
  rows:    9,078

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-15 04:00:00	SPY	ETF	246.72	246.98	246.72	246.98	6320.0
2017-08-15 05:00:00	SPY	ETF	246.91	246.93	246.91	246.92	1000.0
2017-08-15 06:00:00	SPY	ETF	246.92	247.05	246.84	247.05	11005.0
2017-08-15 07:00:00	SPY	ETF	247.06	247.19	247.03	247.05	69681.0
2017-08-15 08:00:00	SPY	ETF	247.11	247.2	246.88	247.05	568346.0
2017-08-15 09:00:00	SPY	ETF	247.06	247.15	246.41	246.76	5924380.0
2017-08-15 10:00:00	SPY	ETF	246.755	246.81	246.16	246.4201	10254089.0
2017-08-15 11:00:00	SPY	ETF	246.43	246.66	246.36	246.375	3481969.0
2017-08-15 12:00:00	SPY	ETF	246.375	246.65	246.36	246.52	4091863.0
2017-08-15 13:00:00	SPY	ETF	246.525	246.53	246.21	246.38	3525320.0
2017-08-15 14:00:00	SPY	ETF	246.3851	246.71	246.38	246.641	5059550.0
2017-08-15 15:00:00	SPY	ETF	246.64	246.92	246.46	246.53	13843236.0
2017-08-15 16:00:00	SPY	ETF	246.51	246.75	246.48	246.59	7522819.0
2017-08-15 17:00:00	SPY	ETF	246.61	246.63	246.3364	246.61	180262.0
2017-08-15 18:00:00	SPY	ETF	246.62	246.67	246.34	246.44	103396.0
2017-08-15 19:00:00	SPY	ETF	246.41	246.43	246.34	246.4	22655.0
2017-08-15 04:00:00	QQQ	ETF	144.15	144.36	144.15	144.36	2300.0
2017-08-15 05:00:00	QQQ	ETF	144.29	144.4	144.29	144.34	15384.0
2017-08-15 06:00:00	QQQ	ETF	144.32	144.36	144.27	144.35	14178.0
2017-08-15 07:00:00	QQQ	ETF	144.41	144.45	144.37	144.42	17407.0
2017-08-15 08:00:00	QQQ	ETF	144.45	144.48	144.18	144.3	96140.0
2017-08-15 09:00:00	QQQ	ETF	144.28	144.33	143.72	144.01	3785696.0
2017-08-15 10:00:00	QQQ	ETF	144.0117	144.09	143.64	143.89	3185201.0
2017-08-15 11:00:00	QQQ	ETF	143.885	144.16	143.82	143.86	2619695.0
2017-08-15 12:00:00	QQQ	ETF	143.86	144.22	143.84	144.13	1686018.0
2017-08-15 13:00:00	QQQ	ETF	144.13	144.135	143.85	143.92	1932434.0
2017-08-15 14:00:00	QQQ	ETF	143.92	144.11	143.91	144.05	1548368.0
2017-08-15 15:00:00	QQQ	ETF	144.05	144.28	144.0	144.03	5421853.0
2017-08-15 16:00:00	QQQ	ETF	144.03	144.09	144.0	144.08	715141.0
2017-08-15 17:00:00	QQQ	ETF	144.09	144.19	144.02	144.19	32742.0
2017-08-15 18:00:00	QQQ	ETF	144.13	144.13	143.91	143.97	40588.0
2017-08-15 19:00:00	QQQ	ETF	143.91	143.91	143.85	143.9	8711.0
2017-08-15 04:00:00	IWM	ETF	138.72	138.72	138.72	138.72	503.0
2017-08-15 05:00:00	IWM	ETF	138.74	138.74	138.73	138.73	1509.0
2017-08-15 06:00:00	IWM	ETF	138.74	138.82	138.74	138.82	1813.0
2017-08-15 07:00:00	IWM	ETF	138.89	138.89	138.71	138.73	86559.0
2017-08-15 08:00:00	IWM	ETF	138.85	138.96	138.71	138.91	43833.0
2017-08-15 09:00:00	IWM	ETF	138.91	138.94	137.91	138.185	2673565.0
2017-08-15 10:00:00	IWM	ETF	138.18	138.2	137.68	137.9	2337706.0
2017-08-15 11:00:00	IWM	ETF	137.9	137.99	137.56	137.65	1599395.0
2017-08-15 12:00:00	IWM	ETF	137.655	137.82	137.6	137.67	1386500.0
2017-08-15 13:00:00	IWM	ETF	137.68	137.68	137.42	137.5	1316410.0
2017-08-15 14:00:00	IWM	ETF	137.49	137.67	137.44	137.5	1187015.0
2017-08-15 15:00:00	IWM	ETF	137.51	137.88	137.34	137.41	3726581.0
2017-08-15 16:00:00	IWM	ETF	137.41	137.46	137.32	137.35	710996.0
2017-08-15 17:00:00	IWM	ETF	137.8106	137.8106	137.33	137.35	38094.0
2017-08-15 18:00:00	IWM	ETF	137.41	137.47	137.3	137.3	9367.0
2017-08-15 19:00:00	IWM	ETF	137.3	137.3	137.3	137.3	1237.0
2017-08-15 07:00:00	DIA	ETF	220.5	220.55	220.5	220.5	600.0
2017-08-15 08:00:00	DIA	ETF	220.57	220.72	220.52	220.52	452.0

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

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