PREVIEW / etf_daily / 2007-04-25

all etf daily files

  file:    by_date/etf_daily/2007/2007-04-25.parquet
  size:    21 KB
  rows:    452

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-04-25	SPY	ETF	148.73	149.66	148.02	149.48	108418800.0
2007-04-25	QQQ	ETF	45.85	46.32	45.7	46.31	106954392.0
2007-04-25	IWM	ETF	82.54	82.93	81.97	82.41	51964600.0
2007-04-25	DIA	ETF	129.92	130.99	129.56	130.62	12649900.0
2007-04-25	GLD	ETF	67.85	68.06	67.66	67.89	2614100.0
2007-04-25	TLT	ETF	88.57	88.79	88.11	88.49	569000.0
2007-04-25	AAA	ETF	70.83	71.8	70.83	71.8	16300.0
2007-04-25	ADRE	ETF	41.48	41.9799	41.422	41.94	117461.0
2007-04-25	AGG	ETF	100.37	100.45	100.2	100.33	401800.0
2007-04-25	AIQ	ETF	45.3	45.6	45.1	45.5	36140.0
2007-04-25	AIS	ETF	1.6	1.61	1.54	1.57	232900.0
2007-04-25	ARB	ETF	49.72	49.88	49.42	49.57	288100.0
2007-04-25	BAB	ETF	101.96	102.96	101.54	102.65	95800.0
2007-04-25	BBH	ETF	62.4167	62.7233	62.0533	62.6333	305700.0
2007-04-25	BITS	ETF	31.76	32.6	31.68	32.2	14187.0
2007-04-25	BIV	ETF	75.53	75.62	75.47	75.48	7800.0
2007-04-25	BLV	ETF	75.85	75.92	75.73	75.82	34300.0
2007-04-25	BND	ETF	75.43	75.55	75.39	75.42	264200.0
2007-04-25	BNE	ETF	17.33	17.43	16.93	16.94	159500.0
2007-04-25	BRF	ETF	14.5	14.54	14.5	14.51	10700.0
2007-04-25	BSV	ETF	75.36	75.38	75.3	75.31	30000.0
2007-04-25	BTF	ETF	111.54999999999998	112.39999999999999	111.14999999999999	112.05	2060.0
2007-04-25	CBON	ETF	30.74	31.616	30.59	31.46	71598.0
2007-04-25	CDL	ETF	9.77	9.85	9.74	9.81	79100.0
2007-04-25	CEF	ETF	9.69	9.79	9.6	9.71	346000.0
2007-04-25	CGO	ETF	17.47	17.74	17.21	17.72	63400.0
2007-04-25	CHB	ETF	10.43	10.81	10.22	10.63	1656452.0
2007-04-25	CHI	ETF	20.22	20.35	20.22	20.24	77100.0
2007-04-25	CHIC	ETF	30.0	30.22	29.28	29.75	564855.0
2007-04-25	CHY	ETF	16.93	17.1	16.93	17.03	127600.0
2007-04-25	CN	ETF	51.2	51.365	50.7	51.09	72500.0
2007-04-25	CNXT	ETF	1.59	1.59	1.52	1.55	8289607.0
2007-04-25	CPI	ETF	21.01	21.3	21.0	21.3	3500.0
2007-04-25	CPST	ETF	1.23	1.23	1.15	1.16	2032647.0
2007-04-25	CSA	ETF	21.49	21.49	21.1	21.12	35400.0
2007-04-25	CSB	ETF	33.51	33.82	33.51	33.7832	11300.0
2007-04-25	CSD	ETF	28.8	28.95	28.7	28.92	32800.0
2007-04-25	CSQ	ETF	15.52	15.53	15.44	15.53	415800.0
2007-04-25	CTEC	ETF	89.64999999999999	90.0	88.49999999999999	89.04999999999998	8830.0
2007-04-25	CVY	ETF	27.74	27.76	27.6	27.73	14600.0
2007-04-25	CWI	ETF	26.64	26.8	26.6	26.8	60750.0
2007-04-25	CZA	ETF	26.32	26.34	26.32	26.32	5800.0
2007-04-25	DBA	ETF	25.08	25.96	25.0	25.55	203100.0
2007-04-25	DBB	ETF	27.6	27.81	27.35	27.81	12600.0
2007-04-25	DBC	ETF	25.45	25.95	25.45	25.85	207000.0
2007-04-25	DBE	ETF	27.82	28.25	27.8	28.21	4400.0
2007-04-25	DBO	ETF	26.35	26.64	26.27	26.64	3000.0
2007-04-25	DBP	ETF	27.13	27.13	26.95	27.08	7300.0
2007-04-25	DBS	ETF	27.23	27.3	27.02	27.2	10400.0
2007-04-25	DBV	ETF	27.5	27.59	27.4901	27.56	83700.0

> showing 50 of 452 rows — these rows as CSV

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