PREVIEW / etf_1hour / 2017-05-23

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-23.parquet
  size:    274 KB
  rows:    8,933

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-23 04:00:00	SPY	ETF	239.8	240.05	239.8	239.9	27309.0
2017-05-23 05:00:00	SPY	ETF	239.91	239.91	239.76	239.76	8690.0
2017-05-23 06:00:00	SPY	ETF	239.85	239.9	239.8	239.9	62090.0
2017-05-23 07:00:00	SPY	ETF	239.9	240.06	239.85	239.92	342096.0
2017-05-23 08:00:00	SPY	ETF	239.92	240.03	239.85	239.88	204055.0
2017-05-23 09:00:00	SPY	ETF	239.87	240.02	239.57	239.655	4537447.0
2017-05-23 10:00:00	SPY	ETF	239.66	239.94	239.51	239.88	8204524.0
2017-05-23 11:00:00	SPY	ETF	239.87	240.15	239.84	240.09	4996285.0
2017-05-23 12:00:00	SPY	ETF	240.09	240.24	239.82	239.8558	4984098.0
2017-05-23 13:00:00	SPY	ETF	239.85	240.11	239.84	240.02	3094578.0
2017-05-23 14:00:00	SPY	ETF	240.015	240.18	239.88	240.12	5310851.0
2017-05-23 15:00:00	SPY	ETF	240.11	240.21	239.84	240.02	12437892.0
2017-05-23 16:00:00	SPY	ETF	240.01	240.14	239.96	240.01	2843428.0
2017-05-23 17:00:00	SPY	ETF	240.0	240.01	239.93	239.98	307479.0
2017-05-23 18:00:00	SPY	ETF	239.98	239.99	239.93	239.97	55518.0
2017-05-23 19:00:00	SPY	ETF	239.96	239.98	239.95	239.97	14662.0
2017-05-23 04:00:00	QQQ	ETF	139.28	139.36	139.28	139.3	2100.0
2017-05-23 05:00:00	QQQ	ETF	139.21	139.23	139.21	139.23	1377.0
2017-05-23 06:00:00	QQQ	ETF	139.22	139.25	139.21	139.25	1000.0
2017-05-23 07:00:00	QQQ	ETF	139.28	139.4	139.27	139.34	151549.0
2017-05-23 08:00:00	QQQ	ETF	139.28	139.4	139.28	139.31	22603.0
2017-05-23 09:00:00	QQQ	ETF	139.32	139.44	138.84	138.9861	2981217.0
2017-05-23 10:00:00	QQQ	ETF	138.9801	139.17	138.896	139.06	2215009.0
2017-05-23 11:00:00	QQQ	ETF	139.06	139.24	139.05	139.225	1576473.0
2017-05-23 12:00:00	QQQ	ETF	139.22	139.24	138.7801	138.8593	2161444.0
2017-05-23 13:00:00	QQQ	ETF	138.86	139.01	138.85	138.9573	1353401.0
2017-05-23 14:00:00	QQQ	ETF	138.95	139.1	138.9001	139.04	1299027.0
2017-05-23 15:00:00	QQQ	ETF	139.04	139.145	138.95	139.14	3062853.0
2017-05-23 16:00:00	QQQ	ETF	139.14	139.3	139.12	139.23	1454486.0
2017-05-23 17:00:00	QQQ	ETF	139.22	139.26	139.21	139.21	5529.0
2017-05-23 18:00:00	QQQ	ETF	139.2	139.24	139.2	139.22	6903.0
2017-05-23 19:00:00	QQQ	ETF	139.22	139.23	139.21	139.23	3600.0
2017-05-23 04:00:00	IWM	ETF	137.17	137.19	137.16	137.16	5703.0
2017-05-23 05:00:00	IWM	ETF	137.17	137.17	137.17	137.17	2800.0
2017-05-23 06:00:00	IWM	ETF	137.09	137.11	137.09	137.11	1103.0
2017-05-23 07:00:00	IWM	ETF	137.18	137.32	137.18	137.25	49521.0
2017-05-23 08:00:00	IWM	ETF	137.25	137.3	137.15	137.15	135360.0
2017-05-23 09:00:00	IWM	ETF	137.19	137.37	136.35	136.485	1970556.0
2017-05-23 10:00:00	IWM	ETF	136.48	137.05	136.37	137.05	2814231.0
2017-05-23 11:00:00	IWM	ETF	137.045	137.63	136.99	137.5	2650419.0
2017-05-23 12:00:00	IWM	ETF	137.5	137.69	136.94	137.0101	1871521.0
2017-05-23 13:00:00	IWM	ETF	137.01	137.32	137.01	137.205	1077772.0
2017-05-23 14:00:00	IWM	ETF	137.2	137.64	137.13	137.52	1097599.0
2017-05-23 15:00:00	IWM	ETF	137.53	137.67	137.2289	137.41	3243549.0
2017-05-23 16:00:00	IWM	ETF	137.39	137.5	137.34	137.34	758714.0
2017-05-23 17:00:00	IWM	ETF	137.4	137.41	137.37	137.37	8436.0
2017-05-23 18:00:00	IWM	ETF	137.4	137.4	137.4	137.4	111.0
2017-05-23 19:00:00	IWM	ETF	137.43	137.43	137.43	137.43	100.0
2017-05-23 04:00:00	DIA	ETF	208.88	209.0	208.88	209.0	200.0
2017-05-23 07:00:00	DIA	ETF	209.1	209.25	209.1	209.25	4162.0

> showing 50 of 8,933 rows — these rows as CSV

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