PREVIEW / etf_daily / 2007-04-23

all etf daily files

  file:    by_date/etf_daily/2007/2007-04-23.parquet
  size:    21 KB
  rows:    454

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-23	SPY	ETF	148.37	148.73	147.97	148.06	77270800.0
2007-04-23	QQQ	ETF	45.44	45.6	45.34	45.47	85450450.0
2007-04-23	IWM	ETF	82.21	82.51	81.88	82.22	34858200.0
2007-04-23	DIA	ETF	129.39	129.73	129.06	129.17	7509000.0
2007-04-23	GLD	ETF	68.41	68.65	68.04	68.26	2487500.0
2007-04-23	TLT	ETF	88.14	88.59	88.04	88.47	419000.0
2007-04-23	AAA	ETF	71.02	71.46	71.0	71.4	27400.0
2007-04-23	ADRE	ETF	41.63	41.76	41.3	41.3	139885.0
2007-04-23	AGG	ETF	100.18	100.3	100.03	100.24	409600.0
2007-04-23	AIQ	ETF	45.45	45.5	43.75	44.3	36460.0
2007-04-23	AIS	ETF	1.52	1.52	1.46	1.49	223300.0
2007-04-23	ARB	ETF	49.3	49.59	49.16	49.45	114600.0
2007-04-23	BAB	ETF	103.07	103.41	102.58	102.66	91300.0
2007-04-23	BBH	ETF	62.6633	62.9033	62.3333	62.7133	814800.0
2007-04-23	BITS	ETF	33.24	33.48	32.9	33.08	3732.0
2007-04-23	BIV	ETF	75.3	75.43	75.25	75.41	5300.0
2007-04-23	BLV	ETF	75.51	75.75	75.51	75.72	3800.0
2007-04-23	BND	ETF	75.28	75.43	75.22	75.36	43200.0
2007-04-23	BNE	ETF	17.08	17.19	16.73	16.86	111200.0
2007-04-23	BRF	ETF	14.54	14.54	14.49	14.53	8900.0
2007-04-23	BSV	ETF	75.24	75.36	75.24	75.29	1049800.0
2007-04-23	BTF	ETF	111.6	111.8	111.3	111.35	660.0
2007-04-23	CBON	ETF	29.83	30.85	29.83	30.54	114618.0
2007-04-23	CDL	ETF	9.78	9.81	9.66	9.71	245900.0
2007-04-23	CEF	ETF	9.69	9.78	9.68	9.72	207100.0
2007-04-23	CGO	ETF	17.76	17.86	17.74	17.79	19300.0
2007-04-23	CHB	ETF	10.65	10.72	10.25	10.47	1759948.0
2007-04-23	CHI	ETF	20.21	20.29	20.13	20.18	66500.0
2007-04-23	CHIC	ETF	30.55	30.69	29.99	30.2	311415.0
2007-04-23	CHY	ETF	16.95	16.95	16.87	16.94	115400.0
2007-04-23	CIL	ETF	25.77	25.85	25.77	25.85	1500.0
2007-04-23	CN	ETF	50.84	51.09	50.48	50.69	50100.0
2007-04-23	CNXT	ETF	1.42	1.45	1.41	1.44	6813723.0
2007-04-23	CPI	ETF	21.3	21.3	21.21	21.3	9900.0
2007-04-23	CPST	ETF	1.24	1.26	1.16	1.17	3106708.0
2007-04-23	CSA	ETF	20.93	21.06	20.88	21.01	6200.0
2007-04-23	CSB	ETF	33.27	33.48	33.27	33.31	21300.0
2007-04-23	CSD	ETF	28.5	28.6	28.49	28.5	9500.0
2007-04-23	CSQ	ETF	15.55	15.56	15.4	15.46	306000.0
2007-04-23	CTEC	ETF	92.2	92.39999999999999	89.19999999999999	89.89999999999999	9345.0
2007-04-23	CVY	ETF	27.65	27.74	27.55	27.58	25100.0
2007-04-23	CWI	ETF	26.5667	26.6667	26.5267	26.6067	203850.0
2007-04-23	DBA	ETF	25.25	25.29	24.96	25.0	323000.0
2007-04-23	DBB	ETF	27.5	28.0	27.43	27.77	16700.0
2007-04-23	DBC	ETF	25.29	25.7	25.25	25.7	252700.0
2007-04-23	DBE	ETF	27.6	27.94	27.5	27.85	56500.0
2007-04-23	DBO	ETF	26.08	26.56	26.07	26.48	10800.0
2007-04-23	DBP	ETF	27.28	27.38	27.23	27.26	6800.0
2007-04-23	DBS	ETF	27.43	27.62	27.29	27.59	7300.0
2007-04-23	DBV	ETF	27.73	27.7399	27.6	27.64	78000.0

> showing 50 of 454 rows — these rows as CSV

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