PREVIEW / etf_1hour / 2002-11-11

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-11-11.parquet
  size:    15 KB
  rows:    373

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-11 08:00:00	SPY	ETF	89.52	89.52	89.42	89.5	4000.0
2002-11-11 09:00:00	SPY	ETF	89.43	89.56	88.87	88.99	2726300.0
2002-11-11 10:00:00	SPY	ETF	88.97	89.23	88.73	89.04	4366600.0
2002-11-11 11:00:00	SPY	ETF	89.05	89.2	88.61	88.84	4627300.0
2002-11-11 12:00:00	SPY	ETF	88.8	88.88	88.3	88.57	4663600.0
2002-11-11 13:00:00	SPY	ETF	88.6	88.93	88.41	88.71	2839100.0
2002-11-11 14:00:00	SPY	ETF	88.7	88.8	88.38	88.6	2465800.0
2002-11-11 15:00:00	SPY	ETF	88.58	88.63	87.8	88.05	7591100.0
2002-11-11 16:00:00	SPY	ETF	88.03	88.31	88.02	88.26	1611500.0
2002-11-11 17:00:00	SPY	ETF	88.24	88.29	88.12	88.15	78100.0
2002-11-11 18:00:00	SPY	ETF	88.16	88.23	88.14	88.2	18900.0
2002-11-11 19:00:00	SPY	ETF	88.16	88.16	88.11	88.11	900.0
2002-11-11 08:00:00	QQQ	ETF	24.95	25.05	24.92	25.0	34300.0
2002-11-11 09:00:00	QQQ	ETF	25.02	25.05	24.57	24.67	14212600.0
2002-11-11 10:00:00	QQQ	ETF	24.68	24.74	24.44	24.54	11294200.0
2002-11-11 11:00:00	QQQ	ETF	24.55	24.67	24.39	24.43	10137100.0
2002-11-11 12:00:00	QQQ	ETF	24.43	24.46	24.3	24.44	6746200.0
2002-11-11 13:00:00	QQQ	ETF	24.44	24.59	24.35	24.45	5954700.0
2002-11-11 14:00:00	QQQ	ETF	24.44	24.5	24.32	24.4	4875600.0
2002-11-11 15:00:00	QQQ	ETF	24.36	24.4	24.15	24.25	14515100.0
2002-11-11 16:00:00	QQQ	ETF	24.23	24.47	24.22	24.33	1456800.0
2002-11-11 17:00:00	QQQ	ETF	24.32	24.32	24.2	24.22	248800.0
2002-11-11 18:00:00	QQQ	ETF	24.25	24.26	24.2	24.21	55500.0
2002-11-11 19:00:00	QQQ	ETF	24.24	24.24	24.23	24.23	2800.0
2002-11-11 09:00:00	IWM	ETF	37.725	37.725	37.425	37.435	258000.0
2002-11-11 10:00:00	IWM	ETF	37.405	37.54	37.285	37.35	301000.0
2002-11-11 11:00:00	IWM	ETF	37.35	37.355	37.125	37.22	247200.0
2002-11-11 12:00:00	IWM	ETF	37.2	37.2	36.91	37.07	422800.0
2002-11-11 13:00:00	IWM	ETF	37.065	37.17	37.03	37.135	215400.0
2002-11-11 14:00:00	IWM	ETF	37.1	37.13	36.995	37.085	71200.0
2002-11-11 15:00:00	IWM	ETF	37.06	37.06	36.79	36.805	675800.0
2002-11-11 16:00:00	IWM	ETF	36.79	36.89	36.79	36.81	10000.0
2002-11-11 08:00:00	DIA	ETF	85.24	85.24	85.0	85.1	5900.0
2002-11-11 09:00:00	DIA	ETF	85.14	85.17	84.55	84.6	1238800.0
2002-11-11 10:00:00	DIA	ETF	84.63	84.87	84.46	84.72	831800.0
2002-11-11 11:00:00	DIA	ETF	84.72	84.82	84.36	84.5	906900.0
2002-11-11 12:00:00	DIA	ETF	84.49	84.52	84.08	84.37	561500.0
2002-11-11 13:00:00	DIA	ETF	84.34	84.72	84.2	84.52	1130000.0
2002-11-11 14:00:00	DIA	ETF	84.55	84.57	84.18	84.33	506400.0
2002-11-11 15:00:00	DIA	ETF	84.3	84.33	83.61	83.78	1491400.0
2002-11-11 16:00:00	DIA	ETF	83.76	84.0	83.75	84.0	104400.0
2002-11-11 17:00:00	DIA	ETF	84.0	84.0	83.96	83.96	2900.0
2002-11-11 19:00:00	DIA	ETF	83.9	83.9	83.9	83.9	200.0
2002-11-11 20:00:00	DIA	ETF	83.83	83.83	83.83	83.83	100.0
2002-11-11 09:00:00	TLT	ETF	88.55	88.59	88.4	88.59	4000.0
2002-11-11 10:00:00	TLT	ETF	88.6	88.65	88.5	88.5	4700.0
2002-11-11 11:00:00	TLT	ETF	88.46	88.75	88.46	88.66	31100.0
2002-11-11 12:00:00	TLT	ETF	88.66	88.75	88.61	88.67	4300.0
2002-11-11 13:00:00	TLT	ETF	88.66	88.69	88.63	88.63	2700.0
2002-11-11 14:00:00	TLT	ETF	88.66	88.66	88.63	88.66	2800.0

> showing 50 of 373 rows — these rows as CSV

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