PREVIEW / etf_daily / 2008-12-09

all etf daily files

  file:    by_date/etf_daily/2008/2008-12-09.parquet
  size:    28 KB
  rows:    633

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-09	SPY	ETF	90.37	92.13	88.98	89.5	370790000.0
2008-12-09	QQQ	ETF	29.68	30.83	29.57	30.01	178390054.0
2008-12-09	IWM	ETF	47.69	49.41	46.28	46.65	81950900.0
2008-12-09	DIA	ETF	88.34	89.41	86.62	87.11	34188200.0
2008-12-09	GLD	ETF	75.56	76.85	75.3	76.33	9618300.0
2008-12-09	TLT	ETF	110.58	112.53	110.25	112.42	2055500.0
2008-12-09	AAXJ	ETF	31.98	32.42	31.8	31.9	987100.0
2008-12-09	ACWI	ETF	31.0	31.34	30.54	30.61	230600.0
2008-12-09	ACWX	ETF	28.5	29.09	28.18	28.46	437720.0
2008-12-09	ADRE	ETF	26.5	26.76	25.65	26.11	454555.0
2008-12-09	AFK	ETF	20.16	20.2	19.86	20.2	2454.0
2008-12-09	AGG	ETF	99.75	100.12	99.21	100.12	762100.0
2008-12-09	AGQ	ETF	48.36	50.02	48.06	48.94	7400.0
2008-12-09	AGZ	ETF	105.84	106.59	105.84	106.59	11578.0
2008-12-09	AIA	ETF	24.56	25.67	24.48	24.61	68333.0
2008-12-09	AIQ	ETF	32.9	34.0	32.45	32.55	52166.0
2008-12-09	AIS	ETF	0.36	0.38	0.36	0.37	36017.0
2008-12-09	AIVI	ETF	35.46	36.49	34.33	35.39	34300.0
2008-12-09	AOA	ETF	24.0	24.05	22.25	23.84	54500.0
2008-12-09	AOK	ETF	25.23	26.0	25.23	26.0	1450.0
2008-12-09	AOM	ETF	24.93	24.96	24.72	24.75	21030.0
2008-12-09	AOR	ETF	24.4	25.05	24.25	24.61	56483.0
2008-12-09	ARB	ETF	12.91	12.91	11.89	12.15	564674.0
2008-12-09	BAL	ETF	25.55	25.55	25.33	25.33	200.0
2008-12-09	BBH	ETF	54.4233	54.8867	53.53	54.1067	192900.0
2008-12-09	BIL	ETF	91.86	91.86	91.72	91.74	241200.0
2008-12-09	BITS	ETF	16.52	17.2	16.0	17.0	1850.0
2008-12-09	BIV	ETF	74.95	75.59	74.93	75.53	47300.0
2008-12-09	BJK	ETF	16.66	16.66	16.4	16.4	400.0
2008-12-09	BKF	ETF	23.98	24.77	23.91	23.93	22643.0
2008-12-09	BLV	ETF	73.65	74.62	73.65	74.57	13200.0
2008-12-09	BMVP	ETF	10.3467	10.6464	10.2633	10.3133	81525.0
2008-12-09	BND	ETF	75.49	76.35	75.49	75.78	347300.0
2008-12-09	BNE	ETF	4.06	4.3	3.67	3.91	213857.0
2008-12-09	BRF	ETF	15.08	15.08	15.02	15.05	23200.0
2008-12-09	BSV	ETF	78.61	78.98	77.96	78.11	141700.0
2008-12-09	BTF	ETF	49.5	50.7	49.0	49.45	16251.0
2008-12-09	BWX	ETF	25.275	25.505	25.2007	25.4	245006.0
2008-12-09	CBON	ETF	2.22	2.39	2.1	2.11	41265.0
2008-12-09	CDL	ETF	0.19	0.2	0.175	0.19	1737609.0
2008-12-09	CEF	ETF	9.21	9.37	9.09	9.26	793000.0
2008-12-09	CGO	ETF	8.31	8.5	8.13	8.31	36450.0
2008-12-09	CGW	ETF	14.28	14.29	13.78	14.012	81377.0
2008-12-09	CHB	ETF	0.8	0.999	0.76	0.89	1098237.0
2008-12-09	CHI	ETF	7.89	7.89	7.25	7.33	240377.0
2008-12-09	CHIC	ETF	5.84	5.93	5.38	5.41	279091.0
2008-12-09	CHW	ETF	5.05	5.07	4.88	4.94	214439.0
2008-12-09	CHY	ETF	6.56	7.03	6.56	6.95	258320.0
2008-12-09	CMF	ETF	48.301	48.5525	47.74	48.4475	7028.0
2008-12-09	CNXT	ETF	1.0	1.25	1.0	1.19	383071.0

> showing 50 of 633 rows — these rows as CSV

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