PREVIEW / etf_daily / 2013-03-22

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-22.parquet
  size:    40 KB
  rows:    974

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-03-22	SPY	ETF	154.85	155.6	154.73	155.6	111163600.0
2013-03-22	QQQ	ETF	68.21	68.64	68.13	68.59	28838417.0
2013-03-22	IWM	ETF	94.25	94.37	93.94	94.16	33429900.0
2013-03-22	DIA	ETF	144.31	144.94	144.28	144.9	5027800.0
2013-03-22	GLD	ETF	155.45	155.99	155.42	155.55	4746300.0
2013-03-22	TLT	ETF	117.3	117.5	116.77	117.33	6323800.0
2013-03-22	AADR	ETF	32.96	32.96	32.89	32.89	600.0
2013-03-22	AAXJ	ETF	58.08	58.12	57.88	58.11	306000.0
2013-03-22	ACTV	ETF	4.25	4.305	4.21	4.25	382991.0
2013-03-22	ACWI	ETF	50.44	50.63	50.39	50.6	529300.0
2013-03-22	ACWV	ETF	60.95	61.18	60.89	61.13	109000.0
2013-03-22	ACWX	ETF	42.84	42.96	42.734	42.88	174612.0
2013-03-22	ADRE	ETF	38.11	38.2	38.06	38.19	42119.0
2013-03-22	AFK	ETF	30.3	30.32	30.01	30.03	80386.0
2013-03-22	AGEM	ETF	22.41	22.41	22.41	22.41	375.0
2013-03-22	AGG	ETF	110.52	110.52	110.35	110.41	776000.0
2013-03-22	AGQ	ETF	154.64	156.6	154.24	154.72	392075.0
2013-03-22	AGZ	ETF	113.4	113.4	113.14	113.1401	11573.0
2013-03-22	AIA	ETF	45.38	45.563	45.371	45.55	17413.0
2013-03-22	AIQ	ETF	7.17	7.2	7.13	7.13	25780.0
2013-03-22	AIVI	ETF	42.83	42.98	42.82	42.91	26800.0
2013-03-22	AMJ	ETF	44.36	44.93	44.34	44.74	1501170.0
2013-03-22	AMLP	ETF	87.5	87.85	87.0	87.5	773440.0
2013-03-22	ANGL	ETF	27.3	27.3	27.3	27.3	2600.0
2013-03-22	AOA	ETF	39.56	39.64	39.54	39.63	16200.0
2013-03-22	AOK	ETF	31.2	31.2	31.1201	31.15	15316.0
2013-03-22	AOM	ETF	32.66	32.73	32.66	32.69	13281.0
2013-03-22	AOR	ETF	35.47	35.5799	35.47	35.56	12475.0
2013-03-22	ARB	ETF	46.92	46.96	46.85	46.87	144457.0
2013-03-22	ARGT	ETF	17.78	17.78	17.78	17.78	350.0
2013-03-22	ASEA	ETF	17.04	17.1	16.99	17.04	9400.0
2013-03-22	ATMP	ETF	25.6	25.77	25.47	25.65	88000.0
2013-03-22	AVIV	ETF	22.52	23.22	22.4	22.81	1544024.0
2013-03-22	AWAY	ETF	32.41	33.23	32.15	33.11	1975778.0
2013-03-22	BAB	ETF	30.3	30.3	30.151	30.23	116891.0
2013-03-22	BAL	ETF	57.35	57.35	56.221	56.31	20978.0
2013-03-22	BALT	ETF	4.12	4.38	4.12	4.3	309091.0
2013-03-22	BBH	ETF	62.51	62.69	62.1	62.69	14700.0
2013-03-22	BCM	ETF	43.0	43.01	43.0	43.0	1922.0
2013-03-22	BIB	ETF	18.4525	18.65	18.4525	18.6451	40340.0
2013-03-22	BICK	ETF	23.86	23.861	23.82	23.82	2980.0
2013-03-22	BIL	ETF	91.6	91.62	91.6	91.62	83900.0
2013-03-22	BIS	ETF	2040.0	2040.0	2040.0	2040.0	3.0
2013-03-22	BIV	ETF	87.75	87.75	87.58	87.7	112000.0
2013-03-22	BIZD	ETF	20.62	20.63	20.49	20.59	12200.0
2013-03-22	BJK	ETF	39.13	39.18	39.1	39.18	3200.0
2013-03-22	BKF	ETF	38.64	38.76	38.56	38.67	44345.0
2013-03-22	BKLN	ETF	25.07	25.08	25.06	25.08	2199500.0
2013-03-22	BLV	ETF	91.3	91.3	90.88	91.23	26300.0
2013-03-22	BMVP	ETF	18.3967	18.48	18.3967	18.4521	10009.0

> showing 50 of 974 rows — these rows as CSV

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