PREVIEW / etf_daily / 2011-11-23

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-23.parquet
  size:    37 KB
  rows:    884

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-11-23	SPY	ETF	118.07	119.19	116.56	116.56	224329100.0
2011-11-23	QQQ	ETF	54.11	54.17	53.26	53.29	48467335.0
2011-11-23	IWM	ETF	68.9	69.09	67.37	67.48	69700300.0
2011-11-23	DIA	ETF	113.75	113.89	112.33	112.33	7988400.0
2011-11-23	GLD	ETF	164.55	165.37	163.12	164.83	11483300.0
2011-11-23	TLT	ETF	121.16	123.05	121.03	122.58	10129300.0
2011-11-23	AAXJ	ETF	48.77	48.77	48.06	48.14	349900.0
2011-11-23	ACTV	ETF	13.84	13.84	12.96	13.01	384649.0
2011-11-23	ACWI	ETF	40.28	40.28	39.6	39.64	368600.0
2011-11-23	ACWV	ETF	48.95	48.95	48.21	48.21	300.0
2011-11-23	ACWX	ETF	35.4	35.4	34.76	34.79	507148.0
2011-11-23	ADRE	ETF	37.79	37.79	37.041	37.041	45277.0
2011-11-23	AFK	ETF	25.98	26.01	25.66	25.68	10535.0
2011-11-23	AGEM	ETF	20.33	20.41	20.159	20.29	32559.0
2011-11-23	AGG	ETF	109.6	109.94	109.54	109.78	865500.0
2011-11-23	AGQ	ETF	227.04	232.04	222.0	227.2	663800.0
2011-11-23	AGZ	ETF	112.79	112.79	112.3916	112.67	22386.0
2011-11-23	AIA	ETF	38.44	38.44	37.98	38.01	7458.0
2011-11-23	AIQ	ETF	5.7	5.8	5.6	5.6	17285.0
2011-11-23	AIS	ETF	2.57	2.58	2.48	2.53	1105288.0
2011-11-23	AIVI	ETF	37.99	37.99	37.32	37.34	64800.0
2011-11-23	AMJ	ETF	36.8	36.96	36.37	36.54	1068386.0
2011-11-23	AMLP	ETF	79.0	80.0	78.55	78.75	164860.0
2011-11-23	AOA	ETF	31.41	31.41	31.0	31.13	4200.0
2011-11-23	AOK	ETF	28.83	28.8692	28.8	28.81	7072.0
2011-11-23	AOM	ETF	29.29	29.29	29.14	29.192	8368.0
2011-11-23	AOR	ETF	30.11	30.11	29.8723	29.97	15655.0
2011-11-23	ARB	ETF	37.59	37.7581	36.51	36.66	103008.0
2011-11-23	ARGT	ETF	21.5	21.52	20.96	20.96	800.0
2011-11-23	ASEA	ETF	14.14	14.14	14.0	14.12	1100.0
2011-11-23	AWAY	ETF	28.92	28.93	27.3	27.63	663150.0
2011-11-23	BAB	ETF	28.74	29.18	28.66	29.07	411104.0
2011-11-23	BAL	ETF	56.1	56.55	55.89	56.04	19100.0
2011-11-23	BALT	ETF	4.69	4.73	4.43	4.52	90933.0
2011-11-23	BBH	ETF	34.1033	34.16	33.8033	33.8467	46800.0
2011-11-23	BCM	ETF	43.22	43.47	43.2	43.2	794.0
2011-11-23	BIB	ETF	7.5088	7.517	7.4212	7.5	21592.0
2011-11-23	BICK	ETF	22.59	22.67	22.408	22.43	7013.0
2011-11-23	BIL	ETF	91.7	91.7	91.66	91.7	877150.0
2011-11-23	BIS	ETF	6236.8	6244.8	6200.0	6244.8	5.35
2011-11-23	BITS	ETF	21.28	21.6	21.2	21.28	750.0
2011-11-23	BIV	ETF	87.45	87.74	87.35	87.74	146900.0
2011-11-23	BJK	ETF	29.55	29.55	28.91	29.07	22400.0
2011-11-23	BKF	ETF	35.7	35.7773	35.1505	35.2	92179.0
2011-11-23	BKLN	ETF	23.78	23.79	23.64	23.65	103300.0
2011-11-23	BLV	ETF	92.04	92.9	91.97	92.71	53100.0
2011-11-23	BMVP	ETF	12.82	12.82	12.73	12.74	17785.0
2011-11-23	BND	ETF	83.6	83.83	83.57	83.78	1525400.0
2011-11-23	BNO	ETF	37.24	37.285	37.055	37.185	71000.0
2011-11-23	BOIL	ETF	2888000.0	3083000.0	2864000.0	3083000.0	0.2

> showing 50 of 884 rows — these rows as CSV

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