PREVIEW / etf_daily / 2007-05-18

all etf daily files

  file:    by_date/etf_daily/2007/2007-05-18.parquet
  size:    22 KB
  rows:    481

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-18	SPY	ETF	152.01	152.62	151.81	152.62	99182000.0
2007-05-18	QQQ	ETF	46.48	46.71	46.38	46.71	104992456.0
2007-05-18	IWM	ETF	81.19	82.05	80.78	81.73	80552700.0
2007-05-18	DIA	ETF	135.08	135.5	135.0	135.5	9481600.0
2007-05-18	GLD	ETF	65.07	65.67	64.85	65.52	3158200.0
2007-05-18	TLT	ETF	87.35	87.5	86.88	86.93	856500.0
2007-05-18	AAA	ETF	25.71	26.36	25.61	26.09	69400.0
2007-05-18	ADRE	ETF	43.62	43.85	43.436	43.77	155587.0
2007-05-18	AGG	ETF	99.68	99.74	99.41	99.45	431900.0
2007-05-18	AIQ	ETF	42.2	42.7	41.45	42.5	35600.0
2007-05-18	AIS	ETF	1.82	1.85	1.79	1.8	378100.0
2007-05-18	ARB	ETF	48.83	49.66	48.78	49.62	201100.0
2007-05-18	BBH	ETF	58.9733	59.2833	58.8833	59.0333	654900.0
2007-05-18	BITS	ETF	30.08	30.52	30.0	30.2	7736.0
2007-05-18	BIV	ETF	74.94	74.98	74.77	74.8	25300.0
2007-05-18	BLV	ETF	74.84	74.95	74.55	74.61	19800.0
2007-05-18	BMVP	ETF	18.04	18.1633	18.04	18.1536	30500.0
2007-05-18	BND	ETF	75.08	75.08	74.93	74.94	62200.0
2007-05-18	BNE	ETF	19.17	19.51	18.98	19.39	405600.0
2007-05-18	BRF	ETF	14.51	14.5297	14.51	14.51	10100.0
2007-05-18	BSV	ETF	75.15	75.2	73.68	75.06	71900.0
2007-05-18	BTF	ETF	111.75	111.85	111.6	111.85	420.0
2007-05-18	CBON	ETF	29.79	29.9	29.18	29.57	86799.0
2007-05-18	CDL	ETF	8.15	8.37	8.1	8.35	1837900.0
2007-05-18	CEF	ETF	9.02	9.2	9.02	9.18	224400.0
2007-05-18	CGO	ETF	18.1	18.32	18.06	18.25	24500.0
2007-05-18	CGW	ETF	24.76	25.1	24.76	25.0	770900.0
2007-05-18	CHB	ETF	11.33	11.4	11.04	11.21	1944270.0
2007-05-18	CHI	ETF	20.17	20.18	20.1	20.16	79900.0
2007-05-18	CHIC	ETF	25.84	26.6	25.78	26.52	683366.0
2007-05-18	CHY	ETF	17.15	17.19	17.15	17.17	102300.0
2007-05-18	CIL	ETF	26.07	26.07	25.93	25.93	200.0
2007-05-18	CN	ETF	51.55	52.1	50.92	51.56	119500.0
2007-05-18	CNXT	ETF	1.36	1.39	1.34	1.37	8116624.0
2007-05-18	CPI	ETF	23.6	23.6	23.6	23.6	500.0
2007-05-18	CPST	ETF	0.91	0.91	0.89	0.9	824283.0
2007-05-18	CSA	ETF	20.2	20.22	19.67	19.76	32000.0
2007-05-18	CSB	ETF	32.06	32.16	32.0	32.14	36100.0
2007-05-18	CSD	ETF	29.36	29.59	29.36	29.59	13100.0
2007-05-18	CSQ	ETF	15.59	15.7	15.59	15.7	355200.0
2007-05-18	CTEC	ETF	86.64999999999999	88.55	85.89999999999999	87.5	8286.2
2007-05-18	CVY	ETF	28.06	28.09	28.03	28.05	21200.0
2007-05-18	CWI	ETF	26.9333	27.0333	26.9133	27.0333	88800.0
2007-05-18	CZA	ETF	26.67	26.67	26.67	26.67	1000.0
2007-05-18	DBA	ETF	25.16	25.25	24.81	24.88	144200.0
2007-05-18	DBB	ETF	26.61	27.12	26.52	27.03	36000.0
2007-05-18	DBC	ETF	25.49	25.55	25.33	25.43	186600.0
2007-05-18	DBE	ETF	28.45	28.61	28.35	28.45	19600.0
2007-05-18	DBO	ETF	26.5	26.58	26.4	26.51	4500.0
2007-05-18	DBP	ETF	25.84	26.06	25.82	25.94	3400.0

> showing 50 of 481 rows — these rows as CSV

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