PREVIEW / etf_daily / 2010-06-23

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-23.parquet
  size:    32 KB
  rows:    758

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-06-23	SPY	ETF	109.64	110.03	108.48	109.23	254639900.0
2010-06-23	QQQ	ETF	46.29	46.47	45.69	46.05	92397530.0
2010-06-23	IWM	ETF	64.58	65.26	63.81	64.57	70315300.0
2010-06-23	DIA	ETF	103.08	103.68	102.27	102.99	12966900.0
2010-06-23	GLD	ETF	120.89	121.02	119.77	120.95	14120400.0
2010-06-23	TLT	ETF	98.61	99.57	98.57	99.24	9137800.0
2010-06-23	AAXJ	ETF	55.94	55.94	54.3	54.64	1714300.0
2010-06-23	ACWI	ETF	40.13	40.15	39.57	39.93	753300.0
2010-06-23	ACWX	ETF	37.41	37.55	36.99	37.29	47291.0
2010-06-23	ADRE	ETF	41.45	41.8	41.09	41.64	66970.0
2010-06-23	AFK	ETF	29.3	29.3	28.88	29.09	5258.0
2010-06-23	AGG	ETF	106.35	106.74	106.35	106.66	334200.0
2010-06-23	AGQ	ETF	126.52	126.52	121.82	124.88	267800.0
2010-06-23	AGZ	ETF	109.75	109.89	109.57	109.72	19796.0
2010-06-23	AIA	ETF	38.55	38.75	38.2585	38.45	14892.0
2010-06-23	AIQ	ETF	23.7	24.15	23.3	23.5	13290.0
2010-06-23	AIS	ETF	1.75	1.82	1.72	1.8	578673.0
2010-06-23	AIVI	ETF	39.13	39.47	38.81	39.19	10800.0
2010-06-23	AMJ	ETF	30.62	30.62	30.0	30.22	208829.0
2010-06-23	AOA	ETF	29.64	29.7	29.49	29.66	8700.0
2010-06-23	AOK	ETF	27.56	27.758	27.56	27.72	1775.0
2010-06-23	AOM	ETF	28.07	28.219	27.99	28.2055	15557.0
2010-06-23	AOR	ETF	28.1501	28.88	28.1501	28.81	8615.0
2010-06-23	ARB	ETF	28.61	28.62	27.67	27.72	205209.0
2010-06-23	BAB	ETF	26.0	26.05	25.91	26.01	319291.0
2010-06-23	BAL	ETF	38.75	38.75	37.96	37.96	4750.0
2010-06-23	BALT	ETF	11.92	12.1	11.62	11.82	174103.0
2010-06-23	BBH	ETF	30.5467	30.9567	30.5367	30.8233	63900.0
2010-06-23	BICK	ETF	28.74	28.74	28.32	28.675	2070.0
2010-06-23	BIL	ETF	91.7	91.72	91.7	91.72	63800.0
2010-06-23	BIS	ETF	11756.8	11756.8	11691.2	11691.2	7.55
2010-06-23	BITS	ETF	27.3996	27.52	26.2404	27.32	738.0
2010-06-23	BIV	ETF	82.7	82.93	82.65	82.91	92800.0
2010-06-23	BJK	ETF	24.55	24.87	24.54	24.83	9500.0
2010-06-23	BKF	ETF	42.95	43.91	42.95	43.71	518891.0
2010-06-23	BLV	ETF	81.02	81.5	80.61	81.25	31800.0
2010-06-23	BMVP	ETF	12.4	12.44	12.28	12.35	13573.0
2010-06-23	BND	ETF	80.9	81.1	80.82	81.03	583500.0
2010-06-23	BNE	ETF	11.21	11.23	11.21	11.23	282964.0
2010-06-23	BNO	ETF	26.19	26.19	25.755	25.82	119800.0
2010-06-23	BRF	ETF	45.49	45.7	44.86	45.55	303737.0
2010-06-23	BSCE	ETF	20.23	20.24	20.23	20.24	1900.0
2010-06-23	BSV	ETF	80.7	80.78	80.66	80.78	396200.0
2010-06-23	BTF	ETF	67.05	67.8	66.55	67.69999999999999	6160.0
2010-06-23	BWX	ETF	26.895	26.905	26.67	26.89	181674.0
2010-06-23	BWZ	ETF	33.63	33.8699	33.63	33.761	16036.0
2010-06-23	BZQ	ETF	3899.2	4022.4	3854.4	3857.6	1301.0
2010-06-23	CEF	ETF	15.17	15.17	14.93	14.99	1349400.0
2010-06-23	CEW	ETF	21.6	21.6	21.4	21.49	296830.0
2010-06-23	CGO	ETF	13.2	13.2	13.04	13.2	12963.0

> showing 50 of 758 rows — these rows as CSV

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