PREVIEW / etf_1hour / 2002-10-29

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-29.parquet
  size:    16 KB
  rows:    372

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-29 08:00:00	SPY	ETF	89.26	89.34	89.2	89.26	3100.0
2002-10-29 09:00:00	SPY	ETF	89.22	89.49	88.84	89.05	4597400.0
2002-10-29 10:00:00	SPY	ETF	89.11	89.11	87.0	87.58	16078600.0
2002-10-29 11:00:00	SPY	ETF	87.54	87.74	87.21	87.63	5992800.0
2002-10-29 12:00:00	SPY	ETF	87.57	87.99	87.37	87.44	4280300.0
2002-10-29 13:00:00	SPY	ETF	87.48	87.99	87.28	87.83	3312900.0
2002-10-29 14:00:00	SPY	ETF	87.82	87.88	87.17	87.64	5369800.0
2002-10-29 15:00:00	SPY	ETF	87.7	89.1	87.64	88.6	11085300.0
2002-10-29 16:00:00	SPY	ETF	88.56	88.7	88.37	88.63	2212200.0
2002-10-29 17:00:00	SPY	ETF	88.58	88.8	88.55	88.8	533600.0
2002-10-29 18:00:00	SPY	ETF	88.8	88.82	88.66	88.75	12000.0
2002-10-29 19:00:00	SPY	ETF	88.8	88.8	88.71	88.71	2000.0
2002-10-29 08:00:00	QQQ	ETF	24.34	24.38	24.34	24.35	14100.0
2002-10-29 09:00:00	QQQ	ETF	24.34	24.47	24.15	24.26	9049100.0
2002-10-29 10:00:00	QQQ	ETF	24.26	24.26	23.48	23.61	25194800.0
2002-10-29 11:00:00	QQQ	ETF	23.63	23.7	23.48	23.56	7700000.0
2002-10-29 12:00:00	QQQ	ETF	23.57	23.68	23.48	23.51	8002100.0
2002-10-29 13:00:00	QQQ	ETF	23.53	23.7	23.44	23.63	7622400.0
2002-10-29 14:00:00	QQQ	ETF	23.62	23.66	23.37	23.51	8554300.0
2002-10-29 15:00:00	QQQ	ETF	23.53	24.03	23.5	23.91	16199200.0
2002-10-29 16:00:00	QQQ	ETF	23.9	23.93	23.83	23.9	1885100.0
2002-10-29 17:00:00	QQQ	ETF	23.88	24.0	23.85	23.99	237200.0
2002-10-29 18:00:00	QQQ	ETF	24.0	24.01	23.89	24.0	49800.0
2002-10-29 19:00:00	QQQ	ETF	24.02	24.06	24.0	24.06	4100.0
2002-10-29 09:00:00	IWM	ETF	36.775	36.89	36.62	36.72	120600.0
2002-10-29 10:00:00	IWM	ETF	36.5	36.5	36.09	36.205	857000.0
2002-10-29 11:00:00	IWM	ETF	36.22	36.29	36.14	36.245	371200.0
2002-10-29 12:00:00	IWM	ETF	36.275	36.34	36.19	36.25	68400.0
2002-10-29 13:00:00	IWM	ETF	36.205	36.345	36.185	36.34	388400.0
2002-10-29 14:00:00	IWM	ETF	36.31	36.31	36.1	36.2	275000.0
2002-10-29 15:00:00	IWM	ETF	36.225	36.65	36.2	36.6	934600.0
2002-10-29 16:00:00	IWM	ETF	36.65	36.715	36.62	36.65	12600.0
2002-10-29 17:00:00	IWM	ETF	36.745	36.745	36.745	36.745	1088200.0
2002-10-29 08:00:00	DIA	ETF	83.63	83.81	83.63	83.81	1300.0
2002-10-29 09:00:00	DIA	ETF	83.8	84.12	83.58	83.83	985800.0
2002-10-29 10:00:00	DIA	ETF	83.81	83.9	81.85	82.38	3787600.0
2002-10-29 11:00:00	DIA	ETF	82.39	82.68	82.1	82.5	1140900.0
2002-10-29 12:00:00	DIA	ETF	82.49	82.9	82.32	82.43	1300800.0
2002-10-29 13:00:00	DIA	ETF	82.42	83.04	82.23	82.9	1017700.0
2002-10-29 14:00:00	DIA	ETF	82.88	82.95	82.21	82.69	1466800.0
2002-10-29 15:00:00	DIA	ETF	82.73	84.2	82.66	83.81	2556700.0
2002-10-29 16:00:00	DIA	ETF	83.83	83.88	83.65	83.75	183700.0
2002-10-29 17:00:00	DIA	ETF	83.79	83.9	83.79	83.9	10900.0
2002-10-29 18:00:00	DIA	ETF	83.79	83.79	83.79	83.79	800.0
2002-10-29 09:00:00	TLT	ETF	85.82	85.94	85.77	85.9	6500.0
2002-10-29 10:00:00	TLT	ETF	85.95	86.89	85.95	86.78	53700.0
2002-10-29 11:00:00	TLT	ETF	86.75	86.85	86.55	86.62	19400.0
2002-10-29 12:00:00	TLT	ETF	86.7	86.87	86.65	86.87	6100.0
2002-10-29 13:00:00	TLT	ETF	86.85	86.86	86.44	86.53	7300.0
2002-10-29 14:00:00	TLT	ETF	86.66	86.89	86.49	86.49	8000.0

> showing 50 of 372 rows — these rows as CSV

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