PREVIEW / etf_daily / 2007-09-21

all etf daily files

  file:    by_date/etf_daily/2007/2007-09-21.parquet
  size:    23 KB
  rows:    499

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-09-21	SPY	ETF	152.71	153.12	151.74	151.97	141457500.0
2007-09-21	QQQ	ETF	50.28	50.52	50.0143	50.36	86837267.0
2007-09-21	IWM	ETF	81.28	81.56	80.86	80.96	57473900.0
2007-09-21	DIA	ETF	138.37	139.02	137.9	137.9	8249600.0
2007-09-21	GLD	ETF	72.65	73.0	71.47	72.34	9937400.0
2007-09-21	TLT	ETF	87.58	88.13	87.58	87.89	2217600.0
2007-09-21	ADRE	ETF	50.5	50.69	50.01	50.3399	209993.0
2007-09-21	AGG	ETF	99.6	99.74	99.33	99.71	465700.0
2007-09-21	AIQ	ETF	45.05	47.5	44.7	46.7	53660.0
2007-09-21	AIS	ETF	1.42	1.46	1.4	1.42	68200.0
2007-09-21	ARB	ETF	46.06	46.66	46.06	46.6	368600.0
2007-09-21	BBH	ETF	58.7333	58.8767	58.4233	58.63	454200.0
2007-09-21	BIL	ETF	91.8	91.88	91.78	91.82	23450.0
2007-09-21	BITS	ETF	26.68	26.88	26.0	26.32	9668.0
2007-09-21	BIV	ETF	75.15	75.22	74.99	75.17	13300.0
2007-09-21	BLV	ETF	73.94	74.42	73.94	74.42	19600.0
2007-09-21	BMVP	ETF	17.23	17.2466	17.14	17.15	95100.0
2007-09-21	BND	ETF	75.37	75.48	75.22	75.48	233800.0
2007-09-21	BNE	ETF	16.76	17.0	16.68	16.73	485100.0
2007-09-21	BOSS	ETF	47.2	48.05	47.2	47.75	200.0
2007-09-21	BRF	ETF	14.59	14.59	14.59	14.59	400.0
2007-09-21	BSV	ETF	75.83	75.97	75.78	75.96	33500.0
2007-09-21	BTF	ETF	107.2	107.3	106.95	106.95	1600.0
2007-09-21	CBON	ETF	26.5	26.5	25.78	25.95	112653.0
2007-09-21	CDL	ETF	4.39	4.4	4.06	4.25	1418100.0
2007-09-21	CEF	ETF	9.7	9.72	9.6	9.72	583200.0
2007-09-21	CGO	ETF	17.47	17.6099	17.41	17.48	26800.0
2007-09-21	CGW	ETF	25.36	25.36	25.13	25.29	117500.0
2007-09-21	CHB	ETF	10.76	11.17	10.67	11.17	3937300.0
2007-09-21	CHI	ETF	16.76	17.06	16.75	17.02	138400.0
2007-09-21	CHIC	ETF	17.29	17.35	16.67	16.93	468783.0
2007-09-21	CHW	ETF	13.46	13.8	13.39	13.77	135300.0
2007-09-21	CHY	ETF	14.9	15.05	14.8	15.0	139600.0
2007-09-21	CN	ETF	47.9	48.5	47.79	47.84	342400.0
2007-09-21	CNXT	ETF	1.27	1.29	1.23	1.24	6876110.0
2007-09-21	CPST	ETF	1.24	1.24	1.15	1.17	2336492.0
2007-09-21	CSA	ETF	18.45	18.55	17.75	17.98	55700.0
2007-09-21	CSD	ETF	29.08	29.33	29.08	29.25	27100.0
2007-09-21	CSM	ETF	1.455	1.465	1.455	1.465	30000.0
2007-09-21	CSQ	ETF	14.59	14.65	14.45	14.64	282900.0
2007-09-21	CVY	ETF	26.46	26.48	26.37	26.39	10300.0
2007-09-21	CWI	ETF	27.7733	27.9533	27.7533	27.8733	128850.0
2007-09-21	CZA	ETF	26.12	26.1201	26.12	26.1201	300.0
2007-09-21	DBA	ETF	28.74	28.82	28.51	28.77	577900.0
2007-09-21	DBB	ETF	25.74	25.81	25.37	25.57	29200.0
2007-09-21	DBC	ETF	27.59	27.69	27.41	27.69	255500.0
2007-09-21	DBE	ETF	30.94	31.04	30.59	30.76	80000.0
2007-09-21	DBO	ETF	29.47	29.59	29.22	29.59	12200.0
2007-09-21	DBP	ETF	28.35	28.4	27.99	28.18	32500.0
2007-09-21	DBS	ETF	26.48	26.569	26.11	26.49	17600.0

> showing 50 of 499 rows — these rows as CSV

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