PREVIEW / etf_daily / 2007-08-29

all etf daily files

  file:    by_date/etf_daily/2007/2007-08-29.parquet
  size:    22 KB
  rows:    489

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
2007-08-29	SPY	ETF	144.37	146.74	143.96	146.54	207654200.0
2007-08-29	QQQ	ETF	47.05	48.12	47.05	48.08	113203904.0
2007-08-29	IWM	ETF	76.98	78.56	76.77	78.56	70723200.0
2007-08-29	DIA	ETF	131.08	132.95	130.97	132.74	10693800.0
2007-08-29	GLD	ETF	65.89	66.2	65.73	66.07	4469800.0
2007-08-29	TLT	ETF	88.49	88.77	88.16	88.22	2686700.0
2007-08-29	ADRE	ETF	44.47	45.57	44.37	45.57	130181.0
2007-08-29	AGG	ETF	99.77	99.85	99.54	99.55	201400.0
2007-08-29	AIQ	ETF	43.8	45.7	43.65	45.65	21120.0
2007-08-29	AIS	ETF	1.5	1.5	1.44	1.46	120300.0
2007-08-29	ARB	ETF	49.04	49.99	48.9	49.88	182000.0
2007-08-29	BBH	ETF	53.6333	54.2267	53.45	54.2167	108900.0
2007-08-29	BIL	ETF	91.96	91.98	91.9	91.98	10550.0
2007-08-29	BITS	ETF	25.72	26.36	25.6	26.32	2764.0
2007-08-29	BIV	ETF	75.5	75.62	75.3	75.39	10500.0
2007-08-29	BLV	ETF	74.66	74.79	74.33	74.48	16600.0
2007-08-29	BMVP	ETF	16.58	16.82	16.52	16.82	64100.0
2007-08-29	BND	ETF	75.44	75.52	75.28	75.35	92200.0
2007-08-29	BNE	ETF	16.64	16.73	16.36	16.58	159400.0
2007-08-29	BRF	ETF	14.6	14.68	14.52	14.55	2000.0
2007-08-29	BSV	ETF	75.9	75.96	75.75	75.83	73500.0
2007-08-29	BTF	ETF	104.55	106.5	104.45	106.5	1360.0
2007-08-29	CBON	ETF	25.38	25.42	24.86	25.0	126961.0
2007-08-29	CDL	ETF	4.15	4.23	4.11	4.23	1859100.0
2007-08-29	CEF	ETF	9.15	9.16	9.05	9.12	166900.0
2007-08-29	CGO	ETF	16.66	16.87	16.64	16.81	20600.0
2007-08-29	CGW	ETF	24.21	24.58	24.08	24.49	155700.0
2007-08-29	CHB	ETF	10.46	11.04	10.43	10.96	1417900.0
2007-08-29	CHI	ETF	16.6	16.6	16.34	16.39	85700.0
2007-08-29	CHIC	ETF	17.07	17.49	17.07	17.35	312983.0
2007-08-29	CHW	ETF	13.67	13.9	13.55	13.7184	63100.0
2007-08-29	CHY	ETF	14.58	14.58	14.16	14.23	151300.0
2007-08-29	CN	ETF	48.32	49.69	47.95	49.44	194300.0
2007-08-29	CNXT	ETF	1.09	1.1	1.06	1.08	5543368.0
2007-08-29	CPST	ETF	1.12	1.13	1.08	1.1	2009363.0
2007-08-29	CSA	ETF	17.28	17.4	17.06	17.33	42800.0
2007-08-29	CSD	ETF	28.31	28.68	28.18	28.67	15800.0
2007-08-29	CSQ	ETF	14.25	14.34	14.05	14.34	270700.0
2007-08-29	CTEC	ETF	100.6	102.05	98.39999999999999	100.99999999999999	24592.4
2007-08-29	CVY	ETF	25.4	25.86	25.4	25.85	30000.0
2007-08-29	CWI	ETF	26.08	26.4533	25.9933	26.4533	132450.0
2007-08-29	CZA	ETF	25.2	25.25	25.12	25.22	1700.0
2007-08-29	DBA	ETF	26.57	26.62	26.34	26.54	118800.0
2007-08-29	DBB	ETF	25.3	25.55	25.0	25.45	15000.0
2007-08-29	DBC	ETF	25.39	25.64	25.39	25.63	264700.0
2007-08-29	DBE	ETF	28.13	28.32	28.13	28.28	7300.0
2007-08-29	DBO	ETF	26.55	26.71	26.46	26.69	14700.0
2007-08-29	DBP	ETF	25.58	25.61	25.52	25.57	6100.0
2007-08-29	DBS	ETF	23.39	23.45	23.3101	23.45	1500.0
2007-08-29	DBV	ETF	27.33	27.67	27.26	27.67	144600.0

> showing 50 of 489 rows — these rows as CSV

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