PREVIEW / etf_daily / 2007-05-09

all etf daily files

  file:    by_date/etf_daily/2007/2007-05-09.parquet
  size:    21 KB
  rows:    455

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-09	SPY	ETF	150.64	152.82	150.37	151.16	102070100.0
2007-05-09	QQQ	ETF	46.49	46.97	46.46	46.83	116007860.0
2007-05-09	IWM	ETF	82.0	83.23	81.95	82.62	66106100.0
2007-05-09	DIA	ETF	132.99	133.77	132.8	133.57	9628000.0
2007-05-09	GLD	ETF	67.81	67.84	66.92	67.45	4647500.0
2007-05-09	TLT	ETF	88.65	88.66	88.26	88.29	634900.0
2007-05-09	AAA	ETF	71.59	72.0	69.0	69.69	107900.0
2007-05-09	ADRE	ETF	41.87	42.74	41.87	42.74	263972.0
2007-05-09	AGG	ETF	100.19	100.19	99.93	99.94	302100.0
2007-05-09	AIQ	ETF	44.55	44.95	44.05	44.25	38420.0
2007-05-09	AIS	ETF	1.7	1.7	1.64	1.7	285700.0
2007-05-09	ARB	ETF	48.43	49.16	48.25	48.9	112900.0
2007-05-09	BAB	ETF	98.7	99.1	98.3	98.91	54600.0
2007-05-09	BBH	ETF	62.23	62.4433	62.0033	62.4167	365700.0
2007-05-09	BITS	ETF	32.64	32.8	31.8	32.04	32430.0
2007-05-09	BIV	ETF	75.45	75.46	75.31	75.31	46200.0
2007-05-09	BLV	ETF	75.7	75.74	75.5	75.54	5900.0
2007-05-09	BMVP	ETF	17.99	18.12	17.99	18.1	32100.0
2007-05-09	BND	ETF	75.47	75.47	75.29	75.31	50200.0
2007-05-09	BNE	ETF	16.51	16.85	16.5	16.78	127500.0
2007-05-09	BRF	ETF	14.55	14.55	14.54	14.55	14300.0
2007-05-09	BSV	ETF	75.31	75.31	75.19	75.27	47800.0
2007-05-09	BTF	ETF	111.75	112.35	111.64999999999999	112.35	920.0
2007-05-09	CBON	ETF	30.73	31.58	30.73	31.21	44661.0
2007-05-09	CDL	ETF	8.94	8.94	8.7	8.73	311300.0
2007-05-09	CEF	ETF	9.41	9.47	9.33	9.39	126100.0
2007-05-09	CGO	ETF	17.88	18.39	17.85	18.09	56000.0
2007-05-09	CHB	ETF	10.65	11.46	10.64	11.14	2770800.0
2007-05-09	CHI	ETF	20.3	20.37	20.2	20.2337	84700.0
2007-05-09	CHIC	ETF	26.5	26.75	26.29	26.42	374567.0
2007-05-09	CHY	ETF	17.1	17.16	17.08	17.08	86260.0
2007-05-09	CN	ETF	49.13	49.37	48.73	49.29	49000.0
2007-05-09	CNXT	ETF	1.53	1.54	1.51	1.54	2686923.0
2007-05-09	CPI	ETF	23.6501	23.85	23.6501	23.8	1500.0
2007-05-09	CPST	ETF	0.9289	0.93	0.9	0.9	2812025.0
2007-05-09	CSA	ETF	21.13	21.13	20.72	20.78	28900.0
2007-05-09	CSB	ETF	31.52	31.81	31.45	31.72	15400.0
2007-05-09	CSD	ETF	29.21	29.38	29.12	29.37	12500.0
2007-05-09	CSM	ETF	1.3875	1.3875	1.3875	1.3875	2000.0
2007-05-09	CSQ	ETF	15.45	15.51	15.4	15.49	349900.0
2007-05-09	CTEC	ETF	92.55	97.14999999999999	92.55	94.89999999999999	49653.0
2007-05-09	CVY	ETF	27.94	28.14	27.93	28.08	38000.0
2007-05-09	CWI	ETF	26.7867	26.9933	26.7867	26.9933	53850.0
2007-05-09	CZA	ETF	26.55	26.56	26.52	26.54	4700.0
2007-05-09	DBA	ETF	24.78	24.96	24.78	24.9	310300.0
2007-05-09	DBB	ETF	28.51	28.82	28.43	28.71	65900.0
2007-05-09	DBC	ETF	25.08	25.15	24.8	25.08	252300.0
2007-05-09	DBE	ETF	27.41	27.48	26.92	27.48	92200.0
2007-05-09	DBO	ETF	25.84	25.94	25.49	25.75	22100.0
2007-05-09	DBP	ETF	26.81	26.9	26.55	26.72	25400.0

> showing 50 of 455 rows — these rows as CSV

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