PREVIEW / etf_1hour / 2017-10-19

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-19.parquet
  size:    288 KB
  rows:    9,503

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-10-19 04:00:00	SPY	ETF	254.57	254.86	254.0	254.78	135731.0
2017-10-19 05:00:00	SPY	ETF	254.78	254.92	254.68	254.74	87434.0
2017-10-19 06:00:00	SPY	ETF	254.73	254.8	254.39	254.54	348615.0
2017-10-19 07:00:00	SPY	ETF	254.54	254.74	254.23	254.63	498036.0
2017-10-19 08:00:00	SPY	ETF	254.32	255.72	254.32	254.85	828583.0
2017-10-19 09:00:00	SPY	ETF	254.85	255.26	254.46	254.57	7757542.0
2017-10-19 10:00:00	SPY	ETF	254.57	255.18	254.35	255.1745	8895128.0
2017-10-19 11:00:00	SPY	ETF	255.17	255.23	255.03	255.08	7073336.0
2017-10-19 12:00:00	SPY	ETF	255.08	255.255	254.97	255.23	4742394.0
2017-10-19 13:00:00	SPY	ETF	255.24	255.56	255.22	255.42	4133714.0
2017-10-19 14:00:00	SPY	ETF	255.43	255.64	255.39	255.56	5756419.0
2017-10-19 15:00:00	SPY	ETF	255.56	255.82	255.46	255.82	12832512.0
2017-10-19 16:00:00	SPY	ETF	255.81	255.92	255.7682	255.88	6113126.0
2017-10-19 17:00:00	SPY	ETF	255.85	255.91	255.79	255.89	1460347.0
2017-10-19 18:00:00	SPY	ETF	255.88	255.9	255.82	255.83	137141.0
2017-10-19 19:00:00	SPY	ETF	255.83	255.87	255.76	255.85	231773.0
2017-10-19 04:00:00	QQQ	ETF	147.75	148.06	147.43	148.05	50419.0
2017-10-19 05:00:00	QQQ	ETF	147.99	148.16	147.94	148.05	33515.0
2017-10-19 06:00:00	QQQ	ETF	148.09	148.09	147.71	147.86	90947.0
2017-10-19 07:00:00	QQQ	ETF	147.83	147.97	147.7	147.93	304344.0
2017-10-19 08:00:00	QQQ	ETF	147.87	148.86	147.75	148.09	274125.0
2017-10-19 09:00:00	QQQ	ETF	148.08	148.26	147.31	147.53	5433472.0
2017-10-19 10:00:00	QQQ	ETF	147.52	148.01	147.27	148.008	5483500.0
2017-10-19 11:00:00	QQQ	ETF	148.0	148.15	147.78	147.83	2257680.0
2017-10-19 12:00:00	QQQ	ETF	147.835	147.925	147.695	147.84	2001085.0
2017-10-19 13:00:00	QQQ	ETF	147.84	148.13	147.84	148.0091	1138710.0
2017-10-19 14:00:00	QQQ	ETF	148.01	148.15	147.89	148.095	1356656.0
2017-10-19 15:00:00	QQQ	ETF	148.1	148.33	148.065	148.33	4596486.0
2017-10-19 16:00:00	QQQ	ETF	148.32	148.45	148.3	148.43	645992.0
2017-10-19 17:00:00	QQQ	ETF	148.39	148.4	148.37	148.38	23182.0
2017-10-19 18:00:00	QQQ	ETF	148.39	148.39	148.3	148.31	26658.0
2017-10-19 19:00:00	QQQ	ETF	148.3	148.35	148.27	148.32	9791.0
2017-10-19 04:00:00	IWM	ETF	148.52	148.63	148.28	148.63	18132.0
2017-10-19 05:00:00	IWM	ETF	148.67	148.78	148.61	148.74	7311.0
2017-10-19 06:00:00	IWM	ETF	148.69	148.69	148.42	148.54	21989.0
2017-10-19 07:00:00	IWM	ETF	148.57	148.73	148.38	148.7	95979.0
2017-10-19 08:00:00	IWM	ETF	148.68	148.83	148.45	148.83	198979.0
2017-10-19 09:00:00	IWM	ETF	148.79	149.05	148.38	148.52	2769051.0
2017-10-19 10:00:00	IWM	ETF	148.51	148.99	148.17	148.89	3190435.0
2017-10-19 11:00:00	IWM	ETF	148.89	148.92	148.34	148.39	1799850.0
2017-10-19 12:00:00	IWM	ETF	148.395	148.62	148.32	148.58	1235806.0
2017-10-19 13:00:00	IWM	ETF	148.59	149.13	148.59	148.95	1455906.0
2017-10-19 14:00:00	IWM	ETF	148.95	149.32	148.93	149.1355	1400976.0
2017-10-19 15:00:00	IWM	ETF	149.13	149.33	149.09	149.29	1932549.0
2017-10-19 16:00:00	IWM	ETF	149.29	149.36	148.8711	149.32	582980.0
2017-10-19 17:00:00	IWM	ETF	149.2	149.34	149.2	149.34	202074.0
2017-10-19 18:00:00	IWM	ETF	149.23	149.25	149.23	149.25	2077.0
2017-10-19 19:00:00	IWM	ETF	149.22	149.29	149.21	149.29	11497.0
2017-10-19 04:00:00	DIA	ETF	230.96	230.96	230.4	230.4	400.0
2017-10-19 05:00:00	DIA	ETF	231.04	231.08	230.96	231.08	11000.0

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

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