PREVIEW / etf_daily / 2014-10-13

all etf daily files

  file:    by_date/etf_daily/2014/2014-10-13.parquet
  size:    46 KB
  rows:    1,133

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
2014-10-13	SPY	ETF	190.46	191.15	187.3	187.41	230939000.0
2014-10-13	QQQ	ETF	94.29	94.99	92.88	92.96	80835922.0
2014-10-13	IWM	ETF	104.84	106.11	103.86	104.32	72054300.0
2014-10-13	DIA	ETF	165.09	165.79	162.84	162.93	14117000.0
2014-10-13	GLD	ETF	118.14	118.67	117.93	118.52	5396300.0
2014-10-13	TLT	ETF	120.16	121.17	120.05	120.78	6450700.0
2014-10-13	AADR	ETF	35.08	35.3	35.08	35.3	1600.0
2014-10-13	AAXJ	ETF	60.57	61.0	60.27	60.27	627300.0
2014-10-13	ACWI	ETF	56.68	56.95	55.98	56.01	1308400.0
2014-10-13	ACWV	ETF	66.07	66.31	65.51	65.55	319800.0
2014-10-13	ACWX	ETF	43.71	43.76	43.16	43.16	1986587.0
2014-10-13	ADRE	ETF	39.21	39.8399	39.21	39.3855	35781.0
2014-10-13	AFK	ETF	29.78	29.9	29.6	29.6	31189.0
2014-10-13	AGG	ETF	110.15	110.34	110.04	110.31	1098500.0
2014-10-13	AGQ	ETF	47.84	48.29	47.22	48.13	171100.0
2014-10-13	AGZ	ETF	112.9776	113.42	112.8301	113.11	64046.0
2014-10-13	AGZD	ETF	24.995	24.995	24.685	24.855	12800.0
2014-10-13	AIA	ETF	46.34	46.57	45.94	45.94	70821.0
2014-10-13	AIQ	ETF	21.79	22.76	21.31	21.59	42971.0
2014-10-13	AIRR	ETF	17.24	17.38	17.06	17.09	380900.0
2014-10-13	AIVI	ETF	44.55	44.65	43.97	43.97	17600.0
2014-10-13	AMJ	ETF	48.57	49.23	46.18	46.28	1995817.0
2014-10-13	AMLP	ETF	90.8	91.3	86.55	86.55	1690520.0
2014-10-13	AMZA	ETF	235.0	235.0	221.5	221.5	990.0
2014-10-13	ANGL	ETF	27.49	27.49	27.48	27.49	2900.0
2014-10-13	AOA	ETF	44.07	44.24	43.65	43.65	59600.0
2014-10-13	AOK	ETF	32.14	32.14	31.97	31.9728	40758.0
2014-10-13	AOM	ETF	34.3	34.3799	34.15	34.15	36336.0
2014-10-13	AOR	ETF	38.53	38.632	38.27	38.27	89679.0
2014-10-13	ARGT	ETF	19.32	19.32	18.98	18.98	10100.0
2014-10-13	ARKQ	ETF	18.66	18.75	18.54	18.75	3900.0
2014-10-13	ARKW	ETF	18.89	18.97	18.71	18.966	4000.0
2014-10-13	ASEA	ETF	16.33	16.37	16.29	16.35	3300.0
2014-10-13	ASHR	ETF	25.79	25.9	25.58	25.63	569100.0
2014-10-13	ASHS	ETF	34.2	34.2	33.94	33.94	3800.0
2014-10-13	ATMP	ETF	29.77	29.87	28.44	28.45	13400.0
2014-10-13	AVIV	ETF	27.73	28.24	27.7	27.86	127159.0
2014-10-13	AWAY	ETF	34.01	34.58	33.58	33.67	1394636.0
2014-10-13	BAB	ETF	30.02	30.2	30.02	30.12	72939.0
2014-10-13	BAL	ETF	43.0401	43.9	43.0401	43.78	8126.0
2014-10-13	BALT	ETF	3.18	3.24	2.97	2.97	754847.0
2014-10-13	BAR	ETF	3.165	3.207	3.165	3.207	76610.0
2014-10-13	BBH	ETF	101.26	101.85	98.63	98.87	127400.0
2014-10-13	BCHP	ETF	17.69	17.6962	17.69	17.6962	253.0
2014-10-13	BCM	ETF	36.5	36.561	36.5	36.502	4437.0
2014-10-13	BFOR	ETF	7.185	7.215	7.07	7.0775	454400.0
2014-10-13	BIB	ETF	47.765	48.39	45.12	45.685	917384.0
2014-10-13	BICK	ETF	24.72	24.9121	24.67	24.88	2766.0
2014-10-13	BIL	ETF	91.5	91.5	91.48	91.5	722250.0
2014-10-13	BIS	ETF	516.0	545.2	510.0	540.0	27011.0

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

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