PREVIEW / etf_daily / 2013-11-20

all etf daily files

  file:    by_date/etf_daily/2013/2013-11-20.parquet
  size:    43 KB
  rows:    1,050

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-20	SPY	ETF	179.39	179.93	177.98	178.47	124909000.0
2013-11-20	QQQ	ETF	83.14	83.4301	82.455	82.7	32177418.0
2013-11-20	IWM	ETF	109.93	110.2	108.85	109.33	43376700.0
2013-11-20	DIA	ETF	159.55	159.88	158.35	158.77	8401100.0
2013-11-20	GLD	ETF	121.67	122.44	119.76	120.12	14281000.0
2013-11-20	TLT	ETF	104.42	104.84	102.65	102.78	14190900.0
2013-11-20	AADR	ETF	36.48	36.48	36.11	36.11	400.0
2013-11-20	AAXJ	ETF	60.69	60.89	60.11	60.17	688700.0
2013-11-20	ACWI	ETF	56.76	56.81	56.16	56.27	766200.0
2013-11-20	ACWV	ETF	64.35	64.51	64.1	64.12	13600.0
2013-11-20	ACWX	ETF	46.55	46.55	45.973	46.04	791225.0
2013-11-20	ADRE	ETF	38.43	38.5001	37.98	38.05	11688.0
2013-11-20	AFK	ETF	31.5	31.6	31.18	31.18	11213.0
2013-11-20	AGG	ETF	107.34	107.46	106.94	106.98	984800.0
2013-11-20	AGQ	ETF	69.28	69.84	66.0	66.4	740050.0
2013-11-20	AGZ	ETF	111.76	111.96	111.52	111.54	50376.0
2013-11-20	AIA	ETF	49.13	49.13	48.66	48.66	7910.0
2013-11-20	AIQ	ETF	24.52	25.5	24.04	24.06	83918.0
2013-11-20	AIVI	ETF	47.04	47.08	46.61	46.67	41200.0
2013-11-20	ALTL	ETF	31.665	31.665	31.665	31.665	100.0
2013-11-20	AMJ	ETF	45.21	45.7	45.15	45.3	591079.0
2013-11-20	AMLP	ETF	87.0	87.55	86.9	87.15	943980.0
2013-11-20	ANGL	ETF	26.88	26.88	26.72	26.73	1300.0
2013-11-20	AOA	ETF	43.72	43.82	43.42	43.42	53200.0
2013-11-20	AOK	ETF	31.9	31.9	31.7501	31.78	19290.0
2013-11-20	AOM	ETF	34.06	34.096	33.898	33.95	24495.0
2013-11-20	AOR	ETF	38.04	38.09	37.79	37.83	20566.0
2013-11-20	ARGT	ETF	19.99	19.99	19.56	19.56	3400.0
2013-11-20	ASEA	ETF	16.59	16.63	16.48	16.48	5800.0
2013-11-20	ASHR	ETF	25.59	25.59	25.4	25.43	555600.0
2013-11-20	ATMP	ETF	26.71	26.71	26.57	26.58	5500.0
2013-11-20	AVIV	ETF	25.61	25.98	25.21	25.67	221549.0
2013-11-20	AWAY	ETF	36.15	36.94	35.81	36.49	1947796.0
2013-11-20	BAB	ETF	27.53	27.6099	27.29	27.33	198747.0
2013-11-20	BAL	ETF	49.5	49.51	48.89	48.89	11801.0
2013-11-20	BALT	ETF	4.67	4.76	4.63	4.7	478015.0
2013-11-20	BBH	ETF	82.88	84.18	82.81	83.25	61500.0
2013-11-20	BCM	ETF	38.87	38.89	38.834	38.834	3728.0
2013-11-20	BFOR	ETF	7.1775	7.185	7.11	7.1275	193600.0
2013-11-20	BIB	ETF	32.625	33.3725	32.125	32.7	181836.0
2013-11-20	BICK	ETF	24.75	24.75	24.72	24.72	650.0
2013-11-20	BIL	ETF	91.58	91.58	91.56	91.56	108300.0
2013-11-20	BIS	ETF	983.2	983.2	953.6	972.0	244.0
2013-11-20	BIV	ETF	83.66	83.84	83.35	83.42	175700.0
2013-11-20	BIZD	ETF	21.13	21.14	21.06	21.06	19000.0
2013-11-20	BJK	ETF	49.27	49.27	48.57	48.63	15000.0
2013-11-20	BKF	ETF	38.98	38.98	38.4199	38.45	49357.0
2013-11-20	BKLN	ETF	24.82	24.83	24.81	24.81	2632000.0
2013-11-20	BLV	ETF	82.64	82.94	81.66	81.78	65800.0
2013-11-20	BMVP	ETF	21.98	22.0333	21.78	21.8127	7672.0

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

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