PREVIEW / etf_daily / 2013-11-11

all etf daily files

  file:    by_date/etf_daily/2013/2013-11-11.parquet
  size:    42 KB
  rows:    1,049

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-11-11	SPY	ETF	177.12	177.53	176.91	177.32	62614000.0
2013-11-11	QQQ	ETF	82.39	82.64	82.14	82.41	24822945.0
2013-11-11	IWM	ETF	109.04	109.6	108.64	109.38	19897700.0
2013-11-11	DIA	ETF	157.33	157.73	157.15	157.61	3795200.0
2013-11-11	GLD	ETF	123.92	123.97	123.66	123.87	3277700.0
2013-11-11	TLT	ETF	103.53	103.58	102.96	103.02	4927200.0
2013-11-11	AADR	ETF	36.4	36.4	36.1	36.18	20100.0
2013-11-11	AAXJ	ETF	58.88	59.11	58.83	58.85	216800.0
2013-11-11	ACTV	ETF	14.47	14.49	14.47	14.48	459823.0
2013-11-11	ACWI	ETF	55.95	56.02	55.86	55.96	588600.0
2013-11-11	ACWV	ETF	64.16	64.16	63.88	63.95	26200.0
2013-11-11	ACWX	ETF	45.78	45.79	45.71	45.73	121417.0
2013-11-11	ADRE	ETF	37.24	37.32	37.13	37.18	9866.0
2013-11-11	AFK	ETF	31.29	31.29	30.96	31.01	56198.0
2013-11-11	AGG	ETF	106.82	106.83	106.68	106.76	1281400.0
2013-11-11	AGQ	ETF	77.04	77.28	76.48	77.04	120350.0
2013-11-11	AGZ	ETF	109.9401	113.078	109.9401	111.1112	2766.0
2013-11-11	AIA	ETF	47.64	47.64	47.33	47.34	29996.0
2013-11-11	AIQ	ETF	24.47	24.75	23.79	23.89	35823.0
2013-11-11	AIVI	ETF	46.8	46.87	46.78	46.85	15900.0
2013-11-11	AMJ	ETF	45.6	45.694	45.16	45.24	485472.0
2013-11-11	AMLP	ETF	87.35	87.8	87.0	87.15	423020.0
2013-11-11	ANGL	ETF	26.7	26.8	26.5	26.8	1700.0
2013-11-11	AOA	ETF	43.27	43.34	43.23	43.32	10200.0
2013-11-11	AOK	ETF	31.72	31.72	31.67	31.71	16951.0
2013-11-11	AOM	ETF	33.8	33.862	33.7897	33.85	63648.0
2013-11-11	AOR	ETF	37.7	37.75	37.63	37.75	79945.0
2013-11-11	ARGT	ETF	19.54	19.77	19.54	19.74	8600.0
2013-11-11	ASEA	ETF	16.78	16.78	16.6	16.62	5100.0
2013-11-11	ASHR	ETF	24.5	24.53	24.47	24.5	104100.0
2013-11-11	ATMP	ETF	26.45	26.61	26.45	26.52	23800.0
2013-11-11	AVIV	ETF	25.03	25.64	25.03	25.37	238657.0
2013-11-11	AWAY	ETF	32.64	33.93	32.63	33.29	1197318.0
2013-11-11	BAB	ETF	27.39	27.4699	27.27	27.275	101036.0
2013-11-11	BAL	ETF	48.86	49.15	48.749	48.749	4340.0
2013-11-11	BALT	ETF	4.71	5.07	4.71	5.02	649794.0
2013-11-11	BBH	ETF	80.53	80.72	79.7	80.55	44100.0
2013-11-11	BFOR	ETF	7.1025	7.1175	7.075	7.1125	410800.0
2013-11-11	BIB	ETF	31.0475	31.2647	30.4488	31.05	193488.0
2013-11-11	BICK	ETF	23.75	23.8524	23.72	23.75	1946.0
2013-11-11	BIL	ETF	91.56	91.58	91.56	91.58	125500.0
2013-11-11	BIS	ETF	1033.2	1037.52	1017.64	1026.336	157.5
2013-11-11	BIV	ETF	83.37	83.46	83.22	83.33	394000.0
2013-11-11	BIZD	ETF	20.42	20.75	20.42	20.75	3200.0
2013-11-11	BJK	ETF	49.03	49.47	49.03	49.43	14200.0
2013-11-11	BKF	ETF	37.38	37.509	37.21	37.27	66259.0
2013-11-11	BKLN	ETF	24.88	24.88	24.86	24.87	1022500.0
2013-11-11	BLV	ETF	81.69	81.85	81.5	81.64	130300.0
2013-11-11	BMVP	ETF	21.6033	21.6433	21.5534	21.64	2676.0
2013-11-11	BND	ETF	80.59	80.59	80.5	80.51	1695300.0

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

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