PREVIEW / etf_daily / 2005-07-22

all etf daily files

  file:    by_date/etf_daily/2005/2005-07-22.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-22	SPY	ETF	122.88	123.56	122.63	123.54	52607100.0
2005-07-22	QQQ	ETF	39.47	39.59	39.22	39.42	71717398.0
2005-07-22	IWM	ETF	66.45	67.42	66.31	67.32	27929800.0
2005-07-22	DIA	ETF	106.31	106.55	105.82	106.48	5836600.0
2005-07-22	GLD	ETF	42.45	42.48	42.34	42.45	633300.0
2005-07-22	TLT	ETF	93.1	93.62	93.03	93.55	1614900.0
2005-07-22	AAA	ETF	52.14	52.14	51.75	51.86	38900.0
2005-07-22	ADRE	ETF	95.67	95.8878	95.2812	95.64	6456.0
2005-07-22	AFK	ETF	25.9	25.9	25.68	25.85	9900.0
2005-07-22	AGG	ETF	101.95	102.13	101.75	101.95	125100.0
2005-07-22	AIQ	ETF	51.05	52.25	51.0	51.75	27040.0
2005-07-22	AIS	ETF	1.07	1.09	1.05	1.06	94000.0
2005-07-22	ARB	ETF	42.6	42.75	41.9	42.3	229900.0
2005-07-22	BAB	ETF	48.24	48.34	48.15	48.16	20000.0
2005-07-22	BBH	ETF	63.73	63.8067	62.4867	63.25	1710900.0
2005-07-22	BCM	ETF	64.38	64.5	63.58	63.72	161000.0
2005-07-22	BIS	ETF	688.0	688.0	688.0	688.0	3.75
2005-07-22	BITS	ETF	14.32	14.32	13.8	14.0	4230.0
2005-07-22	BKF	ETF	34.26	34.68	34.26	34.49	27100.0
2005-07-22	BNE	ETF	13.84	14.3	13.84	14.3	183400.0
2005-07-22	BRF	ETF	15.4	15.45	15.35	15.4	4000.0
2005-07-22	BTF	ETF	86.6	86.99999999999999	86.6	86.99999999999999	1380.0
2005-07-22	CBON	ETF	31.99	32.45	31.741	32.43	27009.0
2005-07-22	CDC	ETF	6.75	6.75	6.6	6.6	5000.0
2005-07-22	CDL	ETF	11.75	11.97	11.7	11.97	527100.0
2005-07-22	CEF	ETF	5.31	5.31	5.23	5.25	183300.0
2005-07-22	CEW	ETF	26.8	26.8	26.75	26.75	1600.0
2005-07-22	CHB	ETF	11.98	12.5	11.98	12.43	743500.0
2005-07-22	CHI	ETF	19.94	19.94	19.85	19.9	64700.0
2005-07-22	CHIC	ETF	14.85	15.09	14.25	15.0	386580.0
2005-07-22	CHIR	ETF	35.7501	35.7501	35.1699	35.61	1245254.0
2005-07-22	CHY	ETF	16.48	16.59	16.4618	16.59	83100.0
2005-07-22	CIL	ETF	25.79	25.8	25.79	25.8	300.0
2005-07-22	CIZ	ETF	22.6	22.6	22.6	22.6	100.0
2005-07-22	CN	ETF	31.0	31.07	30.85	30.9	11400.0
2005-07-22	CNXT	ETF	1.83	1.88	1.8	1.88	3982008.0
2005-07-22	CPI	ETF	23.55	23.55	23.49	23.49	800.0
2005-07-22	CPST	ETF	1.69	1.75	1.6807	1.72	257376.0
2005-07-22	CSB	ETF	30.06	30.262	30.018	30.034	5200.0
2005-07-22	CSM	ETF	2.42	2.42	2.42	2.42	1200.0
2005-07-22	CSQ	ETF	14.28	14.29	14.17	14.2	329200.0
2005-07-22	CTEC	ETF	53.4	54.3	53.3	53.75	6660.0
2005-07-22	CURE	ETF	0.31	0.3187	0.3063	0.3113	665072.0
2005-07-22	CYA	ETF	137.0	137.0	132.0	134.0	380.0
2005-07-22	CYB	ETF	2.81	2.84	2.71	2.71	48300.0
2005-07-22	DGT	ETF	63.96	64.3	63.7	64.01	59400.0
2005-07-22	DIG	ETF	12.2875	12.5	12.2875	12.425	6320.0
2005-07-22	DIV	ETF	13.81	13.89	13.78	13.86	17200.0
2005-07-22	DRIV	ETF	36.3	36.99	35.99	36.48	448278.0
2005-07-22	DUSA	ETF	9.37	9.44	8.9	9.405	100677.0

> showing 50 of 274 rows — these rows as CSV

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