PREVIEW / etf_1hour / 2017-09-22

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-22.parquet
  size:    273 KB
  rows:    8,919

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-22 04:00:00	SPY	ETF	249.22	249.3	249.08	249.24	8758.0
2017-09-22 05:00:00	SPY	ETF	249.21	249.21	249.21	249.21	200.0
2017-09-22 06:00:00	SPY	ETF	249.32	249.41	249.31	249.38	18200.0
2017-09-22 07:00:00	SPY	ETF	249.41	249.41	249.13	249.13	114299.0
2017-09-22 08:00:00	SPY	ETF	249.12	249.42	249.03	249.03	213497.0
2017-09-22 09:00:00	SPY	ETF	249.03	249.31	248.97	249.14	4984142.0
2017-09-22 10:00:00	SPY	ETF	249.15	249.42	249.09	249.1189	4693061.0
2017-09-22 11:00:00	SPY	ETF	249.115	249.3	249.05	249.28	3104993.0
2017-09-22 12:00:00	SPY	ETF	249.29	249.36	249.14	249.14	3687247.0
2017-09-22 13:00:00	SPY	ETF	249.14	249.26	249.04	249.23	3859096.0
2017-09-22 14:00:00	SPY	ETF	249.2275	249.29	249.14	249.26	2860265.0
2017-09-22 15:00:00	SPY	ETF	249.265	249.63	249.26	249.42	13019855.0
2017-09-22 16:00:00	SPY	ETF	249.43	249.56	249.26	249.52	14019823.0
2017-09-22 17:00:00	SPY	ETF	249.52	249.53	249.47	249.52	104114.0
2017-09-22 18:00:00	SPY	ETF	249.49	249.52	249.48	249.48	5992.0
2017-09-22 19:00:00	SPY	ETF	249.5	249.54	249.5	249.54	14653.0
2017-09-22 04:00:00	QQQ	ETF	144.32	144.32	144.14	144.21	7500.0
2017-09-22 05:00:00	QQQ	ETF	144.18	144.19	144.18	144.19	800.0
2017-09-22 06:00:00	QQQ	ETF	144.33	144.36	144.31	144.35	14621.0
2017-09-22 07:00:00	QQQ	ETF	144.35	144.35	144.06	144.08	39746.0
2017-09-22 08:00:00	QQQ	ETF	144.35	144.35	144.02	144.09	175919.0
2017-09-22 09:00:00	QQQ	ETF	144.09	144.47	143.9108	144.14	2847198.0
2017-09-22 10:00:00	QQQ	ETF	144.15	144.53	144.01	144.02	3193419.0
2017-09-22 11:00:00	QQQ	ETF	144.02	144.2	144.01	144.18	1711352.0
2017-09-22 12:00:00	QQQ	ETF	144.18	144.2892	144.05	144.09	1509718.0
2017-09-22 13:00:00	QQQ	ETF	144.09	144.21	143.855	144.15	1408195.0
2017-09-22 14:00:00	QQQ	ETF	144.16	144.29	144.09	144.275	1501527.0
2017-09-22 15:00:00	QQQ	ETF	144.28	144.45	144.16	144.32	5129699.0
2017-09-22 16:00:00	QQQ	ETF	144.33	144.415	144.2145	144.415	1088363.0
2017-09-22 17:00:00	QQQ	ETF	144.36	144.37	144.32	144.32	7880.0
2017-09-22 18:00:00	QQQ	ETF	144.33	144.33	144.31	144.31	5070.0
2017-09-22 19:00:00	QQQ	ETF	144.33	144.33	144.31	144.33	4640.0
2017-09-22 04:00:00	IWM	ETF	143.55	143.55	143.52	143.52	732.0
2017-09-22 05:00:00	IWM	ETF	143.64	143.75	143.5	143.75	2853.0
2017-09-22 06:00:00	IWM	ETF	143.74	143.84	143.74	143.81	1103.0
2017-09-22 07:00:00	IWM	ETF	143.85	143.85	143.63	143.69	76270.0
2017-09-22 08:00:00	IWM	ETF	143.7	143.74	143.63	143.63	56613.0
2017-09-22 09:00:00	IWM	ETF	143.64	143.98	143.56	143.87	2176890.0
2017-09-22 10:00:00	IWM	ETF	143.88	144.67	143.875	144.37	3435768.0
2017-09-22 11:00:00	IWM	ETF	144.37	144.55	144.11	144.25	2042872.0
2017-09-22 12:00:00	IWM	ETF	144.25	144.355	144.17	144.245	1440361.0
2017-09-22 13:00:00	IWM	ETF	144.24	144.51	144.24	144.49	2075627.0
2017-09-22 14:00:00	IWM	ETF	144.49	144.545	144.29	144.38	1470618.0
2017-09-22 15:00:00	IWM	ETF	144.38	144.52	144.28	144.28	3669903.0
2017-09-22 16:00:00	IWM	ETF	144.29	144.47	144.26	144.35	749280.0
2017-09-22 17:00:00	IWM	ETF	144.35	144.38	144.3	144.34	1050954.0
2017-09-22 18:00:00	IWM	ETF	144.37	144.39	144.35	144.37	3906.0
2017-09-22 19:00:00	IWM	ETF	144.39	144.41	144.38	144.41	6221.0
2017-09-22 08:00:00	DIA	ETF	223.3	223.3	223.2	223.2	5400.0
2017-09-22 09:00:00	DIA	ETF	223.14	223.42	223.13	223.28	343446.0

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

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