PREVIEW / etf_1hour / 2002-11-21

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-11-21.parquet
  size:    16 KB
  rows:    393

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-21 08:00:00	SPY	ETF	92.57	92.89	92.21	92.82	67600.0
2002-11-21 09:00:00	SPY	ETF	92.82	93.04	92.43	92.9	6745200.0
2002-11-21 10:00:00	SPY	ETF	92.87	93.53	92.67	93.39	10252900.0
2002-11-21 11:00:00	SPY	ETF	93.43	93.75	93.35	93.5	6083800.0
2002-11-21 12:00:00	SPY	ETF	93.46	93.76	93.2	93.52	5637300.0
2002-11-21 13:00:00	SPY	ETF	93.51	94.0	93.45	93.72	5810100.0
2002-11-21 14:00:00	SPY	ETF	93.75	94.11	93.45	93.98	5250000.0
2002-11-21 15:00:00	SPY	ETF	93.98	94.04	93.36	93.9	7386800.0
2002-11-21 16:00:00	SPY	ETF	93.91	94.19	93.87	94.09	4746600.0
2002-11-21 17:00:00	SPY	ETF	94.05	94.06	93.83	93.91	48500.0
2002-11-21 18:00:00	SPY	ETF	93.9	93.94	93.88	93.94	10200.0
2002-11-21 08:00:00	QQQ	ETF	26.96	27.04	26.83	27.02	139900.0
2002-11-21 09:00:00	QQQ	ETF	27.03	27.35	26.85	27.27	17587500.0
2002-11-21 10:00:00	QQQ	ETF	27.28	27.61	27.14	27.56	19164800.0
2002-11-21 11:00:00	QQQ	ETF	27.55	27.74	27.47	27.53	13795200.0
2002-11-21 12:00:00	QQQ	ETF	27.53	27.71	27.42	27.58	9685100.0
2002-11-21 13:00:00	QQQ	ETF	27.58	27.76	27.55	27.63	8491600.0
2002-11-21 14:00:00	QQQ	ETF	27.63	27.84	27.47	27.81	10871800.0
2002-11-21 15:00:00	QQQ	ETF	27.8	27.85	27.54	27.8	16081400.0
2002-11-21 16:00:00	QQQ	ETF	27.79	27.84	27.71	27.78	2646300.0
2002-11-21 17:00:00	QQQ	ETF	27.78	27.81	27.59	27.62	1403100.0
2002-11-21 18:00:00	QQQ	ETF	27.63	27.65	27.6	27.65	49500.0
2002-11-21 19:00:00	QQQ	ETF	27.65	27.67	27.6	27.63	14100.0
2002-11-21 09:00:00	IWM	ETF	39.01	39.15	38.88	39.14	264000.0
2002-11-21 10:00:00	IWM	ETF	39.245	39.47	39.08	39.39	606000.0
2002-11-21 11:00:00	IWM	ETF	39.455	39.575	39.395	39.5	593000.0
2002-11-21 12:00:00	IWM	ETF	39.485	39.53	39.35	39.51	216000.0
2002-11-21 13:00:00	IWM	ETF	39.51	39.735	39.505	39.635	316400.0
2002-11-21 14:00:00	IWM	ETF	39.69	39.78	39.535	39.76	398600.0
2002-11-21 15:00:00	IWM	ETF	39.75	39.76	39.575	39.685	540400.0
2002-11-21 16:00:00	IWM	ETF	39.685	39.76	39.625	39.735	89600.0
2002-11-21 08:00:00	DIA	ETF	87.0	87.35	86.75	87.3	11800.0
2002-11-21 09:00:00	DIA	ETF	87.3	87.45	86.91	87.33	1213000.0
2002-11-21 10:00:00	DIA	ETF	87.3	87.95	87.07	87.87	1536100.0
2002-11-21 11:00:00	DIA	ETF	87.89	88.18	87.81	87.97	1005600.0
2002-11-21 12:00:00	DIA	ETF	88.05	88.3	87.84	88.08	939300.0
2002-11-21 13:00:00	DIA	ETF	88.1	88.61	88.01	88.38	1545200.0
2002-11-21 14:00:00	DIA	ETF	88.41	88.82	88.21	88.74	932200.0
2002-11-21 15:00:00	DIA	ETF	88.7	88.79	88.15	88.69	1319400.0
2002-11-21 16:00:00	DIA	ETF	88.71	88.85	88.61	88.78	260600.0
2002-11-21 17:00:00	DIA	ETF	88.74	88.74	88.05	88.56	4600.0
2002-11-21 18:00:00	DIA	ETF	88.54	88.54	88.41	88.45	1600.0
2002-11-21 19:00:00	DIA	ETF	88.45	88.45	88.45	88.45	100.0
2002-11-21 09:00:00	TLT	ETF	86.5	86.5	86.25	86.3	18600.0
2002-11-21 10:00:00	TLT	ETF	86.4	86.44	86.19	86.19	66200.0
2002-11-21 11:00:00	TLT	ETF	86.19	86.19	85.96	86.12	136300.0
2002-11-21 12:00:00	TLT	ETF	85.95	86.25	85.95	86.0	11800.0
2002-11-21 13:00:00	TLT	ETF	86.0	86.03	85.86	85.96	17400.0
2002-11-21 14:00:00	TLT	ETF	86.02	86.2	85.98	86.05	23700.0
2002-11-21 15:00:00	TLT	ETF	86.17	86.2	86.06	86.12	47200.0

> showing 50 of 393 rows — these rows as CSV

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