PREVIEW / etf_1hour / 2003-09-04

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-09-04.parquet
  size:    17 KB
  rows:    436

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-09-04 08:00:00	SPY	ETF	103.06	103.25	103.01	103.02	255600.0
2003-09-04 09:00:00	SPY	ETF	103.06	103.28	102.93	103.2	4202500.0
2003-09-04 10:00:00	SPY	ETF	103.2	103.55	102.76	102.92	6668500.0
2003-09-04 11:00:00	SPY	ETF	102.92	103.27	102.84	103.07	2847600.0
2003-09-04 12:00:00	SPY	ETF	103.07	103.38	103.02	103.26	2004900.0
2003-09-04 13:00:00	SPY	ETF	103.27	103.53	103.22	103.45	1675700.0
2003-09-04 14:00:00	SPY	ETF	103.46	103.52	103.22	103.23	1979900.0
2003-09-04 15:00:00	SPY	ETF	103.23	103.433	103.21	103.43	3417800.0
2003-09-04 16:00:00	SPY	ETF	103.4	103.72	103.38	103.545	1561300.0
2003-09-04 17:00:00	SPY	ETF	103.53	103.6	103.53	103.55	29100.0
2003-09-04 18:00:00	SPY	ETF	103.58	103.65	103.55	103.57	6900.0
2003-09-04 19:00:00	SPY	ETF	103.57	103.58	103.56	103.58	500.0
2003-09-04 08:00:00	QQQ	ETF	33.86	33.95	33.5	33.83	147200.0
2003-09-04 09:00:00	QQQ	ETF	33.84	33.98	33.7	33.91	9902800.0
2003-09-04 10:00:00	QQQ	ETF	33.91	34.07	33.76	33.79	13359000.0
2003-09-04 11:00:00	QQQ	ETF	33.799	34.0	33.74	33.91	6053500.0
2003-09-04 12:00:00	QQQ	ETF	33.92	34.14	33.89	34.072	7168800.0
2003-09-04 13:00:00	QQQ	ETF	34.08	34.2	34.02	34.18	6549100.0
2003-09-04 14:00:00	QQQ	ETF	34.17	34.22	34.05	34.065	4865600.0
2003-09-04 15:00:00	QQQ	ETF	34.06	34.18	34.02	34.15	8177600.0
2003-09-04 16:00:00	QQQ	ETF	34.16	34.37	34.12	34.25	2964600.0
2003-09-04 17:00:00	QQQ	ETF	34.25	34.3	34.25	34.288	120600.0
2003-09-04 18:00:00	QQQ	ETF	34.28	34.33	34.28	34.31	119600.0
2003-09-04 19:00:00	QQQ	ETF	34.31	34.32	34.29	34.3	19500.0
2003-09-04 09:00:00	IWM	ETF	51.0	51.075	50.805	51.045	428400.0
2003-09-04 10:00:00	IWM	ETF	51.04	51.165	50.835	50.855	1619600.0
2003-09-04 11:00:00	IWM	ETF	50.845	50.895	50.78	50.86	1002200.0
2003-09-04 12:00:00	IWM	ETF	50.87	51.09	50.845	51.07	395400.0
2003-09-04 13:00:00	IWM	ETF	51.055	51.19	51.035	51.19	419400.0
2003-09-04 14:00:00	IWM	ETF	51.19	51.275	51.04	51.065	380800.0
2003-09-04 15:00:00	IWM	ETF	51.055	51.225	51.055	51.165	384400.0
2003-09-04 16:00:00	IWM	ETF	51.155	51.175	51.13	51.175	10800.0
2003-09-04 08:00:00	DIA	ETF	95.93	95.93	95.81	95.88	6900.0
2003-09-04 09:00:00	DIA	ETF	95.85	96.09	95.76	96.07	548900.0
2003-09-04 10:00:00	DIA	ETF	96.08	96.37	95.65	95.82	1853100.0
2003-09-04 11:00:00	DIA	ETF	95.81	96.08	95.73	95.92	513100.0
2003-09-04 12:00:00	DIA	ETF	95.92	96.13	95.86	96.04	318000.0
2003-09-04 13:00:00	DIA	ETF	96.05	96.27	95.99	96.24	275800.0
2003-09-04 14:00:00	DIA	ETF	96.21	96.28	96.01	96.05	332700.0
2003-09-04 15:00:00	DIA	ETF	96.05	96.22	96.02	96.13	579000.0
2003-09-04 16:00:00	DIA	ETF	96.15	96.35	96.09	96.31	144200.0
2003-09-04 17:00:00	DIA	ETF	96.31	96.34	96.3	96.34	3600.0
2003-09-04 18:00:00	DIA	ETF	96.22	96.26	96.22	96.26	1000.0
2003-09-04 19:00:00	DIA	ETF	96.25	96.25	96.25	96.25	400.0
2003-09-04 09:00:00	TLT	ETF	82.49	82.49	82.4	82.45	14000.0
2003-09-04 10:00:00	TLT	ETF	82.37	82.41	82.16	82.4	180600.0
2003-09-04 11:00:00	TLT	ETF	82.4	82.4	82.2	82.35	43300.0
2003-09-04 12:00:00	TLT	ETF	82.31	82.7	82.31	82.65	149600.0
2003-09-04 13:00:00	TLT	ETF	82.6	82.7	82.54	82.58	42400.0
2003-09-04 14:00:00	TLT	ETF	82.58	82.58	82.25	82.47	47000.0

> showing 50 of 436 rows — these rows as CSV

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