PREVIEW / etf_daily / 2013-08-23

all etf daily files

  file:    by_date/etf_daily/2013/2013-08-23.parquet
  size:    41 KB
  rows:    1,012

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-08-23	SPY	ETF	166.55	166.83	165.77	166.62	90888900.0
2013-08-23	QQQ	ETF	76.73	76.77	76.4	76.67	20697258.0
2013-08-23	IWM	ETF	103.19	103.25	102.45	103.17	20801100.0
2013-08-23	DIA	ETF	149.59	150.01	149.06	149.83	9601600.0
2013-08-23	GLD	ETF	132.58	135.24	132.5	134.9	11623400.0
2013-08-23	TLT	ETF	103.01	104.39	102.74	104.29	17441200.0
2013-08-23	AADR	ETF	33.81	33.81	33.81	33.81	200.0
2013-08-23	AAXJ	ETF	54.66	54.89	54.52	54.79	344700.0
2013-08-23	ACTV	ETF	9.75	9.96	9.54	9.64	694125.0
2013-08-23	ACWI	ETF	52.29	52.42	52.09	52.35	706600.0
2013-08-23	ACWV	ETF	60.5	60.82	60.41	60.82	35700.0
2013-08-23	ACWX	ETF	42.92	43.17	42.9072	43.15	271190.0
2013-08-23	ADRE	ETF	35.28	35.54	35.11	35.52	20512.0
2013-08-23	AFK	ETF	29.2	29.52	29.2	29.43	29014.0
2013-08-23	AGEM	ETF	21.1411	21.24	21.1411	21.24	1947.0
2013-08-23	AGG	ETF	105.54	105.93	105.45	105.9	653100.0
2013-08-23	AGQ	ETF	93.24	100.96	93.08	100.2	782950.0
2013-08-23	AGZ	ETF	110.15	110.5099	110.09	110.302	32115.0
2013-08-23	AIA	ETF	44.11	44.11	43.83	44.02	15843.0
2013-08-23	AIQ	ETF	23.99	24.16	23.54	24.06	117202.0
2013-08-23	AIVI	ETF	43.14	43.4	43.09	43.35	21600.0
2013-08-23	ALTL	ETF	29.6317	29.6317	29.6317	29.6317	295.0
2013-08-23	AMJ	ETF	46.08	46.36	45.57	46.33	812579.0
2013-08-23	AMLP	ETF	87.65	87.95	87.55	87.85	519840.0
2013-08-23	ANGL	ETF	26.3	26.32	26.21	26.31	5700.0
2013-08-23	AOA	ETF	41.11	41.16	40.96	41.16	15800.0
2013-08-23	AOK	ETF	30.92	30.99	30.9	30.99	20927.0
2013-08-23	AOM	ETF	32.68	32.82	32.65	32.82	23381.0
2013-08-23	AOR	ETF	36.17	36.24	36.05	36.24	23345.0
2013-08-23	ARB	ETF	46.72	46.79	46.7	46.72	140626.0
2013-08-23	ARGT	ETF	19.16	19.23	19.16	19.23	3600.0
2013-08-23	ASEA	ETF	15.51	15.6	15.5	15.56	10500.0
2013-08-23	ATMP	ETF	26.33	26.38	26.24	26.32	13700.0
2013-08-23	AVIV	ETF	23.11	23.33	23.1	23.29	93113.0
2013-08-23	AWAY	ETF	29.98	30.12	29.62	29.9	461365.0
2013-08-23	BAB	ETF	26.92	27.16	26.92	27.09	205366.0
2013-08-23	BAL	ETF	54.04	54.5	53.8411	53.908	18811.0
2013-08-23	BALT	ETF	4.73	4.78	4.68	4.74	259649.0
2013-08-23	BBH	ETF	77.65	77.7	77.0	77.21	48300.0
2013-08-23	BCM	ETF	41.39	41.39	41.39	41.39	2063.0
2013-08-23	BFOR	ETF	6.595	6.6075	6.565	6.6025	97600.0
2013-08-23	BIB	ETF	28.2775	28.2775	27.59	27.915	76556.0
2013-08-23	BICK	ETF	21.6	21.78	21.6	21.78	1700.0
2013-08-23	BIL	ETF	91.6	91.6	91.58	91.6	86050.0
2013-08-23	BIV	ETF	81.84	82.23	81.69	82.2	278100.0
2013-08-23	BIZD	ETF	20.12	20.12	20.0	20.12	8200.0
2013-08-23	BJK	ETF	43.05	43.25	43.05	43.25	11800.0
2013-08-23	BKF	ETF	34.76	35.03	34.5301	34.99	46547.0
2013-08-23	BKLN	ETF	24.68	24.7	24.64	24.65	2303500.0
2013-08-23	BLV	ETF	80.86	81.98	80.86	81.9	54500.0

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

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