PREVIEW / etf_daily / 2013-06-20

all etf daily files

  file:    by_date/etf_daily/2013/2013-06-20.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-06-20	SPY	ETF	161.86	163.47	158.98	159.4	321255900.0
2013-06-20	QQQ	ETF	71.92	72.16	70.79	71.025	60908388.0
2013-06-20	IWM	ETF	96.71	98.21	95.29	95.69	76262300.0
2013-06-20	DIA	ETF	149.84	149.88	147.29	147.58	14309900.0
2013-06-20	GLD	ETF	125.22	126.38	123.33	123.6	28872100.0
2013-06-20	TLT	ETF	110.75	111.21	109.28	110.27	27898500.0
2013-06-20	AAXJ	ETF	53.82	53.94	52.12	52.49	1364500.0
2013-06-20	ACTV	ETF	6.96	7.06	6.53	6.63	414514.0
2013-06-20	ACWI	ETF	50.74	50.74	49.79	49.92	2294200.0
2013-06-20	ACWV	ETF	60.02	60.02	58.79	59.03	82300.0
2013-06-20	ACWX	ETF	41.4	41.4	40.55	40.64	411952.0
2013-06-20	ADRE	ETF	33.99	33.99	33.29	33.43	71097.0
2013-06-20	AFK	ETF	27.95	27.95	27.18	27.35	24653.0
2013-06-20	AGEM	ETF	19.6014	19.9078	19.6014	19.63	1126.0
2013-06-20	AGG	ETF	107.33	107.53	107.12	107.21	3057100.0
2013-06-20	AGQ	ETF	70.56	72.56	68.48	68.52	1303075.0
2013-06-20	AGZ	ETF	112.0	112.0	110.97	111.12	28294.0
2013-06-20	AIA	ETF	41.87	41.87	40.69	40.98	109879.0
2013-06-20	AIQ	ETF	16.03	16.1	14.95	15.83	34329.0
2013-06-20	AIVI	ETF	41.58	41.59	40.75	40.85	30200.0
2013-06-20	AMJ	ETF	45.18	45.727	43.9	44.26	1157404.0
2013-06-20	AMLP	ETF	88.0	88.15	85.8	86.45	1687680.0
2013-06-20	ANGL	ETF	26.75	26.75	26.53	26.59	3300.0
2013-06-20	AOA	ETF	39.9	39.9	39.32	39.41	58500.0
2013-06-20	AOK	ETF	30.8	30.8	30.58	30.59	39421.0
2013-06-20	AOM	ETF	32.46	32.46	32.1401	32.19	74674.0
2013-06-20	AOR	ETF	35.51	35.51	35.13	35.16	81074.0
2013-06-20	ARB	ETF	46.76	46.8	46.68	46.72	259181.0
2013-06-20	ARGT	ETF	16.31	16.31	16.17	16.19	4300.0
2013-06-20	ASEA	ETF	16.47	16.47	15.51	15.67	239400.0
2013-06-20	ATMP	ETF	25.4	25.42	24.72	24.88	55600.0
2013-06-20	AVIV	ETF	25.6	25.67	24.51	24.66	730259.0
2013-06-20	AWAY	ETF	29.73	30.2	29.6	30.08	651304.0
2013-06-20	BAB	ETF	28.52	28.52	28.01	28.24	877249.0
2013-06-20	BAL	ETF	54.18	54.74	54.15	54.69	29004.0
2013-06-20	BALT	ETF	3.59	3.59	3.44	3.48	150485.0
2013-06-20	BBH	ETF	66.68	67.06	65.75	66.03	206800.0
2013-06-20	BCM	ETF	39.19	39.2931	39.19	39.2776	1073.0
2013-06-20	BFOR	ETF	6.25	6.25	6.1	6.125	842000.0
2013-06-20	BIB	ETF	22.0025	22.0025	20.865	21.04	473456.0
2013-06-20	BICK	ETF	20.9	20.9	20.5713	20.5923	35655.0
2013-06-20	BIL	ETF	91.62	91.62	91.6	91.6	1520400.0
2013-06-20	BIS	ETF	1598.0	1654.8	1596.48	1651.76	428.5
2013-06-20	BIV	ETF	83.84	83.94	83.57	83.82	523900.0
2013-06-20	BIZD	ETF	19.5	19.5	19.26	19.37	10800.0
2013-06-20	BJK	ETF	41.35	41.35	40.16	40.33	16900.0
2013-06-20	BKF	ETF	33.99	33.99	33.11	33.52	687432.0
2013-06-20	BKLN	ETF	24.83	24.84	24.61	24.71	7774500.0
2013-06-20	BLV	ETF	85.46	85.46	84.11	84.87	404800.0
2013-06-20	BMVP	ETF	19.09	19.09	18.69	18.7	14388.0

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

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