PREVIEW / etf_daily / 2007-05-14

all etf daily files

  file:    by_date/etf_daily/2007/2007-05-14.parquet
  size:    22 KB
  rows:    466

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-05-14	SPY	ETF	150.86	151.3	149.79	150.53	108027500.0
2007-05-14	QQQ	ETF	46.77	46.88	46.19	46.46	118966171.0
2007-05-14	IWM	ETF	82.29	82.59	81.46	81.62	71975000.0
2007-05-14	DIA	ETF	133.61	133.95	133.09	133.72	10734000.0
2007-05-14	GLD	ETF	66.63	66.65	66.0	66.28	3597600.0
2007-05-14	TLT	ETF	88.23	88.28	87.96	87.96	315200.0
2007-05-14	AAA	ETF	70.25	70.5	68.4	69.75	56500.0
2007-05-14	ADRE	ETF	42.9	42.98	42.33	42.54	211583.0
2007-05-14	AGG	ETF	100.0	100.02	99.76	99.93	247300.0
2007-05-14	AIQ	ETF	44.5	44.5	43.05	43.65	63640.0
2007-05-14	AIS	ETF	1.74	1.8	1.72	1.76	617500.0
2007-05-14	ARB	ETF	49.11	49.14	48.21	48.46	192700.0
2007-05-14	BAB	ETF	96.55	97.09	95.91	96.59	34900.0
2007-05-14	BBH	ETF	60.36	60.5733	60.22	60.3133	406800.0
2007-05-14	BITS	ETF	32.4	32.6	30.4	30.56	23390.0
2007-05-14	BIV	ETF	75.3	75.33	75.22	75.25	23000.0
2007-05-14	BLV	ETF	75.5	75.5	75.32	75.32	7600.0
2007-05-14	BMVP	ETF	18.05	18.1	17.96	18.0	39400.0
2007-05-14	BND	ETF	75.3	75.3	75.18	75.23	71200.0
2007-05-14	BNE	ETF	18.0	18.01	17.72	17.81	233100.0
2007-05-14	BOSS	ETF	50.5	51.98	50.5	51.98	100.0
2007-05-14	BRF	ETF	14.53	14.53	14.51	14.51	10400.0
2007-05-14	BSV	ETF	75.21	75.24	75.2	75.22	23400.0
2007-05-14	BTF	ETF	112.35	112.35	111.99999999999999	112.15999999999998	1200.0
2007-05-14	CBON	ETF	30.59	30.75	29.76	29.99	60921.0
2007-05-14	CDL	ETF	8.63	8.66	8.35	8.37	714100.0
2007-05-14	CEF	ETF	9.26	9.29	9.16	9.17	274900.0
2007-05-14	CGO	ETF	17.95	17.99	17.6	17.75	50800.0
2007-05-14	CGW	ETF	24.82	24.82	24.75	24.8	22900.0
2007-05-14	CHB	ETF	11.31	11.8	11.19	11.7	1985200.0
2007-05-14	CHI	ETF	20.27	20.37	20.23	20.33	67200.0
2007-05-14	CHIC	ETF	25.58	25.83	24.93	25.45	503811.0
2007-05-14	CHY	ETF	17.14	17.2	17.11	17.1401	87700.0
2007-05-14	CIL	ETF	25.87	25.99	25.87	25.99	4600.0
2007-05-14	CN	ETF	49.1	49.5	48.38	48.4	308900.0
2007-05-14	CNXT	ETF	1.47	1.48	1.44	1.46	6245278.0
2007-05-14	CPI	ETF	23.65	23.65	23.65	23.65	300.0
2007-05-14	CPST	ETF	0.93	0.9603	0.9	0.901	1823680.0
2007-05-14	CSA	ETF	20.92	21.0	20.8	20.84	25500.0
2007-05-14	CSB	ETF	32.02	32.04	31.76	31.8	32900.0
2007-05-14	CSD	ETF	29.55	29.59	29.42	29.47	28100.0
2007-05-14	CSM	ETF	1.4	1.4	1.39	1.39	13600.0
2007-05-14	CSQ	ETF	15.43	15.5	15.38	15.5	395700.0
2007-05-14	CTEC	ETF	88.45	89.60000000000001	87.2	87.65	12782.0
2007-05-14	CVY	ETF	28.06	28.06	27.93	27.94	14100.0
2007-05-14	CWI	ETF	26.9	26.9067	26.74	26.74	10800.0
2007-05-14	DBA	ETF	25.47	25.51	25.26	25.26	170200.0
2007-05-14	DBB	ETF	27.99	27.99	27.54	27.79	65700.0
2007-05-14	DBC	ETF	25.33	25.37	25.15	25.26	443700.0
2007-05-14	DBE	ETF	27.97	27.97	27.67	27.69	10300.0

> showing 50 of 466 rows — these rows as CSV

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