PREVIEW / etf_daily / 2005-09-20

all etf daily files

  file:    by_date/etf_daily/2005/2005-09-20.parquet
  size:    15 KB
  rows:    282

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-09-20	SPY	ETF	123.2	123.61	121.87	122.05	84480300.0
2005-09-20	QQQ	ETF	39.16	39.541	38.809	38.93	115514289.0
2005-09-20	IWM	ETF	66.76	66.92	65.56	65.66	29350200.0
2005-09-20	DIA	ETF	105.68	105.97	104.57	104.72	11001900.0
2005-09-20	GLD	ETF	46.52	46.52	46.22	46.23	1898900.0
2005-09-20	TLT	ETF	92.29	92.8	91.88	92.54	1848800.0
2005-09-20	AAA	ETF	55.46	55.95	55.01	55.22	5600.0
2005-09-20	ADRE	ETF	106.66	106.66	105.04	105.16	17704.0
2005-09-20	AFK	ETF	25.53	25.53	25.4	25.4	11500.0
2005-09-20	AGG	ETF	101.84	101.9	101.43	101.73	219700.0
2005-09-20	AIQ	ETF	44.0	44.25	42.5	42.95	35940.0
2005-09-20	AIS	ETF	0.86	0.86	0.84	0.85	42500.0
2005-09-20	ARB	ETF	41.05	41.28	40.5	40.78	196000.0
2005-09-20	BAB	ETF	52.93	53.24	52.65	52.66	12200.0
2005-09-20	BBC	ETF	7.55	7.87	7.5	7.8	143500.0
2005-09-20	BBH	ETF	65.9333	66.71	65.61	65.9833	1403100.0
2005-09-20	BCM	ETF	62.88	63.68	62.722	62.96	63100.0
2005-09-20	BIS	ETF	656.0	660.8	656.0	660.8	12.5
2005-09-20	BITS	ETF	12.12	12.16	12.12	12.16	262.0
2005-09-20	BKF	ETF	30.11	30.8	30.08	30.74	51100.0
2005-09-20	BNE	ETF	14.23	14.25	13.97	14.01	125300.0
2005-09-20	BRF	ETF	15.37	15.37	15.35	15.35	6800.0
2005-09-20	BTF	ETF	86.5	86.89999999999999	86.1	86.1	1340.0
2005-09-20	CBON	ETF	32.5	32.69	32.32	32.69	8377.0
2005-09-20	CDC	ETF	3.6	3.6	3.31	3.4	3100.0
2005-09-20	CDL	ETF	13.55	13.7	13.14	13.32	351600.0
2005-09-20	CEF	ETF	5.62	5.62	5.4	5.48	512000.0
2005-09-20	CEW	ETF	25.95	25.95	25.95	25.95	400.0
2005-09-20	CHB	ETF	13.95	14.22	13.25	13.38	733100.0
2005-09-20	CHI	ETF	20.4	20.46	20.15	20.15	94800.0
2005-09-20	CHIC	ETF	14.66	14.74	14.1	14.26	340320.0
2005-09-20	CHIR	ETF	43.77	44.0601	43.65	43.86	1859201.0
2005-09-20	CHY	ETF	16.45	16.55	16.28	16.32	138600.0
2005-09-20	CIL	ETF	25.95	25.95	25.95	25.95	100.0
2005-09-20	CIZ	ETF	22.1	22.1	22.1	22.1	100.0
2005-09-20	CN	ETF	35.56	35.72	35.4	35.51	47000.0
2005-09-20	CNXT	ETF	1.94	2.0	1.85	1.91	81935383.0
2005-09-20	COMB	ETF	8.1	8.1	8.1	8.1	200.0
2005-09-20	CPI	ETF	24.2	24.2	24.1	24.1	400.0
2005-09-20	CPST	ETF	4.42	4.45	4.0	4.38	10912656.0
2005-09-20	CSB	ETF	30.34	30.6	29.91	29.96	20700.0
2005-09-20	CSQ	ETF	14.02	14.02	13.87	13.9	389800.0
2005-09-20	CTEC	ETF	55.0	55.0	54.349999999999994	54.5	7393.200000000001
2005-09-20	CURE	ETF	0.2325	0.2412	0.2325	0.2375	926296.0
2005-09-20	CYA	ETF	59.0	59.0	58.6	59.0	350.0
2005-09-20	CYB	ETF	4.07	4.14	4.07	4.08	6500.0
2005-09-20	DGT	ETF	65.35	65.52	64.92	64.92	1100.0
2005-09-20	DIG	ETF	14.5125	14.55	14.4	14.4	12480.0
2005-09-20	DIV	ETF	13.43	13.57	13.38	13.52	14200.0
2005-09-20	DRIV	ETF	37.68	37.68	36.4	36.52	590626.0

> showing 50 of 282 rows — these rows as CSV

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