PREVIEW / etf_daily / 2007-05-08

all etf daily files

  file:    by_date/etf_daily/2007/2007-05-08.parquet
  size:    21 KB
  rows:    457

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-08	SPY	ETF	150.58	150.92	150.13	150.75	80584000.0
2007-05-08	QQQ	ETF	46.47	46.77	46.3	46.73	95196932.0
2007-05-08	IWM	ETF	82.19	82.62	81.54	82.29	59329800.0
2007-05-08	DIA	ETF	132.69	133.22	132.35	133.12	9462600.0
2007-05-08	GLD	ETF	67.95	68.02	67.53	67.88	2475300.0
2007-05-08	TLT	ETF	89.01	89.01	88.64	88.64	488400.0
2007-05-08	AAA	ETF	69.96	72.0	68.29	71.73	93900.0
2007-05-08	ADRE	ETF	42.15	42.15	41.45	41.92	218660.0
2007-05-08	AGG	ETF	100.19	100.2	100.02	100.06	291000.0
2007-05-08	AIQ	ETF	43.65	44.85	43.65	44.8	32940.0
2007-05-08	AIS	ETF	1.71	1.72	1.63	1.71	447800.0
2007-05-08	ARB	ETF	48.78	48.78	47.96	48.69	180802.0
2007-05-08	BAB	ETF	99.9	100.28	99.39	100.15	34300.0
2007-05-08	BBH	ETF	62.3333	62.3933	62.0267	62.3133	465000.0
2007-05-08	BITS	ETF	34.04	34.216	32.6	32.64	24955.0
2007-05-08	BIV	ETF	75.39	75.52	75.39	75.42	13400.0
2007-05-08	BLV	ETF	75.83	75.92	75.8	75.81	4600.0
2007-05-08	BMVP	ETF	17.95	18.01	17.91	18.0	44500.0
2007-05-08	BND	ETF	75.48	75.49	75.33	75.4	34000.0
2007-05-08	BNE	ETF	16.69	16.69	16.41	16.59	156100.0
2007-05-08	BOSS	ETF	50.15	50.15	49.29	49.29	100.0
2007-05-08	BRF	ETF	14.54	14.56	14.51	14.55	9300.0
2007-05-08	BSV	ETF	75.28	75.32	75.23	75.26	26600.0
2007-05-08	BTF	ETF	112.5	112.69999999999999	112.24999999999999	112.24999999999999	1220.0
2007-05-08	CBON	ETF	30.61	31.0	30.53	30.9	38252.0
2007-05-08	CDL	ETF	9.05	9.05	8.9	8.91	164900.0
2007-05-08	CEF	ETF	9.4	9.48	9.32	9.47	417100.0
2007-05-08	CGO	ETF	17.8	17.99	17.75	17.99	17700.0
2007-05-08	CHB	ETF	10.59	10.61	10.27	10.6	1063200.0
2007-05-08	CHI	ETF	20.39	20.49	20.34	20.47	73700.0
2007-05-08	CHIC	ETF	26.89	26.98	26.1	26.39	568897.0
2007-05-08	CHY	ETF	17.17	17.26	17.16	17.26	104700.0
2007-05-08	CIL	ETF	25.88	25.88	25.86	25.86	400.0
2007-05-08	CN	ETF	49.5	49.5	48.47	49.02	62100.0
2007-05-08	CNXT	ETF	1.5	1.54	1.48	1.54	7372666.0
2007-05-08	CPST	ETF	0.96	0.96	0.9104	0.93	3330988.0
2007-05-08	CSA	ETF	20.83	21.05	20.83	21.0	14600.0
2007-05-08	CSB	ETF	31.52	31.57	31.3	31.45	29000.0
2007-05-08	CSD	ETF	29.12	29.31	28.98	29.31	48700.0
2007-05-08	CSQ	ETF	15.45	15.57	15.42	15.57	342000.0
2007-05-08	CTEC	ETF	91.6	91.64999999999999	89.89999999999999	90.7	8197.2
2007-05-08	CVY	ETF	27.99	27.99	27.87	27.93	9900.0
2007-05-08	CWI	ETF	26.7667	26.7667	26.56	26.7533	91350.0
2007-05-08	CZA	ETF	26.46	26.46	26.3999	26.43	1800.0
2007-05-08	DBA	ETF	24.94	25.04	24.78	24.83	334500.0
2007-05-08	DBB	ETF	28.85	29.02	28.51	28.85	276400.0
2007-05-08	DBC	ETF	25.06	25.21	25.0	25.21	189100.0
2007-05-08	DBE	ETF	27.26	27.58	27.21	27.49	29000.0
2007-05-08	DBO	ETF	25.82	25.96	25.65	25.9	13400.0
2007-05-08	DBP	ETF	26.98	27.02	26.85	26.93	10700.0

> showing 50 of 457 rows — these rows as CSV

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