PREVIEW / etf_daily / 2011-08-12

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-12.parquet
  size:    37 KB
  rows:    871

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
2011-08-12	SPY	ETF	118.4	119.21	117.28	118.12	313731600.0
2011-08-12	QQQ	ETF	53.42	53.9	52.88	53.57	90483235.0
2011-08-12	IWM	ETF	69.99	70.6	68.8	69.79	86475800.0
2011-08-12	DIA	ETF	112.49	113.49	111.58	112.8	14097500.0
2011-08-12	GLD	ETF	169.57	170.06	167.77	169.97	29220000.0
2011-08-12	TLT	ETF	104.44	105.66	104.07	105.57	15590800.0
2011-08-12	AADR	ETF	27.87	28.78	27.87	28.65	2200.0
2011-08-12	AAXJ	ETF	55.48	55.8	54.98	55.53	1016700.0
2011-08-12	ACTV	ETF	14.89	16.16	14.89	15.66	458285.0
2011-08-12	ACWI	ETF	42.79	43.01	42.25	42.71	1083200.0
2011-08-12	ACWX	ETF	39.38	39.6	38.89	39.36	168006.0
2011-08-12	ADRE	ETF	40.54	40.78	40.18	40.62	147666.0
2011-08-12	AFK	ETF	29.09	29.56	28.6	29.188	25988.0
2011-08-12	AGEM	ETF	22.49	22.73	22.49	22.73	1005.0
2011-08-12	AGG	ETF	109.16	109.56	108.93	109.24	2472300.0
2011-08-12	AGQ	ETF	391.78	407.14	388.52	405.4	443350.0
2011-08-12	AGZ	ETF	112.204	112.37	112.12	112.1201	8153.0
2011-08-12	AIA	ETF	40.77	40.82	40.28	40.53	56414.0
2011-08-12	AIQ	ETF	8.05	9.25	7.8005	8.3	149632.0
2011-08-12	AIS	ETF	2.12	2.16	2.04	2.1	1151642.0
2011-08-12	AIVI	ETF	41.33	41.61	40.93	41.35	42200.0
2011-08-12	AMJ	ETF	36.36	36.87	35.49	35.62	3109797.0
2011-08-12	AMLP	ETF	79.0	79.0	77.2	77.4	150840.0
2011-08-12	AOA	ETF	32.13	32.31	31.86	32.11	16400.0
2011-08-12	AOK	ETF	29.01	29.01	28.5	28.9356	31992.0
2011-08-12	AOM	ETF	29.69	29.73	29.5616	29.63	16438.0
2011-08-12	AOR	ETF	30.57	30.6799	30.5	30.53	24607.0
2011-08-12	ARB	ETF	34.83	35.09	33.66	34.88	97542.0
2011-08-12	ARGT	ETF	26.02	26.02	25.56	25.7	2900.0
2011-08-12	ASEA	ETF	16.16	16.21	16.04	16.08	11100.0
2011-08-12	AWAY	ETF	37.43	38.08	36.59	37.14	139125.0
2011-08-12	BAB	ETF	26.87	27.0	26.44	26.88	132810.0
2011-08-12	BAL	ETF	60.96	62.7699	60.93	62.73	76767.0
2011-08-12	BALT	ETF	4.26	4.58	4.19	4.52	200832.0
2011-08-12	BBH	ETF	30.6033	31.1167	30.4867	30.9633	47400.0
2011-08-12	BCM	ETF	46.36	46.36	46.36	46.36	400.0
2011-08-12	BIB	ETF	6.65	6.8125	6.3175	6.7387	215760.0
2011-08-12	BICK	ETF	26.92	26.982	26.688	26.8324	12334.0
2011-08-12	BIL	ETF	91.72	91.72	91.7	91.72	779850.0
2011-08-12	BIS	ETF	7808.0	7808.0	7634.24	7634.24	5.95
2011-08-12	BITS	ETF	20.4	21.0	19.68	20.536	5474.0
2011-08-12	BIV	ETF	87.04	87.67	86.59	87.56	134000.0
2011-08-12	BJK	ETF	32.81	32.9	32.43	32.62	18300.0
2011-08-12	BKF	ETF	40.91	40.98	40.1902	40.74	271778.0
2011-08-12	BKLN	ETF	23.02	23.35	22.99	23.27	40000.0
2011-08-12	BLV	ETF	85.76	86.44	84.41	86.26	66600.0
2011-08-12	BMVP	ETF	13.32	13.39	13.2	13.26	13959.0
2011-08-12	BND	ETF	83.34	83.65	83.29	83.47	1140700.0
2011-08-12	BNO	ETF	36.23	36.355	35.905	36.015	204800.0
2011-08-12	BOSS	ETF	66.0	66.8	66.0	66.8	100.0

> showing 50 of 871 rows — these rows as CSV

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