PREVIEW / etf_daily / 2013-12-02

all etf daily files

  file:    by_date/etf_daily/2013/2013-12-02.parquet
  size:    43 KB
  rows:    1,052

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
2013-12-02	SPY	ETF	181.09	181.43	180.25	180.53	99726000.0
2013-12-02	QQQ	ETF	85.83	85.96	85.35	85.48	26354619.0
2013-12-02	IWM	ETF	113.7	113.76	112.06	112.37	43155200.0
2013-12-02	DIA	ETF	160.76	160.84	159.71	159.92	5655700.0
2013-12-02	GLD	ETF	119.2	119.29	117.5	117.58	10297100.0
2013-12-02	TLT	ETF	103.8	103.91	103.22	103.33	7527800.0
2013-12-02	AADR	ETF	37.49	37.49	37.17	37.21	400.0
2013-12-02	AAXJ	ETF	61.25	61.25	60.14	60.14	864100.0
2013-12-02	ACWI	ETF	56.87	56.96	56.57	56.59	1374100.0
2013-12-02	ACWV	ETF	64.29	64.29	63.9	63.9	27600.0
2013-12-02	ACWX	ETF	46.37	46.37	46.09	46.12	136226.0
2013-12-02	ADRE	ETF	37.86	37.88	37.4	37.4	26963.0
2013-12-02	AFK	ETF	31.03	31.1499	30.88	30.97	14596.0
2013-12-02	AGG	ETF	107.1	107.12	106.83	106.83	1518700.0
2013-12-02	AGQ	ETF	64.48	65.0	61.48	61.76	876025.0
2013-12-02	AGZ	ETF	111.84	111.84	111.25	111.3	9820.0
2013-12-02	AIA	ETF	49.25	49.25	48.85	48.86	7424.0
2013-12-02	AIQ	ETF	29.01	29.23	25.7	26.85	45012.0
2013-12-02	AIVI	ETF	47.02	47.02	46.74	46.74	22700.0
2013-12-02	AMJ	ETF	45.62	45.96	45.11	45.13	559744.0
2013-12-02	AMLP	ETF	88.45	88.55	87.65	87.8	422500.0
2013-12-02	ANGL	ETF	27.03	27.16	26.91	26.95	7700.0
2013-12-02	AOA	ETF	43.96	44.03	43.8	43.81	13000.0
2013-12-02	AOK	ETF	31.91	31.94	31.89	31.89	11832.0
2013-12-02	AOM	ETF	34.17	34.18	34.08	34.09	29855.0
2013-12-02	AOR	ETF	38.17	38.22	38.07	38.07	21625.0
2013-12-02	ARGT	ETF	20.9	20.9	20.31	20.31	33200.0
2013-12-02	ASEA	ETF	16.32	16.36	16.16	16.18	3200.0
2013-12-02	ASHR	ETF	25.57	25.57	25.13	25.15	661800.0
2013-12-02	ATMP	ETF	26.58	26.58	26.49	26.49	2600.0
2013-12-02	AVIV	ETF	25.63	25.68	24.72	24.83	156251.0
2013-12-02	AWAY	ETF	36.36	36.72	35.87	36.59	1063713.0
2013-12-02	BAB	ETF	27.55	27.5899	27.48	27.4848	76301.0
2013-12-02	BAL	ETF	49.56	49.82	49.28	49.2997	24421.0
2013-12-02	BALT	ETF	5.12	5.2	4.92	4.93	771449.0
2013-12-02	BBH	ETF	87.25	87.96	86.87	87.9	63200.0
2013-12-02	BCM	ETF	39.11	39.144	39.03	39.144	1411.0
2013-12-02	BFOR	ETF	7.34	7.34	7.2775	7.28	236400.0
2013-12-02	BIB	ETF	37.115	37.185	36.38	37.185	136796.0
2013-12-02	BICK	ETF	24.82	24.82	24.65	24.65	2401.0
2013-12-02	BIL	ETF	91.56	91.58	91.56	91.56	187800.0
2013-12-02	BIS	ETF	866.0	868.88	850.04	855.6	466.0
2013-12-02	BIV	ETF	83.36	83.42	83.18	83.28	309400.0
2013-12-02	BIZD	ETF	21.6	21.6	21.33	21.33	6500.0
2013-12-02	BJK	ETF	50.17	50.42	50.08	50.13	26700.0
2013-12-02	BKF	ETF	38.49	38.49	37.84	37.88	90898.0
2013-12-02	BKLN	ETF	24.85	24.85	24.8	24.84	2785400.0
2013-12-02	BLV	ETF	82.5	82.5	81.91	82.04	263400.0
2013-12-02	BMVP	ETF	22.4733	22.5633	22.4046	22.4266	37300.0
2013-12-02	BND	ETF	80.66	80.71	80.5	80.5	1297500.0

> showing 50 of 1,052 rows — these rows as CSV

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