PREVIEW / etf_1hour / 2002-11-26

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-11-26.parquet
  size:    16 KB
  rows:    398

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-26 08:00:00	SPY	ETF	93.4	93.71	93.2	93.24	29500.0
2002-11-26 09:00:00	SPY	ETF	93.24	93.45	92.95	93.44	2523500.0
2002-11-26 10:00:00	SPY	ETF	93.42	93.44	92.35	92.41	9058300.0
2002-11-26 11:00:00	SPY	ETF	92.44	92.75	92.25	92.73	4511200.0
2002-11-26 12:00:00	SPY	ETF	92.73	92.99	92.57	92.78	3376400.0
2002-11-26 13:00:00	SPY	ETF	92.77	92.8	92.39	92.52	3251700.0
2002-11-26 14:00:00	SPY	ETF	92.48	92.54	92.08	92.4	6471500.0
2002-11-26 15:00:00	SPY	ETF	92.42	92.42	91.62	91.85	7692200.0
2002-11-26 16:00:00	SPY	ETF	91.85	91.91	91.55	91.83	1911700.0
2002-11-26 17:00:00	SPY	ETF	91.79	91.85	91.76	91.82	5000.0
2002-11-26 18:00:00	SPY	ETF	91.79	91.88	91.79	91.88	700.0
2002-11-26 08:00:00	QQQ	ETF	27.94	28.0	27.82	27.84	60800.0
2002-11-26 09:00:00	QQQ	ETF	27.84	27.85	27.65	27.84	10129700.0
2002-11-26 10:00:00	QQQ	ETF	27.81	27.87	27.37	27.46	17086800.0
2002-11-26 11:00:00	QQQ	ETF	27.46	27.64	27.4	27.58	6315800.0
2002-11-26 12:00:00	QQQ	ETF	27.59	27.7	27.47	27.55	4592000.0
2002-11-26 13:00:00	QQQ	ETF	27.54	27.55	27.22	27.29	9269700.0
2002-11-26 14:00:00	QQQ	ETF	27.28	27.3	27.1	27.23	10135400.0
2002-11-26 15:00:00	QQQ	ETF	27.26	27.26	26.9	27.04	15111400.0
2002-11-26 16:00:00	QQQ	ETF	27.03	27.22	26.94	27.19	3041200.0
2002-11-26 17:00:00	QQQ	ETF	27.17	27.19	27.15	27.17	144500.0
2002-11-26 18:00:00	QQQ	ETF	27.17	27.2	27.16	27.2	14300.0
2002-11-26 19:00:00	QQQ	ETF	27.18	27.21	27.15	27.15	3300.0
2002-11-26 09:00:00	IWM	ETF	40.275	40.4	40.16	40.295	230200.0
2002-11-26 10:00:00	IWM	ETF	40.3	40.325	39.635	39.75	370000.0
2002-11-26 11:00:00	IWM	ETF	39.675	39.975	39.6	39.965	156000.0
2002-11-26 12:00:00	IWM	ETF	39.985	40.065	39.935	40.0	106600.0
2002-11-26 13:00:00	IWM	ETF	40.0	40.005	39.84	39.905	117000.0
2002-11-26 14:00:00	IWM	ETF	39.9	39.935	39.755	39.935	187800.0
2002-11-26 15:00:00	IWM	ETF	39.935	39.935	39.63	39.75	640200.0
2002-11-26 16:00:00	IWM	ETF	39.8	39.92	39.66	39.66	539600.0
2002-11-26 08:00:00	DIA	ETF	88.35	88.65	88.25	88.65	3300.0
2002-11-26 09:00:00	DIA	ETF	88.12	88.28	87.83	88.28	671200.0
2002-11-26 10:00:00	DIA	ETF	88.28	88.28	87.2	87.26	1602900.0
2002-11-26 11:00:00	DIA	ETF	87.29	87.6	87.05	87.53	740000.0
2002-11-26 12:00:00	DIA	ETF	87.57	87.79	87.41	87.59	442700.0
2002-11-26 13:00:00	DIA	ETF	87.62	87.65	87.34	87.47	353600.0
2002-11-26 14:00:00	DIA	ETF	87.47	87.53	87.18	87.47	707600.0
2002-11-26 15:00:00	DIA	ETF	87.44	87.47	86.85	87.01	726300.0
2002-11-26 16:00:00	DIA	ETF	86.99	87.08	86.85	87.08	138600.0
2002-11-26 17:00:00	DIA	ETF	86.95	86.97	86.85	86.97	1400.0
2002-11-26 18:00:00	DIA	ETF	87.0	87.0	87.0	87.0	400.0
2002-11-26 19:00:00	DIA	ETF	87.0	87.0	87.0	87.0	400.0
2002-11-26 09:00:00	TLT	ETF	86.2	86.3	86.17	86.17	52000.0
2002-11-26 10:00:00	TLT	ETF	86.15	86.76	86.15	86.7	100700.0
2002-11-26 11:00:00	TLT	ETF	86.66	86.86	86.66	86.72	28700.0
2002-11-26 12:00:00	TLT	ETF	86.79	86.8	86.62	86.65	44100.0
2002-11-26 13:00:00	TLT	ETF	86.72	86.77	86.61	86.75	4400.0
2002-11-26 14:00:00	TLT	ETF	86.86	86.94	86.8	86.9	55300.0
2002-11-26 15:00:00	TLT	ETF	86.85	87.02	86.85	86.9	88400.0

> showing 50 of 398 rows — these rows as CSV

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