PREVIEW / etf_daily / 2005-11-04

all etf daily files

  file:    by_date/etf_daily/2005/2005-11-04.parquet
  size:    15 KB
  rows:    287

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2005-11-04	SPY	ETF	122.4	122.46	121.55	122.11	59156000.0
2005-11-04	QQQ	ETF	39.994	40.23	39.84	40.08	100944407.0
2005-11-04	IWM	ETF	65.58	65.77	64.94	65.48	26502300.0
2005-11-04	DIA	ETF	105.37	105.49	104.74	105.19	4155600.0
2005-11-04	GLD	ETF	45.93	46.07	45.32	45.51	1813200.0
2005-11-04	TLT	ETF	88.42	88.64	87.86	88.12	1888700.0
2005-11-04	AAA	ETF	56.38	56.38	55.83	55.97	1600.0
2005-11-04	ADRE	ETF	107.38	107.69	105.2101	105.94	13600.0
2005-11-04	AFK	ETF	25.49	25.52	25.38	25.38	4600.0
2005-11-04	AGG	ETF	99.59	99.71	99.4	99.55	121200.0
2005-11-04	AIQ	ETF	32.25	33.0	31.0	31.0	57300.0
2005-11-04	AIS	ETF	1.179	1.19	1.14	1.19	86100.0
2005-11-04	AOM	ETF	3.55	3.62	3.45	3.52	24200.0
2005-11-04	ARB	ETF	37.48	37.78	37.2	37.59	125700.0
2005-11-04	BAB	ETF	54.3	54.69	53.29	53.65	35300.0
2005-11-04	BBC	ETF	7.0	7.02	6.8	6.94	41000.0
2005-11-04	BBH	ETF	66.4167	67.2867	66.3333	67.0	1296900.0
2005-11-04	BCM	ETF	61.9	62.37	61.85	62.1	42600.0
2005-11-04	BITS	ETF	10.84	11.96	10.84	11.52	17256.0
2005-11-04	BKF	ETF	22.58	22.58	19.88	20.35	461500.0
2005-11-04	BNE	ETF	14.5	14.99	14.33	14.94	105400.0
2005-11-04	BOSS	ETF	29.0	29.32	29.0	29.32	100.0
2005-11-04	BRF	ETF	15.24	15.25	15.23	15.23	2900.0
2005-11-04	BTF	ETF	85.8	85.99999999999999	85.05	85.29999999999998	18300.0
2005-11-04	CBON	ETF	32.81	33.14	32.81	32.9815	1850.0
2005-11-04	CDL	ETF	14.0	14.0	13.66	13.81	1092900.0
2005-11-04	CEF	ETF	5.7	5.7	5.62	5.65	244300.0
2005-11-04	CEW	ETF	26.0	26.0	26.0	26.0	100.0
2005-11-04	CGO	ETF	15.0	15.01	15.0	15.01	28300.0
2005-11-04	CHB	ETF	14.25	14.48	14.03	14.25	370000.0
2005-11-04	CHI	ETF	20.25	20.34	20.15	20.31	88100.0
2005-11-04	CHIC	ETF	16.92	17.95	16.35	17.25	1274303.0
2005-11-04	CHIR	ETF	44.22	44.28	44.1501	44.1699	2896227.0
2005-11-04	CHY	ETF	15.79	15.83	15.7	15.77	91400.0
2005-11-04	CIL	ETF	25.97	25.97	25.97	25.97	400.0
2005-11-04	CIZ	ETF	21.4	21.4	21.4	21.4	200.0
2005-11-04	CN	ETF	34.21	34.21	33.95	34.15	9600.0
2005-11-04	CNXT	ETF	2.27	2.33	2.24	2.32	13324652.0
2005-11-04	COMB	ETF	8.47	8.47	8.47	8.47	30000.0
2005-11-04	CPI	ETF	24.25	24.25	24.25	24.25	500.0
2005-11-04	CPST	ETF	2.7	2.7901	2.62	2.75	2511429.0
2005-11-04	CSA	ETF	17.11	17.19	17.05	17.13	17900.0
2005-11-04	CSB	ETF	28.89	28.99	28.35	28.5	34700.0
2005-11-04	CSM	ETF	2.4325	2.4325	2.4325	2.4325	1600.0
2005-11-04	CSQ	ETF	13.4	13.43	13.3	13.39	303200.0
2005-11-04	CTEC	ETF	43.4625	43.49999999999999	42.8	42.9	7094.400000000001
2005-11-04	CURE	ETF	0.0663	0.0712	0.065	0.0675	1980816.0
2005-11-04	DGT	ETF	64.5	64.55	64.18	64.24	1600.0
2005-11-04	DIV	ETF	12.09	12.18	12.08	12.11	8100.0
2005-11-04	DRIV	ETF	27.72	28.17	27.42	27.65	754742.0

> showing 50 of 287 rows — these rows as CSV

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