PREVIEW / etf_1hour / 2017-03-23

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-23.parquet
  size:    269 KB
  rows:    8,694

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-03-23 04:00:00	SPY	ETF	234.25	234.25	234.0	234.12	4739.0
2017-03-23 05:00:00	SPY	ETF	234.12	234.38	234.09	234.2	28826.0
2017-03-23 06:00:00	SPY	ETF	234.29	234.5	234.17	234.5	10002.0
2017-03-23 07:00:00	SPY	ETF	234.51	234.58	234.37	234.46	71320.0
2017-03-23 08:00:00	SPY	ETF	234.51	234.58	234.12	234.19	597004.0
2017-03-23 09:00:00	SPY	ETF	234.18	234.45	233.72	234.16	9191215.0
2017-03-23 10:00:00	SPY	ETF	234.16	234.97	234.08	234.77	11297417.0
2017-03-23 11:00:00	SPY	ETF	234.78	235.34	234.75	235.06	11464953.0
2017-03-23 12:00:00	SPY	ETF	235.06	235.31	235.04	235.28	8460174.0
2017-03-23 13:00:00	SPY	ETF	235.29	235.29	234.2847	234.69	13064520.0
2017-03-23 14:00:00	SPY	ETF	234.7	234.96	234.53	234.61	5511716.0
2017-03-23 15:00:00	SPY	ETF	234.61	234.655	233.6	234.01	28041013.0
2017-03-23 16:00:00	SPY	ETF	234.0	234.6665	233.67	233.86	8871838.0
2017-03-23 17:00:00	SPY	ETF	233.85	233.88	233.74	233.8	227389.0
2017-03-23 18:00:00	SPY	ETF	233.83	234.22	233.83	234.0	154315.0
2017-03-23 19:00:00	SPY	ETF	234.0	234.2	233.99	234.05	30549.0
2017-03-23 04:00:00	QQQ	ETF	130.78	130.78	130.51	130.51	62598.0
2017-03-23 05:00:00	QQQ	ETF	130.52	130.59	130.52	130.59	1099.0
2017-03-23 06:00:00	QQQ	ETF	130.63	130.72	130.58	130.72	6998.0
2017-03-23 07:00:00	QQQ	ETF	130.76	130.81	130.73	130.75	5300.0
2017-03-23 08:00:00	QQQ	ETF	130.77	130.84	130.6	130.6	132846.0
2017-03-23 09:00:00	QQQ	ETF	130.59	130.67	130.251	130.375	2316926.0
2017-03-23 10:00:00	QQQ	ETF	130.37	130.765	130.171	130.65	2341933.0
2017-03-23 11:00:00	QQQ	ETF	130.65	130.88	130.62	130.812	1652264.0
2017-03-23 12:00:00	QQQ	ETF	130.8	130.88	130.725	130.84	912526.0
2017-03-23 13:00:00	QQQ	ETF	130.84	130.845	130.35	130.545	2504155.0
2017-03-23 14:00:00	QQQ	ETF	130.5337	130.8	130.505	130.645	1213570.0
2017-03-23 15:00:00	QQQ	ETF	130.63	130.64	130.14	130.39	5042605.0
2017-03-23 16:00:00	QQQ	ETF	130.38	130.5093	130.21	130.36	2686116.0
2017-03-23 17:00:00	QQQ	ETF	130.39	130.39	130.35	130.35	3485.0
2017-03-23 18:00:00	QQQ	ETF	130.39	130.56	130.38	130.52	16483.0
2017-03-23 19:00:00	QQQ	ETF	130.52	130.56	130.48	130.52	6750.0
2017-03-23 04:00:00	IWM	ETF	133.93	133.96	133.93	133.96	900.0
2017-03-23 05:00:00	IWM	ETF	134.17	134.17	134.06	134.09	1979.0
2017-03-23 06:00:00	IWM	ETF	134.22	134.22	134.22	134.22	300.0
2017-03-23 07:00:00	IWM	ETF	134.25	134.3	134.2	134.24	11647.0
2017-03-23 08:00:00	IWM	ETF	134.24	134.37	134.11	134.11	131531.0
2017-03-23 09:00:00	IWM	ETF	134.09	134.46	133.64	134.42	3081041.0
2017-03-23 10:00:00	IWM	ETF	134.42	135.44	134.37	135.25	5340976.0
2017-03-23 11:00:00	IWM	ETF	135.24	135.66	135.1501	135.28	3775671.0
2017-03-23 12:00:00	IWM	ETF	135.28	135.6957	135.2001	135.63	1778878.0
2017-03-23 13:00:00	IWM	ETF	135.63	135.63	134.92	135.27	4479668.0
2017-03-23 14:00:00	IWM	ETF	135.27	135.43	135.1401	135.2	2515791.0
2017-03-23 15:00:00	IWM	ETF	135.2	135.24	134.34	134.75	7939110.0
2017-03-23 16:00:00	IWM	ETF	134.74	134.78	133.9881	134.73	2331861.0
2017-03-23 17:00:00	IWM	ETF	134.68	134.75	134.66	134.69	5650.0
2017-03-23 18:00:00	IWM	ETF	134.74	134.88	134.74	134.85	2177.0
2017-03-23 19:00:00	IWM	ETF	134.85	134.85	134.67	134.67	22081.0
2017-03-23 07:00:00	DIA	ETF	206.36	206.36	206.36	206.36	535.0
2017-03-23 08:00:00	DIA	ETF	206.21	206.44	206.16	206.16	2430.0

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

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