PREVIEW / etf_daily / 2007-10-05

all etf daily files

  file:    by_date/etf_daily/2007/2007-10-05.parquet
  size:    23 KB
  rows:    510

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-10-05	SPY	ETF	155.03	156.1	154.63	155.85	134579700.0
2007-10-05	QQQ	ETF	52.17	52.9	52.06	52.818	115677118.0
2007-10-05	IWM	ETF	83.47	84.42	82.98	84.13	92101800.0
2007-10-05	DIA	ETF	140.43	141.21	140.14	140.68	9357800.0
2007-10-05	GLD	ETF	72.8	73.64	71.88	73.4	10597200.0
2007-10-05	TLT	ETF	88.31	88.44	87.71	88.28	2184700.0
2007-10-05	ADRE	ETF	54.75	55.82	54.57	55.51	294300.0
2007-10-05	AGG	ETF	99.32	99.65	98.24	98.87	750200.0
2007-10-05	AIQ	ETF	46.5	48.85	46.05	48.7	33440.0
2007-10-05	AIS	ETF	1.39	1.39	1.33	1.36	468600.0
2007-10-05	ARB	ETF	46.0	46.76	45.94	46.4	293100.0
2007-10-05	BBH	ETF	58.7	59.69	58.5367	59.53	307200.0
2007-10-05	BIL	ETF	91.58	91.7	91.54	91.54	22200.0
2007-10-05	BITS	ETF	25.76	26.88	25.2	26.68	8442.0
2007-10-05	BIV	ETF	75.28	75.77	75.07	75.26	16300.0
2007-10-05	BLV	ETF	74.68	74.72	74.3	74.65	49400.0
2007-10-05	BMVP	ETF	17.5167	17.6987	17.4963	17.6233	36700.0
2007-10-05	BND	ETF	75.4	75.43	75.25	75.35	80500.0
2007-10-05	BNE	ETF	17.37	18.03	17.29	17.97	388500.0
2007-10-05	BRF	ETF	14.67	14.68	14.61	14.63	16900.0
2007-10-05	BSV	ETF	75.76	75.79	75.7	75.78	55500.0
2007-10-05	BTF	ETF	108.69999999999999	109.1	107.94999999999999	109.1	2480.0
2007-10-05	BWX	ETF	25.85	25.975	25.85	25.95	12000.0
2007-10-05	CBON	ETF	25.53	26.66	25.5	26.02	137969.0
2007-10-05	CDL	ETF	4.09	4.19	4.0	4.15	1831100.0
2007-10-05	CEF	ETF	9.71	9.92	9.7	9.85	496200.0
2007-10-05	CGO	ETF	18.49	18.49	17.95	18.11	26200.0
2007-10-05	CGW	ETF	26.05	26.28	26.0001	26.21	40100.0
2007-10-05	CHB	ETF	12.4	12.66	12.21	12.59	1729700.0
2007-10-05	CHI	ETF	16.96	17.1	16.96	17.07	161800.0
2007-10-05	CHIC	ETF	14.25	15.01	14.25	14.93	1334681.0
2007-10-05	CHW	ETF	13.74	13.87	13.58	13.62	176800.0
2007-10-05	CHY	ETF	15.5	15.53	15.35	15.44	138700.0
2007-10-05	CMF	ETF	51.855	51.885	51.855	51.885	6600.0
2007-10-05	CN	ETF	58.74	61.3	58.74	60.41	488700.0
2007-10-05	CNXT	ETF	1.37	1.43	1.36	1.43	15640748.0
2007-10-05	CPI	ETF	23.7	23.7001	23.2	23.5	3100.0
2007-10-05	CPST	ETF	1.15	1.2	1.15	1.18	1899669.0
2007-10-05	CSA	ETF	18.65	18.83	18.65	18.8	41900.0
2007-10-05	CSD	ETF	29.59	30.0	29.59	29.84	213600.0
2007-10-05	CSM	ETF	1.4625	1.4625	1.4625	1.4625	2400.0
2007-10-05	CSQ	ETF	14.72	14.81	14.71	14.78	216100.0
2007-10-05	CVY	ETF	26.62	26.87	26.62	26.83	18800.0
2007-10-05	CWI	ETF	28.9533	29.24	28.9533	29.18	72300.0
2007-10-05	CZA	ETF	26.98	27.12	26.9799	27.12	2700.0
2007-10-05	DBA	ETF	28.46	28.47	28.2	28.42	148300.0
2007-10-05	DBB	ETF	26.46	26.46	26.29	26.4	16900.0
2007-10-05	DBC	ETF	27.54	27.76	27.45	27.75	167800.0
2007-10-05	DBE	ETF	30.62	30.69	30.4	30.61	6300.0
2007-10-05	DBO	ETF	29.3	29.48	29.06	29.47	3800.0

> showing 50 of 510 rows — these rows as CSV

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