PREVIEW / etf_1hour / 2019-09-26

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-26.parquet
  size:    324 KB
  rows:    10,766

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
2019-09-26 04:00:00	SPY	ETF	297.83	298.5	297.73	298.16	38411.0
2019-09-26 05:00:00	SPY	ETF	298.2	298.28	298.07	298.07	9072.0
2019-09-26 06:00:00	SPY	ETF	298.11	298.24	298.0	298.16	5641.0
2019-09-26 07:00:00	SPY	ETF	298.1	298.34	298.03	298.32	97910.0
2019-09-26 08:00:00	SPY	ETF	298.1501	298.34	297.03	298.0	390648.0
2019-09-26 09:00:00	SPY	ETF	297.98	298.03	296.53	296.75	5339885.0
2019-09-26 10:00:00	SPY	ETF	296.75	297.21	296.26	296.56	7652876.0
2019-09-26 11:00:00	SPY	ETF	296.56	296.57	295.45	295.845	7005012.0
2019-09-26 12:00:00	SPY	ETF	295.845	296.83	295.61	296.6	6181937.0
2019-09-26 13:00:00	SPY	ETF	296.61	296.88	296.11	296.87	4171196.0
2019-09-26 14:00:00	SPY	ETF	296.88	297.54	296.87	296.96	6443286.0
2019-09-26 15:00:00	SPY	ETF	296.96	297.86	296.7	296.97	13178755.0
2019-09-26 16:00:00	SPY	ETF	296.98	297.24	296.8564	296.94	5070532.0
2019-09-26 17:00:00	SPY	ETF	296.96	297.0	296.84	296.84	2309972.0
2019-09-26 18:00:00	SPY	ETF	296.98	297.26	296.98	297.08	85188.0
2019-09-26 19:00:00	SPY	ETF	297.1	297.16	296.8	296.84	35853.0
2019-09-26 04:00:00	QQQ	ETF	190.0	190.5	189.95	190.27	7367.0
2019-09-26 05:00:00	QQQ	ETF	190.33	190.4	190.13	190.17	11774.0
2019-09-26 06:00:00	QQQ	ETF	190.25	190.25	190.06	190.19	9409.0
2019-09-26 07:00:00	QQQ	ETF	190.18	190.37	190.07	190.36	35899.0
2019-09-26 08:00:00	QQQ	ETF	190.14	190.38	189.56	190.14	351418.0
2019-09-26 09:00:00	QQQ	ETF	190.15	190.17	188.75	188.91	3233225.0
2019-09-26 10:00:00	QQQ	ETF	188.9166	189.48	188.55	188.88	3697568.0
2019-09-26 11:00:00	QQQ	ETF	188.87	188.92	187.98	188.42	4218108.0
2019-09-26 12:00:00	QQQ	ETF	188.42	189.14	188.19	188.79	3046738.0
2019-09-26 13:00:00	QQQ	ETF	188.8	189.0794	188.43	189.06	1997799.0
2019-09-26 14:00:00	QQQ	ETF	189.07	189.59	189.07	189.1408	2323313.0
2019-09-26 15:00:00	QQQ	ETF	189.15	190.0	189.12	189.37	4654392.0
2019-09-26 16:00:00	QQQ	ETF	189.39	189.58	189.11	189.2	816818.0
2019-09-26 17:00:00	QQQ	ETF	189.24	189.38	189.08	189.19	24629.0
2019-09-26 18:00:00	QQQ	ETF	189.2	189.39	189.2	189.27	25128.0
2019-09-26 19:00:00	QQQ	ETF	189.29	189.32	189.06	189.06	17606.0
2019-09-26 04:00:00	IWM	ETF	154.45	154.51	154.45	154.48	5800.0
2019-09-26 05:00:00	IWM	ETF	154.34	154.34	154.34	154.34	4000.0
2019-09-26 06:00:00	IWM	ETF	154.25	154.29	154.25	154.29	3000.0
2019-09-26 07:00:00	IWM	ETF	154.3	154.4	154.3	154.39	8900.0
2019-09-26 08:00:00	IWM	ETF	154.16	154.38	153.95	154.13	97106.0
2019-09-26 09:00:00	IWM	ETF	154.13	154.13	153.12	153.35	1614860.0
2019-09-26 10:00:00	IWM	ETF	153.35	153.64	152.64	152.83	2327951.0
2019-09-26 11:00:00	IWM	ETF	152.83	152.84	151.9516	152.1	2519455.0
2019-09-26 12:00:00	IWM	ETF	152.12	152.83	151.99	152.47	2056061.0
2019-09-26 13:00:00	IWM	ETF	152.48	152.53	151.95	152.45	1820561.0
2019-09-26 14:00:00	IWM	ETF	152.47	152.83	152.34	152.56	1761212.0
2019-09-26 15:00:00	IWM	ETF	152.555	152.81	152.3	152.4	3194146.0
2019-09-26 16:00:00	IWM	ETF	152.41	152.55	152.3238	152.42	1150906.0
2019-09-26 17:00:00	IWM	ETF	152.36	152.46	152.33	152.4	10539.0
2019-09-26 18:00:00	IWM	ETF	152.44	152.61	152.44	152.54	44493.0
2019-09-26 19:00:00	IWM	ETF	152.57	152.57	152.39	152.39	2982.0
2019-09-26 04:00:00	DIA	ETF	269.76	270.21	269.74	270.21	800.0
2019-09-26 05:00:00	DIA	ETF	270.25	270.25	270.25	270.25	500.0

> showing 50 of 10,766 rows — these rows as CSV

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