PREVIEW / etf_1hour / 2007-02-22

all etf 1-hour files

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

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-22 06:00:00	SPY	ETF	146.12	146.12	146.12	146.12	4000.0
2007-02-22 07:00:00	SPY	ETF	146.09	146.19	146.09	146.15	48100.0
2007-02-22 08:00:00	SPY	ETF	146.15	146.24	146.12	146.14	932000.0
2007-02-22 09:00:00	SPY	ETF	146.14	146.42	146.04	146.28	9451100.0
2007-02-22 10:00:00	SPY	ETF	146.28	146.32	145.82	146.05	13202600.0
2007-02-22 11:00:00	SPY	ETF	146.05	146.06	145.17	145.6	18166600.0
2007-02-22 12:00:00	SPY	ETF	145.59	145.71	145.53	145.61	7806500.0
2007-02-22 13:00:00	SPY	ETF	145.6	145.82	145.56	145.69	8522100.0
2007-02-22 14:00:00	SPY	ETF	145.69	145.79	145.41	145.49	8929200.0
2007-02-22 15:00:00	SPY	ETF	145.49	145.84	145.49	145.83	8590600.0
2007-02-22 16:00:00	SPY	ETF	145.84	145.91	145.71	145.83	1385800.0
2007-02-22 17:00:00	SPY	ETF	145.8	145.81	145.76	145.79	76700.0
2007-02-22 18:00:00	SPY	ETF	145.79	145.81	145.79	145.8	7600.0
2007-02-22 19:00:00	SPY	ETF	145.81	145.81	145.8	145.81	1700.0
2007-02-22 05:00:00	QQQ	ETF	45.28	45.28	45.28	45.28	200.0
2007-02-22 07:00:00	QQQ	ETF	45.29	45.32	45.28	45.31	708312.0
2007-02-22 08:00:00	QQQ	ETF	45.31	45.4	45.29	45.36	2567726.0
2007-02-22 09:00:00	QQQ	ETF	45.37	45.55	45.34	45.47	19485688.0
2007-02-22 10:00:00	QQQ	ETF	45.47	45.48	45.25	45.45	19946800.0
2007-02-22 11:00:00	QQQ	ETF	45.45	45.45	45.07	45.21	27614800.0
2007-02-22 12:00:00	QQQ	ETF	45.22	45.29	45.16	45.24	7863000.0
2007-02-22 13:00:00	QQQ	ETF	45.25	45.32	45.19	45.24	6420100.0
2007-02-22 14:00:00	QQQ	ETF	45.24	45.29	45.14	45.15	5468000.0
2007-02-22 15:00:00	QQQ	ETF	45.15	45.42	45.15	45.42	16101500.0
2007-02-22 16:00:00	QQQ	ETF	45.42	45.48	45.2399	45.47	4316470.0
2007-02-22 17:00:00	QQQ	ETF	45.46	45.51	45.45	45.47	496594.0
2007-02-22 18:00:00	QQQ	ETF	45.49	45.5	45.47	45.47	19200.0
2007-02-22 19:00:00	QQQ	ETF	45.47	45.49	45.46	45.49	10900.0
2007-02-22 07:00:00	IWM	ETF	82.23	82.23	82.23	82.23	100.0
2007-02-22 08:00:00	IWM	ETF	82.14	82.28	82.14	82.23	86700.0
2007-02-22 09:00:00	IWM	ETF	82.22	82.45	82.05	82.34	6434600.0
2007-02-22 10:00:00	IWM	ETF	82.34	82.35	81.89	82.13	10188400.0
2007-02-22 11:00:00	IWM	ETF	82.13	82.15	81.63	81.87	8142200.0
2007-02-22 12:00:00	IWM	ETF	81.87	81.95	81.73	81.88	3451300.0
2007-02-22 13:00:00	IWM	ETF	81.88	81.93	81.73	81.85	2972700.0
2007-02-22 14:00:00	IWM	ETF	81.86	81.95	81.77	81.86	5223800.0
2007-02-22 15:00:00	IWM	ETF	81.86	82.38	81.86	82.36	15062100.0
2007-02-22 16:00:00	IWM	ETF	82.37	82.41	82.3177	82.35	529100.0
2007-02-22 17:00:00	IWM	ETF	82.35	82.35	82.29	82.29	47700.0
2007-02-22 07:00:00	DIA	ETF	127.37	127.37	127.37	127.37	100.0
2007-02-22 08:00:00	DIA	ETF	127.5	127.57	127.5	127.55	11000.0
2007-02-22 09:00:00	DIA	ETF	127.5	127.59	127.25	127.5	381100.0
2007-02-22 10:00:00	DIA	ETF	127.5	127.52	127.09	127.24	793900.0
2007-02-22 11:00:00	DIA	ETF	127.24	127.25	126.44	126.69	2691900.0
2007-02-22 12:00:00	DIA	ETF	126.7	126.85	126.59	126.69	1336100.0
2007-02-22 13:00:00	DIA	ETF	126.69	126.86	126.63	126.76	493500.0
2007-02-22 14:00:00	DIA	ETF	126.77	126.83	126.51	126.56	502100.0
2007-02-22 15:00:00	DIA	ETF	126.56	126.83	126.56	126.83	851500.0
2007-02-22 16:00:00	DIA	ETF	126.84	126.89	126.75	126.75	64500.0
2007-02-22 17:00:00	DIA	ETF	126.81	126.81	126.71	126.71	300.0

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

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