PREVIEW / etf_daily / 2007-05-04

all etf daily files

  file:    by_date/etf_daily/2007/2007-05-04.parquet
  size:    21 KB
  rows:    454

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-04	SPY	ETF	150.75	151.12	150.22	150.92	96409000.0
2007-05-04	QQQ	ETF	46.77	46.89	46.42	46.63	93632263.0
2007-05-04	IWM	ETF	82.49	82.87	82.15	82.82	47940900.0
2007-05-04	DIA	ETF	132.65	132.8	132.23	132.74	10687600.0
2007-05-04	GLD	ETF	67.74	68.43	67.74	68.19	3313800.0
2007-05-04	TLT	ETF	88.52	88.64	88.5	88.6	262000.0
2007-05-04	AAA	ETF	72.5	74.06	70.49	71.99	206500.0
2007-05-04	ADRE	ETF	42.32	42.52	42.17	42.26	136117.0
2007-05-04	AGG	ETF	100.06	100.13	99.94	100.07	233700.0
2007-05-04	AIQ	ETF	45.35	45.45	43.7	44.45	19900.0
2007-05-04	AIS	ETF	1.54	1.57	1.5	1.54	166300.0
2007-05-04	ARB	ETF	49.31	49.31	48.85	49.27	175100.0
2007-05-04	BAB	ETF	101.61	101.76	100.9	101.46	48300.0
2007-05-04	BBH	ETF	62.8	62.9167	62.3933	62.8667	1064700.0
2007-05-04	BITS	ETF	34.08	34.08	33.0	33.16	27447.0
2007-05-04	BIV	ETF	75.36	75.39	75.36	75.39	13600.0
2007-05-04	BLV	ETF	75.53	75.75	75.53	75.72	11200.0
2007-05-04	BMVP	ETF	17.97	18.03	17.93	17.97	26700.0
2007-05-04	BND	ETF	75.38	75.42	75.3	75.34	19200.0
2007-05-04	BNE	ETF	16.7	16.75	16.61	16.73	176500.0
2007-05-04	BRF	ETF	14.5	14.53	14.49	14.51	5200.0
2007-05-04	BSV	ETF	75.24	75.27	75.2	75.24	33000.0
2007-05-04	BTF	ETF	112.14999999999999	113.0	112.14999999999999	112.55	1080.0
2007-05-04	CBON	ETF	30.91	31.1	30.29	31.04	49747.0
2007-05-04	CDL	ETF	9.1	9.13	8.96	9.06	240500.0
2007-05-04	CEF	ETF	9.55	9.64	9.48	9.52	363500.0
2007-05-04	CGO	ETF	17.92	18.06	17.8	17.86	39200.0
2007-05-04	CHB	ETF	10.98	10.98	10.5	10.64	1792500.0
2007-05-04	CHI	ETF	20.41	20.47	20.39	20.46	54600.0
2007-05-04	CHIC	ETF	26.78	26.78	26.3	26.58	482009.0
2007-05-04	CHY	ETF	17.19	17.25	17.18	17.18	83700.0
2007-05-04	CIL	ETF	25.85	25.85	25.85	25.85	100.0
2007-05-04	CN	ETF	49.9	50.1	49.8	49.96	57026.0
2007-05-04	CNXT	ETF	1.57	1.57	1.49	1.5	8748863.0
2007-05-04	CPST	ETF	1.0	1.01	0.95	0.97	2599604.0
2007-05-04	CSA	ETF	20.55	21.0	20.53	20.97	61000.0
2007-05-04	CSB	ETF	31.95	32.01	31.85	31.93	17500.0
2007-05-04	CSD	ETF	29.1	29.21	28.92	28.98	124800.0
2007-05-04	CSM	ETF	1.3725	1.3725	1.37	1.37	11200.0
2007-05-04	CSQ	ETF	15.41	15.46	15.38	15.42	400800.0
2007-05-04	CTEC	ETF	90.55	90.74999999999999	88.05499999999999	88.75	14281.800000000001
2007-05-04	CVY	ETF	27.86	27.97	27.84	27.9	16900.0
2007-05-04	CWI	ETF	26.8667	26.9533	26.8667	26.9267	62550.0
2007-05-04	CZA	ETF	26.48	26.48	26.48	26.48	400.0
2007-05-04	DBA	ETF	25.5	25.61	25.3	25.61	402000.0
2007-05-04	DBB	ETF	29.05	29.7	28.82	29.43	258700.0
2007-05-04	DBC	ETF	25.55	25.7	25.32	25.49	166800.0
2007-05-04	DBE	ETF	28.0	28.0	27.45	27.52	20200.0
2007-05-04	DBO	ETF	26.23	26.42	25.9	26.02	11900.0
2007-05-04	DBP	ETF	27.1	27.18	26.96	27.05	9600.0

> showing 50 of 454 rows — these rows as CSV

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