PREVIEW / etf_daily / 2013-02-14

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-14.parquet
  size:    40 KB
  rows:    965

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-14	SPY	ETF	151.69	152.47	151.52	152.29	80834300.0
2013-02-14	QQQ	ETF	67.64	68.05	67.62	67.95	24482423.0
2013-02-14	IWM	ETF	91.18	91.88	91.16	91.71	22359300.0
2013-02-14	DIA	ETF	139.38	139.96	139.26	139.86	3048800.0
2013-02-14	GLD	ETF	159.31	159.65	158.04	158.35	12410200.0
2013-02-14	TLT	ETF	116.29	117.04	115.99	116.84	7096000.0
2013-02-14	AADR	ETF	33.32	33.32	33.31	33.32	2500.0
2013-02-14	AAXJ	ETF	60.61	60.78	60.44	60.74	260200.0
2013-02-14	ACTV	ETF	5.475	5.8	5.465	5.55	945557.0
2013-02-14	ACWI	ETF	49.98	50.24	49.97	50.18	331500.0
2013-02-14	ACWV	ETF	58.32	58.51	58.32	58.35	47800.0
2013-02-14	ACWX	ETF	42.87	42.98	42.81	42.96	118776.0
2013-02-14	ADRE	ETF	39.96	40.102	39.96	40.1	15689.0
2013-02-14	AFK	ETF	31.78	31.78	31.33	31.54	31786.0
2013-02-14	AGEM	ETF	23.45	23.45	23.3475	23.3475	1160.0
2013-02-14	AGG	ETF	110.01	110.24	110.01	110.24	731900.0
2013-02-14	AGQ	ETF	181.08	181.8	173.0	175.48	449550.0
2013-02-14	AGZ	ETF	112.99	113.04	112.86	113.01	77419.0
2013-02-14	AIA	ETF	47.63	47.77	47.5637	47.75	5419.0
2013-02-14	AIQ	ETF	7.07	7.24	6.617	6.84	8221.0
2013-02-14	AIVI	ETF	42.15	42.33	42.15	42.32	38300.0
2013-02-14	ALTL	ETF	28.28	28.28	28.28	28.28	100.0
2013-02-14	AMJ	ETF	43.67	44.17	43.5222	44.01	3602232.0
2013-02-14	AMLP	ETF	85.9	86.45	85.9	86.35	572800.0
2013-02-14	ANGL	ETF	26.59	26.94	26.59	26.71	6900.0
2013-02-14	AOA	ETF	38.96	39.04	38.91	39.03	13200.0
2013-02-14	AOK	ETF	31.01	31.01	30.89	30.93	48164.0
2013-02-14	AOM	ETF	32.3	32.42	32.3	32.41	38953.0
2013-02-14	AOR	ETF	35.16	35.16	35.03	35.11	32588.0
2013-02-14	ARB	ETF	47.05	47.09	46.98	46.98	229889.0
2013-02-14	ARGT	ETF	17.52	17.78	17.52	17.78	2650.0
2013-02-14	ASEA	ETF	17.19	17.22	17.15	17.21	10000.0
2013-02-14	AWAY	ETF	24.89	25.35	24.7	25.33	1024824.0
2013-02-14	BAB	ETF	30.19	30.24	30.11	30.17	273218.0
2013-02-14	BAL	ETF	53.21	53.67	53.06	53.4	31925.0
2013-02-14	BALT	ETF	3.34	3.38	3.3	3.34	36043.0
2013-02-14	BBH	ETF	58.16	58.29	57.58	58.06	22700.0
2013-02-14	BCM	ETF	44.55	44.71	44.55	44.68	6002.0
2013-02-14	BIB	ETF	16.3825	16.414	16.0697	16.325	25316.0
2013-02-14	BICK	ETF	25.32	25.46	25.25	25.41	4302.0
2013-02-14	BIL	ETF	91.6	91.62	91.6	91.62	116500.0
2013-02-14	BIS	ETF	2328.8	2344.4	2300.0	2334.8	105.0
2013-02-14	BIV	ETF	87.15	87.35	87.11	87.34	184400.0
2013-02-14	BIZD	ETF	20.28	20.38	20.27	20.38	19500.0
2013-02-14	BJK	ETF	39.1	39.15	39.01	39.15	2200.0
2013-02-14	BKF	ETF	41.09	41.2499	41.0685	41.19	50156.0
2013-02-14	BKLN	ETF	25.02	25.05	25.02	25.05	1399000.0
2013-02-14	BLV	ETF	90.97	91.25	90.75	91.15	40900.0
2013-02-14	BMVP	ETF	17.91	17.94	17.91	17.94	500.0
2013-02-14	BND	ETF	83.2	83.33	83.2	83.32	945500.0

> showing 50 of 965 rows — these rows as CSV

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