PREVIEW / etf_daily / 2013-12-31

all etf daily files

  file:    by_date/etf_daily/2013/2013-12-31.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
2013-12-31	SPY	ETF	184.07	184.69	183.93	184.69	86119900.0
2013-12-31	QQQ	ETF	87.54	87.96	87.52	87.96	24896065.0
2013-12-31	IWM	ETF	115.36	115.71	115.17	115.36	38357200.0
2013-12-31	DIA	ETF	164.94	165.51	164.81	165.47	5667800.0
2013-12-31	GLD	ETF	114.61	117.13	114.46	116.12	12835900.0
2013-12-31	TLT	ETF	102.29	102.55	101.17	101.86	7218600.0
2013-12-31	AADR	ETF	38.01	38.01	37.47	37.47	900.0
2013-12-31	AAXJ	ETF	59.87	60.36	59.87	60.31	399200.0
2013-12-31	ACWI	ETF	57.52	57.68	57.46	57.62	1597400.0
2013-12-31	ACWV	ETF	63.43	63.72	63.4	63.67	24100.0
2013-12-31	ACWX	ETF	46.65	46.78	46.55	46.67	261447.0
2013-12-31	ADRE	ETF	37.1	37.156	37.0	37.14	29911.0
2013-12-31	AFK	ETF	30.61	31.0	30.5	30.92	34309.0
2013-12-31	AGG	ETF	106.48	106.58	106.37	106.43	3280300.0
2013-12-31	AGQ	ETF	60.0	65.4	59.88	63.04	864000.0
2013-12-31	AGZ	ETF	110.71	110.71	110.42	110.55	64235.0
2013-12-31	AGZD	ETF	25.0	25.0	25.0	25.0	20000.0
2013-12-31	AIA	ETF	47.78	48.0	47.74	47.98	18455.0
2013-12-31	AIQ	ETF	25.0	25.02	24.3	24.74	422429.0
2013-12-31	AIVI	ETF	47.38	47.75	47.27	47.62	15700.0
2013-12-31	ALTL	ETF	33.02	33.02	32.9287	32.9287	645.0
2013-12-31	AMJ	ETF	46.1	46.61	45.91	46.35	452186.0
2013-12-31	AMLP	ETF	88.85	89.15	88.75	88.95	475080.0
2013-12-31	AOA	ETF	44.57	44.64	44.54	44.61	29800.0
2013-12-31	AOK	ETF	32.0	32.05	31.978	32.0099	67540.0
2013-12-31	AOM	ETF	34.34	34.36	34.28	34.31	42663.0
2013-12-31	AOR	ETF	38.5	38.55	38.4401	38.5	35117.0
2013-12-31	ARGT	ETF	19.59	19.75	19.56	19.56	2600.0
2013-12-31	ASEA	ETF	15.46	15.5	15.41	15.5	164300.0
2013-12-31	ASHR	ETF	24.48	24.67	24.37	24.66	188800.0
2013-12-31	ATMP	ETF	27.44	27.47	27.38	27.41	20700.0
2013-12-31	AVIV	ETF	23.41	23.94	23.11	23.7	159363.0
2013-12-31	AWAY	ETF	40.73	41.78	40.16	40.88	543755.0
2013-12-31	BAB	ETF	27.39	27.43	27.28	27.2901	341534.0
2013-12-31	BAL	ETF	53.37	53.63	53.18	53.18	5737.0
2013-12-31	BALT	ETF	6.15	6.5501	6.1	6.44	1234818.0
2013-12-31	BBH	ETF	88.69	88.82	88.0	88.52	65300.0
2013-12-31	BCM	ETF	39.59	39.65	39.48	39.51	604267.0
2013-12-31	BFOR	ETF	7.4625	7.4825	7.4525	7.4675	290000.0
2013-12-31	BIB	ETF	37.8675	37.99	37.255	37.6225	91008.0
2013-12-31	BICK	ETF	24.8	24.82	24.7498	24.82	1198.0
2013-12-31	BIL	ETF	91.54	91.58	91.54	91.54	209300.0
2013-12-31	BIS	ETF	826.4	833.6	825.6	825.6	267.0
2013-12-31	BIV	ETF	81.81	81.95	81.63	81.7	395500.0
2013-12-31	BIZD	ETF	21.02	21.04	20.94	20.98	10400.0
2013-12-31	BJK	ETF	53.2	53.43	52.88	53.4	14100.0
2013-12-31	BKF	ETF	37.5	37.76	37.42	37.69	75760.0
2013-12-31	BKLN	ETF	24.86	24.88	24.86	24.88	2250300.0
2013-12-31	BLNG	ETF	33.7199	34.14	33.7199	34.14	600.0
2013-12-31	BLV	ETF	82.05	82.13	81.36	81.65	43500.0

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

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