PREVIEW / etf_daily / 2008-12-23

all etf daily files

  file:    by_date/etf_daily/2008/2008-12-23.parquet
  size:    28 KB
  rows:    631

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-23	SPY	ETF	87.53	87.93	85.8	86.16	221625200.0
2008-12-23	QQQ	ETF	29.28	29.62	28.89	29.06	68804643.0
2008-12-23	IWM	ETF	47.73	48.0	46.34	46.71	64575300.0
2008-12-23	DIA	ETF	85.59	85.93	83.84	84.07	17174800.0
2008-12-23	GLD	ETF	82.93	83.39	81.59	82.63	6322200.0
2008-12-23	TLT	ETF	120.14	121.5	119.9	121.16	1746400.0
2008-12-23	AAXJ	ETF	32.88	33.15	32.0	32.06	340700.0
2008-12-23	ACWI	ETF	31.05	31.32	30.53	30.72	739200.0
2008-12-23	ACWX	ETF	29.45	29.52	28.85	29.0	522395.0
2008-12-23	ADRE	ETF	26.24	26.62	25.91	26.03	337975.0
2008-12-23	AFK	ETF	20.52	21.39	20.52	21.39	11100.0
2008-12-23	AGG	ETF	102.29	103.54	102.14	103.53	774200.0
2008-12-23	AGQ	ETF	56.38	57.3	50.78	52.76	24550.0
2008-12-23	AGZ	ETF	108.53	108.68	107.9	108.631	9490.0
2008-12-23	AIA	ETF	25.84	25.84	24.3	24.3	9172.0
2008-12-23	AIQ	ETF	35.85	36.15	34.55	34.95	32373.0
2008-12-23	AIS	ETF	0.34	0.34	0.3093	0.339	122475.0
2008-12-23	AIVI	ETF	32.63	32.93	32.01	32.2	47700.0
2008-12-23	AOA	ETF	23.53	23.54	23.42	23.42	3800.0
2008-12-23	AOM	ETF	25.11	25.11	25.0872	25.0872	4127.0
2008-12-23	AOR	ETF	24.32	24.46	24.32	24.434	600.0
2008-12-23	ARB	ETF	12.21	12.84	12.12	12.47	416957.0
2008-12-23	BBH	ETF	57.0867	57.5	56.6433	56.92	413100.0
2008-12-23	BIL	ETF	91.82	91.84	91.74	91.74	155600.0
2008-12-23	BITS	ETF	17.1996	19.0	16.48	17.76	11053.0
2008-12-23	BIV	ETF	78.71	79.7	77.96	79.08	109300.0
2008-12-23	BJK	ETF	17.34	17.4	16.5	17.4	1200.0
2008-12-23	BKF	ETF	23.81	26.69	23.41	23.64	79571.0
2008-12-23	BLV	ETF	80.31	80.88	79.0	80.65	25400.0
2008-12-23	BMVP	ETF	10.417	10.438	10.197	10.223	35886.0
2008-12-23	BND	ETF	77.62	78.59	77.62	78.53	338900.0
2008-12-23	BNE	ETF	5.08	5.48	5.05	5.13	123337.0
2008-12-23	BSV	ETF	79.48	80.0	78.9	79.99	131800.0
2008-12-23	BTF	ETF	48.4	48.550000000000004	47.55	47.699999999999996	8446.2
2008-12-23	BWX	ETF	27.25	27.25	27.135	27.215	338904.0
2008-12-23	CBON	ETF	2.5	2.55	2.44	2.5	42497.0
2008-12-23	CDL	ETF	0.2	0.22	0.19	0.19	348609.0
2008-12-23	CEF	ETF	10.4	10.5	10.1	10.29	587800.0
2008-12-23	CGO	ETF	9.08	9.32	9.07	9.2	17334.0
2008-12-23	CGW	ETF	14.38	14.85	14.27	14.46	153993.0
2008-12-23	CHB	ETF	0.74	0.74	0.63	0.71	1053441.0
2008-12-23	CHI	ETF	8.1	8.24	7.97	8.11	339498.0
2008-12-23	CHIC	ETF	6.55	6.55	6.1	6.16	154475.0
2008-12-23	CHW	ETF	5.27	5.38	5.13	5.24	307498.0
2008-12-23	CHY	ETF	7.93	7.94	7.67	7.78	246701.0
2008-12-23	CMF	ETF	50.1	50.245	49.7275	50.245	8894.0
2008-12-23	CNXT	ETF	0.7	0.7	0.66	0.688	229272.0
2008-12-23	COW	ETF	33.82	33.94	33.65	33.89	66144.0
2008-12-23	CPST	ETF	1.1	1.1	1.04	1.06	978976.0
2008-12-23	CSA	ETF	9.43	9.6	9.08	9.16	70865.0

> showing 50 of 631 rows — these rows as CSV

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