PREVIEW / etf_daily / 2008-12-16

all etf daily files

  file:    by_date/etf_daily/2008/2008-12-16.parquet
  size:    28 KB
  rows:    634

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-16	SPY	ETF	91.88	92.02	88.18	91.88	377699500.0
2008-12-16	QQQ	ETF	29.42	30.66	29.0993	30.56	172053683.0
2008-12-16	IWM	ETF	46.26	48.48	46.1	48.33	109318300.0
2008-12-16	DIA	ETF	89.57	89.75	86.33	89.57	30326100.0
2008-12-16	GLD	ETF	82.38	84.64	81.93	84.46	18666400.0
2008-12-16	TLT	ETF	116.46	116.9	113.97	116.46	4015100.0
2008-12-16	AAXJ	ETF	33.34	34.85	32.35	34.83	316800.0
2008-12-16	ACWI	ETF	31.11	33.1	31.11	32.92	799800.0
2008-12-16	ACWX	ETF	29.55	31.07	29.4	31.0	543951.0
2008-12-16	ADRE	ETF	27.43	29.21	27.38	29.1	312855.0
2008-12-16	AFK	ETF	20.84	21.442	20.84	21.442	375.0
2008-12-16	AGG	ETF	101.13	101.13	100.3	101.13	670800.0
2008-12-16	AGQ	ETF	56.68	67.48	56.0	62.52	26450.0
2008-12-16	AGZ	ETF	107.5	108.71	107.29	108.71	3111.0
2008-12-16	AIA	ETF	25.92	27.3999	25.92	27.3999	20379.0
2008-12-16	AIQ	ETF	32.55	35.25	31.95	35.15	36517.0
2008-12-16	AIS	ETF	0.38	0.38	0.33	0.37	287125.0
2008-12-16	AIVI	ETF	35.82	38.15	35.82	37.93	169500.0
2008-12-16	AOA	ETF	23.2	24.89	23.2	24.69	40600.0
2008-12-16	AOK	ETF	25.06	25.66	25.05	25.211	2450.0
2008-12-16	AOM	ETF	24.94	25.114	24.93	25.006	1416.0
2008-12-16	AOR	ETF	24.11	25.5	24.09	25.375	13049.0
2008-12-16	ARB	ETF	10.23	10.62	10.0	10.47	484230.0
2008-12-16	BAL	ETF	25.7401	25.7401	25.74	25.7401	300.0
2008-12-16	BBH	ETF	55.61	55.61	54.2067	55.61	284400.0
2008-12-16	BIL	ETF	91.78	91.82	91.72	91.78	176200.0
2008-12-16	BITS	ETF	17.72	17.96	17.52	17.96	3272.0
2008-12-16	BIV	ETF	76.54	77.74	76.01	77.56	140600.0
2008-12-16	BJK	ETF	16.85	16.85	16.85	16.85	200.0
2008-12-16	BKF	ETF	25.79	26.8548	25.352	26.63	32533.0
2008-12-16	BLV	ETF	75.86	77.43	75.72	77.29	46100.0
2008-12-16	BMVP	ETF	10.27	10.74	10.27	10.69	94060.0
2008-12-16	BND	ETF	76.74	77.5	76.3	77.5	304200.0
2008-12-16	BNE	ETF	3.38	4.25	3.28	4.25	216874.0
2008-12-16	BSV	ETF	78.8	79.3	78.22	79.02	128100.0
2008-12-16	BTF	ETF	47.0	48.49999999999999	47.0	47.85	11798.2
2008-12-16	BWX	ETF	26.495	27.18	26.39	27.095	264412.0
2008-12-16	CBON	ETF	2.26	2.4	2.2	2.29	41117.0
2008-12-16	CDL	ETF	0.1611	0.185	0.16	0.18	1379682.0
2008-12-16	CEF	ETF	10.68	10.73	10.15	10.68	1068700.0
2008-12-16	CGO	ETF	8.2	8.662	8.2	8.5	27380.0
2008-12-16	CGW	ETF	14.19	15.47	14.19	15.21	161969.0
2008-12-16	CHB	ETF	0.86	1.11	0.86	1.04	1415960.0
2008-12-16	CHI	ETF	7.18	7.74	7.02	7.63	346137.0
2008-12-16	CHIC	ETF	5.52	6.04	5.5	6.01	218318.0
2008-12-16	CHW	ETF	4.85	5.22	4.79	5.22	248319.0
2008-12-16	CHY	ETF	7.1	7.1	6.62	6.86	334411.0
2008-12-16	CMF	ETF	49.68	50.25	48.905	50.25	11078.0
2008-12-16	CNXT	ETF	1.0	1.03	0.81	0.81	1882450.0
2008-12-16	COW	ETF	33.38	34.286	33.37	34.25	21537.0

> showing 50 of 634 rows — these rows as CSV

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