PREVIEW / etf_daily / 2010-10-29

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-29.parquet
  size:    34 KB
  rows:    794

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-29	SPY	ETF	118.28	118.72	118.07	118.49	144305500.0
2010-10-29	QQQ	ETF	52.29	52.49	52.1698	52.18	46668690.0
2010-10-29	IWM	ETF	69.88	70.67	69.83	70.3	40455100.0
2010-10-29	DIA	ETF	111.02	111.38	110.81	111.31	5972000.0
2010-10-29	GLD	ETF	131.48	132.82	131.06	132.62	14334900.0
2010-10-29	TLT	ETF	99.82	100.46	99.62	100.42	6753800.0
2010-10-29	AADR	ETF	28.86	28.86	28.86	28.86	300.0
2010-10-29	AAXJ	ETF	62.08	62.36	61.94	62.29	503000.0
2010-10-29	ACWI	ETF	44.79	44.89	44.74	44.83	54600.0
2010-10-29	ACWX	ETF	42.71	42.8396	42.63	42.81	88196.0
2010-10-29	ADRE	ETF	46.07	46.1081	45.84	46.05	34190.0
2010-10-29	AFK	ETF	33.37	33.37	33.1124	33.2599	13261.0
2010-10-29	AGG	ETF	108.45	108.55	108.36	108.55	963600.0
2010-10-29	AGQ	ETF	201.0	211.18	199.74	211.18	402150.0
2010-10-29	AGZ	ETF	111.52	111.54	111.38	111.52	47369.0
2010-10-29	AIA	ETF	43.73	43.75	43.54	43.7	12682.0
2010-10-29	AIQ	ETF	18.8	19.95	18.5	19.7	195571.0
2010-10-29	AIS	ETF	1.41	1.48	1.39	1.46	370051.0
2010-10-29	AIVI	ETF	45.28	45.43	45.14	45.39	12300.0
2010-10-29	AMJ	ETF	35.22	35.5	35.16	35.485	2039286.0
2010-10-29	AMLP	ETF	79.25	79.7	79.25	79.7	61240.0
2010-10-29	AOA	ETF	32.56	32.66	32.56	32.66	10500.0
2010-10-29	AOK	ETF	28.74	28.8	28.7101	28.77	16196.0
2010-10-29	AOM	ETF	29.62	29.62	29.58	29.59	9276.0
2010-10-29	AOR	ETF	30.65	30.73	30.63	30.71	13807.0
2010-10-29	ARB	ETF	25.93	26.14	25.21	25.32	483217.0
2010-10-29	BAB	ETF	26.15	26.2	26.07	26.17	106812.0
2010-10-29	BAL	ETF	61.7	61.9299	60.374	61.53	38041.0
2010-10-29	BALT	ETF	11.2	11.415	11.19	11.3	98915.0
2010-10-29	BBH	ETF	33.94	34.0633	33.87	33.9633	34500.0
2010-10-29	BIB	ETF	6.9088	6.9088	6.9088	6.9088	5792.0
2010-10-29	BICK	ETF	32.59	32.59	32.34	32.56	18070.0
2010-10-29	BIL	ETF	91.7	91.72	91.7	91.72	57850.0
2010-10-29	BITS	ETF	28.0	28.4	27.4	27.92	6925.0
2010-10-29	BIV	ETF	86.81	86.9	86.67	86.86	124500.0
2010-10-29	BJK	ETF	30.97	31.28	30.97	31.22	23400.0
2010-10-29	BKF	ETF	49.11	49.26	49.02	49.215	116212.0
2010-10-29	BLV	ETF	83.26	83.71	83.26	83.54	29200.0
2010-10-29	BMVP	ETF	13.71	13.76	13.68	13.74	12887.0
2010-10-29	BND	ETF	82.61	82.71	82.57	82.7	442900.0
2010-10-29	BNE	ETF	11.32	11.36	11.31	11.35	301709.0
2010-10-29	BNO	ETF	27.79	27.79	27.775	27.775	10000.0
2010-10-29	BRF	ETF	59.38	60.07	59.28	60.07	321206.0
2010-10-29	BSCE	ETF	21.03	21.04	21.015	21.04	5537.0
2010-10-29	BSV	ETF	81.87	81.99	81.87	81.98	377000.0
2010-10-29	BTF	ETF	77.9495	78.15	77.655	78.0	4663.0
2010-10-29	BWX	ETF	30.49	30.645	30.47	30.62	1003238.0
2010-10-29	BWZ	ETF	37.56	37.805	37.53	37.79	9337.0
2010-10-29	BZQ	ETF	2696.0	2707.2	2680.0	2684.8	432.0
2010-10-29	CEF	ETF	17.49	17.76	17.41	17.7	1263100.0

> showing 50 of 794 rows — these rows as CSV

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