PREVIEW / etf_1hour / 2002-12-18

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-12-18.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-12-18 08:00:00	SPY	ETF	90.52	90.54	90.42	90.45	18100.0
2002-12-18 09:00:00	SPY	ETF	90.45	90.49	90.02	90.18	3804400.0
2002-12-18 10:00:00	SPY	ETF	90.19	90.21	89.42	89.45	5941000.0
2002-12-18 11:00:00	SPY	ETF	89.43	89.8	89.33	89.78	4284200.0
2002-12-18 12:00:00	SPY	ETF	89.78	90.0	89.66	89.9	3161600.0
2002-12-18 13:00:00	SPY	ETF	89.9	90.2	89.55	89.65	3395400.0
2002-12-18 14:00:00	SPY	ETF	89.65	90.09	89.46	89.47	3699100.0
2002-12-18 15:00:00	SPY	ETF	89.5	89.85	89.36	89.65	4376500.0
2002-12-18 16:00:00	SPY	ETF	89.65	89.96	89.46	89.88	3111700.0
2002-12-18 17:00:00	SPY	ETF	89.9	89.9	89.67	89.68	13900.0
2002-12-18 18:00:00	SPY	ETF	89.71	89.75	89.69	89.75	23800.0
2002-12-18 19:00:00	SPY	ETF	89.72	89.72	89.69	89.7	1500.0
2002-12-18 08:00:00	QQQ	ETF	25.6	25.62	25.5	25.56	90400.0
2002-12-18 09:00:00	QQQ	ETF	25.56	25.6	25.42	25.49	9000300.0
2002-12-18 10:00:00	QQQ	ETF	25.52	25.52	25.07	25.07	13731600.0
2002-12-18 11:00:00	QQQ	ETF	25.1	25.25	25.05	25.2	8692800.0
2002-12-18 12:00:00	QQQ	ETF	25.2	25.29	25.15	25.23	4914100.0
2002-12-18 13:00:00	QQQ	ETF	25.24	25.33	25.1	25.15	5289800.0
2002-12-18 14:00:00	QQQ	ETF	25.17	25.32	25.1	25.11	5653700.0
2002-12-18 15:00:00	QQQ	ETF	25.11	25.25	25.06	25.19	9911200.0
2002-12-18 16:00:00	QQQ	ETF	25.2	25.42	25.17	25.37	4298600.0
2002-12-18 17:00:00	QQQ	ETF	25.37	25.4	25.26	25.3	1053200.0
2002-12-18 18:00:00	QQQ	ETF	25.31	25.34	25.26	25.32	78100.0
2002-12-18 19:00:00	QQQ	ETF	25.33	25.35	25.32	25.35	36600.0
2002-12-18 20:00:00	QQQ	ETF	25.35	25.35	25.35	25.35	100.0
2002-12-18 09:00:00	IWM	ETF	38.75	38.75	38.575	38.585	258800.0
2002-12-18 10:00:00	IWM	ETF	38.56	38.575	38.255	38.265	288200.0
2002-12-18 11:00:00	IWM	ETF	38.27	38.325	38.175	38.3	168800.0
2002-12-18 12:00:00	IWM	ETF	38.325	38.4	38.275	38.35	173400.0
2002-12-18 13:00:00	IWM	ETF	38.37	38.475	38.18	38.21	277200.0
2002-12-18 14:00:00	IWM	ETF	38.22	38.325	38.13	38.15	675400.0
2002-12-18 15:00:00	IWM	ETF	38.14	38.245	38.07	38.145	352400.0
2002-12-18 16:00:00	IWM	ETF	38.145	38.24	37.805	37.805	96800.0
2002-12-18 08:00:00	DIA	ETF	85.25	85.25	85.2	85.2	1100.0
2002-12-18 09:00:00	DIA	ETF	85.29	85.29	84.85	85.06	901500.0
2002-12-18 10:00:00	DIA	ETF	85.08	85.1	84.46	84.51	1319500.0
2002-12-18 11:00:00	DIA	ETF	84.46	84.75	84.36	84.7	825000.0
2002-12-18 12:00:00	DIA	ETF	84.7	85.0	84.63	84.88	542500.0
2002-12-18 13:00:00	DIA	ETF	84.9	85.15	84.56	84.72	689500.0
2002-12-18 14:00:00	DIA	ETF	84.69	85.06	84.45	84.53	459900.0
2002-12-18 15:00:00	DIA	ETF	84.51	84.89	84.37	84.74	1100600.0
2002-12-18 16:00:00	DIA	ETF	84.74	84.91	84.57	84.9	171700.0
2002-12-18 17:00:00	DIA	ETF	84.69	84.78	84.69	84.78	300.0
2002-12-18 18:00:00	DIA	ETF	84.8	84.8	84.65	84.65	700.0
2002-12-18 19:00:00	DIA	ETF	84.65	84.92	84.65	84.92	3200.0
2002-12-18 09:00:00	TLT	ETF	86.48	86.55	86.4	86.55	51800.0
2002-12-18 10:00:00	TLT	ETF	86.46	86.69	86.34	86.36	104100.0
2002-12-18 11:00:00	TLT	ETF	86.38	86.47	86.38	86.46	2300.0
2002-12-18 12:00:00	TLT	ETF	86.37	86.47	86.35	86.39	900.0
2002-12-18 13:00:00	TLT	ETF	86.25	86.41	86.25	86.37	900.0

> showing 50 of 387 rows — these rows as CSV

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