PREVIEW / etf_1hour / 2002-11-07

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-11-07.parquet
  size:    16 KB
  rows:    386

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-07 08:00:00	SPY	ETF	92.29	92.29	91.85	92.06	10400.0
2002-11-07 09:00:00	SPY	ETF	92.02	92.22	91.42	91.6	5378500.0
2002-11-07 10:00:00	SPY	ETF	91.6	91.91	91.18	91.25	6545000.0
2002-11-07 11:00:00	SPY	ETF	91.24	91.44	90.79	90.91	7086400.0
2002-11-07 12:00:00	SPY	ETF	90.89	90.99	90.35	90.81	5106800.0
2002-11-07 13:00:00	SPY	ETF	90.8	91.08	90.62	90.9	2369400.0
2002-11-07 14:00:00	SPY	ETF	90.9	91.26	90.55	90.65	4434200.0
2002-11-07 15:00:00	SPY	ETF	90.63	90.88	90.22	90.57	8485100.0
2002-11-07 16:00:00	SPY	ETF	90.61	90.96	90.5	90.81	3448700.0
2002-11-07 17:00:00	SPY	ETF	90.81	90.85	90.76	90.84	422800.0
2002-11-07 18:00:00	SPY	ETF	90.84	90.9	90.8	90.8	7800.0
2002-11-07 19:00:00	SPY	ETF	90.88	90.88	90.88	90.88	100.0
2002-11-07 08:00:00	QQQ	ETF	26.17	26.17	25.9	25.94	50800.0
2002-11-07 09:00:00	QQQ	ETF	25.94	26.05	25.8	25.93	13937300.0
2002-11-07 10:00:00	QQQ	ETF	25.92	26.1	25.71	25.72	13974300.0
2002-11-07 11:00:00	QQQ	ETF	25.72	25.76	25.5	25.57	12120100.0
2002-11-07 12:00:00	QQQ	ETF	25.59	25.65	25.45	25.57	7275100.0
2002-11-07 13:00:00	QQQ	ETF	25.56	25.7	25.5	25.64	4707100.0
2002-11-07 14:00:00	QQQ	ETF	25.64	25.76	25.46	25.5	7581900.0
2002-11-07 15:00:00	QQQ	ETF	25.49	25.56	25.31	25.49	14175500.0
2002-11-07 16:00:00	QQQ	ETF	25.49	25.72	25.42	25.63	3325100.0
2002-11-07 17:00:00	QQQ	ETF	25.6	25.65	25.57	25.57	126500.0
2002-11-07 18:00:00	QQQ	ETF	25.6	25.64	25.55	25.57	38100.0
2002-11-07 19:00:00	QQQ	ETF	25.56	25.56	25.56	25.56	100.0
2002-11-07 09:00:00	IWM	ETF	38.925	38.925	38.58	38.605	268400.0
2002-11-07 10:00:00	IWM	ETF	38.575	38.65	38.42	38.5	213400.0
2002-11-07 11:00:00	IWM	ETF	38.42	38.53	38.325	38.43	141600.0
2002-11-07 12:00:00	IWM	ETF	38.34	38.43	38.255	38.33	78400.0
2002-11-07 13:00:00	IWM	ETF	38.365	38.46	38.325	38.46	20800.0
2002-11-07 14:00:00	IWM	ETF	38.46	38.53	38.33	38.44	112200.0
2002-11-07 15:00:00	IWM	ETF	38.365	38.43	38.18	38.215	411800.0
2002-11-07 16:00:00	IWM	ETF	38.275	38.69	38.125	38.22	1432200.0
2002-11-07 17:00:00	IWM	ETF	38.25	38.25	38.25	38.25	200.0
2002-11-07 08:00:00	DIA	ETF	87.32	87.32	87.32	87.32	100.0
2002-11-07 09:00:00	DIA	ETF	87.12	87.38	86.55	86.77	1716100.0
2002-11-07 10:00:00	DIA	ETF	86.75	87.07	86.4	86.51	1882000.0
2002-11-07 11:00:00	DIA	ETF	86.51	86.73	86.12	86.26	981100.0
2002-11-07 12:00:00	DIA	ETF	86.29	86.36	85.83	86.17	1338700.0
2002-11-07 13:00:00	DIA	ETF	86.14	86.44	86.0	86.22	582200.0
2002-11-07 14:00:00	DIA	ETF	86.25	86.56	85.94	86.05	888100.0
2002-11-07 15:00:00	DIA	ETF	86.03	86.29	85.55	85.88	1740200.0
2002-11-07 16:00:00	DIA	ETF	85.92	86.59	85.85	86.1	210300.0
2002-11-07 17:00:00	DIA	ETF	86.15	86.32	86.0	86.25	6900.0
2002-11-07 18:00:00	DIA	ETF	86.25	86.35	86.2	86.3	3600.0
2002-11-07 09:00:00	TLT	ETF	87.05	87.16	86.96	86.98	24200.0
2002-11-07 10:00:00	TLT	ETF	87.05	87.05	86.85	86.92	15500.0
2002-11-07 11:00:00	TLT	ETF	87.0	87.15	87.0	87.14	33100.0
2002-11-07 12:00:00	TLT	ETF	87.25	87.28	87.08	87.2	23200.0
2002-11-07 13:00:00	TLT	ETF	87.33	87.48	87.23	87.45	15800.0
2002-11-07 14:00:00	TLT	ETF	87.5	87.6	87.36	87.36	4600.0

> showing 50 of 386 rows — these rows as CSV

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