PREVIEW / etf_daily / 2005-11-02

all etf daily files

  file:    by_date/etf_daily/2005/2005-11-02.parquet
  size:    15 KB
  rows:    284

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-02	SPY	ETF	120.17	121.75	120.13	121.75	74012300.0
2005-11-02	QQQ	ETF	38.725	39.46	38.71	39.347	101555811.0
2005-11-02	IWM	ETF	63.92	65.39	63.85	65.39	33256200.0
2005-11-02	DIA	ETF	103.86	104.89	103.76	104.7	6249000.0
2005-11-02	GLD	ETF	45.99	46.23	45.9	46.13	1008600.0
2005-11-02	TLT	ETF	89.08	89.39	88.83	88.86	781100.0
2005-11-02	AAA	ETF	55.9	56.94	55.74	56.94	10300.0
2005-11-02	ADRE	ETF	105.69	106.41	104.89	106.28	23836.0
2005-11-02	AFK	ETF	25.45	25.48	25.44	25.45	2800.0
2005-11-02	AGG	ETF	99.89	99.97	99.66	99.79	104800.0
2005-11-02	AIQ	ETF	34.3	34.75	33.55	34.25	14240.0
2005-11-02	AIS	ETF	1.15	1.19	1.14	1.19	74100.0
2005-11-02	ARB	ETF	37.4	37.95	37.3	37.78	107500.0
2005-11-02	BAB	ETF	54.02	55.3	53.83	55.3	42300.0
2005-11-02	BBC	ETF	6.75	7.03	6.75	6.97	41200.0
2005-11-02	BBH	ETF	64.5833	65.6067	64.5833	64.87	1993800.0
2005-11-02	BCM	ETF	61.85	62.05	61.62	61.92	18500.0
2005-11-02	BITS	ETF	10.24	11.0	10.24	10.88	1698.0
2005-11-02	BKF	ETF	19.1	21.7	19.1	21.7	353300.0
2005-11-02	BNE	ETF	14.5	14.65	14.39	14.57	174900.0
2005-11-02	BRF	ETF	15.32	15.32	15.32	15.32	100.0
2005-11-02	BTF	ETF	84.49999999999999	85.15	84.14999999999999	84.8	15960.0
2005-11-02	CBON	ETF	32.99	33.15	32.91	33.1	4492.0
2005-11-02	CDL	ETF	13.68	13.87	13.67	13.75	169900.0
2005-11-02	CEF	ETF	5.65	5.73	5.65	5.7	359500.0
2005-11-02	CEW	ETF	25.75	25.8	25.75	25.8	200.0
2005-11-02	CGO	ETF	15.01	15.01	15.0	15.01	23400.0
2005-11-02	CHB	ETF	13.55	14.14	13.4	14.06	575200.0
2005-11-02	CHI	ETF	19.78	20.0	19.77	19.96	122500.0
2005-11-02	CHIC	ETF	17.34	18.25	17.34	18.2	540243.0
2005-11-02	CHIR	ETF	44.28	44.37	44.1801	44.2299	2386596.0
2005-11-02	CHY	ETF	15.51	15.71	15.4436	15.7	68100.0
2005-11-02	CIL	ETF	26.05	26.05	26.05	26.05	1000.0
2005-11-02	CIZ	ETF	21.6	21.6	21.4	21.444	1300.0
2005-11-02	CN	ETF	32.65	32.81	32.65	32.8	13100.0
2005-11-02	CNXT	ETF	1.96	2.1801	1.95	2.16	26059371.0
2005-11-02	COMB	ETF	8.45	8.47	8.45	8.47	200.0
2005-11-02	CPI	ETF	24.3	24.3	24.3	24.3	400.0
2005-11-02	CPST	ETF	2.51	2.82	2.5	2.8	5294159.0
2005-11-02	CSA	ETF	17.2	17.2	17.06	17.08	34800.0
2005-11-02	CSB	ETF	29.35	29.74	29.35	29.57	15200.0
2005-11-02	CSQ	ETF	13.59	13.67	13.41	13.5	290300.0
2005-11-02	CTEC	ETF	42.949999999999996	43.4	42.599999999999994	43.2	17090.2
2005-11-02	CURE	ETF	0.075	0.0762	0.0712	0.0725	2278888.0
2005-11-02	CYB	ETF	3.23	3.23	3.18	3.18	1600.0
2005-11-02	DGT	ETF	63.94	64.1	63.94	64.07	4200.0
2005-11-02	DIG	ETF	13.8625	13.8625	13.8625	13.8625	80.0
2005-11-02	DIV	ETF	12.28	12.35	12.2	12.35	29200.0
2005-11-02	DRIV	ETF	26.9	27.57	25.93	27.14	3033381.0
2005-11-02	DSI	ETF	5.805	5.805	5.805	5.805	800.0

> showing 50 of 284 rows — these rows as CSV

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