PREVIEW / etf_daily / 2005-08-29

all etf daily files

  file:    by_date/etf_daily/2005/2005-08-29.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-08-29	SPY	ETF	120.41	121.78	120.38	121.69	56179200.0
2005-08-29	QQQ	ETF	38.26	38.85	38.26	38.76	74971199.0
2005-08-29	IWM	ETF	64.43	65.37	64.2	65.37	23967300.0
2005-08-29	DIA	ETF	103.5	104.81	103.45	104.64	6547200.0
2005-08-29	GLD	ETF	43.81	43.96	43.56	43.57	1585500.0
2005-08-29	TLT	ETF	94.83	94.88	94.5	94.59	550100.0
2005-08-29	AAA	ETF	56.74	56.74	56.45	56.55	8200.0
2005-08-29	ADRE	ETF	97.02	97.9099	96.8	97.9099	10424.0
2005-08-29	AFK	ETF	25.75	25.89	25.75	25.85	28900.0
2005-08-29	AGG	ETF	102.2	102.32	102.07	102.2	97700.0
2005-08-29	AIQ	ETF	45.05	45.85	44.9	45.7	18360.0
2005-08-29	AIS	ETF	0.91	0.92	0.9	0.92	76000.0
2005-08-29	ARB	ETF	41.7	42.42	41.62	42.38	78000.0
2005-08-29	BAB	ETF	50.56	50.75	50.5	50.55	8600.0
2005-08-29	BBC	ETF	6.45	6.9	6.35	6.75	93200.0
2005-08-29	BBH	ETF	62.9233	64.2533	62.6133	64.1333	1746600.0
2005-08-29	BCM	ETF	58.61	58.85	58.52	58.59	17200.0
2005-08-29	BIS	ETF	675.2	675.2	675.2	675.2	1.25
2005-08-29	BITS	ETF	12.68	12.752	11.92	12.4	4283.0
2005-08-29	BKF	ETF	33.55	33.55	32.9	32.95	39100.0
2005-08-29	BNE	ETF	13.42	14.0	13.42	13.87	184900.0
2005-08-29	BRF	ETF	15.53	15.56	15.44	15.45	11300.0
2005-08-29	BTF	ETF	85.5	85.7	85.44999999999999	85.7	640.0
2005-08-29	CBON	ETF	33.14	33.5	32.76	33.25	102555.0
2005-08-29	CDC	ETF	3.6	3.6	3.47	3.53	5200.0
2005-08-29	CDL	ETF	13.46	13.65	13.27	13.47	215100.0
2005-08-29	CEF	ETF	5.3	5.32	5.23	5.26	419200.0
2005-08-29	CEW	ETF	26.28	26.3	26.25	26.25	3300.0
2005-08-29	CHB	ETF	11.17	11.53	11.16	11.53	472100.0
2005-08-29	CHI	ETF	20.0	20.15	19.91	20.14	83400.0
2005-08-29	CHIC	ETF	14.2	14.8	13.88	14.36	266451.0
2005-08-29	CHIR	ETF	35.1999	36.42	35.16	36.3	1044518.0
2005-08-29	CHY	ETF	16.35	16.38	16.32	16.38	92200.0
2005-08-29	CIL	ETF	25.83	25.84	25.83	25.84	1300.0
2005-08-29	CN	ETF	33.4	33.76	33.37	33.68	29800.0
2005-08-29	CNXT	ETF	1.68	1.72	1.65	1.71	3011774.0
2005-08-29	CPST	ETF	4.66	4.84	4.41	4.6	21038232.0
2005-08-29	CSB	ETF	30.3	30.48	30.1	30.25	7400.0
2005-08-29	CSM	ETF	2.4175	2.425	2.4175	2.425	4800.0
2005-08-29	CSQ	ETF	14.04	14.27	13.99	14.27	299000.0
2005-08-29	CTEC	ETF	53.65	53.75	51.6	52.05	4603.0
2005-08-29	CURE	ETF	0.2888	0.305	0.275	0.3038	1970248.0
2005-08-29	CYA	ETF	69.4	69.4	65.2	68.0	685.0
2005-08-29	CYB	ETF	3.78	3.85	3.76	3.76	2500.0
2005-08-29	DGT	ETF	63.25	63.8	63.25	63.8	4200.0
2005-08-29	DIV	ETF	13.6	13.6	13.43	13.5	10000.0
2005-08-29	DRIV	ETF	36.79	37.62	36.75	37.53	505251.0
2005-08-29	DSI	ETF	5.7	5.75	5.7	5.75	16200.0
2005-08-29	DUSA	ETF	10.61	10.89	10.51	10.89	52484.0
2005-08-29	DVY	ETF	62.07	62.48	61.7	62.48	640000.0

> showing 50 of 279 rows — these rows as CSV

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