PREVIEW / etf_daily / 2007-09-07

all etf daily files

  file:    by_date/etf_daily/2007/2007-09-07.parquet
  size:    23 KB
  rows:    497

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-07	SPY	ETF	146.48	146.89	145.26	146.07	235447600.0
2007-09-07	QQQ	ETF	48.53	48.6	47.95	48.23	152437976.0
2007-09-07	IWM	ETF	77.77	77.93	76.99	77.73	107970400.0
2007-09-07	DIA	ETF	132.37	132.42	130.83	131.52	18245400.0
2007-09-07	GLD	ETF	69.26	70.0	69.0	69.39	14960000.0
2007-09-07	TLT	ETF	89.75	90.5	89.69	90.3	2852200.0
2007-09-07	ADRE	ETF	46.48	46.74	45.67	46.02	442763.0
2007-09-07	AGG	ETF	99.93	100.23	99.75	100.2	353400.0
2007-09-07	AIQ	ETF	44.1	44.4	43.1	43.35	22640.0
2007-09-07	AIS	ETF	1.4	1.41	1.38	1.38	77500.0
2007-09-07	ARB	ETF	48.05	48.44	47.47	47.98	247300.0
2007-09-07	BBH	ETF	56.7333	57.1567	56.6233	56.74	550800.0
2007-09-07	BIL	ETF	91.72	91.74	91.64	91.72	16150.0
2007-09-07	BITS	ETF	26.32	26.84	26.16	26.24	8098.0
2007-09-07	BIV	ETF	76.0	76.03	75.77	75.89	21900.0
2007-09-07	BLV	ETF	75.24	75.65	75.14	75.54	30700.0
2007-09-07	BMVP	ETF	16.6767	16.71	16.51	16.56	104700.0
2007-09-07	BND	ETF	75.78	75.87	75.57	75.81	45700.0
2007-09-07	BNE	ETF	17.03	17.07	16.39	16.42	245500.0
2007-09-07	BRF	ETF	14.56	14.63	14.56	14.62	23100.0
2007-09-07	BSV	ETF	75.87	76.07	75.87	76.01	38000.0
2007-09-07	BTF	ETF	105.19999999999999	105.19999999999999	104.3505	104.45	280.0
2007-09-07	CBON	ETF	24.53	24.53	23.92	24.37	53850.0
2007-09-07	CDL	ETF	4.07	4.21	4.03	4.16	3233300.0
2007-09-07	CEF	ETF	9.55	9.57	9.44	9.47	398200.0
2007-09-07	CGO	ETF	16.85	16.95	16.81	16.9	12200.0
2007-09-07	CGW	ETF	24.1	24.3	24.0101	24.2	57500.0
2007-09-07	CHB	ETF	10.72	10.79	10.32	10.43	2102900.0
2007-09-07	CHI	ETF	17.35	17.5	17.25	17.41	158600.0
2007-09-07	CHIC	ETF	16.91	16.91	16.58	16.75	524342.0
2007-09-07	CHW	ETF	13.95	14.04	13.66	13.97	139600.0
2007-09-07	CHY	ETF	14.98	14.98	14.7	14.92	141300.0
2007-09-07	CN	ETF	47.62	47.9	46.64	46.96	194800.0
2007-09-07	CNXT	ETF	1.29	1.38	1.28	1.38	9461910.0
2007-09-07	CPST	ETF	1.2	1.24	1.16	1.19	1850186.0
2007-09-07	CSA	ETF	18.06	18.25	17.67	17.8	38900.0
2007-09-07	CSD	ETF	28.62	28.66	28.46	28.49	9500.0
2007-09-07	CSM	ETF	1.45	1.45	1.4475	1.45	38400.0
2007-09-07	CSQ	ETF	14.23	14.23	14.06	14.16	254100.0
2007-09-07	CTEC	ETF	104.39999999999999	105.25	101.99999999999999	103.55	19428.8
2007-09-07	CVY	ETF	25.67	25.74	25.58	25.63	18300.0
2007-09-07	CWI	ETF	26.38	26.4933	26.2267	26.32	41850.0
2007-09-07	DBA	ETF	26.72	27.07	26.51	27.0	170900.0
2007-09-07	DBB	ETF	24.59	24.63	24.2	24.52	27900.0
2007-09-07	DBC	ETF	25.99	26.11	25.88	26.1	149200.0
2007-09-07	DBE	ETF	28.73	28.98	28.58	28.92	56100.0
2007-09-07	DBO	ETF	27.15	27.33	27.1	27.33	8900.0
2007-09-07	DBP	ETF	27.0	27.11	26.82	26.9	7000.0
2007-09-07	DBS	ETF	24.77	24.77	24.4305	24.55	12000.0
2007-09-07	DBV	ETF	27.48	27.48	27.05	27.22	136900.0

> showing 50 of 497 rows — these rows as CSV

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