PREVIEW / etf_daily / 2010-05-25

all etf daily files

  file:    by_date/etf_daily/2010/2010-05-25.parquet
  size:    33 KB
  rows:    760

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-25	SPY	ETF	105.11	107.87	104.38	107.82	396505200.0
2010-05-25	QQQ	ETF	43.67	44.76	43.23	44.7	155642916.0
2010-05-25	IWM	ETF	62.8	64.24	61.71	64.19	110830700.0
2010-05-25	DIA	ETF	98.53	100.57	97.75	100.46	25166200.0
2010-05-25	GLD	ETF	117.16	117.52	116.82	117.36	21232700.0
2010-05-25	TLT	ETF	99.65	99.89	98.4	98.57	12952700.0
2010-05-25	AAXJ	ETF	48.51	50.54	48.51	50.44	248800.0
2010-05-25	ACWI	ETF	37.65	38.62	37.34	38.52	181700.0
2010-05-25	ACWX	ETF	34.72	35.64	34.46	35.63	629764.0
2010-05-25	ADRE	ETF	37.01	38.1	36.69	38.1	264713.0
2010-05-25	AFK	ETF	27.32	27.81	26.6	27.81	17671.0
2010-05-25	AGG	ETF	106.1	106.27	105.93	105.97	1154700.0
2010-05-25	AGQ	ETF	114.6	117.92	113.1	117.82	229100.0
2010-05-25	AGZ	ETF	109.57	109.605	109.141	109.16	61123.0
2010-05-25	AIA	ETF	35.08	36.02	34.89	36.02	67267.0
2010-05-25	AIQ	ETF	25.5	26.15	25.2	26.1	17146.0
2010-05-25	AIS	ETF	1.43	1.52	1.42	1.48	737018.0
2010-05-25	AIVI	ETF	35.28	36.29	35.14	36.29	50100.0
2010-05-25	AMJ	ETF	27.76	28.38	27.43	28.36	708859.0
2010-05-25	AOA	ETF	28.17	28.44	27.91	28.44	19100.0
2010-05-25	AOK	ETF	27.1	27.39	27.04	27.39	44617.0
2010-05-25	AOM	ETF	27.35	27.67	27.35	27.66	17920.0
2010-05-25	AOR	ETF	27.76	28.15	27.67	28.15	12591.0
2010-05-25	ARB	ETF	28.76	29.21	27.82	29.21	512775.0
2010-05-25	BAB	ETF	26.37	26.37	26.02	26.128	306093.0
2010-05-25	BAL	ETF	38.31	38.6901	38.31	38.65	5761.0
2010-05-25	BALT	ETF	11.36	11.9	11.36	11.84	258005.0
2010-05-25	BBH	ETF	29.0033	29.5	28.6667	29.5	213300.0
2010-05-25	BIB	ETF	5.3925	5.6113	5.3925	5.6113	4000.0
2010-05-25	BICK	ETF	25.15	25.805	25.0	25.805	10220.0
2010-05-25	BIL	ETF	91.7	91.72	91.7	91.72	343900.0
2010-05-25	BIS	ETF	12758.4	12885.6	12249.6	12249.6	23.75
2010-05-25	BITS	ETF	28.8	28.8004	27.8	28.0	1246.0
2010-05-25	BIV	ETF	82.69	82.78	82.47	82.54	369800.0
2010-05-25	BJK	ETF	22.45	23.0	22.14	23.0	16700.0
2010-05-25	BKF	ETF	38.73	39.26	37.7455	39.21	185734.0
2010-05-25	BLV	ETF	81.58	81.59	80.81	80.96	72400.0
2010-05-25	BMVP	ETF	11.91	12.19	11.8	12.19	37204.0
2010-05-25	BND	ETF	80.82	80.94	80.5	80.71	1072100.0
2010-05-25	BNE	ETF	11.05	11.07	10.98	10.99	751470.0
2010-05-25	BRF	ETF	38.28	39.45	37.85	39.43	381564.0
2010-05-25	BSV	ETF	80.55	80.64	80.5	80.53	582600.0
2010-05-25	BTF	ETF	62.99999999999999	64.6	62.449999999999996	64.6	7410.0
2010-05-25	BWX	ETF	26.585	26.665	26.45	26.615	403228.0
2010-05-25	BWZ	ETF	32.74	33.492	32.01	33.3246	70778.0
2010-05-25	BZQ	ETF	5364.8	5430.4	5008.0	5008.0	2471.0
2010-05-25	CEF	ETF	14.73	14.87	14.69	14.76	2609100.0
2010-05-25	CEW	ETF	20.85	21.0	20.75	20.96	168195.0
2010-05-25	CGO	ETF	12.12	12.49	12.08	12.49	68141.0
2010-05-25	CGW	ETF	15.96	16.329	15.81	16.3	112286.0

> showing 50 of 760 rows — these rows as CSV

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