PREVIEW / etf_daily / 2007-07-05

all etf daily files

  file:    by_date/etf_daily/2007/2007-07-05.parquet
  size:    22 KB
  rows:    486

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-07-05	SPY	ETF	152.4	152.56	151.63	152.18	89279000.0
2007-07-05	QQQ	ETF	48.35	48.77	48.29	48.66	73588499.0
2007-07-05	IWM	ETF	84.45	84.67	83.86	84.51	47326500.0
2007-07-05	DIA	ETF	135.58	135.72	135.05	135.56	9392200.0
2007-07-05	GLD	ETF	64.99	65.0	63.92	64.42	4333200.0
2007-07-05	TLT	ETF	84.31	84.42	83.72	83.82	4586800.0
2007-07-05	ADRE	ETF	46.95	47.0	46.46	46.85	105987.0
2007-07-05	AGG	ETF	97.96	97.96	97.5	97.68	453000.0
2007-07-05	AIQ	ETF	49.95	50.25	49.25	50.0	31820.0
2007-07-05	AIS	ETF	1.64	1.66	1.6	1.64	166100.0
2007-07-05	ARB	ETF	53.2	53.57	52.58	53.52	256200.0
2007-07-05	BBH	ETF	56.45	56.5467	56.1433	56.5367	562500.0
2007-07-05	BIL	ETF	91.6	91.62	91.54	91.62	5450.0
2007-07-05	BITS	ETF	27.04	27.64	26.8	27.48	17829.0
2007-07-05	BIV	ETF	73.44	73.46	73.08	73.23	12900.0
2007-07-05	BLV	ETF	72.51	72.51	72.13	72.22	9000.0
2007-07-05	BMVP	ETF	18.1133	18.1833	18.06	18.1833	120500.0
2007-07-05	BND	ETF	73.93	73.93	73.75	73.78	43100.0
2007-07-05	BNE	ETF	19.57	19.57	19.21	19.4	139300.0
2007-07-05	BRF	ETF	14.49	14.77	14.48	14.49	39000.0
2007-07-05	BSV	ETF	74.72	74.72	74.55	74.6	32000.0
2007-07-05	BTF	ETF	106.95	107.79999999999998	106.95	107.5	1680.0
2007-07-05	CBON	ETF	27.51	27.7099	27.4	27.47	113146.0
2007-07-05	CDL	ETF	6.33	6.4	6.3	6.33	2322604.0
2007-07-05	CEF	ETF	9.04	9.11	9.01	9.06	123900.0
2007-07-05	CGO	ETF	18.29	18.345	18.06	18.1447	16500.0
2007-07-05	CGW	ETF	25.98	25.98	25.7708	25.88	208500.0
2007-07-05	CHB	ETF	10.1	10.16	9.56	9.68	1562200.0
2007-07-05	CHI	ETF	19.4	19.49	19.28	19.4	84200.0
2007-07-05	CHIC	ETF	25.5575	25.7	25.25	25.58	482669.0
2007-07-05	CHY	ETF	16.46	16.5	16.37	16.5	90800.0
2007-07-05	CN	ETF	54.75	55.5	54.26	55.47	79300.0
2007-07-05	CNXT	ETF	1.4	1.43	1.39	1.42	5412856.0
2007-07-05	CPI	ETF	23.75	23.75	23.46	23.46	700.0
2007-07-05	CPST	ETF	1.09	1.11	1.06	1.06	1846728.0
2007-07-05	CSA	ETF	20.35	20.6	20.23	20.24	12200.0
2007-07-05	CSB	ETF	31.95	32.0	31.68	31.89	214900.0
2007-07-05	CSD	ETF	31.05	31.17	31.02	31.17	107600.0
2007-07-05	CSQ	ETF	15.36	15.48	15.15	15.48	255100.0
2007-07-05	CTEC	ETF	111.5	112.5	110.74999999999999	111.6	16366.400000000001
2007-07-05	CVY	ETF	27.89	27.99	27.81	27.92	11800.0
2007-07-05	CWI	ETF	27.8333	27.8733	27.7467	27.82	29550.0
2007-07-05	CZA	ETF	27.39	27.39	27.39	27.39	100.0
2007-07-05	DBA	ETF	26.34	26.46	26.18	26.37	262600.0
2007-07-05	DBB	ETF	27.26	27.51	27.15	27.49	27700.0
2007-07-05	DBC	ETF	26.02	26.15	25.85	26.13	250500.0
2007-07-05	DBE	ETF	29.34	29.38	28.9	29.33	12000.0
2007-07-05	DBO	ETF	27.51	27.64	27.14	27.46	19000.0
2007-07-05	DBP	ETF	25.5	25.53	25.25	25.39	29600.0
2007-07-05	DBS	ETF	24.65	24.69	24.48	24.6	56300.0

> showing 50 of 486 rows — these rows as CSV

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