PREVIEW / etf_1hour / 2017-08-16

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-16.parquet
  size:    280 KB
  rows:    9,041

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-16 04:00:00	SPY	ETF	246.9	247.16	246.9	247.08	16172.0
2017-08-16 05:00:00	SPY	ETF	247.11	247.24	246.97	247.14	162946.0
2017-08-16 06:00:00	SPY	ETF	247.18	247.2	247.02	247.03	35735.0
2017-08-16 07:00:00	SPY	ETF	247.06	247.11	246.9	246.95	91849.0
2017-08-16 08:00:00	SPY	ETF	247.08	247.11	246.9	247.05	322146.0
2017-08-16 09:00:00	SPY	ETF	247.04	247.23	246.87	247.16	7280527.0
2017-08-16 10:00:00	SPY	ETF	247.155	247.46	247.05	247.39	6441267.0
2017-08-16 11:00:00	SPY	ETF	247.39	247.48	247.1	247.37	3899431.0
2017-08-16 12:00:00	SPY	ETF	247.36	247.57	247.11	247.2	4296089.0
2017-08-16 13:00:00	SPY	ETF	247.2	247.3	246.76	246.9589	6945609.0
2017-08-16 14:00:00	SPY	ETF	246.96	247.24	246.45	246.89	9712238.0
2017-08-16 15:00:00	SPY	ETF	246.89	246.97	246.69	246.92	10527368.0
2017-08-16 16:00:00	SPY	ETF	246.93	246.98	246.82	246.86	5662309.0
2017-08-16 17:00:00	SPY	ETF	246.84	247.31	246.83	246.86	455282.0
2017-08-16 18:00:00	SPY	ETF	246.86	246.86	246.55	246.63	170855.0
2017-08-16 19:00:00	SPY	ETF	246.64	246.68	246.5	246.59	78007.0
2017-08-16 04:00:00	QQQ	ETF	144.29	144.47	144.29	144.47	1108.0
2017-08-16 05:00:00	QQQ	ETF	144.44	144.62	144.4	144.55	47055.0
2017-08-16 06:00:00	QQQ	ETF	144.56	144.56	144.37	144.37	10869.0
2017-08-16 07:00:00	QQQ	ETF	144.43	144.43	144.26	144.31	18203.0
2017-08-16 08:00:00	QQQ	ETF	144.39	144.46	144.23	144.43	49803.0
2017-08-16 09:00:00	QQQ	ETF	144.39	144.44	143.95	144.12	2789576.0
2017-08-16 10:00:00	QQQ	ETF	144.13	144.61	144.01	144.545	2983605.0
2017-08-16 11:00:00	QQQ	ETF	144.54	144.6801	144.42	144.651	1841934.0
2017-08-16 12:00:00	QQQ	ETF	144.65	144.96	144.46	144.51	4754216.0
2017-08-16 13:00:00	QQQ	ETF	144.51	144.55	144.07	144.2	3943867.0
2017-08-16 14:00:00	QQQ	ETF	144.21	144.51	143.8007	144.2046	4414860.0
2017-08-16 15:00:00	QQQ	ETF	144.21	144.3093	144.07	144.28	3149801.0
2017-08-16 16:00:00	QQQ	ETF	144.27	144.6272	144.19	144.24	1198462.0
2017-08-16 17:00:00	QQQ	ETF	144.28	144.6393	144.19	144.23	194778.0
2017-08-16 18:00:00	QQQ	ETF	144.24	144.24	144.04	144.04	17953.0
2017-08-16 19:00:00	QQQ	ETF	144.04	144.08	143.9	143.98	18586.0
2017-08-16 04:00:00	IWM	ETF	137.78	137.83	137.75	137.8	4203.0
2017-08-16 05:00:00	IWM	ETF	137.75	137.85	137.75	137.85	19000.0
2017-08-16 06:00:00	IWM	ETF	137.77	137.77	137.77	137.77	402.0
2017-08-16 07:00:00	IWM	ETF	137.75	137.83	137.64	137.64	11704.0
2017-08-16 08:00:00	IWM	ETF	137.8	137.8	137.64	137.66	106082.0
2017-08-16 09:00:00	IWM	ETF	137.65	138.11	137.63	137.96	1950365.0
2017-08-16 10:00:00	IWM	ETF	137.95	138.06	137.85	137.91	1494129.0
2017-08-16 11:00:00	IWM	ETF	137.92	138.39	137.66	138.2	2608385.0
2017-08-16 12:00:00	IWM	ETF	138.2	138.32	137.88	137.94	1485054.0
2017-08-16 13:00:00	IWM	ETF	137.95	138.02	137.605	137.78	2562317.0
2017-08-16 14:00:00	IWM	ETF	137.79	137.85	137.345	137.6	3138845.0
2017-08-16 15:00:00	IWM	ETF	137.61	137.68	137.21	137.45	3257235.0
2017-08-16 16:00:00	IWM	ETF	137.44	137.48	137.31	137.31	1375892.0
2017-08-16 17:00:00	IWM	ETF	137.32	137.44	137.29	137.44	139285.0
2017-08-16 18:00:00	IWM	ETF	137.28	137.29	137.22	137.28	5500.0
2017-08-16 19:00:00	IWM	ETF	137.28	137.4	137.22	137.22	6914.0
2017-08-16 04:00:00	DIA	ETF	220.65	220.65	220.65	220.65	200.0
2017-08-16 06:00:00	DIA	ETF	220.6	220.6	220.6	220.6	100.0

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

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