PREVIEW / etf_daily / 2013-12-27

all etf daily files

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

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-27	SPY	ETF	184.1	184.18	183.66	183.85	61814000.0
2013-12-27	QQQ	ETF	87.83	87.9	87.412	87.52	15831962.0
2013-12-27	IWM	ETF	115.47	115.74	114.78	115.16	20069700.0
2013-12-27	DIA	ETF	164.76	164.92	164.22	164.47	6176900.0
2013-12-27	GLD	ETF	117.31	117.38	116.85	117.12	4206200.0
2013-12-27	TLT	ETF	102.07	102.31	101.69	101.81	4755000.0
2013-12-27	AADR	ETF	37.6	37.6	37.4	37.4	15800.0
2013-12-27	AAXJ	ETF	59.59	59.66	59.45	59.45	641900.0
2013-12-27	ACWI	ETF	57.32	57.34	57.2	57.27	666400.0
2013-12-27	ACWV	ETF	63.5	63.5	63.11	63.26	40000.0
2013-12-27	ACWX	ETF	46.25	46.34	46.19	46.33	1886481.0
2013-12-27	ADRE	ETF	36.63	37.0	36.63	37.0	32915.0
2013-12-27	AFK	ETF	30.25	30.761	30.0	30.11	17997.0
2013-12-27	AGG	ETF	106.38	106.46	106.29	106.43	1320400.0
2013-12-27	AGQ	ETF	67.0	67.2	66.6	66.84	256100.0
2013-12-27	AGZ	ETF	110.41	110.599	110.41	110.45	72978.0
2013-12-27	AGZD	ETF	25.035	25.035	25.035	25.035	1600.0
2013-12-27	AIA	ETF	47.67	47.7	47.54	47.66	15847.0
2013-12-27	AIQ	ETF	25.25	25.6	25.0	25.11	24795.0
2013-12-27	AIVI	ETF	47.31	47.47	47.18	47.18	19500.0
2013-12-27	ALTL	ETF	32.88	32.88	32.77	32.8	1100.0
2013-12-27	AMJ	ETF	45.43	45.96	45.4	45.86	355382.0
2013-12-27	AMLP	ETF	87.9	88.25	87.55	88.15	422200.0
2013-12-27	ANGL	ETF	26.92	26.92	26.81	26.87	900.0
2013-12-27	AOA	ETF	44.49	44.49	44.4	44.42	12800.0
2013-12-27	AOK	ETF	31.94	31.97	31.92	31.93	41417.0
2013-12-27	AOM	ETF	34.29	34.35	34.21	34.22	47212.0
2013-12-27	AOR	ETF	38.44	38.44	38.36	38.41	30075.0
2013-12-27	ARGT	ETF	19.76	19.76	19.66	19.66	1100.0
2013-12-27	ASEA	ETF	15.35	15.39	15.21	15.39	43600.0
2013-12-27	ASHR	ETF	23.89	24.37	23.89	24.37	117900.0
2013-12-27	ATMP	ETF	26.86	27.07	26.86	27.05	29000.0
2013-12-27	AVIV	ETF	23.81	23.84	23.26	23.56	144958.0
2013-12-27	AWAY	ETF	40.92	41.0	40.115	40.29	691343.0
2013-12-27	BAB	ETF	27.46	27.46	27.33	27.355	167244.0
2013-12-27	BAL	ETF	53.13	53.24	52.76	52.76	3167.0
2013-12-27	BALT	ETF	6.86	6.86	6.3	6.39	1660247.0
2013-12-27	BBH	ETF	88.89	88.9	88.14	88.25	167300.0
2013-12-27	BCM	ETF	39.9	40.022	39.89	39.89	5709.0
2013-12-27	BFOR	ETF	7.48	7.48	7.4275	7.44	136400.0
2013-12-27	BIB	ETF	37.71	37.945	37.175	37.2275	170768.0
2013-12-27	BICK	ETF	24.34	24.75	24.34	24.75	6019.0
2013-12-27	BIL	ETF	91.58	91.58	91.56	91.58	150600.0
2013-12-27	BIS	ETF	830.96	839.6	821.2	839.6	353.5
2013-12-27	BIV	ETF	81.75	81.88	81.7	81.82	398500.0
2013-12-27	BIZD	ETF	20.8	21.0	20.8	20.96	32200.0
2013-12-27	BJK	ETF	53.0	53.0	52.64	52.74	3700.0
2013-12-27	BKF	ETF	37.33	37.58	37.33	37.58	70474.0
2013-12-27	BKLN	ETF	24.83	24.85	24.82	24.85	1286900.0
2013-12-27	BLNG	ETF	34.5	34.5	34.5	34.5	2700.0

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

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