PREVIEW / etf_1hour / 2003-10-24

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-24.parquet
  size:    18 KB
  rows:    463

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-24 08:00:00	SPY	ETF	103.03	103.06	102.86	102.9	129900.0
2003-10-24 09:00:00	SPY	ETF	102.91	103.07	102.68	103.07	4573600.0
2003-10-24 10:00:00	SPY	ETF	103.07	103.18	102.76	103.059	3582100.0
2003-10-24 11:00:00	SPY	ETF	103.067	103.24	102.57	102.7	7245100.0
2003-10-24 12:00:00	SPY	ETF	102.7	102.79	102.19	102.33	6397600.0
2003-10-24 13:00:00	SPY	ETF	102.34	102.52	102.21	102.25	5276400.0
2003-10-24 14:00:00	SPY	ETF	102.25	102.71	102.18	102.48	6060700.0
2003-10-24 15:00:00	SPY	ETF	102.45	103.29	102.39	103.28	7359900.0
2003-10-24 16:00:00	SPY	ETF	103.25	103.58	103.23	103.34	2004300.0
2003-10-24 17:00:00	SPY	ETF	103.35	103.4	103.3	103.35	12400.0
2003-10-24 18:00:00	SPY	ETF	103.34	103.57	103.34	103.39	5700.0
2003-10-24 19:00:00	SPY	ETF	103.39	103.39	103.34	103.34	1700.0
2003-10-24 08:00:00	QQQ	ETF	33.83	33.87	33.78	33.83	237200.0
2003-10-24 09:00:00	QQQ	ETF	33.83	33.97	33.72	33.95	16313300.0
2003-10-24 10:00:00	QQQ	ETF	33.95	33.99	33.78	33.89	12202700.0
2003-10-24 11:00:00	QQQ	ETF	33.887	33.98	33.71	33.76	10168300.0
2003-10-24 12:00:00	QQQ	ETF	33.76	33.8	33.501	33.58	13412900.0
2003-10-24 13:00:00	QQQ	ETF	33.58	33.65	33.495	33.5	9439500.0
2003-10-24 14:00:00	QQQ	ETF	33.5	33.69	33.49	33.62	10659200.0
2003-10-24 15:00:00	QQQ	ETF	33.62	34.09	33.6	34.08	15821900.0
2003-10-24 16:00:00	QQQ	ETF	34.07	34.23	34.03	34.14	5330600.0
2003-10-24 17:00:00	QQQ	ETF	34.14	34.18	34.1	34.14	63000.0
2003-10-24 18:00:00	QQQ	ETF	34.14	34.14	34.09	34.09	21400.0
2003-10-24 19:00:00	QQQ	ETF	34.12	34.13	34.1	34.12	13900.0
2003-10-24 09:00:00	IWM	ETF	50.425	50.605	50.305	50.576	1105800.0
2003-10-24 10:00:00	IWM	ETF	50.555	50.625	50.455	50.6	450200.0
2003-10-24 11:00:00	IWM	ETF	50.595	50.71	50.37	50.43	796400.0
2003-10-24 12:00:00	IWM	ETF	50.43	50.465	50.14	50.265	1024600.0
2003-10-24 13:00:00	IWM	ETF	50.215	50.37	50.165	50.21	520600.0
2003-10-24 14:00:00	IWM	ETF	50.25	50.425	50.19	50.315	1109800.0
2003-10-24 15:00:00	IWM	ETF	50.315	50.775	50.3	50.67	1688800.0
2003-10-24 16:00:00	IWM	ETF	50.55	50.625	50.315	50.315	771200.0
2003-10-24 17:00:00	IWM	ETF	50.55	50.55	50.55	50.55	2000.0
2003-10-24 08:00:00	DIA	ETF	95.62	95.62	95.5	95.5	4500.0
2003-10-24 09:00:00	DIA	ETF	95.51	95.81	95.41	95.8	719000.0
2003-10-24 10:00:00	DIA	ETF	95.77	95.89	95.53	95.89	880600.0
2003-10-24 11:00:00	DIA	ETF	95.869	95.99	95.44	95.55	582200.0
2003-10-24 12:00:00	DIA	ETF	95.56	95.62	95.096	95.17	1032400.0
2003-10-24 13:00:00	DIA	ETF	95.22	95.46	95.13	95.16	564600.0
2003-10-24 14:00:00	DIA	ETF	95.18	95.58	95.13	95.34	540700.0
2003-10-24 15:00:00	DIA	ETF	95.38	96.03	95.261	96.03	1505300.0
2003-10-24 16:00:00	DIA	ETF	96.031	96.18	95.93	96.13	424500.0
2003-10-24 17:00:00	DIA	ETF	96.05	96.07	95.95	96.05	1200.0
2003-10-24 18:00:00	DIA	ETF	96.05	96.05	96.05	96.05	400.0
2003-10-24 09:00:00	TLT	ETF	85.0	85.0	84.71	84.78	153200.0
2003-10-24 10:00:00	TLT	ETF	84.8	84.91	84.66	84.73	70900.0
2003-10-24 11:00:00	TLT	ETF	84.78	85.1	84.75	85.01	124200.0
2003-10-24 12:00:00	TLT	ETF	85.01	85.28	84.89	85.26	105000.0
2003-10-24 13:00:00	TLT	ETF	85.25	85.35	85.23	85.35	38600.0
2003-10-24 14:00:00	TLT	ETF	85.35	85.52	85.31	85.5	558200.0

> showing 50 of 463 rows — these rows as CSV

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