PREVIEW / etf_1hour / 2003-01-24

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-24.parquet
  size:    17 KB
  rows:    400

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-01-24 08:00:00	SPY	ETF	88.65	88.74	88.59	88.64	25400.0
2003-01-24 09:00:00	SPY	ETF	88.67	88.7	87.66	87.82	6741700.0
2003-01-24 10:00:00	SPY	ETF	87.83	87.84	87.04	87.4	13053500.0
2003-01-24 11:00:00	SPY	ETF	87.38	87.5	86.67	86.85	9204800.0
2003-01-24 12:00:00	SPY	ETF	86.86	86.88	86.5	86.56	6453100.0
2003-01-24 13:00:00	SPY	ETF	86.57	86.77	86.26	86.67	6672200.0
2003-01-24 14:00:00	SPY	ETF	86.65	86.83	86.38	86.41	6189400.0
2003-01-24 15:00:00	SPY	ETF	86.42	86.74	86.17	86.33	8135100.0
2003-01-24 16:00:00	SPY	ETF	86.33	86.6	86.25	86.29	3250500.0
2003-01-24 17:00:00	SPY	ETF	86.32	86.65	86.29	86.35	72400.0
2003-01-24 18:00:00	SPY	ETF	86.35	86.39	86.35	86.39	1500.0
2003-01-24 19:00:00	SPY	ETF	86.36	86.36	86.3	86.35	1100.0
2003-01-24 08:00:00	QQQ	ETF	25.6	25.6	25.5	25.52	31500.0
2003-01-24 09:00:00	QQQ	ETF	25.52	25.55	25.2	25.25	9048100.0
2003-01-24 10:00:00	QQQ	ETF	25.25	25.29	24.86	25.01	19028500.0
2003-01-24 11:00:00	QQQ	ETF	25.02	25.04	24.78	24.87	8822600.0
2003-01-24 12:00:00	QQQ	ETF	24.87	24.9	24.73	24.76	6117900.0
2003-01-24 13:00:00	QQQ	ETF	24.76	24.9	24.69	24.86	6670300.0
2003-01-24 14:00:00	QQQ	ETF	24.86	24.88	24.69	24.73	4906900.0
2003-01-24 15:00:00	QQQ	ETF	24.72	24.86	24.65	24.75	11037500.0
2003-01-24 16:00:00	QQQ	ETF	24.75	24.85	24.72	24.79	2884700.0
2003-01-24 17:00:00	QQQ	ETF	24.78	24.81	24.77	24.8	63700.0
2003-01-24 18:00:00	QQQ	ETF	24.8	24.84	24.77	24.83	29900.0
2003-01-24 19:00:00	QQQ	ETF	24.84	24.84	24.81	24.81	9700.0
2003-01-24 09:00:00	IWM	ETF	38.0	38.0	37.64	37.695	255000.0
2003-01-24 10:00:00	IWM	ETF	37.695	37.695	37.39	37.505	1051000.0
2003-01-24 11:00:00	IWM	ETF	37.5	37.565	37.425	37.44	184200.0
2003-01-24 12:00:00	IWM	ETF	37.435	37.465	37.375	37.405	355400.0
2003-01-24 13:00:00	IWM	ETF	37.4	37.44	37.31	37.415	429000.0
2003-01-24 14:00:00	IWM	ETF	37.385	37.425	37.375	37.39	236200.0
2003-01-24 15:00:00	IWM	ETF	37.38	37.44	37.26	37.31	837000.0
2003-01-24 16:00:00	IWM	ETF	37.26	37.29	37.19	37.19	31400.0
2003-01-24 08:00:00	DIA	ETF	83.29	83.36	83.29	83.36	1300.0
2003-01-24 09:00:00	DIA	ETF	83.38	83.43	82.7	82.8	1095200.0
2003-01-24 10:00:00	DIA	ETF	82.81	82.85	82.1	82.45	1966400.0
2003-01-24 11:00:00	DIA	ETF	82.48	82.48	81.67	81.87	1497500.0
2003-01-24 12:00:00	DIA	ETF	81.88	81.94	81.52	81.56	814400.0
2003-01-24 13:00:00	DIA	ETF	81.55	81.83	81.3	81.72	1364100.0
2003-01-24 14:00:00	DIA	ETF	81.75	81.85	81.39	81.46	876900.0
2003-01-24 15:00:00	DIA	ETF	81.44	81.75	81.18	81.43	1672900.0
2003-01-24 16:00:00	DIA	ETF	81.42	81.52	81.33	81.48	239800.0
2003-01-24 17:00:00	DIA	ETF	81.44	81.5	81.43	81.45	89200.0
2003-01-24 18:00:00	DIA	ETF	81.43	81.43	81.38	81.38	2600.0
2003-01-24 19:00:00	DIA	ETF	81.37	81.37	81.3	81.3	1100.0
2003-01-24 09:00:00	TLT	ETF	87.74	87.99	87.74	87.88	34500.0
2003-01-24 10:00:00	TLT	ETF	88.0	88.2	87.99	88.14	70800.0
2003-01-24 11:00:00	TLT	ETF	88.17	88.32	88.1	88.32	26600.0
2003-01-24 12:00:00	TLT	ETF	88.4	88.44	88.29	88.41	16800.0
2003-01-24 13:00:00	TLT	ETF	88.36	88.41	88.2	88.26	119300.0
2003-01-24 14:00:00	TLT	ETF	88.27	88.27	88.11	88.18	7300.0

> showing 50 of 400 rows — these rows as CSV

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