PREVIEW / etf_daily / 2010-05-24

all etf daily files

  file:    by_date/etf_daily/2010/2010-05-24.parquet
  size:    32 KB
  rows:    751

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
2010-05-24	SPY	ETF	108.52	109.39	107.61	107.71	269823000.0
2010-05-24	QQQ	ETF	44.81	45.325	44.64	44.66	113385990.0
2010-05-24	IWM	ETF	64.8	65.41	64.14	64.2	75991800.0
2010-05-24	DIA	ETF	101.37	101.98	100.53	100.68	16537800.0
2010-05-24	GLD	ETF	116.34	117.17	116.04	116.84	14300500.0
2010-05-24	TLT	ETF	98.74	98.87	97.9	98.09	7721100.0
2010-05-24	AAXJ	ETF	51.09	51.92	51.09	51.2	188600.0
2010-05-24	ACWI	ETF	39.59	39.59	38.61	38.61	84200.0
2010-05-24	ACWX	ETF	36.79	36.79	35.76	35.76	52917.0
2010-05-24	ADRE	ETF	38.83	39.04	38.33	38.37	190398.0
2010-05-24	AFK	ETF	28.37	28.41	27.93	27.9442	5075.0
2010-05-24	AGG	ETF	105.9	106.0	105.82	105.84	1322700.0
2010-05-24	AGQ	ETF	117.44	120.22	116.2	118.56	345400.0
2010-05-24	AGZ	ETF	109.44	109.4615	109.18	109.37	52817.0
2010-05-24	AIA	ETF	36.79	36.96	36.55	36.55	14613.0
2010-05-24	AIQ	ETF	26.2	26.5	26.0	26.0	12256.0
2010-05-24	AIS	ETF	1.53	1.63	1.52	1.53	476833.0
2010-05-24	AIVI	ETF	36.66	37.0	36.45	36.45	13900.0
2010-05-24	AMJ	ETF	28.49	28.67	28.26	28.34	394224.0
2010-05-24	AOA	ETF	29.07	29.21	28.76	28.76	15300.0
2010-05-24	AOK	ETF	27.52	27.52	27.391	27.391	3572.0
2010-05-24	AOM	ETF	27.75	27.9	27.68	27.74	6792.0
2010-05-24	AOR	ETF	28.4075	28.47	28.24	28.24	8685.0
2010-05-24	ARB	ETF	29.94	30.22	29.27	29.28	206138.0
2010-05-24	BAB	ETF	26.48	26.48	26.2	26.27	506750.0
2010-05-24	BAL	ETF	39.1014	39.16	39.1014	39.16	300.0
2010-05-24	BALT	ETF	11.68	11.81	11.55	11.74	177356.0
2010-05-24	BBH	ETF	29.39	29.7133	29.1667	29.4467	105000.0
2010-05-24	BIB	ETF	5.6612	5.79	5.6612	5.6775	6728.0
2010-05-24	BICK	ETF	26.51	26.63	26.2301	26.32	4270.0
2010-05-24	BIL	ETF	91.72	91.72	91.7	91.72	168600.0
2010-05-24	BIS	ETF	12240.0	12240.0	12192.8	12230.4	12.9
2010-05-24	BITS	ETF	28.99	29.44	27.556	28.6	4235.0
2010-05-24	BIV	ETF	82.49	82.81	82.35	82.45	694100.0
2010-05-24	BJK	ETF	23.54	23.69	23.3	23.41	22500.0
2010-05-24	BKF	ETF	40.23	40.44	39.626	39.73	103433.0
2010-05-24	BLV	ETF	81.46	81.46	80.93	81.0	102300.0
2010-05-24	BMVP	ETF	12.2833	12.3594	12.21	12.21	9782.0
2010-05-24	BND	ETF	80.7	80.77	80.64	80.69	836400.0
2010-05-24	BNE	ETF	11.04	11.08	11.02	11.07	324249.0
2010-05-24	BRF	ETF	40.2	40.6599	39.72	39.85	343355.0
2010-05-24	BSV	ETF	80.61	80.62	80.51	80.58	477900.0
2010-05-24	BTF	ETF	64.55	65.65	64.55	64.64999999999999	2820.0
2010-05-24	BWX	ETF	26.535	26.8075	26.51	26.585	246092.0
2010-05-24	BWZ	ETF	33.09	33.76	33.09	33.66	21133.0
2010-05-24	BZQ	ETF	4774.4	4974.4	4680.0	4921.6	979.5
2010-05-24	CEF	ETF	14.7	14.89	14.65	14.77	1190100.0
2010-05-24	CEW	ETF	21.13	21.31	21.13	21.172	89470.0
2010-05-24	CGO	ETF	12.92	12.92	12.58	12.58	27762.0
2010-05-24	CGW	ETF	16.46	16.5425	16.25	16.25	43444.0

> showing 50 of 751 rows — these rows as CSV

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