PREVIEW / etf_daily / 2011-11-22

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-22.parquet
  size:    37 KB
  rows:    890

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-22	SPY	ETF	119.4	120.1	118.52	119.19	216494900.0
2011-11-22	QQQ	ETF	54.2	54.68	53.87	54.52	51940089.0
2011-11-22	IWM	ETF	70.13	70.63	69.3	69.67	55404700.0
2011-11-22	DIA	ETF	114.98	115.53	114.13	114.74	8396900.0
2011-11-22	GLD	ETF	164.74	165.92	164.61	165.31	12094400.0
2011-11-22	TLT	ETF	120.35	121.41	119.85	121.39	7866300.0
2011-11-22	AADR	ETF	27.44	27.46	27.11	27.13	800.0
2011-11-22	AAXJ	ETF	49.46	49.76	49.05	49.47	298400.0
2011-11-22	ACTV	ETF	13.96	14.14	13.49	14.0	181636.0
2011-11-22	ACWI	ETF	40.58	40.88	40.32	40.59	1481000.0
2011-11-22	ACWV	ETF	49.09	49.09	48.95	48.96	400.0
2011-11-22	ACWX	ETF	35.91	36.04	35.59	35.83	359872.0
2011-11-22	ADRE	ETF	38.41	38.6	37.9505	38.29	23498.0
2011-11-22	AFK	ETF	26.17	26.33	25.96	26.1975	28369.0
2011-11-22	AGEM	ETF	20.69	20.79	20.5	20.79	68696.0
2011-11-22	AGG	ETF	109.56	109.75	109.43	109.68	1051000.0
2011-11-22	AGQ	ETF	227.72	246.0	226.72	242.04	822600.0
2011-11-22	AGZ	ETF	112.66	112.7299	112.28	112.66	45640.0
2011-11-22	AIA	ETF	39.29	39.29	38.76	39.07	6060.0
2011-11-22	AIQ	ETF	5.8	5.95	5.6	5.7	26538.0
2011-11-22	AIS	ETF	2.69	2.69	2.54	2.56	3255826.0
2011-11-22	AIVI	ETF	38.6	38.71	38.21	38.35	227900.0
2011-11-22	AMJ	ETF	37.04	37.1	36.8	37.0	813420.0
2011-11-22	AMLP	ETF	79.45	79.6	79.05	79.3	169360.0
2011-11-22	AOA	ETF	31.82	31.84	31.53	31.66	10600.0
2011-11-22	AOK	ETF	28.9364	28.9536	28.88	28.91	4408.0
2011-11-22	AOM	ETF	29.42	29.42	29.33	29.3785	15261.0
2011-11-22	AOR	ETF	30.312	30.3376	30.23	30.23	3058.0
2011-11-22	ARB	ETF	38.73	39.11	37.93	38.03	73598.0
2011-11-22	ARGT	ETF	21.44	21.6	21.44	21.6	950.0
2011-11-22	ASEA	ETF	14.27	14.37	14.21	14.35	5000.0
2011-11-22	AWAY	ETF	30.69	30.89	28.71	29.25	199701.0
2011-11-22	BAB	ETF	28.69	28.919	28.62	28.9089	228556.0
2011-11-22	BAL	ETF	56.16	57.03	55.35	56.74	40514.0
2011-11-22	BALT	ETF	5.0	5.0	4.68	4.74	106393.0
2011-11-22	BBH	ETF	32.94	34.22	32.94	34.1933	39300.0
2011-11-22	BCM	ETF	43.74	43.9	43.74	43.9	1058.0
2011-11-22	BIB	ETF	7.4437	7.7188	7.4437	7.6772	31360.0
2011-11-22	BICK	ETF	23.55	23.55	23.06	23.25	20994.0
2011-11-22	BIL	ETF	91.7	91.7	91.68	91.68	631450.0
2011-11-22	BIS	ETF	6158.4	6158.4	6010.56	6010.56	25.95
2011-11-22	BITS	ETF	21.52	21.76	20.72	21.28	12375.0
2011-11-22	BIV	ETF	87.59	87.69	87.38	87.67	188900.0
2011-11-22	BJK	ETF	29.56	29.85	29.53	29.7	13300.0
2011-11-22	BKF	ETF	36.36	36.65	35.82	36.17	1112991.0
2011-11-22	BKLN	ETF	23.88	23.89	23.74	23.8	53000.0
2011-11-22	BLNG	ETF	51.36	51.68	51.36	51.68	720.0
2011-11-22	BLV	ETF	91.9	92.28	91.47	92.25	73400.0
2011-11-22	BMVP	ETF	13.033	13.11	13.0	13.023	1735.0
2011-11-22	BND	ETF	83.63	83.73	83.51	83.69	1217400.0

> showing 50 of 890 rows — these rows as CSV

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