PREVIEW / etf_daily / 2007-05-17

all etf daily files

  file:    by_date/etf_daily/2007/2007-05-17.parquet
  size:    22 KB
  rows:    475

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-17	SPY	ETF	151.38	151.96	151.11	151.3	101132800.0
2007-05-17	QQQ	ETF	46.5	46.57	46.29	46.33	110307918.0
2007-05-17	IWM	ETF	81.3	81.41	80.71	80.78	71780400.0
2007-05-17	DIA	ETF	134.95	135.4	134.71	134.93	12408200.0
2007-05-17	GLD	ETF	65.44	65.6	64.72	65.06	8707000.0
2007-05-17	TLT	ETF	87.6	87.72	87.41	87.51	397000.0
2007-05-17	AAA	ETF	26.28	26.55	26.15	26.36	73900.0
2007-05-17	ADRE	ETF	43.6	43.74	43.16	43.55	161729.0
2007-05-17	AGG	ETF	99.79	99.83	99.67	99.74	212200.0
2007-05-17	AIQ	ETF	43.45	43.45	42.05	42.2	31880.0
2007-05-17	AIS	ETF	1.81	1.85	1.77	1.8	480900.0
2007-05-17	ARB	ETF	48.6	48.9	48.3	48.8	153100.0
2007-05-17	BAB	ETF	99.22	99.87	98.48	99.61	77100.0
2007-05-17	BBH	ETF	59.7	59.85	59.05	59.0633	470100.0
2007-05-17	BITS	ETF	31.2	31.2	29.76	30.0	23768.0
2007-05-17	BIV	ETF	75.05	75.1	74.99	75.01	10500.0
2007-05-17	BLV	ETF	75.04	75.08	74.93	74.94	3900.0
2007-05-17	BMVP	ETF	18.01	18.08	18.0	18.02	33800.0
2007-05-17	BND	ETF	75.16	75.18	75.09	75.12	42700.0
2007-05-17	BNE	ETF	19.01	19.33	18.89	19.17	301500.0
2007-05-17	BRF	ETF	14.51	14.53	14.5	14.51	14700.0
2007-05-17	BSV	ETF	75.2	75.2	75.14	75.14	29800.0
2007-05-17	BTF	ETF	110.8	111.14999999999999	110.8	111.14999999999999	220.0
2007-05-17	CBON	ETF	30.1	30.17	29.69	29.76	59271.0
2007-05-17	CDL	ETF	8.24	8.24	8.12	8.13	550600.0
2007-05-17	CEF	ETF	9.09	9.11	8.91	9.06	517900.0
2007-05-17	CGO	ETF	17.84	18.01	17.84	18.01	26200.0
2007-05-17	CGW	ETF	24.66	24.9	24.66	24.85	430700.0
2007-05-17	CHB	ETF	11.24	11.42	10.95	11.27	2473730.0
2007-05-17	CHI	ETF	20.25	20.3	20.16	20.18	100800.0
2007-05-17	CHIC	ETF	25.69	26.05	25.51	25.72	483752.0
2007-05-17	CHY	ETF	17.15	17.19	17.15	17.15	107300.0
2007-05-17	CN	ETF	49.69	51.07	49.53	50.72	176900.0
2007-05-17	CNXT	ETF	1.38	1.4	1.35	1.35	8562159.0
2007-05-17	CPST	ETF	0.9	0.92	0.89	0.9	908926.0
2007-05-17	CSA	ETF	20.76	20.77	20.2501	20.32	57300.0
2007-05-17	CSB	ETF	32.27	32.27	31.97	32.15	46000.0
2007-05-17	CSD	ETF	29.31	29.37	29.26	29.36	10600.0
2007-05-17	CSM	ETF	1.4	1.4	1.4	1.4	4000.0
2007-05-17	CSQ	ETF	15.56	15.63	15.51	15.63	340100.0
2007-05-17	CTEC	ETF	88.1	89.1	86.25	86.35	10976.2
2007-05-17	CVY	ETF	28.01	28.06	27.89	28.02	25200.0
2007-05-17	CWI	ETF	26.78	26.88	26.72	26.86	14400.0
2007-05-17	CZA	ETF	26.6	26.6	26.6	26.6	300.0
2007-05-17	DBA	ETF	25.3	25.41	25.11	25.13	255000.0
2007-05-17	DBB	ETF	26.52	26.83	25.95	26.83	84000.0
2007-05-17	DBC	ETF	25.26	25.49	25.1941	25.47	197800.0
2007-05-17	DBE	ETF	28.1	28.58	28.08	28.56	14700.0
2007-05-17	DBO	ETF	26.2	26.67	26.2	26.55	13200.0
2007-05-17	DBP	ETF	25.8	25.82	25.67	25.81	14200.0

> showing 50 of 475 rows — these rows as CSV

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