PREVIEW / etf_daily / 2007-07-13

all etf daily files

  file:    by_date/etf_daily/2007/2007-07-13.parquet
  size:    22 KB
  rows:    487

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-13	SPY	ETF	154.57	155.46	154.39	154.85	111794300.0
2007-07-13	QQQ	ETF	49.62	49.97	49.5699	49.9	74232103.0
2007-07-13	IWM	ETF	84.9	85.2	84.63	84.9	43138400.0
2007-07-13	DIA	ETF	138.47	139.3	138.41	138.91	8507800.0
2007-07-13	GLD	ETF	66.08	66.23	65.67	66.03	3817800.0
2007-07-13	TLT	ETF	84.45	84.55	83.94	84.26	725900.0
2007-07-13	ADRE	ETF	49.41	49.61	49.16	49.47	180293.0
2007-07-13	AGG	ETF	97.98	98.0	97.7	97.9	247600.0
2007-07-13	AIQ	ETF	52.0	52.0	50.1	51.5	26460.0
2007-07-13	AIS	ETF	1.73	1.74	1.68	1.69	230500.0
2007-07-13	ARB	ETF	53.98	54.62	53.67	54.0	227800.0
2007-07-13	BBH	ETF	56.6667	56.9467	56.4	56.7933	934500.0
2007-07-13	BIL	ETF	91.72	91.74	91.7	91.74	13050.0
2007-07-13	BITS	ETF	27.4	28.8	27.3604	28.76	25029.0
2007-07-13	BIV	ETF	73.43	73.45	73.17	73.36	7700.0
2007-07-13	BLV	ETF	72.55	72.59	72.1	72.49	13100.0
2007-07-13	BMVP	ETF	18.31	18.42	18.31	18.38	30100.0
2007-07-13	BND	ETF	73.9	73.98	73.73	73.93	86400.0
2007-07-13	BNE	ETF	19.97	20.05	19.73	19.75	111200.0
2007-07-13	BRF	ETF	14.45	14.48	14.45	14.46	12700.0
2007-07-13	BSV	ETF	74.8	74.8	74.7	74.72	16300.0
2007-07-13	BTF	ETF	109.64999999999999	109.64999999999999	108.904	109.19999999999999	540.0
2007-07-13	CBON	ETF	27.63	27.89	27.38	27.45	52508.0
2007-07-13	CDL	ETF	6.25	6.3	6.15	6.2	2063657.0
2007-07-13	CEF	ETF	9.36	9.39	9.32	9.37	145300.0
2007-07-13	CGO	ETF	18.24	18.57	18.24	18.57	26500.0
2007-07-13	CGW	ETF	26.39	26.45	26.16	26.34	129300.0
2007-07-13	CHB	ETF	9.65	10.04	9.48	9.69	3127200.0
2007-07-13	CHI	ETF	18.93	18.9799	18.23	18.38	350100.0
2007-07-13	CHIC	ETF	24.67	24.77	24.16	24.27	415506.0
2007-07-13	CHY	ETF	15.94	15.95	15.75	15.8876	190300.0
2007-07-13	CN	ETF	55.58	56.38	55.57	56.11	70000.0
2007-07-13	CNXT	ETF	1.53	1.57	1.48	1.5	12901535.0
2007-07-13	CPI	ETF	23.7	23.72	23.7	23.72	1700.0
2007-07-13	CPST	ETF	1.43	1.43	1.31	1.32	5223130.0
2007-07-13	CSA	ETF	18.75	18.75	18.31	18.7	25000.0
2007-07-13	CSB	ETF	32.82	32.9	32.51	32.58	90000.0
2007-07-13	CSD	ETF	31.4	31.52	31.38	31.46	50200.0
2007-07-13	CSQ	ETF	15.27	15.41	15.23	15.34	257300.0
2007-07-13	CTEC	ETF	109.89999999999999	110.64999999999999	109.39999999999999	110.25	10651.6
2007-07-13	CVY	ETF	27.95	28.09	27.94	28.06	24700.0
2007-07-13	CWI	ETF	28.5067	28.6133	28.4533	28.5667	28500.0
2007-07-13	CZA	ETF	27.79	27.79	27.79	27.79	100.0
2007-07-13	DBA	ETF	27.6	27.68	27.33	27.57	190900.0
2007-07-13	DBB	ETF	27.48	27.76	27.45	27.76	13800.0
2007-07-13	DBC	ETF	26.61	26.65	26.48	26.65	168200.0
2007-07-13	DBE	ETF	29.6	29.64	29.49	29.6	19400.0
2007-07-13	DBO	ETF	27.57	27.75	27.5	27.75	19400.0
2007-07-13	DBP	ETF	26.2	26.2	26.0	26.15	14200.0
2007-07-13	DBS	ETF	25.77	25.82	25.56	25.66	10300.0

> showing 50 of 487 rows — these rows as CSV

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