PREVIEW / etf_1hour / 2007-02-21

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-02-21.parquet
  size:    66 KB
  rows:    2,097

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
2007-02-21 06:00:00	SPY	ETF	145.98	145.98	145.97	145.98	17000.0
2007-02-21 07:00:00	SPY	ETF	145.95	145.95	145.85	145.9	46600.0
2007-02-21 08:00:00	SPY	ETF	145.93	146.03	145.47	145.58	2889100.0
2007-02-21 09:00:00	SPY	ETF	145.6	145.74	145.47	145.66	8630200.0
2007-02-21 10:00:00	SPY	ETF	145.66	145.82	145.35	145.61	10386600.0
2007-02-21 11:00:00	SPY	ETF	145.62	145.78	145.5	145.74	5608200.0
2007-02-21 12:00:00	SPY	ETF	145.738	146.07	145.66	146.0	8341500.0
2007-02-21 13:00:00	SPY	ETF	146.0	146.06	145.7	145.79	7931300.0
2007-02-21 14:00:00	SPY	ETF	145.78	146.0	145.6	145.92	10399600.0
2007-02-21 15:00:00	SPY	ETF	145.93	145.97	145.82	145.89	6863400.0
2007-02-21 16:00:00	SPY	ETF	145.9	145.99	145.88	145.96	1012200.0
2007-02-21 17:00:00	SPY	ETF	145.92	145.96	145.92	145.96	27400.0
2007-02-21 18:00:00	SPY	ETF	145.95	145.95	145.92	145.95	23300.0
2007-02-21 07:00:00	QQQ	ETF	45.0	45.02	44.97	44.99	151000.0
2007-02-21 08:00:00	QQQ	ETF	45.0	45.02	44.81	44.86	2501169.0
2007-02-21 09:00:00	QQQ	ETF	44.87	45.0	44.83	44.95	19896973.0
2007-02-21 10:00:00	QQQ	ETF	44.94	45.1	44.88	45.06	18586700.0
2007-02-21 11:00:00	QQQ	ETF	45.06	45.07	44.97	45.03	9808500.0
2007-02-21 12:00:00	QQQ	ETF	45.03	45.15	44.98	45.11	11246800.0
2007-02-21 13:00:00	QQQ	ETF	45.11	45.18	44.98	45.03	10082600.0
2007-02-21 14:00:00	QQQ	ETF	45.03	45.14	44.96	45.13	10842900.0
2007-02-21 15:00:00	QQQ	ETF	45.12	45.21	45.07	45.19	9269400.0
2007-02-21 16:00:00	QQQ	ETF	45.19	45.27	45.18	45.23	2792935.0
2007-02-21 17:00:00	QQQ	ETF	45.23	45.24	45.21	45.23	95670.0
2007-02-21 18:00:00	QQQ	ETF	45.22	45.26	45.22	45.26	56621.0
2007-02-21 19:00:00	QQQ	ETF	45.24	45.26	45.22	45.26	20585.0
2007-02-21 07:00:00	IWM	ETF	81.93	81.93	81.93	81.93	2000.0
2007-02-21 08:00:00	IWM	ETF	81.93	81.94	81.56	81.65	288700.0
2007-02-21 09:00:00	IWM	ETF	81.62	81.89	81.57	81.8	6809200.0
2007-02-21 10:00:00	IWM	ETF	81.81	82.03	81.53	81.84	7322500.0
2007-02-21 11:00:00	IWM	ETF	81.85	82.03	81.73	81.93	6561100.0
2007-02-21 12:00:00	IWM	ETF	81.93	82.1	81.87	82.05	2987600.0
2007-02-21 13:00:00	IWM	ETF	82.04	82.1	81.65	81.89	5477000.0
2007-02-21 14:00:00	IWM	ETF	81.89	82.49	81.76	82.08	4119200.0
2007-02-21 15:00:00	IWM	ETF	82.08	82.16	81.95	82.06	3890400.0
2007-02-21 16:00:00	IWM	ETF	82.06	82.16	82.05	82.05	406100.0
2007-02-21 17:00:00	IWM	ETF	82.07	82.1	82.07	82.1	400200.0
2007-02-21 18:00:00	IWM	ETF	82.07	82.07	82.07	82.07	500.0
2007-02-21 07:00:00	DIA	ETF	127.52	127.52	127.52	127.52	100.0
2007-02-21 08:00:00	DIA	ETF	127.57	127.58	127.27	127.34	227800.0
2007-02-21 09:00:00	DIA	ETF	127.26	127.4	127.07	127.2	534400.0
2007-02-21 10:00:00	DIA	ETF	127.2	127.34	126.98	127.21	847100.0
2007-02-21 11:00:00	DIA	ETF	127.21	127.28	127.06	127.25	703900.0
2007-02-21 12:00:00	DIA	ETF	127.25	127.59	127.22	127.54	1163600.0
2007-02-21 13:00:00	DIA	ETF	127.55	127.57	127.25	127.32	334700.0
2007-02-21 14:00:00	DIA	ETF	127.31	127.51	127.19	127.38	628400.0
2007-02-21 15:00:00	DIA	ETF	127.39	127.41	127.27	127.34	656200.0
2007-02-21 16:00:00	DIA	ETF	127.33	127.35	127.28	127.29	149900.0
2007-02-21 07:00:00	GLD	ETF	65.33	65.33	65.31	65.31	1500.0
2007-02-21 08:00:00	GLD	ETF	65.31	65.43	65.16	65.27	221900.0

> showing 50 of 2,097 rows — these rows as CSV

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