PREVIEW / etf_daily / 2007-09-28

all etf daily files

  file:    by_date/etf_daily/2007/2007-09-28.parquet
  size:    23 KB
  rows:    494

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-28	SPY	ETF	152.85	153.19	151.98	152.58	133372100.0
2007-09-28	QQQ	ETF	51.54	51.68	51.18	51.41	75545964.0
2007-09-28	IWM	ETF	80.97	81.25	79.93	80.04	90453200.0
2007-09-28	DIA	ETF	138.96	139.1	138.36	138.91	10128400.0
2007-09-28	GLD	ETF	73.19	73.8	72.74	73.51	8837600.0
2007-09-28	TLT	ETF	89.16	89.33	88.22	88.72	1254700.0
2007-09-28	ADRE	ETF	53.64	53.65	52.55	52.81	231518.0
2007-09-28	AGG	ETF	99.98	100.26	99.81	100.02	336100.0
2007-09-28	AIQ	ETF	44.75	45.3	44.1	45.3	31000.0
2007-09-28	AIS	ETF	1.4	1.44	1.38	1.42	169000.0
2007-09-28	ARB	ETF	45.69	45.88	44.9	45.34	266200.0
2007-09-28	BBH	ETF	58.95	58.9667	58.2233	58.5933	355200.0
2007-09-28	BIL	ETF	91.8	91.9	91.8	91.8	122600.0
2007-09-28	BITS	ETF	26.16	26.32	26.0	26.2	4548.0
2007-09-28	BIV	ETF	75.85	75.85	75.5	75.55	14900.0
2007-09-28	BLV	ETF	75.16	75.23	74.55	74.76	18700.0
2007-09-28	BMVP	ETF	17.24	17.28	17.16	17.27	40100.0
2007-09-28	BND	ETF	75.87	75.87	75.56	75.69	129200.0
2007-09-28	BNE	ETF	17.03	17.05	16.66	16.66	125800.0
2007-09-28	BRF	ETF	14.69	14.7	14.6	14.6	8500.0
2007-09-28	BSV	ETF	76.2	76.25	76.1	76.13	164300.0
2007-09-28	BTF	ETF	106.3	106.3	105.64999999999999	105.64999999999999	1900.0
2007-09-28	CBON	ETF	25.47	25.47	24.94	25.14	60898.0
2007-09-28	CDL	ETF	4.14	4.18	4.06	4.16	1190400.0
2007-09-28	CEF	ETF	9.78	9.92	9.77	9.83	733300.0
2007-09-28	CGO	ETF	17.69	17.88	17.69	17.8799	11200.0
2007-09-28	CGW	ETF	26.08	26.1	25.93	26.01	115100.0
2007-09-28	CHB	ETF	11.24	11.27	10.9	10.98	1078600.0
2007-09-28	CHI	ETF	17.34	17.34	17.04	17.2	112400.0
2007-09-28	CHIC	ETF	14.67	14.9625	14.5	14.64	1038817.0
2007-09-28	CHW	ETF	13.23	13.42	13.14	13.19	177800.0
2007-09-28	CHY	ETF	15.35	15.38	15.21	15.34	113800.0
2007-09-28	CN	ETF	54.46	54.46	51.84	52.5	838200.0
2007-09-28	CNXT	ETF	1.2	1.23	1.19	1.2	4101833.0
2007-09-28	CPST	ETF	1.22	1.25	1.19	1.2	1312582.0
2007-09-28	CSA	ETF	18.15	19.0	18.14	18.5	72600.0
2007-09-28	CSD	ETF	29.3	29.3	29.06	29.11	29100.0
2007-09-28	CSM	ETF	1.465	1.47	1.465	1.47	800.0
2007-09-28	CSQ	ETF	14.78	14.94	14.72	14.86	293900.0
2007-09-28	CVY	ETF	26.01	26.01	25.89	25.91	39800.0
2007-09-28	CWI	ETF	28.5	28.58	28.4267	28.48	103350.0
2007-09-28	DBA	ETF	29.98	30.05	29.29	29.5	620300.0
2007-09-28	DBB	ETF	26.49	26.49	26.22	26.39	34000.0
2007-09-28	DBC	ETF	28.25	28.27	27.89	28.11	467400.0
2007-09-28	DBE	ETF	30.94	30.99	30.4	30.57	8700.0
2007-09-28	DBO	ETF	29.77	29.77	29.3	29.37	1000.0
2007-09-28	DBP	ETF	28.5	28.7	28.5	28.61	10900.0
2007-09-28	DBS	ETF	26.91	27.2	26.91	27.01	19400.0
2007-09-28	DBV	ETF	28.28	28.45	28.28	28.44	103100.0
2007-09-28	DDM	ETF	8.2292	8.2533	8.1675	8.2192	1933200.0

> showing 50 of 494 rows — these rows as CSV

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