PREVIEW / etf_1hour / 2003-03-24

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-03-24.parquet
  size:    16 KB
  rows:    398

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-03-24 08:00:00	SPY	ETF	88.39	88.39	87.95	87.97	142500.0
2003-03-24 09:00:00	SPY	ETF	87.95	88.14	87.67	87.76	9243400.0
2003-03-24 10:00:00	SPY	ETF	87.76	87.87	86.95	87.2	14138400.0
2003-03-24 11:00:00	SPY	ETF	87.19	87.3	86.81	86.93	5588000.0
2003-03-24 12:00:00	SPY	ETF	86.95	87.1	86.72	86.99	4043400.0
2003-03-24 13:00:00	SPY	ETF	87.01	87.01	86.6	86.8	4370800.0
2003-03-24 14:00:00	SPY	ETF	86.81	87.04	86.35	86.89	9413800.0
2003-03-24 15:00:00	SPY	ETF	86.88	87.17	86.54	86.58	8937200.0
2003-03-24 16:00:00	SPY	ETF	86.57	86.73	86.51	86.65	2498300.0
2003-03-24 17:00:00	SPY	ETF	86.65	86.69	86.62	86.68	162300.0
2003-03-24 18:00:00	SPY	ETF	86.65	86.65	86.5	86.53	20700.0
2003-03-24 19:00:00	SPY	ETF	86.55	86.56	86.55	86.56	2000.0
2003-03-24 08:00:00	QQQ	ETF	26.56	26.69	26.45	26.47	214900.0
2003-03-24 09:00:00	QQQ	ETF	26.47	26.6	26.38	26.51	15806900.0
2003-03-24 10:00:00	QQQ	ETF	26.5	26.57	26.23	26.3	15838900.0
2003-03-24 11:00:00	QQQ	ETF	26.3	26.38	26.19	26.25	6671000.0
2003-03-24 12:00:00	QQQ	ETF	26.25	26.3	26.2	26.24	4911900.0
2003-03-24 13:00:00	QQQ	ETF	26.25	26.29	26.08	26.14	9259800.0
2003-03-24 14:00:00	QQQ	ETF	26.13	26.23	25.97	26.15	12283800.0
2003-03-24 15:00:00	QQQ	ETF	26.15	26.25	26.01	26.03	11848000.0
2003-03-24 16:00:00	QQQ	ETF	26.05	26.07	25.98	26.07	2367100.0
2003-03-24 17:00:00	QQQ	ETF	26.07	26.09	26.05	26.06	81600.0
2003-03-24 18:00:00	QQQ	ETF	26.05	26.05	26.01	26.05	62000.0
2003-03-24 19:00:00	QQQ	ETF	26.05	26.05	26.0	26.02	21100.0
2003-03-24 08:00:00	IWM	ETF	36.755	36.755	36.755	36.755	2000.0
2003-03-24 09:00:00	IWM	ETF	36.8	36.97	36.765	36.815	857600.0
2003-03-24 10:00:00	IWM	ETF	36.815	36.845	36.405	36.47	895600.0
2003-03-24 11:00:00	IWM	ETF	36.49	36.56	36.435	36.5	208800.0
2003-03-24 12:00:00	IWM	ETF	36.465	36.55	36.445	36.55	135200.0
2003-03-24 13:00:00	IWM	ETF	36.55	36.6	36.49	36.575	712400.0
2003-03-24 14:00:00	IWM	ETF	36.57	36.71	36.455	36.685	1278400.0
2003-03-24 15:00:00	IWM	ETF	36.695	36.765	36.525	36.595	251800.0
2003-03-24 16:00:00	IWM	ETF	36.575	36.6	36.54	36.545	15400.0
2003-03-24 08:00:00	DIA	ETF	83.75	83.87	83.6	83.63	53700.0
2003-03-24 09:00:00	DIA	ETF	83.61	83.65	83.08	83.27	2977700.0
2003-03-24 10:00:00	DIA	ETF	83.26	83.38	82.64	82.77	3549900.0
2003-03-24 11:00:00	DIA	ETF	82.77	82.89	82.48	82.59	1372300.0
2003-03-24 12:00:00	DIA	ETF	82.55	82.72	82.4	82.54	786300.0
2003-03-24 13:00:00	DIA	ETF	82.55	82.58	82.18	82.35	986400.0
2003-03-24 14:00:00	DIA	ETF	82.31	82.57	81.88	82.48	3043800.0
2003-03-24 15:00:00	DIA	ETF	82.46	82.7	82.15	82.23	1987100.0
2003-03-24 16:00:00	DIA	ETF	82.2	82.29	82.15	82.2	380000.0
2003-03-24 17:00:00	DIA	ETF	82.2	82.2	82.13	82.13	4200.0
2003-03-24 18:00:00	DIA	ETF	82.15	82.19	82.09	82.09	1700.0
2003-03-24 19:00:00	DIA	ETF	82.09	82.11	82.05	82.11	2100.0
2003-03-24 09:00:00	TLT	ETF	87.1	87.1	86.85	87.0	189300.0
2003-03-24 10:00:00	TLT	ETF	87.03	87.23	87.0	87.09	62800.0
2003-03-24 11:00:00	TLT	ETF	87.1	87.2	87.05	87.1	7900.0
2003-03-24 12:00:00	TLT	ETF	87.19	87.29	87.17	87.26	22000.0
2003-03-24 13:00:00	TLT	ETF	87.25	87.56	87.25	87.43	27500.0

> showing 50 of 398 rows — these rows as CSV

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