PREVIEW / etf_1hour / 2003-10-02

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-02.parquet
  size:    18 KB
  rows:    438

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
2003-10-02 08:00:00	SPY	ETF	102.03	102.23	102.03	102.03	82400.0
2003-10-02 09:00:00	SPY	ETF	102.04	102.13	101.63	102.12	5664800.0
2003-10-02 10:00:00	SPY	ETF	102.09	102.48	101.97	102.15	11168500.0
2003-10-02 11:00:00	SPY	ETF	102.11	102.36	101.83	101.85	4612300.0
2003-10-02 12:00:00	SPY	ETF	101.85	102.1	101.75	102.04	2846400.0
2003-10-02 13:00:00	SPY	ETF	102.03	102.18	101.92	102.14	1983300.0
2003-10-02 14:00:00	SPY	ETF	102.14	102.353	102.04	102.2	2879700.0
2003-10-02 15:00:00	SPY	ETF	102.2	102.51	102.17	102.34	6765000.0
2003-10-02 16:00:00	SPY	ETF	102.34	102.56	102.291	102.49	1656400.0
2003-10-02 17:00:00	SPY	ETF	102.44	102.5	102.43	102.46	45500.0
2003-10-02 18:00:00	SPY	ETF	102.49	102.49	102.44	102.44	2300.0
2003-10-02 19:00:00	SPY	ETF	102.43	102.43	102.43	102.43	600.0
2003-10-02 08:00:00	QQQ	ETF	33.25	33.29	33.15	33.16	221800.0
2003-10-02 09:00:00	QQQ	ETF	33.15	33.28	32.97	33.28	13199900.0
2003-10-02 10:00:00	QQQ	ETF	33.27	33.43	33.12	33.194	19291500.0
2003-10-02 11:00:00	QQQ	ETF	33.193	33.28	33.03	33.05	7822000.0
2003-10-02 12:00:00	QQQ	ETF	33.04	33.15	32.93	33.1	8260800.0
2003-10-02 13:00:00	QQQ	ETF	33.1	33.18	33.02	33.132	4042200.0
2003-10-02 14:00:00	QQQ	ETF	33.14	33.25	33.07	33.181	6179400.0
2003-10-02 15:00:00	QQQ	ETF	33.18	33.33	33.15	33.21	11678000.0
2003-10-02 16:00:00	QQQ	ETF	33.22	33.27	33.2	33.22	2550500.0
2003-10-02 17:00:00	QQQ	ETF	33.22	33.25	33.2	33.24	74500.0
2003-10-02 18:00:00	QQQ	ETF	33.22	33.24	33.22	33.23	12400.0
2003-10-02 19:00:00	QQQ	ETF	33.23	33.24	33.2	33.2	6100.0
2003-10-02 09:00:00	IWM	ETF	49.85	50.1	49.755	50.1	1296400.0
2003-10-02 10:00:00	IWM	ETF	50.095	50.35	49.9	50.015	1193600.0
2003-10-02 11:00:00	IWM	ETF	49.98	50.175	49.94	49.99	591200.0
2003-10-02 12:00:00	IWM	ETF	49.965	50.145	49.91	50.1	930600.0
2003-10-02 13:00:00	IWM	ETF	50.125	50.185	50.05	50.175	277200.0
2003-10-02 14:00:00	IWM	ETF	50.16	50.285	50.145	50.175	258200.0
2003-10-02 15:00:00	IWM	ETF	50.175	50.365	50.085	50.125	1166800.0
2003-10-02 16:00:00	IWM	ETF	50.135	50.38	50.115	50.315	296800.0
2003-10-02 17:00:00	IWM	ETF	50.175	50.175	50.175	50.175	20000.0
2003-10-02 08:00:00	DIA	ETF	94.7	94.73	94.65	94.65	1400.0
2003-10-02 09:00:00	DIA	ETF	94.57	94.84	94.45	94.84	568900.0
2003-10-02 10:00:00	DIA	ETF	94.83	95.18	94.69	94.8	842500.0
2003-10-02 11:00:00	DIA	ETF	94.76	95.12	94.73	94.76	436100.0
2003-10-02 12:00:00	DIA	ETF	94.74	94.92	94.6	94.88	743300.0
2003-10-02 13:00:00	DIA	ETF	94.88	94.98	94.8	94.95	284100.0
2003-10-02 14:00:00	DIA	ETF	94.94	95.15	94.88	95.03	751100.0
2003-10-02 15:00:00	DIA	ETF	95.06	95.29	94.91	95.05	1518900.0
2003-10-02 16:00:00	DIA	ETF	95.05	95.2	95.05	95.2	106900.0
2003-10-02 17:00:00	DIA	ETF	95.15	95.19	95.15	95.19	1000.0
2003-10-02 18:00:00	DIA	ETF	95.2	95.2	95.2	95.2	200.0
2003-10-02 09:00:00	TLT	ETF	86.84	86.84	86.56	86.6	194100.0
2003-10-02 10:00:00	TLT	ETF	86.57	86.8	86.47	86.7	364800.0
2003-10-02 11:00:00	TLT	ETF	86.7	86.94	86.69	86.78	81900.0
2003-10-02 12:00:00	TLT	ETF	86.81	86.85	86.79	86.85	102000.0
2003-10-02 13:00:00	TLT	ETF	86.86	87.28	86.86	87.27	47400.0
2003-10-02 14:00:00	TLT	ETF	87.26	87.45	87.19	87.19	34200.0

> showing 50 of 438 rows — these rows as CSV

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