PREVIEW / etf_daily / 2005-09-14

all etf daily files

  file:    by_date/etf_daily/2005/2005-09-14.parquet
  size:    15 KB
  rows:    279

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-14	SPY	ETF	123.74	123.92	123.02	123.21	57694600.0
2005-09-14	QQQ	ETF	39.65	39.68	39.15	39.18	98671668.0
2005-09-14	IWM	ETF	67.2	67.3	66.25	66.4	21257200.0
2005-09-14	DIA	ETF	106.27	106.41	105.43	105.57	6904700.0
2005-09-14	GLD	ETF	44.82	44.96	44.66	44.96	1733800.0
2005-09-14	TLT	ETF	93.82	93.88	93.38	93.48	346400.0
2005-09-14	AAA	ETF	56.67	56.67	56.11	56.31	5900.0
2005-09-14	ADRE	ETF	102.59	103.69	102.59	103.0	8712.0
2005-09-14	AFK	ETF	25.47	25.69	25.47	25.59	4800.0
2005-09-14	AGG	ETF	102.29	102.33	101.9	102.19	171500.0
2005-09-14	AIQ	ETF	45.1	45.25	44.2	44.7	12200.0
2005-09-14	AIS	ETF	0.9	0.9	0.86	0.87	19400.0
2005-09-14	ARB	ETF	41.75	41.8	40.64	40.64	116300.0
2005-09-14	BAB	ETF	52.82	53.21	52.74	52.95	21200.0
2005-09-14	BBC	ETF	6.9	7.8	6.9	7.55	120000.0
2005-09-14	BBH	ETF	66.0	66.3567	65.0	65.2333	1907400.0
2005-09-14	BCM	ETF	62.08	62.21	61.95	62.18	276100.0
2005-09-14	BIS	ETF	688.0	688.0	688.0	688.0	129.0
2005-09-14	BITS	ETF	12.04	12.432	11.84	12.08	1650.0
2005-09-14	BKF	ETF	31.6	31.6	30.39	30.62	92600.0
2005-09-14	BNE	ETF	14.01	14.07	13.78	13.79	112200.0
2005-09-14	BRF	ETF	15.37	15.46	15.35	15.42	11200.0
2005-09-14	BTF	ETF	86.35	86.6	86.19999999999999	86.5	3360.0
2005-09-14	CBON	ETF	33.05	33.13	32.5	32.74	11565.0
2005-09-14	CDC	ETF	2.78	2.94	2.65	2.8	36200.0
2005-09-14	CDL	ETF	13.12	13.12	12.81	12.96	464500.0
2005-09-14	CEF	ETF	5.3	5.34	5.27	5.33	464500.0
2005-09-14	CEW	ETF	25.85	25.85	25.85	25.85	100.0
2005-09-14	CHB	ETF	13.62	13.7	13.11	13.16	365400.0
2005-09-14	CHI	ETF	20.29	20.3	20.14	20.14	80800.0
2005-09-14	CHIC	ETF	14.65	14.93	14.18	14.45	490965.0
2005-09-14	CHIR	ETF	43.8501	44.0598	43.8501	44.0001	1346189.0
2005-09-14	CHY	ETF	16.57	16.58	16.43	16.5	88700.0
2005-09-14	CIL	ETF	25.95	25.95	25.95	25.95	100.0
2005-09-14	CN	ETF	35.2	35.5	34.77	34.9	29100.0
2005-09-14	CNXT	ETF	1.63	1.67	1.61	1.63	3959643.0
2005-09-14	CPI	ETF	23.75	23.8	23.75	23.8	4500.0
2005-09-14	CPST	ETF	5.58	5.728	5.44	5.53	9515696.0
2005-09-14	CSB	ETF	30.96	31.24	30.96	31.0	8300.0
2005-09-14	CSQ	ETF	14.14	14.2	14.02	14.07	420600.0
2005-09-14	CTEC	ETF	54.699999999999996	55.0	53.8	54.74999999999999	9212.0
2005-09-14	CURE	ETF	0.2562	0.27	0.2512	0.2512	484576.0
2005-09-14	CYA	ETF	58.2	58.2	49.0	54.2	1840.0
2005-09-14	CYB	ETF	4.0	4.35	4.0	4.29	234100.0
2005-09-14	DGT	ETF	65.38	65.52	65.24	65.24	2600.0
2005-09-14	DIG	ETF	13.7375	13.75	13.4125	13.75	43520.0
2005-09-14	DIV	ETF	13.79	13.79	13.71	13.78	8900.0
2005-09-14	DRIV	ETF	39.28	39.28	38.0	38.2	475503.0
2005-09-14	DSI	ETF	5.8	5.8	5.8	5.8	1000.0
2005-09-14	DUSA	ETF	9.44	9.49	9.06	9.06	74211.0

> showing 50 of 279 rows — these rows as CSV

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