PREVIEW / etf_daily / 2011-10-07

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-07.parquet
  size:    37 KB
  rows:    877

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-10-07	SPY	ETF	117.17	117.25	115.06	115.71	312657900.0
2011-10-07	QQQ	ETF	54.41	54.66	53.72	54.07	72525198.0
2011-10-07	IWM	ETF	67.38	67.61	65.2	65.5	93662300.0
2011-10-07	DIA	ETF	111.87	112.21	110.38	111.02	10022000.0
2011-10-07	GLD	ETF	161.02	161.58	158.23	159.18	12977400.0
2011-10-07	TLT	ETF	117.75	119.05	116.85	118.24	11564600.0
2011-10-07	AADR	ETF	26.38	26.4	26.24	26.4	1800.0
2011-10-07	AAXJ	ETF	48.84	48.84	47.64	47.89	332700.0
2011-10-07	ACTV	ETF	15.68	15.74	14.27	14.4	62686.0
2011-10-07	ACWI	ETF	40.88	40.88	39.92	40.07	1659400.0
2011-10-07	ACWX	ETF	36.46	36.56	35.856	35.91	183684.0
2011-10-07	ADRE	ETF	37.4	37.62	36.39	36.62	59019.0
2011-10-07	AFK	ETF	26.45	26.52	26.03	26.33	10807.0
2011-10-07	AGEM	ETF	20.59	20.6	19.93	20.11	19258.0
2011-10-07	AGG	ETF	109.23	109.37	109.03	109.23	1513800.0
2011-10-07	AGQ	ETF	242.76	246.3	218.76	224.02	1093250.0
2011-10-07	AGZ	ETF	112.33	112.51	111.49	112.25	419056.0
2011-10-07	AIA	ETF	38.01	38.01	37.0529	37.26	46855.0
2011-10-07	AIQ	ETF	5.95	6.0	5.5	5.6	26411.0
2011-10-07	AIS	ETF	2.23	2.23	2.09	2.11	761479.0
2011-10-07	AIVI	ETF	40.07	40.1	39.36	39.52	49400.0
2011-10-07	AMJ	ETF	34.51	34.73	33.8	33.94	198681.0
2011-10-07	AMLP	ETF	76.4	76.5	75.3	76.0	132440.0
2011-10-07	AOA	ETF	31.22	31.22	30.82	30.85	1300.0
2011-10-07	AOK	ETF	28.75	28.75	28.65	28.67	19316.0
2011-10-07	AOM	ETF	29.14	29.1484	29.01	29.12	7859.0
2011-10-07	AOR	ETF	29.98	29.98	29.6841	29.73	73914.0
2011-10-07	ARB	ETF	36.62	36.78	35.54	35.98	204006.0
2011-10-07	ASEA	ETF	14.01	14.1	13.89	14.1	2400.0
2011-10-07	AWAY	ETF	35.41	36.0	33.64	35.22	119891.0
2011-10-07	BAB	ETF	28.51	28.74	28.01	28.695	202110.0
2011-10-07	BAL	ETF	63.3	63.45	62.75	63.44	10789.0
2011-10-07	BALT	ETF	4.85	4.91	4.55	4.6	95350.0
2011-10-07	BBH	ETF	33.34	33.5467	33.06	33.3433	71100.0
2011-10-07	BCM	ETF	42.19	42.19	41.96	42.0	3930.0
2011-10-07	BIB	ETF	7.2625	7.3155	7.1151	7.135	31840.0
2011-10-07	BICK	ETF	23.0	23.14	22.54	22.709	11925.0
2011-10-07	BIL	ETF	91.68	91.7	91.68	91.7	750650.0
2011-10-07	BIS	ETF	6729.6	6793.6	6650.24	6693.44	21.15
2011-10-07	BITS	ETF	21.32	22.0	20.52	20.8	1325.0
2011-10-07	BIV	ETF	86.5	86.88	86.45	86.73	627700.0
2011-10-07	BJK	ETF	29.37	29.5	28.73	29.01	29100.0
2011-10-07	BKF	ETF	35.38	35.4893	34.54	34.72	176034.0
2011-10-07	BKLN	ETF	22.81	23.0	22.46	22.84	106100.0
2011-10-07	BLNG	ETF	50.21	50.21	49.64	49.8301	2379.0
2011-10-07	BLV	ETF	89.93	90.84	89.53	90.41	100600.0
2011-10-07	BMVP	ETF	12.77	12.77	12.46	12.65	6912.0
2011-10-07	BND	ETF	83.08	83.25	82.97	83.08	4949900.0
2011-10-07	BNO	ETF	35.655	35.855	35.25	35.675	80600.0
2011-10-07	BOIL	ETF	3754000.0	3754000.0	3652000.0	3675990.0	0.07

> showing 50 of 877 rows — these rows as CSV

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