PREVIEW / etf_daily / 2005-07-21

all etf daily files

  file:    by_date/etf_daily/2005/2005-07-21.parquet
  size:    15 KB
  rows:    274

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-07-21	SPY	ETF	123.55	123.61	122.47	122.72	101110900.0
2005-07-21	QQQ	ETF	39.56	39.693	39.21	39.47	127792685.0
2005-07-21	IWM	ETF	67.45	67.45	66.22	66.3	41935700.0
2005-07-21	DIA	ETF	106.91	106.99	106.02	106.19	8750400.0
2005-07-21	GLD	ETF	42.43	42.51	42.33	42.46	1777300.0
2005-07-21	TLT	ETF	93.48	93.54	92.68	92.83	3824200.0
2005-07-21	AAA	ETF	52.03	52.25	51.73	52.0	2600.0
2005-07-21	ADRE	ETF	94.5	95.7884	94.5	95.67	11532.0
2005-07-21	AFK	ETF	25.9	25.9	25.75	25.77	3900.0
2005-07-21	AGG	ETF	102.15	102.16	101.79	101.8	135000.0
2005-07-21	AIQ	ETF	52.85	53.65	51.0	51.0	32000.0
2005-07-21	AIS	ETF	1.13	1.13	1.04	1.09	65400.0
2005-07-21	ARB	ETF	43.56	43.8	42.14	42.6	540800.0
2005-07-21	BAB	ETF	48.32	48.43	47.84	47.9	28300.0
2005-07-21	BBH	ETF	64.3333	64.5767	63.1867	64.1267	2232300.0
2005-07-21	BCM	ETF	63.9	64.52	63.9	64.14	6400.0
2005-07-21	BIS	ETF	688.0	688.0	688.0	688.0	6.25
2005-07-21	BITS	ETF	14.04	14.8	13.24	14.0	12137.0
2005-07-21	BKF	ETF	35.0	35.23	34.18	34.26	51100.0
2005-07-21	BNE	ETF	14.26	14.29	13.75	13.85	114500.0
2005-07-21	BOSS	ETF	28.0	28.0	28.0	28.0	100.0
2005-07-21	BRF	ETF	15.39	15.45	15.35	15.45	10100.0
2005-07-21	BTF	ETF	87.3	87.3	86.3	86.89999999999999	1100.0
2005-07-21	CBON	ETF	31.55	31.8	31.45	31.55	28543.0
2005-07-21	CDC	ETF	7.11	7.11	6.75	6.75	5500.0
2005-07-21	CDL	ETF	11.69	11.91	11.5	11.75	1854700.0
2005-07-21	CEF	ETF	5.18	5.28	5.18	5.28	350700.0
2005-07-21	CHB	ETF	11.9	12.25	11.82	11.96	926000.0
2005-07-21	CHI	ETF	19.94	19.98	19.89	19.9	77100.0
2005-07-21	CHIC	ETF	14.0	15.14	13.36	14.79	2139854.0
2005-07-21	CHIR	ETF	35.8899	35.9301	35.1099	35.7501	1501738.0
2005-07-21	CHY	ETF	16.55	16.55	16.46	16.48	136500.0
2005-07-21	CIL	ETF	25.73	25.79	25.72	25.79	5500.0
2005-07-21	CIZ	ETF	22.65	22.65	22.65	22.65	200.0
2005-07-21	CN	ETF	30.55	30.99	30.5	30.92	58300.0
2005-07-21	CNXT	ETF	1.86	1.87	1.78	1.81	3818979.0
2005-07-21	CPST	ETF	1.76	1.79	1.66	1.68	792106.0
2005-07-21	CSB	ETF	30.31	30.33	30.18	30.18	3900.0
2005-07-21	CSQ	ETF	14.31	14.34	14.15	14.25	457700.0
2005-07-21	CTEC	ETF	54.199999999999996	54.599999999999994	52.8	53.449999999999996	4580.0
2005-07-21	CURE	ETF	0.3113	0.3275	0.3088	0.3125	766440.0
2005-07-21	CYA	ETF	138.0	138.0	131.0	132.0	810.0
2005-07-21	CYB	ETF	2.95	2.95	2.8	2.81	26600.0
2005-07-21	DGT	ETF	64.25	64.59	63.75	63.96	1800.0
2005-07-21	DIG	ETF	12.1	12.2875	12.1	12.2875	1680.0
2005-07-21	DIV	ETF	13.94	13.94	13.8	13.81	8200.0
2005-07-21	DRIV	ETF	36.71	37.082	36.28	36.32	670561.0
2005-07-21	DUSA	ETF	8.9	9.44	8.87	9.37	156265.0
2005-07-21	DVY	ETF	64.3	64.3	63.34	63.47	633400.0
2005-07-21	EDEN	ETF	0.88	0.9	0.85	0.9	38932.0

> showing 50 of 274 rows — these rows as CSV

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