PREVIEW / etf_daily / 2013-04-05

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-05.parquet
  size:    40 KB
  rows:    983

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-04-05	SPY	ETF	153.95	155.35	153.77	155.16	159666000.0
2013-04-05	QQQ	ETF	67.35	67.96	67.19	67.861	55613276.0
2013-04-05	IWM	ETF	90.52	91.75	90.42	91.73	46418300.0
2013-04-05	DIA	ETF	144.18	145.51	144.05	145.31	7307400.0
2013-04-05	GLD	ETF	151.54	152.96	151.07	152.81	14491800.0
2013-04-05	TLT	ETF	122.88	123.43	122.63	122.82	18626200.0
2013-04-05	AADR	ETF	32.35	32.7	32.35	32.47	1800.0
2013-04-05	AAXJ	ETF	56.81	57.54	56.69	57.49	379600.0
2013-04-05	ACTV	ETF	4.09	4.27	4.05	4.25	436378.0
2013-04-05	ACWI	ETF	49.85	50.32	49.77	50.3	2239700.0
2013-04-05	ACWV	ETF	61.48	61.79	61.08	61.68	65900.0
2013-04-05	ACWX	ETF	41.97	42.33	41.8	42.33	241636.0
2013-04-05	ADRE	ETF	37.34	37.83	37.09	37.8	21287.0
2013-04-05	AFK	ETF	29.81	30.0	29.71	30.0	7713.0
2013-04-05	AGEM	ETF	21.86	22.03	21.8	22.0	49050.0
2013-04-05	AGG	ETF	111.17	111.26	111.11	111.2	1013800.0
2013-04-05	AGQ	ETF	137.76	140.08	136.44	139.64	373675.0
2013-04-05	AGZ	ETF	113.514	113.78	113.486	113.618	4996.0
2013-04-05	AIA	ETF	44.5	45.0601	44.32	45.05	37707.0
2013-04-05	AIQ	ETF	8.08	8.54	8.08	8.45	13693.0
2013-04-05	AIVI	ETF	41.7	42.06	41.64	42.05	25400.0
2013-04-05	ALTL	ETF	28.78	28.78	28.78	28.78	812.0
2013-04-05	AMJ	ETF	44.7	45.65	44.07	45.15	2810099.0
2013-04-05	AMLP	ETF	86.8	87.35	86.4	87.2	486800.0
2013-04-05	ANGL	ETF	26.67	27.18	26.67	27.18	700.0
2013-04-05	AOA	ETF	39.05	39.33	39.0	39.31	89200.0
2013-04-05	AOK	ETF	31.08	31.16	31.054	31.16	17296.0
2013-04-05	AOM	ETF	32.52	32.63	32.49	32.63	14473.0
2013-04-05	AOR	ETF	35.22	35.39	35.1428	35.39	41482.0
2013-04-05	ARB	ETF	46.84	46.87	46.81	46.85	158485.0
2013-04-05	ARGT	ETF	16.9	17.0	16.88	17.0	1750.0
2013-04-05	ASEA	ETF	17.46	17.58	17.4	17.58	17400.0
2013-04-05	ATMP	ETF	25.5	25.57	25.29	25.5	9200.0
2013-04-05	AVIV	ETF	23.95	24.74	23.75	24.52	583769.0
2013-04-05	AWAY	ETF	29.7	30.07	29.14	30.04	812640.0
2013-04-05	BAB	ETF	30.73	30.83	30.7	30.71	366348.0
2013-04-05	BAL	ETF	56.6	56.68	55.942	55.9454	12972.0
2013-04-05	BALT	ETF	3.45	3.6	3.45	3.57	126730.0
2013-04-05	BBH	ETF	64.42	64.73	63.68	64.73	43600.0
2013-04-05	BCM	ETF	41.86	41.86	41.806	41.806	576.0
2013-04-05	BIB	ETF	19.2575	19.605	18.9025	19.6025	153064.0
2013-04-05	BICK	ETF	22.83	23.133	22.83	23.08	9505.0
2013-04-05	BIL	ETF	91.6	91.62	91.6	91.62	182250.0
2013-04-05	BIS	ETF	1925.6	1940.8	1924.4	1928.0	29.5
2013-04-05	BIV	ETF	88.26	88.32	88.16	88.19	202400.0
2013-04-05	BIZD	ETF	19.75	19.85	19.69	19.85	13900.0
2013-04-05	BJK	ETF	38.58	38.8	38.09	38.8	18200.0
2013-04-05	BKF	ETF	37.25	38.02	37.17	37.93	1073138.0
2013-04-05	BKLN	ETF	25.11	25.13	25.11	25.13	1678200.0
2013-04-05	BLV	ETF	94.0	94.3	93.84	93.84	51300.0

> showing 50 of 983 rows — these rows as CSV

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