PREVIEW / etf_1hour / 2002-11-25

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-11-25.parquet
  size:    16 KB
  rows:    397

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-11-25 08:00:00	SPY	ETF	93.8	93.8	93.56	93.56	7500.0
2002-11-25 09:00:00	SPY	ETF	93.52	93.89	93.25	93.86	4381400.0
2002-11-25 10:00:00	SPY	ETF	93.86	94.26	93.77	93.85	4799900.0
2002-11-25 11:00:00	SPY	ETF	93.83	93.85	92.85	92.9	7410500.0
2002-11-25 12:00:00	SPY	ETF	92.9	93.08	92.77	92.99	3731800.0
2002-11-25 13:00:00	SPY	ETF	93.0	93.48	92.88	93.38	2226300.0
2002-11-25 14:00:00	SPY	ETF	93.35	93.76	93.25	93.72	2986300.0
2002-11-25 15:00:00	SPY	ETF	93.72	94.09	93.63	93.79	4904700.0
2002-11-25 16:00:00	SPY	ETF	93.81	93.85	93.45	93.51	1637500.0
2002-11-25 17:00:00	SPY	ETF	93.51	93.61	93.51	93.56	212500.0
2002-11-25 18:00:00	SPY	ETF	93.56	93.61	93.5	93.61	1500.0
2002-11-25 19:00:00	SPY	ETF	93.57	93.6	93.55	93.55	1200.0
2002-11-25 08:00:00	QQQ	ETF	27.7	27.99	27.7	27.89	55300.0
2002-11-25 09:00:00	QQQ	ETF	27.87	28.09	27.68	28.03	11985200.0
2002-11-25 10:00:00	QQQ	ETF	28.03	28.2	27.9	28.02	13295800.0
2002-11-25 11:00:00	QQQ	ETF	28.02	28.05	27.65	27.69	9680300.0
2002-11-25 12:00:00	QQQ	ETF	27.65	27.75	27.54	27.66	7312700.0
2002-11-25 13:00:00	QQQ	ETF	27.67	27.89	27.65	27.82	5605700.0
2002-11-25 14:00:00	QQQ	ETF	27.81	27.99	27.77	27.96	5740700.0
2002-11-25 15:00:00	QQQ	ETF	27.94	28.15	27.91	28.06	10432500.0
2002-11-25 16:00:00	QQQ	ETF	28.03	28.07	27.9	27.93	2649600.0
2002-11-25 17:00:00	QQQ	ETF	27.93	27.96	27.91	27.96	46400.0
2002-11-25 18:00:00	QQQ	ETF	27.95	27.96	27.92	27.95	15400.0
2002-11-25 19:00:00	QQQ	ETF	27.95	28.0	27.95	28.0	12200.0
2002-11-25 09:00:00	IWM	ETF	40.0	40.325	39.91	40.32	163200.0
2002-11-25 10:00:00	IWM	ETF	40.355	40.445	40.23	40.245	394200.0
2002-11-25 11:00:00	IWM	ETF	40.25	40.255	39.895	39.895	306400.0
2002-11-25 12:00:00	IWM	ETF	39.925	39.925	39.8	39.875	196800.0
2002-11-25 13:00:00	IWM	ETF	39.875	40.115	39.865	40.075	179800.0
2002-11-25 14:00:00	IWM	ETF	40.13	40.335	40.075	40.33	326800.0
2002-11-25 15:00:00	IWM	ETF	40.335	40.425	40.28	40.375	550600.0
2002-11-25 16:00:00	IWM	ETF	40.375	40.375	40.22	40.25	23800.0
2002-11-25 08:00:00	DIA	ETF	88.49	88.49	88.25	88.25	3500.0
2002-11-25 09:00:00	DIA	ETF	88.25	88.6	87.97	88.57	870200.0
2002-11-25 10:00:00	DIA	ETF	88.55	88.89	88.47	88.61	1383000.0
2002-11-25 11:00:00	DIA	ETF	88.57	88.57	87.81	87.82	913100.0
2002-11-25 12:00:00	DIA	ETF	87.82	88.03	87.72	87.92	564800.0
2002-11-25 13:00:00	DIA	ETF	87.89	88.29	87.81	88.23	340900.0
2002-11-25 14:00:00	DIA	ETF	88.27	88.63	88.08	88.57	618500.0
2002-11-25 15:00:00	DIA	ETF	88.56	88.9	88.44	88.68	1215000.0
2002-11-25 16:00:00	DIA	ETF	88.65	88.7	88.42	88.49	134600.0
2002-11-25 17:00:00	DIA	ETF	88.55	88.58	88.55	88.58	400.0
2002-11-25 19:00:00	DIA	ETF	88.58	88.58	88.58	88.58	200.0
2002-11-25 09:00:00	TLT	ETF	86.0	86.18	86.0	86.14	32500.0
2002-11-25 10:00:00	TLT	ETF	86.04	86.14	85.95	86.07	19000.0
2002-11-25 11:00:00	TLT	ETF	86.0	86.22	85.96	86.22	159200.0
2002-11-25 12:00:00	TLT	ETF	86.24	86.38	86.23	86.23	3000.0
2002-11-25 13:00:00	TLT	ETF	86.2	86.2	85.92	86.0	8600.0
2002-11-25 14:00:00	TLT	ETF	85.91	86.05	85.91	85.92	55700.0
2002-11-25 15:00:00	TLT	ETF	85.89	85.89	85.8	85.8	800.0

> showing 50 of 397 rows — these rows as CSV

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