PREVIEW / etf_daily / 2010-05-10

all etf daily files

  file:    by_date/etf_daily/2010/2010-05-10.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-10	SPY	ETF	115.81	116.65	114.91	116.16	396159600.0
2010-05-10	QQQ	ETF	47.42	47.8	47.31	47.77	136041589.0
2010-05-10	IWM	ETF	68.55	69.06	67.7	69.03	107703400.0
2010-05-10	DIA	ETF	107.57	108.47	107.0	108.0	20454000.0
2010-05-10	GLD	ETF	117.5	117.9	116.81	117.57	28433800.0
2010-05-10	TLT	ETF	93.16	93.94	93.09	93.6	10240100.0
2010-05-10	AAXJ	ETF	55.59	55.9	55.17	55.84	401700.0
2010-05-10	ACWI	ETF	42.14	42.23	41.62	41.95	562300.0
2010-05-10	ACWX	ETF	39.38	39.69	39.05	39.33	246759.0
2010-05-10	ADRE	ETF	42.71	42.71	42.11	42.7	261291.0
2010-05-10	AFK	ETF	31.0	31.92	30.49	30.75	22549.0
2010-05-10	AGG	ETF	104.42	104.62	104.34	104.4	1173600.0
2010-05-10	AGQ	ETF	128.44	129.42	126.1	127.04	185450.0
2010-05-10	AGZ	ETF	108.0	108.67	108.0	108.46	30107.0
2010-05-10	AIA	ETF	39.89	39.96	39.31	39.726	23944.0
2010-05-10	AIQ	ETF	25.6	26.5	25.5	26.4	29834.0
2010-05-10	AIS	ETF	1.6	1.6199	1.57	1.6	504491.0
2010-05-10	AIVI	ETF	39.33	40.07	38.32	39.74	48100.0
2010-05-10	AMJ	ETF	30.39	30.5	29.9	30.02	503010.0
2010-05-10	AOA	ETF	30.95	31.11	30.71	30.79	23900.0
2010-05-10	AOK	ETF	28.12	28.12	27.8	27.8454	14823.0
2010-05-10	AOM	ETF	28.69	28.69	28.502	28.54	31218.0
2010-05-10	AOR	ETF	29.5	29.53	29.34	29.53	38120.0
2010-05-10	ARB	ETF	30.33	31.69	30.22	31.57	237635.0
2010-05-10	BAB	ETF	25.76	26.02	25.75	25.83	195932.0
2010-05-10	BAL	ETF	38.72	38.72	38.25	38.27	2038.0
2010-05-10	BALT	ETF	12.5	12.93	12.15	12.6	343942.0
2010-05-10	BBH	ETF	31.47	31.67	31.0633	31.24	102600.0
2010-05-10	BIB	ETF	6.5113	6.6037	6.3625	6.3625	19192.0
2010-05-10	BICK	ETF	29.19	29.89	28.465	29.04	36753.0
2010-05-10	BIL	ETF	91.7	91.72	91.7	91.72	219550.0
2010-05-10	BIS	ETF	10572.8	11100.8	10572.8	10963.2	60.0
2010-05-10	BITS	ETF	30.92	30.96	29.68	30.816	3985.0
2010-05-10	BIV	ETF	81.41	81.41	81.05	81.24	143900.0
2010-05-10	BJK	ETF	24.87	25.53	24.87	25.38	25800.0
2010-05-10	BKF	ETF	43.74	44.46	43.02	43.95	434571.0
2010-05-10	BLV	ETF	78.5	78.85	78.0	78.62	31200.0
2010-05-10	BMVP	ETF	12.847	13.131	12.847	13.1	42267.0
2010-05-10	BND	ETF	79.72	79.99	79.71	79.81	517000.0
2010-05-10	BNE	ETF	11.23	11.25	11.05	11.22	564971.0
2010-05-10	BRF	ETF	43.41	44.57	43.41	44.53	356886.0
2010-05-10	BSV	ETF	80.36	80.5	80.16	80.19	432800.0
2010-05-10	BTF	ETF	70.0	71.75	69.25	69.9465	6344.0
2010-05-10	BWX	ETF	27.0	27.16	26.85	26.89	261340.0
2010-05-10	BWZ	ETF	34.07	35.0	34.0	34.185	55637.0
2010-05-10	BZQ	ETF	3830.4	4040.0	3800.0	3840.0	1651.0
2010-05-10	CEF	ETF	15.3	15.5	15.02	15.16	3019300.0
2010-05-10	CEW	ETF	22.01	22.029	21.88	21.99	74389.0
2010-05-10	CGO	ETF	13.73	14.26	13.66	13.89	51048.0
2010-05-10	CGW	ETF	17.65	17.74	17.19	17.63	88242.0

> showing 50 of 760 rows — these rows as CSV

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