PREVIEW / etf_daily / 2007-09-27

all etf daily files

  file:    by_date/etf_daily/2007/2007-09-27.parquet
  size:    23 KB
  rows:    501

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-27	SPY	ETF	152.91	153.1	152.19	153.09	102713300.0
2007-09-27	QQQ	ETF	51.62	51.65	51.36	51.58	73425170.0
2007-09-27	IWM	ETF	80.93	81.08	80.53	81.0	63248800.0
2007-09-27	DIA	ETF	139.06	139.13	138.55	139.13	8948300.0
2007-09-27	GLD	ETF	72.65	72.8	72.17	72.7	5728200.0
2007-09-27	TLT	ETF	88.24	88.78	88.15	88.52	1802900.0
2007-09-27	ADRE	ETF	53.2	53.24	52.5	53.15	350783.0
2007-09-27	AGG	ETF	99.65	100.0	99.65	99.87	380900.0
2007-09-27	AIQ	ETF	44.95	45.0	44.3	44.9	15600.0
2007-09-27	AIS	ETF	1.4	1.43	1.4	1.41	68900.0
2007-09-27	ARB	ETF	46.57	46.76	45.54	45.74	313400.0
2007-09-27	BBH	ETF	59.26	59.4033	58.6967	58.9333	483600.0
2007-09-27	BIL	ETF	91.92	91.94	91.82	91.84	30100.0
2007-09-27	BITS	ETF	26.32	26.44	25.924	26.12	3079.0
2007-09-27	BIV	ETF	75.39	75.63	75.39	75.61	13800.0
2007-09-27	BLV	ETF	74.5	74.88	74.5	74.88	4100.0
2007-09-27	BMVP	ETF	17.2	17.23	17.14	17.2167	67300.0
2007-09-27	BND	ETF	75.5	75.69	75.49	75.66	36300.0
2007-09-27	BNE	ETF	16.9	17.0	16.63	16.96	133700.0
2007-09-27	BOSS	ETF	47.06	48.85	47.06	48.85	400.0
2007-09-27	BRF	ETF	14.61	14.69	14.61	14.69	400.0
2007-09-27	BSV	ETF	76.03	76.17	76.03	76.12	75900.0
2007-09-27	BTF	ETF	106.3	106.95	105.99999999999999	106.3	1080.0
2007-09-27	CBON	ETF	25.29	25.4	24.95	25.38	74068.0
2007-09-27	CDL	ETF	4.16	4.21	4.1	4.15	1265900.0
2007-09-27	CEF	ETF	9.67	9.75	9.66	9.73	676000.0
2007-09-27	CGO	ETF	17.76	17.85	17.76	17.8001	19100.0
2007-09-27	CGW	ETF	25.96	26.0	25.76	25.95	137055.0
2007-09-27	CHB	ETF	11.09	11.34	10.91	11.29	1192100.0
2007-09-27	CHI	ETF	17.32	17.4	17.29	17.31	74180.0
2007-09-27	CHIC	ETF	15.75	15.81	14.55	14.65	913212.0
2007-09-27	CHW	ETF	13.24	13.45	13.19	13.35	205500.0
2007-09-27	CHY	ETF	15.41	15.45	15.33	15.39	94800.0
2007-09-27	CN	ETF	53.22	55.16	52.92	55.16	1525000.0
2007-09-27	CNXT	ETF	1.22	1.25	1.18	1.21	5617363.0
2007-09-27	CPI	ETF	23.55	23.55	23.55	23.55	100.0
2007-09-27	CPST	ETF	1.19	1.25	1.16	1.2301	2406800.0
2007-09-27	CSA	ETF	18.1	18.165	17.7	18.08	34200.0
2007-09-27	CSD	ETF	29.15	29.22	29.06	29.22	13500.0
2007-09-27	CSM	ETF	1.4625	1.47	1.46	1.47	8800.0
2007-09-27	CSQ	ETF	14.77	14.88	14.7	14.88	261000.0
2007-09-27	CVY	ETF	26.02	26.08	25.96	26.02	12400.0
2007-09-27	CWI	ETF	28.3667	28.46	28.3067	28.44	57750.0
2007-09-27	CZA	ETF	26.33	26.41	26.33	26.41	900.0
2007-09-27	DBA	ETF	30.98	31.16	29.25	29.95	466700.0
2007-09-27	DBB	ETF	26.45	26.51	26.25	26.49	19100.0
2007-09-27	DBC	ETF	28.19	28.2	27.64	28.2	249200.0
2007-09-27	DBE	ETF	30.35	30.94	30.35	30.87	26800.0
2007-09-27	DBO	ETF	29.15	29.57	29.14	29.57	2000.0
2007-09-27	DBP	ETF	28.3	28.31	28.05	28.26	16600.0

> showing 50 of 501 rows — these rows as CSV

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