PREVIEW / etf_daily / 2013-12-10

all etf daily files

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

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-10	SPY	ETF	180.98	181.36	180.64	180.75	80976000.0
2013-12-10	QQQ	ETF	86.19	86.45	86.12	86.29	26965928.0
2013-12-10	IWM	ETF	112.23	112.58	111.24	111.43	34938800.0
2013-12-10	DIA	ETF	159.77	160.19	159.64	159.72	4047600.0
2013-12-10	GLD	ETF	122.14	122.32	121.47	121.82	9155600.0
2013-12-10	TLT	ETF	103.84	103.95	103.45	103.9	7040400.0
2013-12-10	AADR	ETF	37.16	37.16	36.83	36.91	4200.0
2013-12-10	AAXJ	ETF	60.51	60.99	60.51	60.98	636000.0
2013-12-10	ACWI	ETF	56.43	56.64	56.43	56.53	3442800.0
2013-12-10	ACWV	ETF	63.87	63.87	63.56	63.74	37300.0
2013-12-10	ACWX	ETF	45.88	45.9	45.77	45.86	182234.0
2013-12-10	ADRE	ETF	37.63	37.851	37.5301	37.821	16599.0
2013-12-10	AFK	ETF	31.0	31.06	30.91	30.98	19468.0
2013-12-10	AGG	ETF	107.05	107.07	106.89	106.93	2986900.0
2013-12-10	AGQ	ETF	69.88	69.92	68.76	69.76	382300.0
2013-12-10	AGZ	ETF	111.64	111.64	111.14	111.16	33295.0
2013-12-10	AIA	ETF	48.66	48.819	48.55	48.8028	4063.0
2013-12-10	AIQ	ETF	20.65	21.565	20.65	21.24	52853.0
2013-12-10	AIVI	ETF	46.46	46.49	46.23	46.41	58100.0
2013-12-10	ALTL	ETF	32.1	32.11	32.0675	32.11	1417.0
2013-12-10	AMJ	ETF	44.1	44.47	44.08	44.12	423094.0
2013-12-10	AMLP	ETF	86.4	86.6	86.0	86.05	531940.0
2013-12-10	ANGL	ETF	27.15	27.15	27.09	27.09	400.0
2013-12-10	AOA	ETF	43.96	43.96	43.76	43.79	23300.0
2013-12-10	AOK	ETF	31.8799	31.93	31.811	31.93	18340.0
2013-12-10	AOM	ETF	34.21	34.21	34.05	34.09	37390.0
2013-12-10	AOR	ETF	38.19	38.19	38.03	38.089	16372.0
2013-12-10	ARGT	ETF	20.01	20.04	19.95	19.99	10500.0
2013-12-10	ASEA	ETF	16.03	16.14	16.03	16.08	48100.0
2013-12-10	ASHR	ETF	25.72	25.83	25.66	25.8	162800.0
2013-12-10	ATMP	ETF	26.04	26.14	25.98	25.99	169200.0
2013-12-10	AVIV	ETF	24.54	24.74	24.47	24.49	101760.0
2013-12-10	AWAY	ETF	39.95	40.55	39.42	39.9	1022205.0
2013-12-10	BAB	ETF	27.63	27.64	27.56	27.61	135393.0
2013-12-10	BAL	ETF	50.4572	50.671	50.4572	50.6343	6305.0
2013-12-10	BALT	ETF	5.24	5.41	5.2	5.28	1078358.0
2013-12-10	BBH	ETF	87.03	87.23	85.54	86.42	82900.0
2013-12-10	BCM	ETF	39.92	39.92	39.92	39.92	6016.0
2013-12-10	BFOR	ETF	7.275	7.2975	7.23	7.2475	190400.0
2013-12-10	BIB	ETF	36.095	36.1125	34.7525	35.545	280880.0
2013-12-10	BICK	ETF	24.81	24.98	24.81	24.9557	9226.0
2013-12-10	BIL	ETF	91.56	91.58	91.56	91.56	66400.0
2013-12-10	BIS	ETF	876.0	906.8	870.8	892.0	410.5
2013-12-10	BIV	ETF	83.31	83.39	83.23	83.38	286000.0
2013-12-10	BIZD	ETF	21.14	21.21	21.09	21.13	7700.0
2013-12-10	BJK	ETF	51.68	51.93	51.58	51.85	70000.0
2013-12-10	BKF	ETF	38.24	38.55	38.24	38.52	162520.0
2013-12-10	BKLN	ETF	24.86	24.87	24.85	24.87	2246600.0
2013-12-10	BLV	ETF	82.41	82.65	82.31	82.62	51400.0
2013-12-10	BMVP	ETF	22.36	22.36	22.27	22.3	3301.0

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

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