PREVIEW / etf_daily / 2008-05-27

all etf daily files

  file:    by_date/etf_daily/2008/2008-05-27.parquet
  size:    26 KB
  rows:    584

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
2008-05-27	SPY	ETF	137.8	139.0	137.53	138.66	168322900.0
2008-05-27	QQQ	ETF	48.32	49.11	48.29	49.05	106987732.0
2008-05-27	IWM	ETF	72.38	73.42	72.35	73.32	62334000.0
2008-05-27	DIA	ETF	124.87	125.68	124.37	125.43	9471600.0
2008-05-27	GLD	ETF	89.84	89.87	89.16	89.36	7601700.0
2008-05-27	TLT	ETF	91.38	91.56	90.98	91.15	1985800.0
2008-05-27	ACWI	ETF	54.6	54.6	52.73	53.45	4000.0
2008-05-27	ACWX	ETF	56.41	56.41	54.46	54.47	24360.0
2008-05-27	ADRE	ETF	55.5	55.7	54.81	55.33	526464.0
2008-05-27	AGG	ETF	101.5	101.69	101.35	101.37	865300.0
2008-05-27	AIA	ETF	45.2	45.72	45.04	45.72	33987.0
2008-05-27	AIQ	ETF	45.3	45.8	44.3	44.55	20998.0
2008-05-27	AIS	ETF	0.82	0.83	0.8	0.82	34122.0
2008-05-27	AIVI	ETF	66.96	67.28	66.77	67.2	23200.0
2008-05-27	ARB	ETF	48.47	49.68	48.39	49.68	236386.0
2008-05-27	BBH	ETF	53.3433	54.1233	53.3433	53.75	363600.0
2008-05-27	BIL	ETF	91.62	91.7	91.62	91.64	27250.0
2008-05-27	BITS	ETF	22.92	23.88	22.68	23.0	8475.0
2008-05-27	BIV	ETF	77.77	77.77	77.34	77.51	37200.0
2008-05-27	BJK	ETF	37.25	37.75	37.25	37.75	400.0
2008-05-27	BKF	ETF	57.46	57.46	56.374	57.05	38294.0
2008-05-27	BLV	ETF	75.13	75.27	74.95	75.09	1900.0
2008-05-27	BMVP	ETF	16.127	16.247	16.127	16.243	29836.0
2008-05-27	BND	ETF	77.15	77.16	76.9	76.98	146100.0
2008-05-27	BNE	ETF	15.13	15.26	15.03	15.24	383562.0
2008-05-27	BRF	ETF	14.74	14.74	14.74	14.74	3200.0
2008-05-27	BSV	ETF	77.8	77.86	77.63	77.68	98600.0
2008-05-27	BTF	ETF	100.0	100.99999999999999	99.74999999999999	100.64999999999999	4584.8
2008-05-27	BWX	ETF	28.085	28.115	27.985	28.07	265434.0
2008-05-27	CBON	ETF	8.39	8.68	8.31	8.59	27865.0
2008-05-27	CDL	ETF	1.69	1.71	1.59	1.67	1124333.0
2008-05-27	CEF	ETF	12.86	12.86	12.54	12.56	433300.0
2008-05-27	CGO	ETF	16.44	17.17	16.44	16.6	15431.0
2008-05-27	CGW	ETF	25.8	25.8	24.95	25.23	144528.0
2008-05-27	CHB	ETF	8.1	8.21	7.72	8.01	1101899.0
2008-05-27	CHI	ETF	15.4	15.57	15.4	15.55	87580.0
2008-05-27	CHIC	ETF	17.72	18.42	17.72	18.28	178343.0
2008-05-27	CHW	ETF	12.36	12.4	12.3	12.32	110056.0
2008-05-27	CHY	ETF	14.25	14.48	14.2301	14.48	144397.0
2008-05-27	CMF	ETF	52.66	52.66	52.455	52.59	4472.0
2008-05-27	CNXT	ETF	0.4558	0.4699	0.44	0.458	5263201.0
2008-05-27	COW	ETF	44.83	45.28	44.1501	44.56	352853.0
2008-05-27	CPI	ETF	21.0	21.0	20.75	20.75	300.0
2008-05-27	CPST	ETF	3.53	3.61	3.38	3.57	6141668.0
2008-05-27	CSA	ETF	17.5	17.97	17.49	17.97	45880.0
2008-05-27	CSB	ETF	23.25	23.25	22.07	22.2	61702.0
2008-05-27	CSD	ETF	23.93	24.2	23.49	24.01	28700.0
2008-05-27	CSQ	ETF	12.96	13.06	12.94	13.01	282363.0
2008-05-27	CUT	ETF	22.44	22.44	20.89	21.71	26800.0
2008-05-27	CVY	ETF	23.05	23.14	22.99	23.11	27400.0

> showing 50 of 584 rows — these rows as CSV

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