PREVIEW / etf_daily / 2007-07-26

all etf daily files

  file:    by_date/etf_daily/2007/2007-07-26.parquet
  size:    23 KB
  rows:    503

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-26	SPY	ETF	150.19	150.8	146.39	148.02	467592500.0
2007-07-26	QQQ	ETF	49.07	49.47	48.05	48.98	318648472.0
2007-07-26	IWM	ETF	79.21	80.86	77.55	78.54	244724700.0
2007-07-26	DIA	ETF	136.55	137.14	131.14	134.71	46788100.0
2007-07-26	GLD	ETF	66.46	66.8	64.73	65.65	10704100.0
2007-07-26	TLT	ETF	86.74	87.46	86.65	87.03	2866400.0
2007-07-26	ADRE	ETF	47.75	47.79	44.1	45.99	1198339.0
2007-07-26	AGG	ETF	98.57	99.0	98.55	98.83	324600.0
2007-07-26	AIQ	ETF	49.0	49.0	45.9	46.8	82160.0
2007-07-26	AIS	ETF	1.67	1.72	1.62	1.65	148000.0
2007-07-26	ARB	ETF	50.25	50.59	49.39	49.9	497700.0
2007-07-26	BBH	ETF	56.3333	57.2	56.1533	56.74	1048200.0
2007-07-26	BIL	ETF	91.86	91.9	91.8	91.88	41050.0
2007-07-26	BITS	ETF	26.28	26.61	25.88	26.0	14644.0
2007-07-26	BIV	ETF	74.48	74.72	74.4	74.65	14900.0
2007-07-26	BLV	ETF	73.84	74.21	73.76	73.95	19900.0
2007-07-26	BMVP	ETF	17.4433	17.5033	17.07	17.2333	201350.0
2007-07-26	BND	ETF	74.65	74.71	74.49	74.71	51500.0
2007-07-26	BNE	ETF	18.76	18.94	18.04	18.17	221800.0
2007-07-26	BRF	ETF	14.48	14.51	14.48	14.51	6800.0
2007-07-26	BSV	ETF	75.35	75.43	75.16	75.35	51100.0
2007-07-26	BTF	ETF	105.95	105.95	103.45	103.45	1520.0
2007-07-26	CBON	ETF	24.09	24.33	23.45	23.8	139940.0
2007-07-26	CDL	ETF	5.7	5.7	5.0	5.38	6964117.0
2007-07-26	CEF	ETF	9.38	9.4	9.15	9.26	373600.0
2007-07-26	CGO	ETF	17.78	17.84	17.19	17.7016	51300.0
2007-07-26	CGW	ETF	25.4	25.5	24.67	24.92	255900.0
2007-07-26	CHB	ETF	11.8	12.24	11.47	11.73	3086806.0
2007-07-26	CHI	ETF	16.56	16.8648	15.98	16.86	455300.0
2007-07-26	CHIC	ETF	20.51	21.85	18.81	19.3	2771081.0
2007-07-26	CHW	ETF	15.0	15.01	15.0	15.0	1399100.0
2007-07-26	CHY	ETF	14.26	14.63	14.11	14.62	478800.0
2007-07-26	CN	ETF	52.41	52.74	49.3	50.13	414700.0
2007-07-26	CNXT	ETF	1.39	1.4	1.31	1.31	9256925.0
2007-07-26	CPST	ETF	1.21	1.25	1.09	1.15	3893684.0
2007-07-26	CSA	ETF	17.46	17.65	17.06	17.39	39700.0
2007-07-26	CSD	ETF	29.71	29.83	29.06	29.43	97900.0
2007-07-26	CSQ	ETF	14.31	14.45	13.74	14.44	619900.0
2007-07-26	CTEC	ETF	103.94999999999999	105.74999999999999	99.39999999999999	102.85	22481.0
2007-07-26	CVY	ETF	26.7	26.7	26.08	26.39	86300.0
2007-07-26	CWI	ETF	27.2667	27.2733	26.54	26.8533	63750.0
2007-07-26	CZA	ETF	26.55	26.55	26.08	26.19	23700.0
2007-07-26	DBA	ETF	26.31	26.43	26.03	26.12	241900.0
2007-07-26	DBB	ETF	27.55	27.71	27.28	27.54	28000.0
2007-07-26	DBC	ETF	26.32	26.3999	25.82	26.03	227400.0
2007-07-26	DBE	ETF	29.43	29.55	28.33	29.02	19300.0
2007-07-26	DBO	ETF	27.98	28.25	27.19	27.19	10100.0
2007-07-26	DBP	ETF	26.08	26.17	25.5	25.82	13300.0
2007-07-26	DBS	ETF	25.37	25.5201	24.96	25.13	42800.0
2007-07-26	DBV	ETF	29.49	29.5	29.07	29.17	308100.0

> showing 50 of 503 rows — these rows as CSV

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