PREVIEW / etf_daily / 2010-10-26

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-26.parquet
  size:    34 KB
  rows:    799

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-10-26	SPY	ETF	118.1	118.84	117.87	118.72	158982900.0
2010-10-26	QQQ	ETF	51.62	52.15	51.42	52.03	60498263.0
2010-10-26	IWM	ETF	70.36	71.17	69.99	70.69	37884100.0
2010-10-26	DIA	ETF	111.2	111.91	110.93	111.76	5371300.0
2010-10-26	GLD	ETF	129.99	131.14	129.73	130.88	10710900.0
2010-10-26	TLT	ETF	100.86	101.06	100.05	100.1	8432000.0
2010-10-26	AADR	ETF	28.83	28.9	28.82	28.89	1100.0
2010-10-26	AAXJ	ETF	62.87	62.97	62.47	62.83	479700.0
2010-10-26	ACWI	ETF	44.76	44.98	44.62	44.9	224900.0
2010-10-26	ACWX	ETF	42.76	42.91	42.61	42.91	1186033.0
2010-10-26	ADRE	ETF	46.11	46.5772	45.89	46.49	122739.0
2010-10-26	AFK	ETF	33.46	33.6699	33.12	33.53	34680.0
2010-10-26	AGG	ETF	108.38	108.41	108.2	108.26	433200.0
2010-10-26	AGQ	ETF	187.6	198.54	186.46	196.42	285650.0
2010-10-26	AGZ	ETF	111.4495	111.54	111.4	111.43	6644.0
2010-10-26	AIA	ETF	44.25	44.37	44.09	44.32	65935.0
2010-10-26	AIQ	ETF	20.85	20.85	20.35	20.45	54660.0
2010-10-26	AIS	ETF	1.41	1.42	1.39	1.41	244601.0
2010-10-26	AIVI	ETF	45.14	45.25	44.92	45.25	18900.0
2010-10-26	AMJ	ETF	34.96	35.2099	34.96	35.18	533164.0
2010-10-26	AMLP	ETF	78.9	79.25	78.9	79.2	156720.0
2010-10-26	AOA	ETF	32.65	32.67	32.62	32.62	2000.0
2010-10-26	AOK	ETF	28.72	28.8	28.72	28.7799	10104.0
2010-10-26	AOM	ETF	29.56	29.65	29.56	29.59	4456.0
2010-10-26	AOR	ETF	30.67	30.78	30.66	30.7299	12110.0
2010-10-26	ARB	ETF	27.94	28.89	26.35	27.11	1045373.0
2010-10-26	BAB	ETF	26.25	26.27	26.12	26.12	167914.0
2010-10-26	BAL	ETF	62.27	63.86	61.99	63.15	119016.0
2010-10-26	BALT	ETF	11.42	11.58	11.14	11.18	179543.0
2010-10-26	BBH	ETF	33.4233	33.59	33.2967	33.59	69600.0
2010-10-26	BIB	ETF	6.6312	6.6312	6.6312	6.6312	800.0
2010-10-26	BICK	ETF	32.91	33.04	32.7817	33.02	53676.0
2010-10-26	BIL	ETF	91.7	91.72	91.7	91.72	89500.0
2010-10-26	BIS	ETF	9252.8	9252.8	9153.6	9180.8	46.9
2010-10-26	BITS	ETF	27.12	28.8	26.8	27.92	3512.0
2010-10-26	BIV	ETF	86.73	86.76	86.5	86.53	95600.0
2010-10-26	BJK	ETF	30.33	30.51	30.31	30.45	8300.0
2010-10-26	BKF	ETF	49.29	49.81	49.2	49.64	123754.0
2010-10-26	BLV	ETF	83.99	83.99	83.39	83.44	25800.0
2010-10-26	BMVP	ETF	13.6033	13.7433	13.5808	13.7133	6639.0
2010-10-26	BND	ETF	82.5	82.58	82.41	82.44	386600.0
2010-10-26	BNE	ETF	11.3	11.36	11.28	11.36	260351.0
2010-10-26	BRF	ETF	58.99	59.66	58.75	59.3	363475.0
2010-10-26	BSCE	ETF	21.05	21.05	21.038	21.05	4008.0
2010-10-26	BSV	ETF	81.86	81.88	81.77	81.82	802500.0
2010-10-26	BTF	ETF	78.05	78.55	77.89999999999999	78.15	3445.6000000000004
2010-10-26	BWX	ETF	30.48	30.585	30.41	30.435	193212.0
2010-10-26	BWZ	ETF	37.54	37.68	37.25	37.2901	22154.0
2010-10-26	BZQ	ETF	2723.2	2732.8	2617.6	2641.6	819.5
2010-10-26	CEF	ETF	17.11	17.41	17.07	17.24	875700.0

> showing 50 of 799 rows — these rows as CSV

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