PREVIEW / etf_daily / 2008-11-20

all etf daily files

  file:    by_date/etf_daily/2008/2008-11-20.parquet
  size:    28 KB
  rows:    622

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-11-20	SPY	ETF	80.13	82.51	75.05	75.45	814180400.0
2008-11-20	QQQ	ETF	26.54	27.45	25.47	25.56	342471382.0
2008-11-20	IWM	ETF	41.0	41.93	38.44	38.53	140070900.0
2008-11-20	DIA	ETF	79.4	82.2	75.37	76.06	77925200.0
2008-11-20	GLD	ETF	73.15	74.2	72.43	73.45	13584200.0
2008-11-20	TLT	ETF	101.82	104.44	101.1	104.43	5459800.0
2008-11-20	AAXJ	ETF	26.57	27.48	25.14	25.38	377400.0
2008-11-20	ACWI	ETF	27.28	28.18	26.2	26.27	115600.0
2008-11-20	ACWX	ETF	25.45	25.51	23.81	24.13	167691.0
2008-11-20	ADRE	ETF	21.8	22.12	20.43	20.98	487789.0
2008-11-20	AFK	ETF	20.15	20.1501	19.72	19.72	800.0
2008-11-20	AGG	ETF	97.9	97.94	97.16	97.4	826200.0
2008-11-20	AGZ	ETF	102.54	103.06	102.54	103.06	2241.0
2008-11-20	AIA	ETF	20.23	22.2	20.0	20.0	28629.0
2008-11-20	AIQ	ETF	41.45	41.45	37.3	37.35	30107.0
2008-11-20	AIS	ETF	0.32	0.4	0.31	0.33	477400.0
2008-11-20	AIVI	ETF	31.5	32.15	29.75	29.76	32700.0
2008-11-20	AOA	ETF	22.18	22.18	19.3	20.65	13900.0
2008-11-20	AOK	ETF	23.83	23.83	23.83	23.83	134.0
2008-11-20	AOM	ETF	23.39	23.39	23.39	23.39	180.0
2008-11-20	AOR	ETF	23.9	23.9	23.0	23.0	1846.0
2008-11-20	ARB	ETF	16.15	16.64	14.82	15.06	653787.0
2008-11-20	BAL	ETF	23.55	23.55	23.55	23.55	200.0
2008-11-20	BBH	ETF	53.3333	53.94	50.4033	50.85	963300.0
2008-11-20	BIL	ETF	91.94	91.94	91.68	91.88	226150.0
2008-11-20	BITS	ETF	14.48	15.8	14.2	14.92	5687.0
2008-11-20	BIV	ETF	74.24	74.32	73.5	74.31	60900.0
2008-11-20	BJK	ETF	14.25	14.57	14.0	14.03	2100.0
2008-11-20	BKF	ETF	20.0	20.56	18.5	18.5	99784.0
2008-11-20	BLV	ETF	71.0	71.9	70.39	71.89	38400.0
2008-11-20	BMVP	ETF	9.2833	9.5123	8.6667	8.6917	57052.0
2008-11-20	BND	ETF	74.58	75.37	74.58	74.87	225200.0
2008-11-20	BNE	ETF	2.23	2.25	2.01	2.03	185218.0
2008-11-20	BOSS	ETF	11.2	11.22	11.2	11.22	100.0
2008-11-20	BRF	ETF	14.9	14.912	14.8	14.91	51650.0
2008-11-20	BSV	ETF	77.59	78.24	77.06	78.24	190000.0
2008-11-20	BTF	ETF	42.64999999999999	42.64999999999999	35.55	39.0	48389.8
2008-11-20	BWX	ETF	24.775	24.775	24.51	24.6	167270.0
2008-11-20	CBON	ETF	2.44	2.59	2.26	2.32	206982.0
2008-11-20	CDL	ETF	0.22	0.25	0.2	0.21	1468667.0
2008-11-20	CEF	ETF	8.55	8.77	8.25	8.58	837800.0
2008-11-20	CGO	ETF	7.61	8.03	7.0	7.49	88696.0
2008-11-20	CGW	ETF	13.35	13.59	11.72	11.826	166045.0
2008-11-20	CHB	ETF	0.5	0.53	0.47	0.5	3290722.0
2008-11-20	CHI	ETF	6.59	6.84	6.05	6.57	460315.0
2008-11-20	CHIC	ETF	4.71	4.71	4.24	4.36	903402.0
2008-11-20	CHW	ETF	4.7	4.7	4.06	4.23	554981.0
2008-11-20	CHY	ETF	6.03	6.1	5.75	5.77	730879.0
2008-11-20	CMF	ETF	50.49	50.615	49.875	50.25	8768.0
2008-11-20	CNXT	ETF	0.9	0.9001	0.77	0.775	406220.0

> showing 50 of 622 rows — these rows as CSV

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