PREVIEW / etf_daily / 2013-02-13

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-13.parquet
  size:    40 KB
  rows:    971

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-02-13	SPY	ETF	152.33	152.61	151.72	152.15	82322600.0
2013-02-13	QQQ	ETF	67.93	68.23	67.765	67.97	23497142.0
2013-02-13	IWM	ETF	91.19	91.55	90.98	91.48	22591300.0
2013-02-13	DIA	ETF	140.23	140.36	139.5	139.87	3387800.0
2013-02-13	GLD	ETF	159.6	159.64	158.77	159.05	8961300.0
2013-02-13	TLT	ETF	115.8	116.27	115.55	115.79	6586400.0
2013-02-13	AADR	ETF	33.42	33.42	33.41	33.41	300.0
2013-02-13	AAXJ	ETF	60.73	60.8	60.58	60.67	311100.0
2013-02-13	ACTV	ETF	5.33	5.69	5.31	5.69	951128.0
2013-02-13	ACWI	ETF	50.37	50.43	50.18	50.28	292100.0
2013-02-13	ACWV	ETF	58.31	58.62	58.31	58.51	21000.0
2013-02-13	ACWX	ETF	43.13	43.29	43.08	43.16	158308.0
2013-02-13	ADRE	ETF	40.05	40.27	40.05	40.18	90422.0
2013-02-13	AFK	ETF	31.6	31.67	31.52	31.61	15700.0
2013-02-13	AGEM	ETF	23.5	23.51	23.5	23.51	1400.0
2013-02-13	AGG	ETF	109.94	110.09	109.94	110.04	902200.0
2013-02-13	AGQ	ETF	182.44	182.72	179.0	179.28	338725.0
2013-02-13	AGZ	ETF	112.94	112.97	112.87	112.87	11893.0
2013-02-13	AIA	ETF	47.75	47.76	47.59	47.6699	13883.0
2013-02-13	AIQ	ETF	7.29	7.29	6.99	6.99	10045.0
2013-02-13	AIVI	ETF	42.77	42.91	42.66	42.69	21100.0
2013-02-13	AMJ	ETF	43.58	43.88	43.39	43.84	2249638.0
2013-02-13	AMLP	ETF	85.7	86.05	85.4	85.95	506720.0
2013-02-13	ANGL	ETF	26.79	26.79	26.79	26.79	100.0
2013-02-13	AOA	ETF	39.1	39.1	38.96	39.03	10900.0
2013-02-13	AOK	ETF	30.94	30.949	30.89	30.929	32209.0
2013-02-13	AOM	ETF	32.41	32.43	32.36	32.4	47124.0
2013-02-13	AOR	ETF	35.15	35.1692	35.0401	35.08	23433.0
2013-02-13	ARB	ETF	47.1	47.1	47.0	47.09	395012.0
2013-02-13	ARGT	ETF	17.84	17.9	17.66	17.9	10150.0
2013-02-13	ASEA	ETF	17.19	17.25	17.19	17.21	15400.0
2013-02-13	AWAY	ETF	24.75	25.11	24.66	24.91	899364.0
2013-02-13	BAB	ETF	30.09	30.15	30.033	30.11	223007.0
2013-02-13	BAL	ETF	53.16	53.2498	52.49	53.21	31113.0
2013-02-13	BALT	ETF	3.22	3.4	3.22	3.32	45421.0
2013-02-13	BBH	ETF	57.71	58.07	57.6	57.98	14900.0
2013-02-13	BIB	ETF	16.2	16.4555	16.2	16.39	24824.0
2013-02-13	BICK	ETF	25.44	25.467	25.38	25.43	3641.0
2013-02-13	BIL	ETF	91.62	91.62	91.6	91.6	98300.0
2013-02-13	BIS	ETF	2328.88	2328.88	2328.88	2328.88	2.5
2013-02-13	BIV	ETF	87.15	87.18	87.03	87.04	233500.0
2013-02-13	BIZD	ETF	20.18	20.26	20.16	20.24	11400.0
2013-02-13	BJK	ETF	39.21	39.24	39.1	39.12	3800.0
2013-02-13	BKF	ETF	41.26	41.42	41.25	41.31	32728.0
2013-02-13	BKLN	ETF	25.02	25.02	24.99	25.02	4505900.0
2013-02-13	BLNG	ETF	49.16	49.16	49.16	49.16	200.0
2013-02-13	BLV	ETF	90.67	90.82	90.5	90.61	26700.0
2013-02-13	BMVP	ETF	17.947	17.95	17.883	17.885	2068.0
2013-02-13	BND	ETF	83.21	83.26	83.16	83.2	1154500.0
2013-02-13	BNO	ETF	44.285	44.345	44.115	44.29	233000.0

> showing 50 of 971 rows — these rows as CSV

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