PREVIEW / etf_daily / 2007-04-20

all etf daily files

  file:    by_date/etf_daily/2007/2007-04-20.parquet
  size:    21 KB
  rows:    450

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-20	SPY	ETF	148.22	148.62	147.04	148.62	124114100.0
2007-04-20	QQQ	ETF	45.52	45.67	45.2	45.4	122441399.0
2007-04-20	IWM	ETF	81.96	82.38	81.76	82.31	68702200.0
2007-04-20	DIA	ETF	129.09	129.57	128.89	129.57	10280800.0
2007-04-20	GLD	ETF	68.58	68.73	68.35	68.7	3358100.0
2007-04-20	TLT	ETF	88.45	88.45	88.06	88.15	664500.0
2007-04-20	AAA	ETF	71.4	71.4	70.8	70.88	34900.0
2007-04-20	ADRE	ETF	41.62	41.87	41.52	41.72	74695.0
2007-04-20	AGG	ETF	100.26	100.26	100.02	100.14	162100.0
2007-04-20	AIQ	ETF	45.35	45.65	44.35	44.8	27580.0
2007-04-20	AIS	ETF	1.53	1.53	1.45	1.51	398100.0
2007-04-20	ARB	ETF	49.7	49.75	49.13	49.4	308500.0
2007-04-20	BAB	ETF	103.43	104.11	103.12	103.72	90600.0
2007-04-20	BBH	ETF	61.8567	62.2867	61.7733	61.95	371400.0
2007-04-20	BITS	ETF	32.92	34.0	32.68	33.04	13675.0
2007-04-20	BIV	ETF	75.35	75.37	75.24	75.31	8300.0
2007-04-20	BLV	ETF	75.7	75.7	75.48	75.56	6800.0
2007-04-20	BND	ETF	75.3	75.32	75.21	75.26	32200.0
2007-04-20	BNE	ETF	16.96	17.13	16.88	17.13	105900.0
2007-04-20	BRF	ETF	14.51	14.55	14.51	14.55	4600.0
2007-04-20	BSV	ETF	75.22	75.25	75.22	75.25	28800.0
2007-04-20	BTF	ETF	112.14999999999999	112.14999999999999	111.64999999999999	111.95	2000.0
2007-04-20	CBON	ETF	29.44	30.34	29.44	29.97	68040.0
2007-04-20	CDL	ETF	9.79	9.85	9.72	9.81	161300.0
2007-04-20	CEF	ETF	9.64	9.78	9.64	9.73	243400.0
2007-04-20	CGO	ETF	17.67	17.82	17.62	17.73	32100.0
2007-04-20	CHB	ETF	10.19	10.67	10.15	10.65	2278550.0
2007-04-20	CHI	ETF	20.21	20.24	19.99	20.21	120400.0
2007-04-20	CHIC	ETF	30.19	30.56	29.95	30.56	250718.0
2007-04-20	CHY	ETF	17.04	17.12	16.87	16.95	105700.0
2007-04-20	CIL	ETF	25.77	25.79	25.77	25.77	2000.0
2007-04-20	CN	ETF	51.25	51.93	49.97	51.23	130300.0
2007-04-20	CNXT	ETF	1.45	1.45	1.42	1.43	4240365.0
2007-04-20	CPI	ETF	21.29	21.3	21.21	21.26	3100.0
2007-04-20	CPST	ETF	1.17	1.23	1.15	1.22	4453081.0
2007-04-20	CSA	ETF	20.93	21.0	20.7	21.0	14600.0
2007-04-20	CSB	ETF	33.57	33.79	33.54	33.79	9000.0
2007-04-20	CSD	ETF	28.45	28.45	28.3	28.45	13400.0
2007-04-20	CSQ	ETF	15.57	15.6	15.42	15.55	395200.0
2007-04-20	CTEC	ETF	90.0	92.5	89.25	91.95	10422.0
2007-04-20	CVY	ETF	27.53	27.62	27.51	27.55	16600.0
2007-04-20	CWI	ETF	26.7	26.7467	26.6533	26.72	56550.0
2007-04-20	CZA	ETF	26.07	26.07	26.07	26.07	100.0
2007-04-20	DBA	ETF	25.42	25.5	25.2	25.5	107000.0
2007-04-20	DBB	ETF	27.47	27.55	27.28	27.42	15900.0
2007-04-20	DBC	ETF	25.28	25.53	25.19	25.53	199400.0
2007-04-20	DBE	ETF	27.16	27.43	27.13	27.43	54300.0
2007-04-20	DBO	ETF	25.74	25.95	25.64	25.92	35600.0
2007-04-20	DBP	ETF	27.31	27.4	27.27	27.31	17000.0
2007-04-20	DBS	ETF	27.42	27.45	27.36	27.4325	1900.0

> showing 50 of 450 rows — these rows as CSV

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