PREVIEW / etf_daily / 2007-05-29

all etf daily files

  file:    by_date/etf_daily/2007/2007-05-29.parquet
  size:    22 KB
  rows:    478

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-05-29	SPY	ETF	151.94	152.5	151.45	152.24	82020000.0
2007-05-29	QQQ	ETF	46.49	46.86	46.41	46.81	99722016.0
2007-05-29	IWM	ETF	82.78	83.39	82.72	83.25	59397200.0
2007-05-29	DIA	ETF	135.17	135.9	134.57	135.22	12177200.0
2007-05-29	GLD	ETF	65.12	65.57	64.94	65.07	3343100.0
2007-05-29	TLT	ETF	86.51	86.57	85.83	86.36	1055700.0
2007-05-29	ADRE	ETF	43.85	43.9	43.19	43.44	284977.0
2007-05-29	AGG	ETF	99.36	99.39	99.15	99.26	222700.0
2007-05-29	AIQ	ETF	41.95	43.25	41.85	41.95	65620.0
2007-05-29	AIS	ETF	1.81	1.81	1.77	1.79	162200.0
2007-05-29	ARB	ETF	50.75	51.46	50.51	51.33	191800.0
2007-05-29	BBH	ETF	59.1167	59.88	59.1167	59.8033	592200.0
2007-05-29	BITS	ETF	33.24	33.92	33.04	33.68	14790.0
2007-05-29	BIV	ETF	74.61	74.61	74.52	74.53	14400.0
2007-05-29	BLV	ETF	74.32	74.32	74.19	74.19	42500.0
2007-05-29	BMVP	ETF	18.13	18.15	18.04	18.1	35000.0
2007-05-29	BND	ETF	74.77	74.8	74.69	74.76	27900.0
2007-05-29	BNE	ETF	19.18	19.26	19.05	19.21	162000.0
2007-05-29	BRF	ETF	14.55	14.55	14.47	14.54	20400.0
2007-05-29	BSV	ETF	75.08	75.12	75.02	75.03	51500.0
2007-05-29	BTF	ETF	109.64999999999999	110.0	109.64999999999999	110.0	620.0
2007-05-29	CBON	ETF	29.76	29.83	29.0	29.31	56935.0
2007-05-29	CDL	ETF	8.7	8.95	8.62	8.79	984100.0
2007-05-29	CEF	ETF	9.05	9.11	9.02	9.02	237500.0
2007-05-29	CGO	ETF	17.92	18.13	17.55	17.85	51700.0
2007-05-29	CGW	ETF	25.15	25.28	25.08	25.1	124700.0
2007-05-29	CHB	ETF	11.22	11.48	11.1	11.27	1478000.0
2007-05-29	CHI	ETF	20.0	20.22	19.95	20.21	107300.0
2007-05-29	CHIC	ETF	26.26	26.62	26.14	26.62	516561.0
2007-05-29	CHY	ETF	17.06	17.35	17.05	17.32	127400.0
2007-05-29	CN	ETF	51.5	51.99	50.9612	51.34	50213.0
2007-05-29	CNXT	ETF	1.3	1.32	1.26	1.27	7610222.0
2007-05-29	CPST	ETF	0.8902	0.92	0.89	0.9199	1057281.0
2007-05-29	CSA	ETF	20.45	20.61	20.45	20.49	53600.0
2007-05-29	CSB	ETF	32.1	32.15	31.9	32.01	20800.0
2007-05-29	CSD	ETF	30.18	30.18	30.0	30.13	23600.0
2007-05-29	CSM	ETF	1.4	1.4	1.4	1.4	400.0
2007-05-29	CSQ	ETF	15.47	15.61	15.47	15.59	259800.0
2007-05-29	CTEC	ETF	85.19999999999999	85.19999999999999	83.94999999999999	84.0	13174.6
2007-05-29	CVY	ETF	28.12	28.21	28.07	28.1	12700.0
2007-05-29	CWI	ETF	27.1	27.1133	26.9333	26.9933	7800.0
2007-05-29	CZA	ETF	26.81	26.83	26.81	26.83	1000.0
2007-05-29	DBA	ETF	25.83	25.89	25.5	25.58	158800.0
2007-05-29	DBB	ETF	26.24	26.76	26.23	26.54	95700.0
2007-05-29	DBC	ETF	25.25	25.37	24.9214	25.04	211600.0
2007-05-29	DBE	ETF	28.26	28.26	27.55	27.81	23000.0
2007-05-29	DBO	ETF	26.31	26.31	25.82	25.88	12900.0
2007-05-29	DBP	ETF	25.98	25.98	25.92	25.92	700.0
2007-05-29	DBS	ETF	25.9501	25.97	25.93	25.9699	1700.0
2007-05-29	DBV	ETF	27.88	27.89	27.81	27.89	139100.0

> showing 50 of 478 rows — these rows as CSV

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