PREVIEW / etf_daily / 2011-12-23

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-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-12-23	SPY	ETF	125.67	126.43	125.41	126.39	92187200.0
2011-12-23	QQQ	ETF	55.68	56.08	55.581	56.08	26594530.0
2011-12-23	IWM	ETF	74.55	74.68	74.08	74.55	24333600.0
2011-12-23	DIA	ETF	121.7	122.68	121.5	122.63	2281300.0
2011-12-23	GLD	ETF	156.35	156.49	155.82	156.31	3565100.0
2011-12-23	TLT	ETF	118.56	118.71	117.74	118.27	5409700.0
2011-12-23	AADR	ETF	28.03	28.08	28.03	28.08	3400.0
2011-12-23	AAXJ	ETF	50.47	50.56	50.24	50.54	620600.0
2011-12-23	ACTV	ETF	13.4	13.4	13.17	13.27	88810.0
2011-12-23	ACWI	ETF	41.99	42.39	41.99	42.36	1145000.0
2011-12-23	ACWV	ETF	51.32	51.47	51.32	51.47	500.0
2011-12-23	ACWX	ETF	36.78	36.82	36.587	36.79	519250.0
2011-12-23	ADRE	ETF	38.3	38.44	38.21	38.38	71742.0
2011-12-23	AFK	ETF	26.1	26.14	25.75	25.89	30743.0
2011-12-23	AGEM	ETF	20.68	20.88	20.64	20.73	3076.0
2011-12-23	AGG	ETF	109.71	109.83	109.46	109.77	679700.0
2011-12-23	AGQ	ETF	190.6	191.2	186.4	186.8	225050.0
2011-12-23	AGZ	ETF	112.79	113.18	112.63	112.83	35718.0
2011-12-23	AIA	ETF	39.3735	39.63	39.35	39.48	41487.0
2011-12-23	AIQ	ETF	5.8	6.05	5.4	5.55	23081.0
2011-12-23	AIS	ETF	1.86	1.98	1.82	1.97	1397083.0
2011-12-23	AIVI	ETF	39.43	39.52	39.17	39.52	69200.0
2011-12-23	AMJ	ETF	38.19	38.48	38.16	38.47	1982001.0
2011-12-23	AMLP	ETF	82.0	82.2	81.65	82.15	222440.0
2011-12-23	AOA	ETF	33.3	33.4	33.25	33.4	14500.0
2011-12-23	AOK	ETF	29.38	29.41	29.32	29.41	18595.0
2011-12-23	AOM	ETF	30.02	30.11	30.0012	30.11	53290.0
2011-12-23	AOR	ETF	31.28	31.42	31.27	31.42	109586.0
2011-12-23	ARB	ETF	35.79	35.85	35.45	35.66	43520.0
2011-12-23	ARGT	ETF	21.78	21.78	21.78	21.78	350.0
2011-12-23	ASEA	ETF	14.93	14.94	14.79	14.86	74400.0
2011-12-23	AWAY	ETF	20.78	21.02	19.89	19.9	437962.0
2011-12-23	BAB	ETF	29.06	29.06	28.53	28.6	165472.0
2011-12-23	BAL	ETF	53.921	54.13	53.65	53.65	14227.0
2011-12-23	BALT	ETF	5.07	5.1	4.97	5.01	54995.0
2011-12-23	BBH	ETF	35.9167	36.01	35.8233	36.01	5100.0
2011-12-23	BCM	ETF	43.13	43.13	42.7601	42.7601	338.0
2011-12-23	BIB	ETF	8.4975	8.4975	8.4688	8.4688	10400.0
2011-12-23	BICK	ETF	23.15	23.24	23.13	23.19	4568.0
2011-12-23	BIL	ETF	91.68	91.68	91.52	91.68	508300.0
2011-12-23	BIS	ETF	5372.8	5443.2	5372.8	5427.2	11.2
2011-12-23	BITS	ETF	22.44	23.0	22.0	22.92	9392.0
2011-12-23	BIV	ETF	86.44	86.91	86.31	86.47	178600.0
2011-12-23	BJK	ETF	29.71	29.89	29.62	29.86	15600.0
2011-12-23	BKF	ETF	36.72	36.931	36.61	36.93	131358.0
2011-12-23	BKLN	ETF	23.95	23.95	23.83	23.85	124100.0
2011-12-23	BLV	ETF	89.95	90.82	89.71	90.14	49800.0
2011-12-23	BMVP	ETF	13.67	13.73	13.67	13.73	4615.0
2011-12-23	BND	ETF	83.04	83.38	83.01	83.29	990300.0
2011-12-23	BNO	ETF	37.51	37.545	37.35	37.35	16600.0

> showing 50 of 884 rows — these rows as CSV

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