PREVIEW / etf_daily / 2008-12-05

all etf daily files

  file:    by_date/etf_daily/2008/2008-12-05.parquet
  size:    28 KB
  rows:    629

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-12-05	SPY	ETF	83.65	88.42	82.24	87.93	471905300.0
2008-12-05	QQQ	ETF	27.5	29.07	26.95	28.94	212310887.0
2008-12-05	IWM	ETF	43.37	46.27	42.34	46.1	113947900.0
2008-12-05	DIA	ETF	82.97	86.98	81.31	86.59	43490800.0
2008-12-05	GLD	ETF	74.3	74.81	72.91	74.52	13392300.0
2008-12-05	TLT	ETF	111.95	113.0	110.42	110.48	4557600.0
2008-12-05	AAXJ	ETF	29.14	30.45	28.5	30.45	31500.0
2008-12-05	ACWI	ETF	28.82	29.87	28.03	29.78	158600.0
2008-12-05	ACWX	ETF	26.63	27.24	25.81	27.24	342568.0
2008-12-05	ADRE	ETF	23.25	24.61	22.88	24.56	224688.0
2008-12-05	AFK	ETF	18.8801	19.6	18.88	19.6	11578.0
2008-12-05	AGG	ETF	99.51	99.97	97.88	99.32	616400.0
2008-12-05	AGQ	ETF	44.14	45.66	43.2	45.48	5850.0
2008-12-05	AGZ	ETF	106.06	106.06	105.27	105.48	10300.0
2008-12-05	AIA	ETF	22.74	24.01	22.366	24.01	14860.0
2008-12-05	AIQ	ETF	33.6	33.7	32.5	33.3	52103.0
2008-12-05	AIS	ETF	0.35	0.37	0.34	0.37	130800.0
2008-12-05	AIVI	ETF	33.57	34.7	32.59	34.57	12200.0
2008-12-05	AOA	ETF	21.77	23.97	21.6	22.83	330800.0
2008-12-05	AOK	ETF	24.69	24.84	23.75	24.824	2700.0
2008-12-05	AOM	ETF	23.94	25.6	23.16	24.36	15350.0
2008-12-05	AOR	ETF	23.14	24.4	23.0	24.245	28681.0
2008-12-05	ARB	ETF	12.09	12.66	11.95	12.61	799357.0
2008-12-05	BAL	ETF	24.68	24.68	24.41	24.41	900.0
2008-12-05	BBH	ETF	51.9067	53.5967	51.3633	53.21	453600.0
2008-12-05	BIL	ETF	91.9	91.9	91.74	91.76	147500.0
2008-12-05	BITS	ETF	15.56	16.8	15.28	16.8	2650.0
2008-12-05	BIV	ETF	75.83	76.28	75.07	75.19	95000.0
2008-12-05	BJK	ETF	15.26	16.06	14.85	15.81	3200.0
2008-12-05	BKF	ETF	21.35	23.33	21.35	22.65	26777.0
2008-12-05	BLV	ETF	73.96	75.0	73.89	74.14	23500.0
2008-12-05	BMVP	ETF	9.7	10.23	9.53	10.23	51110.0
2008-12-05	BND	ETF	75.86	76.29	75.51	75.71	376700.0
2008-12-05	BNE	ETF	3.09	3.52	2.85	3.52	213470.0
2008-12-05	BRF	ETF	15.0	15.01	15.0	15.01	12200.0
2008-12-05	BSV	ETF	78.63	78.82	78.33	78.54	102800.0
2008-12-05	BTF	ETF	45.0	47.099999999999994	41.39999999999999	46.849999999999994	24073.800000000003
2008-12-05	BWX	ETF	25.155	25.27	25.055	25.13	247032.0
2008-12-05	CBON	ETF	2.09	2.1	2.0	2.0	46113.0
2008-12-05	CDL	ETF	0.17	0.18	0.16	0.18	574940.0
2008-12-05	CEF	ETF	9.22	9.32	8.95	9.28	903700.0
2008-12-05	CGO	ETF	7.74	8.0	7.65	7.95	12459.0
2008-12-05	CGW	ETF	13.33	13.794	12.94	13.65	68946.0
2008-12-05	CHB	ETF	0.6	0.75	0.53	0.72	1729824.0
2008-12-05	CHI	ETF	7.08	7.25	6.7	7.06	260267.0
2008-12-05	CHIC	ETF	5.6	5.98	5.28	5.94	521110.0
2008-12-05	CHW	ETF	4.41	4.74	4.26	4.74	198842.0
2008-12-05	CHY	ETF	6.36	6.97	6.27	6.63	288125.0
2008-12-05	CMF	ETF	48.675	49.12	48.475	48.52	4964.0
2008-12-05	CNXT	ETF	0.99	1.03	0.98	1.01	258128.0

> showing 50 of 629 rows — these rows as CSV

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