PREVIEW / etf_daily / 2007-09-25

all etf daily files

  file:    by_date/etf_daily/2007/2007-09-25.parquet
  size:    23 KB
  rows:    502

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-25	SPY	ETF	150.81	151.66	150.47	151.39	142289900.0
2007-09-25	QQQ	ETF	50.42	51.07	50.36	51.07	101102118.0
2007-09-25	IWM	ETF	79.64	80.07	79.28	79.82	54940900.0
2007-09-25	DIA	ETF	137.03	137.82	136.83	137.72	13487100.0
2007-09-25	GLD	ETF	71.82	72.59	71.64	72.33	5503500.0
2007-09-25	TLT	ETF	88.5	88.62	87.83	87.83	2513500.0
2007-09-25	ADRE	ETF	51.96	51.96	50.62	51.24	207841.0
2007-09-25	AGG	ETF	99.96	100.01	99.76	99.8	260000.0
2007-09-25	AIQ	ETF	44.55	45.1	44.1	44.55	28500.0
2007-09-25	AIS	ETF	1.41	1.44	1.4	1.41	32800.0
2007-09-25	ARB	ETF	47.0	47.45	45.51	45.63	417900.0
2007-09-25	BBH	ETF	58.7333	59.02	58.4367	58.6333	491400.0
2007-09-25	BIL	ETF	91.8	91.92	91.8	91.92	59000.0
2007-09-25	BITS	ETF	25.84	26.12	25.2	25.64	8678.0
2007-09-25	BIV	ETF	75.51	75.61	75.33	75.33	14600.0
2007-09-25	BLV	ETF	74.8	74.88	74.36	74.36	3000.0
2007-09-25	BMVP	ETF	16.96	17.08	16.93	17.05	78200.0
2007-09-25	BND	ETF	75.68	75.71	75.46	75.48	77500.0
2007-09-25	BNE	ETF	16.81	16.82	16.24	16.5	241800.0
2007-09-25	BRF	ETF	14.6	14.76	14.6	14.6	11900.0
2007-09-25	BSV	ETF	76.12	76.16	75.96	75.96	93200.0
2007-09-25	BTF	ETF	105.05	105.25	104.7	105.1	2140.0
2007-09-25	CBON	ETF	25.02	25.5	25.02	25.06	36491.0
2007-09-25	CDL	ETF	4.24	4.25	4.13	4.14	1470500.0
2007-09-25	CEF	ETF	9.69	9.72	9.6	9.71	435400.0
2007-09-25	CGO	ETF	17.46	17.58	17.36	17.5799	14900.0
2007-09-25	CGW	ETF	25.15	25.27	25.1	25.27	32500.0
2007-09-25	CHB	ETF	11.0	11.27	10.75	11.02	1471600.0
2007-09-25	CHI	ETF	17.02	17.48	17.01	17.37	187700.0
2007-09-25	CHIC	ETF	16.85	16.8724	16.04	16.21	439194.0
2007-09-25	CHW	ETF	13.35	13.69	13.24	13.5	155120.0
2007-09-25	CHY	ETF	15.11	15.49	15.1	15.33	208600.0
2007-09-25	CN	ETF	49.15	50.7	49.1	50.66	346500.0
2007-09-25	CNXT	ETF	1.2	1.25	1.19	1.2	6658666.0
2007-09-25	CPST	ETF	1.16	1.18	1.14	1.14	768128.0
2007-09-25	CSA	ETF	18.17	18.24	17.86	17.97	38700.0
2007-09-25	CSD	ETF	29.01	29.01	28.77	28.86	33800.0
2007-09-25	CSQ	ETF	14.66	14.77	14.65	14.74	352986.0
2007-09-25	CVY	ETF	25.87	25.9	25.83	25.9	29500.0
2007-09-25	CWI	ETF	27.6933	27.8333	27.4	27.8267	37650.0
2007-09-25	CZA	ETF	25.95	25.95	25.95	25.95	200.0
2007-09-25	DBA	ETF	28.77	28.87	28.61	28.76	251900.0
2007-09-25	DBB	ETF	25.72	25.98	25.57	25.88	36900.0
2007-09-25	DBC	ETF	27.31	27.55	27.28	27.44	177500.0
2007-09-25	DBE	ETF	30.35	30.41	30.15	30.28	52400.0
2007-09-25	DBO	ETF	28.9	29.07	28.88	28.93	5600.0
2007-09-25	DBP	ETF	27.89	28.19	27.89	28.15	30200.0
2007-09-25	DBS	ETF	26.2	26.49	26.2	26.47	24200.0
2007-09-25	DBV	ETF	27.78	27.97	27.76	27.94	95400.0
2007-09-25	DDM	ETF	8.0	8.1208	7.9875	8.1208	2977200.0

> showing 50 of 502 rows — these rows as CSV

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