PREVIEW / etf_daily / 2007-09-26

all etf daily files

  file:    by_date/etf_daily/2007/2007-09-26.parquet
  size:    23 KB
  rows:    508

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-26	SPY	ETF	152.25	152.77	151.39	152.19	135547000.0
2007-09-26	QQQ	ETF	51.36	51.51	51.12	51.32	96124510.0
2007-09-26	IWM	ETF	80.5	80.92	79.82	80.52	65425300.0
2007-09-26	DIA	ETF	138.36	139.01	138.04	138.53	8384000.0
2007-09-26	GLD	ETF	72.25	72.93	71.85	72.0	9418300.0
2007-09-26	TLT	ETF	87.62	88.13	87.43	87.91	2646400.0
2007-09-26	ADRE	ETF	52.1	52.17	51.57	52.04	230602.0
2007-09-26	AGG	ETF	99.67	99.84	99.45	99.7	702100.0
2007-09-26	AIQ	ETF	44.85	45.2	44.1	44.7	32560.0
2007-09-26	AIS	ETF	1.4	1.44	1.39	1.4	43900.0
2007-09-26	ARB	ETF	45.7	46.9	45.68	46.52	259300.0
2007-09-26	BBH	ETF	58.6667	59.2	58.65	58.9633	413100.0
2007-09-26	BIL	ETF	91.9	91.92	91.82	91.82	21250.0
2007-09-26	BITS	ETF	25.64	26.96	25.64	26.12	5943.0
2007-09-26	BIV	ETF	75.29	75.45	75.15	75.3	10400.0
2007-09-26	BLV	ETF	74.12	74.31	74.11	74.31	2600.0
2007-09-26	BMVP	ETF	17.157	17.208	17.067	17.14	64900.0
2007-09-26	BND	ETF	75.38	75.57	75.34	75.5	173600.0
2007-09-26	BNE	ETF	16.51	16.89	16.46	16.86	198800.0
2007-09-26	BOSS	ETF	47.26	47.73	47.26	47.73	300.0
2007-09-26	BRF	ETF	14.68	14.68	14.6	14.62	2600.0
2007-09-26	BSV	ETF	75.96	76.09	75.9	76.05	55600.0
2007-09-26	BTF	ETF	105.5	106.1	105.35	106.05	1460.0
2007-09-26	CBON	ETF	25.18	25.68	24.42	25.3	22695.0
2007-09-26	CDL	ETF	4.16	4.22	4.11	4.18	2073100.0
2007-09-26	CEF	ETF	9.68	9.75	9.61	9.66	273200.0
2007-09-26	CGO	ETF	17.64	17.75	17.62	17.68	29200.0
2007-09-26	CGW	ETF	25.41	25.7	25.41	25.6	603700.0
2007-09-26	CHB	ETF	11.11	11.11	10.84	11.02	1289600.0
2007-09-26	CHI	ETF	17.31	17.44	17.31	17.35	119900.0
2007-09-26	CHIC	ETF	16.36	16.38	15.53	15.65	483207.0
2007-09-26	CHW	ETF	13.65	13.77	13.21	13.23	147550.0
2007-09-26	CHY	ETF	15.45	15.45	15.3	15.35	126400.0
2007-09-26	CN	ETF	50.76	51.48	50.56	51.25	380600.0
2007-09-26	CNXT	ETF	1.21	1.24	1.21	1.22	4799622.0
2007-09-26	CPI	ETF	23.85	23.85	23.601	23.601	700.0
2007-09-26	CPST	ETF	1.16	1.19	1.14	1.15	1061936.0
2007-09-26	CSA	ETF	18.13	18.13	17.24	17.93	44800.0
2007-09-26	CSD	ETF	28.97	29.15	28.97	29.01	10200.0
2007-09-26	CSQ	ETF	14.76	14.82	14.7	14.78	212600.0
2007-09-26	CVY	ETF	26.07	26.07	25.88	25.95	53400.0
2007-09-26	CWI	ETF	28.0933	28.1133	27.96	28.06	61800.0
2007-09-26	CZA	ETF	26.08	26.18	26.08	26.18	5200.0
2007-09-26	DBA	ETF	28.7	29.08	28.7	29.06	241900.0
2007-09-26	DBB	ETF	26.16	26.34	25.95	26.07	41000.0
2007-09-26	DBC	ETF	27.54	27.6	27.1701	27.48	217500.0
2007-09-26	DBE	ETF	30.44	30.51	29.69	30.06	29700.0
2007-09-26	DBO	ETF	29.0	29.32	28.5	28.84	17300.0
2007-09-26	DBP	ETF	28.21	28.33	27.94	28.04	20500.0
2007-09-26	DBS	ETF	26.41	26.65	26.23	26.2801	6200.0

> showing 50 of 508 rows — these rows as CSV

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