PREVIEW / etf_daily / 2013-12-03

all etf daily files

  file:    by_date/etf_daily/2013/2013-12-03.parquet
  size:    42 KB
  rows:    1,048

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-03	SPY	ETF	179.94	180.39	179.17	179.75	116563000.0
2013-12-03	QQQ	ETF	85.42	85.64	85.08	85.41	37154262.0
2013-12-03	IWM	ETF	112.13	112.6	111.27	111.83	36930700.0
2013-12-03	DIA	ETF	159.23	159.62	158.46	158.99	8660700.0
2013-12-03	GLD	ETF	117.58	118.31	117.23	117.96	7004800.0
2013-12-03	TLT	ETF	103.7	103.96	103.46	103.71	5076900.0
2013-12-03	AADR	ETF	36.58	36.7	36.58	36.62	3600.0
2013-12-03	AAXJ	ETF	60.41	60.47	59.89	60.3	416800.0
2013-12-03	ACWI	ETF	56.43	56.5	56.14	56.31	987300.0
2013-12-03	ACWV	ETF	63.86	63.92	63.6	63.81	23700.0
2013-12-03	ACWX	ETF	45.91	45.96	45.63	45.78	1445773.0
2013-12-03	ADRE	ETF	37.32	37.47	37.01	37.18	7330.0
2013-12-03	AFK	ETF	30.74	30.93	30.6	30.67	24987.0
2013-12-03	AGG	ETF	106.97	107.02	106.9	106.96	1478600.0
2013-12-03	AGQ	ETF	60.88	61.92	60.48	61.32	323200.0
2013-12-03	AGZ	ETF	111.4	111.5468	111.28	111.33	7568.0
2013-12-03	AIA	ETF	48.74	48.83	48.45	48.73	8097.0
2013-12-03	AIQ	ETF	26.85	26.85	26.001	26.38	16289.0
2013-12-03	AIVI	ETF	46.54	46.59	46.28	46.35	11500.0
2013-12-03	AMJ	ETF	45.01	45.24	44.84	45.0	482678.0
2013-12-03	AMLP	ETF	87.65	87.7	87.3	87.55	474760.0
2013-12-03	ANGL	ETF	26.97	26.97	26.85	26.85	24100.0
2013-12-03	AOA	ETF	43.69	43.74	43.53	43.66	11200.0
2013-12-03	AOK	ETF	31.79	31.86	31.781	31.8	72187.0
2013-12-03	AOM	ETF	34.07	34.09	33.97	34.04	26445.0
2013-12-03	AOR	ETF	38.01	38.07	37.92	37.98	25699.0
2013-12-03	ARGT	ETF	20.37	20.37	19.73	19.81	3900.0
2013-12-03	ASEA	ETF	16.18	16.27	16.18	16.25	12400.0
2013-12-03	ASHR	ETF	25.5	25.55	25.28	25.46	219300.0
2013-12-03	ATMP	ETF	26.43	26.51	26.43	26.49	10000.0
2013-12-03	AVIV	ETF	24.74	24.839	24.36	24.39	201982.0
2013-12-03	AWAY	ETF	35.76	38.03	35.64	37.76	2322003.0
2013-12-03	BAB	ETF	27.54	27.6	27.52	27.531	74910.0
2013-12-03	BAL	ETF	49.2	49.3301	49.15	49.21	9970.0
2013-12-03	BALT	ETF	4.94	5.08	4.8	4.88	691451.0
2013-12-03	BBH	ETF	87.61	87.61	86.36	86.6	64000.0
2013-12-03	BCM	ETF	39.22	39.28	39.2	39.28	10283.0
2013-12-03	BFOR	ETF	7.27	7.275	7.2075	7.235	198400.0
2013-12-03	BIB	ETF	36.65	36.6773	35.5	35.82	222820.0
2013-12-03	BICK	ETF	24.52	24.52	24.52	24.52	600.0
2013-12-03	BIL	ETF	91.56	91.58	91.56	91.58	312850.0
2013-12-03	BIS	ETF	862.0	884.48	862.0	884.0	301.0
2013-12-03	BIV	ETF	83.36	83.46	83.3	83.31	332700.0
2013-12-03	BIZD	ETF	21.1	21.25	21.01	21.02	9400.0
2013-12-03	BJK	ETF	50.1	50.4	50.0	50.25	8800.0
2013-12-03	BKF	ETF	37.73	37.979	37.4	37.69	108435.0
2013-12-03	BKLN	ETF	24.85	24.85	24.82	24.85	1970500.0
2013-12-03	BLV	ETF	82.25	82.41	82.14	82.19	83600.0
2013-12-03	BMVP	ETF	22.3867	22.3867	22.2049	22.2667	11643.0
2013-12-03	BND	ETF	80.59	80.67	80.55	80.58	1043700.0

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

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