PREVIEW / etf_daily / 2005-11-21

all etf daily files

  file:    by_date/etf_daily/2005/2005-11-21.parquet
  size:    16 KB
  rows:    297

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-21	SPY	ETF	125.15	125.91	124.98	125.76	50021200.0
2005-11-21	QQQ	ETF	41.397	41.581	41.24	41.549	69731364.0
2005-11-21	IWM	ETF	67.01	67.69	66.52	67.57	30758600.0
2005-11-21	DIA	ETF	107.76	108.3	107.53	108.16	5132900.0
2005-11-21	GLD	ETF	48.69	49.02	48.5	48.99	2384900.0
2005-11-21	TLT	ETF	90.34	90.66	90.33	90.41	503300.0
2005-11-21	AAA	ETF	52.67	52.77	52.23	52.36	2900.0
2005-11-21	ADRE	ETF	111.8	111.8	109.7185	110.6	40956.0
2005-11-21	AFK	ETF	25.38	25.48	25.36	25.36	10100.0
2005-11-21	AGG	ETF	100.44	100.51	100.24	100.43	194000.0
2005-11-21	AIQ	ETF	28.3	29.5995	26.35	28.15	16920.0
2005-11-21	AIS	ETF	1.19	1.25	1.15	1.19	37500.0
2005-11-21	AOM	ETF	3.6	3.63	3.55	3.57	8600.0
2005-11-21	ARB	ETF	39.25	39.28	38.69	39.0	130800.0
2005-11-21	BAB	ETF	53.63	53.63	52.79	53.2	32000.0
2005-11-21	BBC	ETF	7.5	10.25	7.5	9.84	635700.0
2005-11-21	BBH	ETF	70.05	70.7167	69.6	70.7167	1189200.0
2005-11-21	BCM	ETF	63.3	63.68	63.15	63.68	21400.0
2005-11-21	BITS	ETF	14.44	14.92	13.92	14.36	7316.0
2005-11-21	BKF	ETF	21.84	21.97	21.271	21.42	73900.0
2005-11-21	BNE	ETF	15.39	15.39	15.05	15.35	124500.0
2005-11-21	BRF	ETF	15.15	15.15	15.05	15.14	9400.0
2005-11-21	BTF	ETF	88.24999999999999	88.64999999999999	88.24999999999999	88.2875	1820.0
2005-11-21	CBON	ETF	32.5	33.1	32.5	33.06	16195.0
2005-11-21	CDL	ETF	13.48	13.62	13.375	13.57	695900.0
2005-11-21	CEF	ETF	6.01	6.06	6.0	6.05	372800.0
2005-11-21	CEW	ETF	26.0	26.0	26.0	26.0	400.0
2005-11-21	CGO	ETF	15.0	15.0	15.0	15.0	125700.0
2005-11-21	CHB	ETF	15.0	15.4	14.8	15.18	737600.0
2005-11-21	CHI	ETF	20.01	20.05	19.92	19.96	81300.0
2005-11-21	CHIC	ETF	17.06	17.4	16.99	17.33	137336.0
2005-11-21	CHIR	ETF	44.2899	44.4	44.25	44.31	1247100.0
2005-11-21	CHY	ETF	15.59	15.65	15.51	15.56	132200.0
2005-11-21	CIL	ETF	26.03	26.08	26.0	26.02	2500.0
2005-11-21	CN	ETF	33.68	33.69	33.5601	33.69	2000.0
2005-11-21	CNXT	ETF	2.37	2.4	2.33	2.37	6600860.0
2005-11-21	COMB	ETF	8.4	8.4	8.355	8.4	2015.0
2005-11-21	CPI	ETF	25.6	25.75	25.6	25.75	700.0
2005-11-21	CPST	ETF	3.77	4.01	3.71	3.91	10936424.0
2005-11-21	CSA	ETF	16.8	16.95	16.8	16.8	15800.0
2005-11-21	CSB	ETF	28.35	28.51	28.14	28.3	12500.0
2005-11-21	CSM	ETF	2.43	2.4325	2.43	2.4325	12800.0
2005-11-21	CSQ	ETF	13.16	13.24	13.12	13.2	389500.0
2005-11-21	CTEC	ETF	43.550000000000004	44.24999999999999	42.599999999999994	42.8	17026.2
2005-11-21	CURE	ETF	0.0688	0.0688	0.0625	0.0638	1513632.0
2005-11-21	CYB	ETF	3.5	3.57	3.5	3.57	1600.0
2005-11-21	DGT	ETF	65.2	65.49	65.2	65.46	2600.0
2005-11-21	DIG	ETF	14.7125	14.925	14.7125	14.925	5280.0
2005-11-21	DIV	ETF	11.85	11.9	11.83	11.89	23200.0
2005-11-21	DRIV	ETF	26.31	27.1	25.8	27.0	1667335.0

> showing 50 of 297 rows — these rows as CSV

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