PREVIEW / etf_1hour / 2003-09-08

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-09-08.parquet
  size:    17 KB
  rows:    431

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-08 08:00:00	SPY	ETF	102.84	102.97	102.81	102.97	25400.0
2003-09-08 09:00:00	SPY	ETF	103.0	103.7	102.93	103.596	6926300.0
2003-09-08 10:00:00	SPY	ETF	103.58	103.78	103.37	103.49	4816000.0
2003-09-08 11:00:00	SPY	ETF	103.52	103.79	103.48	103.543	3816700.0
2003-09-08 12:00:00	SPY	ETF	103.55	103.61	103.44	103.5	1683500.0
2003-09-08 13:00:00	SPY	ETF	103.51	103.88	103.46	103.78	2558200.0
2003-09-08 14:00:00	SPY	ETF	103.78	103.83	103.57	103.62	4094300.0
2003-09-08 15:00:00	SPY	ETF	103.62	103.82	103.44	103.8	4211400.0
2003-09-08 16:00:00	SPY	ETF	103.8	103.82	103.63	103.69	2166400.0
2003-09-08 17:00:00	SPY	ETF	103.73	103.74	103.68	103.69	13000.0
2003-09-08 18:00:00	SPY	ETF	103.725	103.73	103.7	103.7	10900.0
2003-09-08 19:00:00	SPY	ETF	103.74	103.74	103.65	103.72	10900.0
2003-09-08 08:00:00	QQQ	ETF	33.95	34.0	33.89	34.0	51200.0
2003-09-08 09:00:00	QQQ	ETF	33.99	34.25	33.95	34.24	9283600.0
2003-09-08 10:00:00	QQQ	ETF	34.24	34.44	34.13	34.32	15173400.0
2003-09-08 11:00:00	QQQ	ETF	34.34	34.51	34.32	34.372	8707500.0
2003-09-08 12:00:00	QQQ	ETF	34.38	34.41	34.27	34.33	6331900.0
2003-09-08 13:00:00	QQQ	ETF	34.332	34.5	34.3	34.42	5023800.0
2003-09-08 14:00:00	QQQ	ETF	34.41	34.476	34.32	34.351	4714200.0
2003-09-08 15:00:00	QQQ	ETF	34.351	34.47	34.27	34.459	10789500.0
2003-09-08 16:00:00	QQQ	ETF	34.45	34.55	34.45	34.53	2967700.0
2003-09-08 17:00:00	QQQ	ETF	34.53	34.542	34.51	34.51	90800.0
2003-09-08 18:00:00	QQQ	ETF	34.52	34.54	34.5	34.51	25400.0
2003-09-08 19:00:00	QQQ	ETF	34.54	34.54	34.53	34.53	22300.0
2003-09-08 09:00:00	IWM	ETF	51.075	51.58	50.985	51.58	651800.0
2003-09-08 10:00:00	IWM	ETF	51.59	51.65	51.41	51.525	652600.0
2003-09-08 11:00:00	IWM	ETF	51.525	51.7	51.46	51.46	1021200.0
2003-09-08 12:00:00	IWM	ETF	51.455	51.47	51.375	51.455	432400.0
2003-09-08 13:00:00	IWM	ETF	51.455	51.685	51.405	51.625	511200.0
2003-09-08 14:00:00	IWM	ETF	51.61	51.69	51.56	51.595	164000.0
2003-09-08 15:00:00	IWM	ETF	51.58	51.67	51.5	51.59	500400.0
2003-09-08 16:00:00	IWM	ETF	51.615	51.64	51.555	51.605	79000.0
2003-09-08 08:00:00	DIA	ETF	95.45	95.5	95.45	95.49	2200.0
2003-09-08 09:00:00	DIA	ETF	95.47	96.06	95.31	96.0	766100.0
2003-09-08 10:00:00	DIA	ETF	96.0	96.13	95.79	95.97	729900.0
2003-09-08 11:00:00	DIA	ETF	95.95	96.16	95.94	96.02	503300.0
2003-09-08 12:00:00	DIA	ETF	96.0	96.05	95.86	95.93	198400.0
2003-09-08 13:00:00	DIA	ETF	95.93	96.24	95.92	96.15	371000.0
2003-09-08 14:00:00	DIA	ETF	96.15	96.18	95.96	96.01	338700.0
2003-09-08 15:00:00	DIA	ETF	96.03	96.14	95.83	96.11	580900.0
2003-09-08 16:00:00	DIA	ETF	96.11	96.18	96.08	96.16	91600.0
2003-09-08 17:00:00	DIA	ETF	96.2	96.45	96.2	96.45	7300.0
2003-09-08 19:00:00	DIA	ETF	96.12	96.25	96.12	96.25	3200.0
2003-09-08 09:00:00	TLT	ETF	83.63	84.0	83.62	83.95	134900.0
2003-09-08 10:00:00	TLT	ETF	83.91	84.18	83.89	84.14	89900.0
2003-09-08 11:00:00	TLT	ETF	84.13	84.44	84.03	84.4	102200.0
2003-09-08 12:00:00	TLT	ETF	84.45	84.45	84.26	84.34	72000.0
2003-09-08 13:00:00	TLT	ETF	84.37	84.4	84.01	84.05	21900.0
2003-09-08 14:00:00	TLT	ETF	84.01	84.01	83.61	83.62	95200.0
2003-09-08 15:00:00	TLT	ETF	83.6	83.63	83.35	83.37	70800.0

> showing 50 of 431 rows — these rows as CSV

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