PREVIEW / etf_daily / 2013-12-09

all etf daily files

  file:    by_date/etf_daily/2013/2013-12-09.parquet
  size:    43 KB
  rows:    1,056

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-12-09	SPY	ETF	181.47	181.67	181.16	181.4	70124000.0
2013-12-09	QQQ	ETF	86.35	86.53	86.2	86.35	22599903.0
2013-12-09	IWM	ETF	112.63	112.89	111.89	112.45	31236500.0
2013-12-09	DIA	ETF	160.29	160.53	160.11	160.23	3967700.0
2013-12-09	GLD	ETF	118.99	119.92	118.95	119.72	5510400.0
2013-12-09	TLT	ETF	102.9	103.23	102.83	103.16	5678800.0
2013-12-09	AAXJ	ETF	60.78	61.24	60.78	61.24	1287900.0
2013-12-09	ACWI	ETF	56.62	56.73	56.56	56.64	1096800.0
2013-12-09	ACWV	ETF	63.93	64.04	63.81	63.89	30700.0
2013-12-09	ACWX	ETF	45.89	46.006	45.8747	45.93	213582.0
2013-12-09	ADRE	ETF	37.7	37.87	37.7	37.8	16935.0
2013-12-09	AFK	ETF	30.89	31.15	30.89	30.95	42351.0
2013-12-09	AGG	ETF	106.7	106.81	106.66	106.76	1379500.0
2013-12-09	AGQ	ETF	65.04	67.0	64.92	66.16	304150.0
2013-12-09	AGZ	ETF	111.2	111.2	111.06	111.08	14768.0
2013-12-09	AIA	ETF	48.97	49.1249	48.97	49.01	15806.0
2013-12-09	AIQ	ETF	23.79	23.87	20.06	20.95	137294.0
2013-12-09	AIVI	ETF	46.33	46.53	46.29	46.49	24400.0
2013-12-09	ALTL	ETF	32.071	32.158	32.07	32.158	1232.0
2013-12-09	AMJ	ETF	44.64	44.67	44.05	44.24	690855.0
2013-12-09	AMLP	ETF	86.65	86.65	86.1	86.2	390980.0
2013-12-09	ANGL	ETF	26.87	26.87	26.86	26.86	3600.0
2013-12-09	AOA	ETF	43.84	43.9	43.83	43.84	30000.0
2013-12-09	AOK	ETF	31.81	31.87	31.81	31.84	21030.0
2013-12-09	AOM	ETF	34.12	34.13	34.08	34.11	46657.0
2013-12-09	AOR	ETF	38.08	38.15	38.08	38.1013	24642.0
2013-12-09	ARGT	ETF	19.9	20.06	19.83	19.86	4300.0
2013-12-09	ASEA	ETF	16.24	16.24	16.18	16.19	6400.0
2013-12-09	ASHR	ETF	25.86	25.86	25.67	25.67	582400.0
2013-12-09	ATMP	ETF	26.05	26.17	26.02	26.02	28200.0
2013-12-09	AVIV	ETF	24.6	24.74	24.49	24.59	227615.0
2013-12-09	AWAY	ETF	39.41	40.0	39.1	39.94	821086.0
2013-12-09	BAB	ETF	27.53	27.53	27.43	27.47	157348.0
2013-12-09	BAL	ETF	50.5	50.65	50.39	50.39	9635.0
2013-12-09	BALT	ETF	5.4	5.469	5.13	5.3	941338.0
2013-12-09	BBH	ETF	87.72	87.97	86.73	87.01	61200.0
2013-12-09	BCM	ETF	39.6299	39.64	39.4129	39.6112	2080.0
2013-12-09	BFOR	ETF	7.3125	7.3125	7.2575	7.275	394000.0
2013-12-09	BIB	ETF	36.9975	36.9975	35.87	35.9475	211656.0
2013-12-09	BICK	ETF	25.0	25.0799	25.0	25.0799	522.0
2013-12-09	BIL	ETF	91.56	91.58	91.56	91.58	224250.0
2013-12-09	BIS	ETF	854.4	880.0	854.4	873.6	212.5
2013-12-09	BIV	ETF	83.03	83.19	83.0	83.09	414800.0
2013-12-09	BIZD	ETF	21.17	21.33	21.17	21.26	15200.0
2013-12-09	BJK	ETF	51.51	51.95	51.37	51.85	31700.0
2013-12-09	BKF	ETF	38.41	38.629	38.41	38.46	70862.0
2013-12-09	BKLN	ETF	24.84	24.87	24.83	24.87	1747900.0
2013-12-09	BLV	ETF	81.79	82.02	81.79	81.99	126000.0
2013-12-09	BMVP	ETF	22.4267	22.4567	22.3567	22.3733	7878.0
2013-12-09	BND	ETF	80.52	80.56	80.47	80.52	957100.0

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

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