PREVIEW / etf_daily / 2013-12-26

all etf daily files

  file:    by_date/etf_daily/2013/2013-12-26.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-26	SPY	ETF	183.34	183.96	183.32	183.86	63365000.0
2013-12-26	QQQ	ETF	87.6	87.81	87.44	87.74	15241096.0
2013-12-26	IWM	ETF	115.63	115.97	115.1	115.23	19670000.0
2013-12-26	DIA	ETF	163.6	164.49	163.58	164.46	4971600.0
2013-12-26	GLD	ETF	117.23	117.23	116.65	116.74	3868400.0
2013-12-26	TLT	ETF	102.35	102.36	102.01	102.1	4645300.0
2013-12-26	AADR	ETF	37.35	37.39	37.2	37.39	6300.0
2013-12-26	AAXJ	ETF	59.2	59.2	58.88	58.88	396200.0
2013-12-26	ACWI	ETF	56.94	57.13	56.88	57.09	309400.0
2013-12-26	ACWV	ETF	62.86	63.2	62.86	63.07	14400.0
2013-12-26	ACWX	ETF	46.08	46.08	45.95	45.98	564415.0
2013-12-26	ADRE	ETF	36.74	36.82	36.48	36.531	42659.0
2013-12-26	AFK	ETF	30.49	30.49	29.935	30.0	19094.0
2013-12-26	AGG	ETF	106.35	106.42	105.35	106.39	750800.0
2013-12-26	AGQ	ETF	66.04	66.8	65.0	65.08	277775.0
2013-12-26	AGZ	ETF	110.46	110.5	110.39	110.41	25193.0
2013-12-26	AIA	ETF	47.23	47.25	47.041	47.18	5979.0
2013-12-26	AIQ	ETF	23.221	25.97	23.22	25.55	16721.0
2013-12-26	AIVI	ETF	46.8	47.22	46.8	47.16	57900.0
2013-12-26	ALTL	ETF	32.84	32.84	32.78	32.8	4318.0
2013-12-26	AMJ	ETF	45.76	45.85	45.48	45.49	373592.0
2013-12-26	AMLP	ETF	87.6	88.1	87.55	87.75	406260.0
2013-12-26	ANGL	ETF	26.89	27.29	26.89	27.03	2500.0
2013-12-26	AOA	ETF	44.59	44.59	44.51	44.58	17400.0
2013-12-26	AOK	ETF	32.0	32.03	31.98	32.001	10331.0
2013-12-26	AOM	ETF	34.41	34.41	34.34	34.389	33712.0
2013-12-26	AOR	ETF	38.66	38.66	38.491	38.53	62948.0
2013-12-26	ARGT	ETF	19.93	19.93	19.66	19.67	2000.0
2013-12-26	ASEA	ETF	15.87	15.87	15.73	15.79	30400.0
2013-12-26	ASHR	ETF	23.76	23.96	23.76	23.92	197900.0
2013-12-26	ATMP	ETF	26.87	26.96	26.84	26.84	70200.0
2013-12-26	AVIV	ETF	24.06	24.25	23.76	23.85	68011.0
2013-12-26	AWAY	ETF	40.6	41.11	40.26	40.6	466119.0
2013-12-26	BAB	ETF	27.44	27.44	27.33	27.36	511725.0
2013-12-26	BAL	ETF	52.01	52.3	51.99	52.03	7792.0
2013-12-26	BALT	ETF	6.3	6.65	6.3	6.58	1243150.0
2013-12-26	BBH	ETF	88.78	88.9	88.11	88.59	109000.0
2013-12-26	BCM	ETF	39.94	40.2	39.71	39.8	137272.0
2013-12-26	BFOR	ETF	7.4525	7.475	7.4375	7.45	197200.0
2013-12-26	BIB	ETF	37.5925	38.0	37.3455	37.885	181016.0
2013-12-26	BICK	ETF	24.455	24.455	24.395	24.395	1431.0
2013-12-26	BIL	ETF	91.58	91.58	91.56	91.56	81300.0
2013-12-26	BIS	ETF	828.0	830.76	822.0	822.0	269.5
2013-12-26	BIV	ETF	81.81	81.89	81.77	81.77	296200.0
2013-12-26	BIZD	ETF	21.3	21.45	21.29	21.29	4500.0
2013-12-26	BJK	ETF	52.31	52.69	52.18	52.67	22400.0
2013-12-26	BKF	ETF	37.17	37.25	37.06	37.11	44906.0
2013-12-26	BKLN	ETF	24.82	24.84	24.81	24.83	1493600.0
2013-12-26	BLNG	ETF	34.54	34.54	34.51	34.51	300.0
2013-12-26	BLV	ETF	82.12	82.13	81.83	81.89	26800.0

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

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