PREVIEW / etf_daily / 2007-07-02

all etf daily files

  file:    by_date/etf_daily/2007/2007-07-02.parquet
  size:    22 KB
  rows:    488

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-07-02	SPY	ETF	150.87	151.92	150.77	151.79	103357000.0
2007-07-02	QQQ	ETF	47.71	48.048	47.68	48.01	80926013.0
2007-07-02	IWM	ETF	83.38	84.09	83.25	83.97	56318400.0
2007-07-02	DIA	ETF	134.42	135.37	134.38	135.27	8861200.0
2007-07-02	GLD	ETF	64.51	65.23	64.51	65.02	2706200.0
2007-07-02	TLT	ETF	84.81	85.37	84.81	85.29	2811700.0
2007-07-02	ADRE	ETF	45.8	46.29	45.62	46.22	114195.0
2007-07-02	AGG	ETF	97.96	98.36	97.96	98.2	2726200.0
2007-07-02	AIQ	ETF	47.35	51.4	46.9	51.25	91940.0
2007-07-02	AIS	ETF	1.58	1.66	1.56	1.66	595000.0
2007-07-02	ARB	ETF	51.78	52.3	51.475	52.03	232100.0
2007-07-02	BBH	ETF	56.4633	56.6567	56.3533	56.62	676200.0
2007-07-02	BIL	ETF	91.62	91.7	91.6	91.62	13050.0
2007-07-02	BITS	ETF	27.792	27.96	26.48	26.6	35693.0
2007-07-02	BIV	ETF	73.7	73.81	73.69	73.81	5900.0
2007-07-02	BLV	ETF	72.86	73.22	72.85	73.19	11300.0
2007-07-02	BMVP	ETF	17.9	18.0272	17.9	18.0233	41700.0
2007-07-02	BND	ETF	74.1	74.25	73.98	74.23	74900.0
2007-07-02	BNE	ETF	19.52	19.7	19.45	19.66	187000.0
2007-07-02	BRF	ETF	14.55	14.55	14.5	14.5	1400.0
2007-07-02	BSV	ETF	74.76	74.82	74.73	74.82	15200.0
2007-07-02	BTF	ETF	106.99949999999998	109.49999999999999	106.64999999999999	107.654	3200.0
2007-07-02	CBON	ETF	28.28	28.34	27.76	28.16	70749.0
2007-07-02	CDL	ETF	6.49	6.51	6.35	6.41	4062713.0
2007-07-02	CEF	ETF	9.14	9.19	9.12	9.16	125200.0
2007-07-02	CGO	ETF	17.88	18.24	17.88	18.24	14300.0
2007-07-02	CGW	ETF	25.65	25.92	25.6	25.85	118900.0
2007-07-02	CHB	ETF	10.03	10.26	9.85	10.07	1339100.0
2007-07-02	CHI	ETF	19.4	19.46	19.2	19.3	88000.0
2007-07-02	CHIC	ETF	27.08	27.14	26.08	26.14	622636.0
2007-07-02	CHY	ETF	16.25	16.32	16.21	16.24	80500.0
2007-07-02	CN	ETF	56.15	56.95	56.0	56.75	141300.0
2007-07-02	CNXT	ETF	1.4	1.42	1.36	1.38	6679143.0
2007-07-02	CPI	ETF	24.05	24.05	23.75	23.85	1200.0
2007-07-02	CPST	ETF	1.06	1.09	1.06	1.09	1395487.0
2007-07-02	CSA	ETF	20.4	20.89	20.4	20.41	24600.0
2007-07-02	CSB	ETF	32.85	32.9	32.6	32.78	160800.0
2007-07-02	CSD	ETF	30.72	31.02	30.72	30.99	22300.0
2007-07-02	CSM	ETF	1.43	1.43	1.395	1.43	22000.0
2007-07-02	CSQ	ETF	15.11	15.26	15.11	15.25	206700.0
2007-07-02	CTEC	ETF	109.8	111.8	106.85	111.3	48602.0
2007-07-02	CVY	ETF	27.67	27.85	27.67	27.85	15700.0
2007-07-02	CWI	ETF	27.4533	27.72	27.4533	27.72	9300.0
2007-07-02	DBA	ETF	26.81	27.3	25.85	26.31	270000.0
2007-07-02	DBB	ETF	26.86	27.17	26.86	27.14	30700.0
2007-07-02	DBC	ETF	26.05	26.05	25.56	25.86	810100.0
2007-07-02	DBE	ETF	28.84	29.12	28.61	29.04	21800.0
2007-07-02	DBO	ETF	27.01	27.4	26.96	27.31	30400.0
2007-07-02	DBP	ETF	25.65	25.71	25.64	25.71	4100.0
2007-07-02	DBS	ETF	24.77	24.93	24.71	24.93	9200.0

> showing 50 of 488 rows — these rows as CSV

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