PREVIEW / etf_daily / 2013-12-30

all etf daily files

  file:    by_date/etf_daily/2013/2013-12-30.parquet
  size:    43 KB
  rows:    1,066

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-30	SPY	ETF	183.87	184.02	183.58	183.82	56857000.0
2013-12-30	QQQ	ETF	87.4	87.51	87.14	87.39	18985622.0
2013-12-30	IWM	ETF	115.11	115.37	114.85	115.09	28917400.0
2013-12-30	DIA	ETF	164.55	164.68	164.4	164.59	4043600.0
2013-12-30	GLD	ETF	116.37	116.4	115.18	115.39	6703200.0
2013-12-30	TLT	ETF	102.15	102.58	102.08	102.51	4491700.0
2013-12-30	AADR	ETF	37.63	37.63	37.6	37.6	1600.0
2013-12-30	AAXJ	ETF	59.67	59.88	59.6	59.84	343000.0
2013-12-30	ACWI	ETF	57.34	57.42	57.28	57.38	652000.0
2013-12-30	ACWV	ETF	63.56	63.56	63.37	63.55	27500.0
2013-12-30	ACWX	ETF	46.45	46.502	46.3601	46.46	232865.0
2013-12-30	ADRE	ETF	36.83	37.0705	36.83	36.97	49344.0
2013-12-30	AFK	ETF	30.65	30.7999	30.47	30.62	25587.0
2013-12-30	AGG	ETF	106.51	106.59	106.44	106.53	1226500.0
2013-12-30	AGQ	ETF	64.48	65.0	63.16	64.04	370450.0
2013-12-30	AGZ	ETF	110.96	110.96	110.5	110.58	34373.0
2013-12-30	AGZD	ETF	24.99	24.99	24.99	24.99	12000.0
2013-12-30	AIA	ETF	47.61	47.709	47.54	47.64	25764.0
2013-12-30	AIQ	ETF	25.11	25.64	25.0	25.3	39290.0
2013-12-30	AIVI	ETF	47.45	47.48	47.35	47.44	29100.0
2013-12-30	AMJ	ETF	45.81	46.33	45.8	46.23	400322.0
2013-12-30	AMLP	ETF	88.25	88.8	88.15	88.7	479440.0
2013-12-30	ANGL	ETF	26.92	27.04	26.87	27.04	1500.0
2013-12-30	AOA	ETF	44.45	44.52	44.42	44.52	25000.0
2013-12-30	AOK	ETF	32.0	32.0	31.95	31.9893	18146.0
2013-12-30	AOM	ETF	34.29	34.3	34.2301	34.3	71988.0
2013-12-30	AOR	ETF	38.43	38.45	38.38	38.44	26620.0
2013-12-30	ARGT	ETF	19.81	19.88	19.51	19.51	3500.0
2013-12-30	ASEA	ETF	15.38	15.38	15.35	15.37	31200.0
2013-12-30	ASHR	ETF	24.29	24.3	24.2	24.2	235700.0
2013-12-30	ATMP	ETF	27.49	27.49	27.15	27.48	36300.0
2013-12-30	AVIV	ETF	23.63	23.89	23.61	23.84	73674.0
2013-12-30	AWAY	ETF	40.24	40.76	39.91	40.65	590164.0
2013-12-30	BAB	ETF	27.41	27.45	27.37	27.43	209750.0
2013-12-30	BAL	ETF	52.94	53.47	52.94	53.19	16145.0
2013-12-30	BALT	ETF	6.35	6.39	6.0296	6.2	1594380.0
2013-12-30	BBH	ETF	88.25	88.56	87.43	88.51	78200.0
2013-12-30	BCM	ETF	39.76	39.84	39.6033	39.65	257790.0
2013-12-30	BFOR	ETF	7.4525	7.4525	7.4175	7.4425	253600.0
2013-12-30	BIB	ETF	37.155	37.7375	36.7375	37.495	125388.0
2013-12-30	BICK	ETF	24.63	24.6952	24.58	24.61	4235.0
2013-12-30	BIL	ETF	91.58	91.58	91.56	91.58	83650.0
2013-12-30	BIS	ETF	848.0	848.0	830.0	832.0	360.5
2013-12-30	BIV	ETF	81.84	82.03	81.82	81.96	527900.0
2013-12-30	BIZD	ETF	21.08	21.08	20.92	20.95	15600.0
2013-12-30	BJK	ETF	52.95	53.04	52.74	52.98	12600.0
2013-12-30	BKF	ETF	37.49	37.64	37.4	37.43	48356.0
2013-12-30	BKLN	ETF	24.85	24.86	24.84	24.86	1820900.0
2013-12-30	BLNG	ETF	34.31	34.37	34.31	34.3299	875.0
2013-12-30	BLV	ETF	81.97	82.1	81.83	82.04	68000.0

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

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