PREVIEW / etf_daily / 2013-11-13

all etf daily files

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

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-13	SPY	ETF	176.09	178.43	176.09	178.38	103844000.0
2013-11-13	QQQ	ETF	82.01	83.55	82.0	83.54	31345887.0
2013-11-13	IWM	ETF	108.66	110.55	108.62	110.52	36465900.0
2013-11-13	DIA	ETF	156.52	158.12	156.5	158.06	5062900.0
2013-11-13	GLD	ETF	122.97	123.24	122.39	122.85	5967000.0
2013-11-13	TLT	ETF	103.87	104.04	103.74	103.88	5782900.0
2013-11-13	AADR	ETF	35.85	36.17	35.85	36.17	26100.0
2013-11-13	AAXJ	ETF	57.98	58.57	57.82	58.51	271800.0
2013-11-13	ACTV	ETF	14.49	14.49	14.48	14.48	849326.0
2013-11-13	ACWI	ETF	55.51	56.14	55.41	56.14	586500.0
2013-11-13	ACWV	ETF	63.8	64.24	63.8	64.24	7400.0
2013-11-13	ACWX	ETF	45.31	45.75	45.21	45.75	119332.0
2013-11-13	ADRE	ETF	36.51	37.06	36.51	37.06	15777.0
2013-11-13	AFK	ETF	30.85	30.87	30.5775	30.87	25229.0
2013-11-13	AGG	ETF	106.94	107.04	106.87	107.0	673300.0
2013-11-13	AGQ	ETF	72.24	72.56	70.44	71.0	396150.0
2013-11-13	AGZ	ETF	111.11	111.62	111.08	111.51	242725.0
2013-11-13	AIA	ETF	46.5761	46.89	46.5739	46.88	6515.0
2013-11-13	AIQ	ETF	25.51	25.96	24.12	24.25	22012.0
2013-11-13	AIVI	ETF	46.16	46.74	46.07	46.74	12600.0
2013-11-13	ALTL	ETF	31.43	31.6834	31.43	31.6834	489.0
2013-11-13	AMJ	ETF	45.05	45.2601	44.9	45.05	641018.0
2013-11-13	AMLP	ETF	86.95	87.2	86.6	86.85	587140.0
2013-11-13	ANGL	ETF	26.67	26.67	26.62	26.62	1800.0
2013-11-13	AOA	ETF	43.04	43.47	43.02	43.47	16200.0
2013-11-13	AOK	ETF	31.65	31.77	31.6275	31.74	29544.0
2013-11-13	AOM	ETF	33.75	33.94	33.75	33.9	24450.0
2013-11-13	AOR	ETF	37.58	37.84	37.58	37.8	30509.0
2013-11-13	ARGT	ETF	19.12	19.34	19.12	19.28	2700.0
2013-11-13	ASEA	ETF	16.48	16.56	16.39	16.56	11000.0
2013-11-13	ASHR	ETF	24.03	24.13	24.0	24.11	45400.0
2013-11-13	ATMP	ETF	26.44	26.49	26.42	26.46	16800.0
2013-11-13	AVIV	ETF	25.12	25.32	24.41	24.89	255280.0
2013-11-13	AWAY	ETF	34.15	35.12	34.14	34.85	3002540.0
2013-11-13	BAB	ETF	27.4	27.4599	27.39	27.43	168094.0
2013-11-13	BAL	ETF	49.11	49.4	49.0	49.11	17572.0
2013-11-13	BALT	ETF	4.66	4.96	4.64	4.95	3653336.0
2013-11-13	BBH	ETF	79.75	81.55	79.75	81.39	128300.0
2013-11-13	BFOR	ETF	7.1	7.1775	7.085	7.1775	173200.0
2013-11-13	BIB	ETF	30.7775	31.745	30.4783	31.685	76504.0
2013-11-13	BICK	ETF	23.58	23.66	23.58	23.66	2427.0
2013-11-13	BIL	ETF	91.56	91.58	91.56	91.58	117500.0
2013-11-13	BIS	ETF	1040.74	1041.596	1000.84	1006.4	272.0
2013-11-13	BIV	ETF	83.48	83.6	83.42	83.53	187300.0
2013-11-13	BIZD	ETF	20.67	20.78	20.65	20.78	4200.0
2013-11-13	BJK	ETF	48.82	49.65	48.82	49.54	13100.0
2013-11-13	BKF	ETF	36.58	37.1	36.5007	37.09	23189.0
2013-11-13	BKLN	ETF	24.89	24.92	24.89	24.92	2122600.0
2013-11-13	BLV	ETF	82.03	82.14	82.0	82.07	70100.0
2013-11-13	BMVP	ETF	21.6433	21.86	21.6233	21.86	9265.0

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

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