PREVIEW / etf_1hour / 2002-10-15

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-15.parquet
  size:    16 KB
  rows:    387

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
2002-10-15 08:00:00	SPY	ETF	86.33	87.0	86.33	86.95	21000.0
2002-10-15 09:00:00	SPY	ETF	86.87	87.62	86.85	87.34	11880100.0
2002-10-15 10:00:00	SPY	ETF	87.32	87.67	86.95	87.25	11168000.0
2002-10-15 11:00:00	SPY	ETF	87.25	87.7	87.08	87.49	6914100.0
2002-10-15 12:00:00	SPY	ETF	87.5	87.9	87.42	87.84	4078000.0
2002-10-15 13:00:00	SPY	ETF	87.85	88.1	87.59	87.68	5719500.0
2002-10-15 14:00:00	SPY	ETF	87.71	88.19	87.52	87.64	8195800.0
2002-10-15 15:00:00	SPY	ETF	87.63	88.5	87.51	88.42	15783800.0
2002-10-15 16:00:00	SPY	ETF	88.4	88.75	87.35	87.55	10061700.0
2002-10-15 17:00:00	SPY	ETF	87.57	88.66	87.24	87.47	1296300.0
2002-10-15 18:00:00	SPY	ETF	87.48	87.64	87.45	87.64	66800.0
2002-10-15 19:00:00	SPY	ETF	87.8	87.8	87.8	87.8	100.0
2002-10-15 08:00:00	QQQ	ETF	23.01	23.37	23.01	23.35	93200.0
2002-10-15 09:00:00	QQQ	ETF	23.35	23.54	23.26	23.35	28474500.0
2002-10-15 10:00:00	QQQ	ETF	23.35	23.45	23.18	23.32	20250700.0
2002-10-15 11:00:00	QQQ	ETF	23.33	23.46	23.26	23.33	10236700.0
2002-10-15 12:00:00	QQQ	ETF	23.31	23.46	23.3	23.45	6845500.0
2002-10-15 13:00:00	QQQ	ETF	23.45	23.54	23.32	23.38	9598600.0
2002-10-15 14:00:00	QQQ	ETF	23.38	23.48	23.23	23.33	9786200.0
2002-10-15 15:00:00	QQQ	ETF	23.28	23.59	23.24	23.58	17464800.0
2002-10-15 16:00:00	QQQ	ETF	23.59	23.63	22.61	22.86	10461100.0
2002-10-15 17:00:00	QQQ	ETF	22.85	23.63	22.79	22.92	3573300.0
2002-10-15 18:00:00	QQQ	ETF	22.9	22.95	22.8	22.89	117400.0
2002-10-15 19:00:00	QQQ	ETF	22.89	22.92	22.89	22.91	3400.0
2002-10-15 09:00:00	IWM	ETF	35.32	35.75	35.215	35.5	925000.0
2002-10-15 10:00:00	IWM	ETF	35.585	35.775	35.585	35.625	997800.0
2002-10-15 11:00:00	IWM	ETF	35.665	35.835	35.625	35.75	265800.0
2002-10-15 12:00:00	IWM	ETF	35.73	35.95	35.73	35.95	344800.0
2002-10-15 13:00:00	IWM	ETF	35.95	36.025	35.8	35.85	234800.0
2002-10-15 14:00:00	IWM	ETF	35.85	35.92	35.695	35.735	513200.0
2002-10-15 15:00:00	IWM	ETF	35.715	35.97	35.685	35.95	496000.0
2002-10-15 16:00:00	IWM	ETF	36.0	36.41	35.91	35.925	27400.0
2002-10-15 17:00:00	IWM	ETF	35.915	35.915	35.915	35.915	1280600.0
2002-10-15 08:00:00	DIA	ETF	80.6	81.37	80.6	81.16	9000.0
2002-10-15 09:00:00	DIA	ETF	81.3	82.32	81.24	81.56	3943000.0
2002-10-15 10:00:00	DIA	ETF	81.56	81.95	81.1	81.54	2808500.0
2002-10-15 11:00:00	DIA	ETF	81.55	81.97	81.35	81.67	1188400.0
2002-10-15 12:00:00	DIA	ETF	81.65	82.01	81.58	81.95	917300.0
2002-10-15 13:00:00	DIA	ETF	81.97	82.2	81.75	81.86	1544300.0
2002-10-15 14:00:00	DIA	ETF	81.88	82.36	81.64	81.9	2023000.0
2002-10-15 15:00:00	DIA	ETF	81.88	82.65	81.8	82.57	3193000.0
2002-10-15 16:00:00	DIA	ETF	82.58	82.85	81.8	81.85	462600.0
2002-10-15 17:00:00	DIA	ETF	81.95	82.4	81.5	81.52	580500.0
2002-10-15 18:00:00	DIA	ETF	81.5	81.62	81.35	81.55	119200.0
2002-10-15 09:00:00	TLT	ETF	87.0	87.13	86.92	87.12	150700.0
2002-10-15 10:00:00	TLT	ETF	87.0	87.3	86.95	87.12	47200.0
2002-10-15 11:00:00	TLT	ETF	87.05	87.05	86.88	86.93	10200.0
2002-10-15 12:00:00	TLT	ETF	87.03	87.06	86.87	86.87	9000.0
2002-10-15 13:00:00	TLT	ETF	86.92	86.92	86.71	86.8	17200.0
2002-10-15 14:00:00	TLT	ETF	86.79	86.86	86.46	86.57	21900.0

> showing 50 of 387 rows — these rows as CSV

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