PREVIEW / etf_daily / 2014-01-08

all etf daily files

  file:    by_date/etf_daily/2014/2014-01-08.parquet
  size:    43 KB
  rows:    1,062

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
2014-01-08	SPY	ETF	183.45	183.83	182.89	183.52	96582300.0
2014-01-08	QQQ	ETF	87.11	87.55	86.945	87.31	27209991.0
2014-01-08	IWM	ETF	114.78	115.08	114.07	114.86	30763600.0
2014-01-08	DIA	ETF	164.7	164.83	163.91	164.35	9461800.0
2014-01-08	GLD	ETF	117.99	118.52	117.5	118.12	7428500.0
2014-01-08	TLT	ETF	102.45	102.69	102.1	102.58	8513000.0
2014-01-08	AADR	ETF	37.64	37.71	37.06	37.5	5400.0
2014-01-08	AAXJ	ETF	57.91	58.21	57.77	57.92	1059200.0
2014-01-08	ACWI	ETF	56.79	56.97	56.73	56.87	510500.0
2014-01-08	ACWV	ETF	62.71	62.76	62.59	62.73	41400.0
2014-01-08	ACWX	ETF	45.89	45.89	45.6799	45.79	227084.0
2014-01-08	ADRE	ETF	35.87	35.87	35.6701	35.68	13070.0
2014-01-08	AFK	ETF	30.1101	30.23	29.93	30.01	22317.0
2014-01-08	AGG	ETF	106.57	106.62	106.4	106.41	1090800.0
2014-01-08	AGQ	ETF	62.8	63.88	62.16	63.6	703925.0
2014-01-08	AGZ	ETF	110.63	110.67	110.54	110.54	22320.0
2014-01-08	AGZD	ETF	25.09	25.115	25.075	25.075	27000.0
2014-01-08	AIA	ETF	45.9	46.02	45.89	46.01	7841.0
2014-01-08	AIQ	ETF	27.0	27.49	27.0	27.12	43344.0
2014-01-08	AIVI	ETF	46.5	46.69	46.45	46.53	17200.0
2014-01-08	ALTL	ETF	32.67	32.67	32.67	32.67	615.0
2014-01-08	AMJ	ETF	45.51	45.6699	45.151	45.34	407231.0
2014-01-08	AMLP	ETF	87.95	88.0	87.05	87.2	715360.0
2014-01-08	ANGL	ETF	27.59	27.59	27.09	27.09	2000.0
2014-01-08	AOA	ETF	44.31	44.36	44.24	44.3	16600.0
2014-01-08	AOK	ETF	31.97	31.97	31.91	31.94	17497.0
2014-01-08	AOM	ETF	34.24	34.25	34.16	34.23	86419.0
2014-01-08	AOR	ETF	38.31	38.36	38.2509	38.3	18951.0
2014-01-08	ARGT	ETF	18.7	18.84	18.65	18.65	7400.0
2014-01-08	ASEA	ETF	15.09	15.1	15.0	15.04	17400.0
2014-01-08	ASHR	ETF	23.56	23.56	23.43	23.55	181900.0
2014-01-08	ATMP	ETF	26.76	26.76	26.63	26.72	22900.0
2014-01-08	AVIV	ETF	23.8	23.8	23.32	23.66	126148.0
2014-01-08	AWAY	ETF	42.45	42.57	41.39	41.61	965307.0
2014-01-08	BAB	ETF	27.45	27.45	27.38	27.415	153462.0
2014-01-08	BAL	ETF	52.92	53.061	52.161	52.191	4995.0
2014-01-08	BALT	ETF	6.5	6.69	6.32	6.61	1486070.0
2014-01-08	BBH	ETF	88.7	90.36	88.5	90.08	92200.0
2014-01-08	BCM	ETF	38.9	39.09	38.58	38.68	108627.0
2014-01-08	BFOR	ETF	7.4225	7.4325	7.39	7.4275	236400.0
2014-01-08	BIB	ETF	37.6825	39.25	37.5825	39.25	250472.0
2014-01-08	BICK	ETF	23.84	23.84	23.84	23.84	817.0
2014-01-08	BIL	ETF	91.56	91.56	91.54	91.56	120550.0
2014-01-08	BIS	ETF	823.6	833.2	792.244	795.56	623.5
2014-01-08	BIV	ETF	82.03	82.06	81.83	81.83	556900.0
2014-01-08	BIZD	ETF	20.85	20.88	20.77	20.83	3400.0
2014-01-08	BJK	ETF	54.64	54.77	54.51	54.76	19400.0
2014-01-08	BKF	ETF	36.15	36.31	36.02	36.09	83015.0
2014-01-08	BKLN	ETF	24.94	24.96	24.93	24.95	3197700.0
2014-01-08	BLV	ETF	82.25	82.28	81.88	82.18	63000.0

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

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