PREVIEW / etf_1hour / 2017-09-21

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-21.parquet
  size:    276 KB
  rows:    9,027

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-09-21 04:00:00	SPY	ETF	249.87	249.88	249.75	249.88	8980.0
2017-09-21 05:00:00	SPY	ETF	249.85	249.9	249.83	249.9	2010.0
2017-09-21 06:00:00	SPY	ETF	249.9	249.92	249.9	249.92	1980.0
2017-09-21 07:00:00	SPY	ETF	249.95	249.97	249.89	249.91	13761.0
2017-09-21 08:00:00	SPY	ETF	249.95	250.01	249.85	249.99	125097.0
2017-09-21 09:00:00	SPY	ETF	249.98	250.0	249.19	249.39	6243456.0
2017-09-21 10:00:00	SPY	ETF	249.395	249.7	249.185	249.6099	8576996.0
2017-09-21 11:00:00	SPY	ETF	249.6	249.82	249.575	249.675	3894105.0
2017-09-21 12:00:00	SPY	ETF	249.68	249.84	249.57	249.74	6627978.0
2017-09-21 13:00:00	SPY	ETF	249.745	249.825	249.625	249.76	2038472.0
2017-09-21 14:00:00	SPY	ETF	249.76	249.79	249.42	249.64	3187253.0
2017-09-21 15:00:00	SPY	ETF	249.63	249.74	249.32	249.4	10351565.0
2017-09-21 16:00:00	SPY	ETF	249.39	249.6847	249.3421	249.57	6232026.0
2017-09-21 17:00:00	SPY	ETF	249.57	249.59	249.48	249.5	85140.0
2017-09-21 18:00:00	SPY	ETF	249.53	249.56	249.48	249.49	54952.0
2017-09-21 19:00:00	SPY	ETF	249.53	249.58	249.42	249.46	54701.0
2017-09-21 04:00:00	QQQ	ETF	145.18	145.24	145.17	145.24	1300.0
2017-09-21 06:00:00	QQQ	ETF	145.24	145.39	145.2	145.39	16377.0
2017-09-21 07:00:00	QQQ	ETF	145.34	145.35	145.29	145.31	10000.0
2017-09-21 08:00:00	QQQ	ETF	145.35	145.39	145.21	145.39	59187.0
2017-09-21 09:00:00	QQQ	ETF	145.34	145.35	144.28	144.48	4484909.0
2017-09-21 10:00:00	QQQ	ETF	144.47	144.575	143.95	144.45	5928183.0
2017-09-21 11:00:00	QQQ	ETF	144.4455	144.81	144.41	144.6911	2685522.0
2017-09-21 12:00:00	QQQ	ETF	144.7	144.93	144.59	144.8	1597935.0
2017-09-21 13:00:00	QQQ	ETF	144.79	145.07	144.78	144.95	2420267.0
2017-09-21 14:00:00	QQQ	ETF	144.96	145.01	144.6001	144.7565	1590264.0
2017-09-21 15:00:00	QQQ	ETF	144.76	144.86	144.42	144.45	3530794.0
2017-09-21 16:00:00	QQQ	ETF	144.46	144.7814	144.44	144.56	1286474.0
2017-09-21 17:00:00	QQQ	ETF	144.5	144.5	144.47	144.49	4683.0
2017-09-21 18:00:00	QQQ	ETF	144.51	144.55	144.47	144.48	12277.0
2017-09-21 19:00:00	QQQ	ETF	144.5	144.55	144.44	144.46	9353.0
2017-09-21 04:00:00	IWM	ETF	143.82	143.92	143.82	143.92	3503.0
2017-09-21 06:00:00	IWM	ETF	144.05	144.05	144.05	144.05	293.0
2017-09-21 07:00:00	IWM	ETF	143.99	143.99	143.96	143.96	17406.0
2017-09-21 08:00:00	IWM	ETF	144.0	144.0	143.89	144.0	34905.0
2017-09-21 09:00:00	IWM	ETF	144.02	144.07	143.48	143.69	1791977.0
2017-09-21 10:00:00	IWM	ETF	143.69	143.98	143.52	143.85	2338921.0
2017-09-21 11:00:00	IWM	ETF	143.86	144.15	143.74	144.01	1907651.0
2017-09-21 12:00:00	IWM	ETF	144.02	144.26	143.95	144.18	1275324.0
2017-09-21 13:00:00	IWM	ETF	144.19	144.21	144.02	144.135	854433.0
2017-09-21 14:00:00	IWM	ETF	144.14	144.17	143.75	143.95	1237576.0
2017-09-21 15:00:00	IWM	ETF	143.95	144.02	143.64	143.705	2145587.0
2017-09-21 16:00:00	IWM	ETF	143.71	144.0222	143.66	143.71	733034.0
2017-09-21 18:00:00	IWM	ETF	143.72	143.75	143.72	143.75	5890.0
2017-09-21 19:00:00	IWM	ETF	143.75	143.8	143.68	143.68	8985.0
2017-09-21 08:00:00	DIA	ETF	223.9	223.92	223.9	223.92	300.0
2017-09-21 09:00:00	DIA	ETF	223.9	223.97	223.54	223.67	304979.0
2017-09-21 10:00:00	DIA	ETF	223.68	223.9	223.53	223.77	240052.0
2017-09-21 11:00:00	DIA	ETF	223.79	223.86	223.64	223.65	225649.0
2017-09-21 12:00:00	DIA	ETF	223.66	223.74	223.49	223.6	121615.0

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

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