PREVIEW / etf_daily / 2007-10-10

all etf daily files

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

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-10	SPY	ETF	156.04	156.44	155.41	156.22	101711100.0
2007-10-10	QQQ	ETF	53.39	53.57	53.21	53.51	91777473.0
2007-10-10	IWM	ETF	84.04	84.23	83.44	84.11	50123200.0
2007-10-10	DIA	ETF	141.39	141.44	140.05	140.73	9729400.0
2007-10-10	GLD	ETF	73.6	73.82	72.63	73.36	4615000.0
2007-10-10	TLT	ETF	87.98	88.43	87.79	88.15	855500.0
2007-10-10	ADRE	ETF	56.71	56.71	55.22	56.27	228968.0
2007-10-10	AGG	ETF	99.46	99.65	99.19	99.57	711600.0
2007-10-10	AIQ	ETF	47.15	47.45	45.95	46.3	36360.0
2007-10-10	AIS	ETF	1.3	1.32	1.28	1.31	135100.0
2007-10-10	ARB	ETF	47.24	47.79	46.81	46.97	143400.0
2007-10-10	BBH	ETF	59.1333	59.3433	58.9067	59.23	94200.0
2007-10-10	BIL	ETF	91.64	91.72	91.64	91.7	21400.0
2007-10-10	BITS	ETF	25.88	26.0	25.56	25.88	7316.0
2007-10-10	BIV	ETF	75.12	75.43	75.12	75.43	9000.0
2007-10-10	BLV	ETF	74.7	74.87	74.6	74.73	5300.0
2007-10-10	BMVP	ETF	17.7233	17.7739	17.658	17.7367	67900.0
2007-10-10	BND	ETF	75.33	75.46	75.29	75.4	69900.0
2007-10-10	BNE	ETF	17.55	17.93	17.52	17.83	119700.0
2007-10-10	BRF	ETF	14.64	14.64	14.64	14.64	1400.0
2007-10-10	BSV	ETF	75.62	75.79	75.61	75.79	28000.0
2007-10-10	BTF	ETF	109.04999999999998	109.74999999999999	109.0	109.74999999999999	620.0
2007-10-10	BWX	ETF	26.145	26.235	26.145	26.15	64600.0
2007-10-10	CBON	ETF	25.5	25.5	25.04	25.35	44816.0
2007-10-10	CDL	ETF	4.38	4.57	4.34	4.51	1814200.0
2007-10-10	CEF	ETF	9.86	9.93	9.84	9.85	361400.0
2007-10-10	CGO	ETF	18.19	18.28	18.1899	18.22	23700.0
2007-10-10	CGW	ETF	26.34	26.34	26.05	26.23	71400.0
2007-10-10	CHB	ETF	12.22	12.34	11.95	12.01	1206000.0
2007-10-10	CHI	ETF	17.1	17.1	16.94	17.09	129900.0
2007-10-10	CHIC	ETF	14.8	14.95	14.47	14.61	850735.0
2007-10-10	CHW	ETF	13.55	13.7	13.4	13.55	107703.0
2007-10-10	CHY	ETF	15.43	15.44	15.3	15.44	88900.0
2007-10-10	CMF	ETF	51.75	51.835	51.75	51.75	12400.0
2007-10-10	CN	ETF	60.08	60.35	59.08	59.39	224200.0
2007-10-10	CNXT	ETF	1.44	1.45	1.38	1.41	8060074.0
2007-10-10	CPST	ETF	1.15	1.15	1.12	1.14	1104184.0
2007-10-10	CSA	ETF	18.63	18.63	18.45	18.57	33600.0
2007-10-10	CSD	ETF	29.95	30.04	29.87	30.04	4500.0
2007-10-10	CSM	ETF	1.465	1.465	1.4625	1.4625	16000.0
2007-10-10	CSQ	ETF	14.74	14.9	14.69	14.9	324600.0
2007-10-10	CVY	ETF	26.7	26.7	26.63	26.67	11400.0
2007-10-10	CWI	ETF	29.1467	29.22	29.0533	29.1933	120600.0
2007-10-10	CZA	ETF	27.34	27.34	27.19	27.19	1800.0
2007-10-10	DBA	ETF	28.48	28.48	28.08	28.37	317100.0
2007-10-10	DBB	ETF	26.33	26.67	26.3	26.58	56400.0
2007-10-10	DBC	ETF	27.51	27.69	27.35	27.68	307200.0
2007-10-10	DBE	ETF	30.26	30.58	30.03	30.51	15200.0
2007-10-10	DBO	ETF	29.25	29.62	29.1	29.5	7800.0
2007-10-10	DBP	ETF	28.58	28.64	28.41	28.49	24500.0

> showing 50 of 512 rows — these rows as CSV

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