PREVIEW / etf_daily / 2013-12-13

all etf daily files

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

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-13	SPY	ETF	178.5	178.66	177.77	178.11	107808000.0
2013-12-13	QQQ	ETF	85.36	85.4	84.709	84.85	34075415.0
2013-12-13	IWM	ETF	110.05	110.53	109.42	110.2	32980300.0
2013-12-13	DIA	ETF	157.54	157.97	157.1	157.65	8886500.0
2013-12-13	GLD	ETF	118.89	119.49	118.76	119.38	6482100.0
2013-12-13	TLT	ETF	103.14	103.3	102.79	103.21	6471300.0
2013-12-13	AADR	ETF	36.3	36.3	36.04	36.04	5600.0
2013-12-13	AAXJ	ETF	59.41	59.58	59.22	59.44	451600.0
2013-12-13	ACWI	ETF	55.58	55.6	55.34	55.47	6322800.0
2013-12-13	ACWV	ETF	63.02	63.02	62.64	62.83	29400.0
2013-12-13	ACWX	ETF	44.97	45.0708	44.88	45.02	271579.0
2013-12-13	ADRE	ETF	36.9	36.96	36.72	36.81	12745.0
2013-12-13	AFK	ETF	30.75	30.75	30.46	30.57	16677.0
2013-12-13	AGG	ETF	106.85	106.85	106.62	106.65	3461600.0
2013-12-13	AGQ	ETF	64.4	65.36	64.04	64.76	181250.0
2013-12-13	AGZ	ETF	110.83	110.95	110.83	110.9476	18425.0
2013-12-13	AIA	ETF	47.63	47.68	47.4501	47.68	16217.0
2013-12-13	AIQ	ETF	21.81	23.23	21.671	23.1	53010.0
2013-12-13	AIVI	ETF	45.73	45.73	45.35	45.61	62800.0
2013-12-13	AMJ	ETF	43.8	44.1	43.35	43.87	455603.0
2013-12-13	AMLP	ETF	85.55	86.0	85.15	85.7	864840.0
2013-12-13	ANGL	ETF	26.87	27.11	26.87	27.08	800.0
2013-12-13	AOA	ETF	43.26	43.26	43.12	43.23	38500.0
2013-12-13	AOK	ETF	31.6101	31.68	31.6	31.645	13839.0
2013-12-13	AOM	ETF	33.79	33.84	33.74	33.82	86490.0
2013-12-13	AOR	ETF	37.73	37.73	37.61	37.67	108805.0
2013-12-13	ARGT	ETF	19.48	19.48	19.39	19.44	3100.0
2013-12-13	ASEA	ETF	15.8	15.8	15.69	15.78	56000.0
2013-12-13	ASHR	ETF	25.27	25.33	25.18	25.29	941200.0
2013-12-13	ATMP	ETF	25.91	25.91	25.61	25.76	11000.0
2013-12-13	AVIV	ETF	23.87	24.01	23.64	23.84	90183.0
2013-12-13	AWAY	ETF	37.92	38.47	37.21	37.86	1273032.0
2013-12-13	BAB	ETF	27.42	27.485	27.4101	27.45	159166.0
2013-12-13	BAL	ETF	51.9451	52.32	51.94	52.1501	5775.0
2013-12-13	BALT	ETF	5.44	5.75	5.38	5.64	2412536.0
2013-12-13	BBH	ETF	84.93	85.0	84.05	84.78	34200.0
2013-12-13	BCM	ETF	39.39	39.41	39.351	39.41	60657.0
2013-12-13	BFOR	ETF	7.15	7.1825	7.1225	7.1525	164400.0
2013-12-13	BIB	ETF	34.0625	34.4748	33.5225	34.155	186020.0
2013-12-13	BICK	ETF	24.13	24.13	24.051	24.11	1474.0
2013-12-13	BIL	ETF	91.58	91.58	91.56	91.58	75850.0
2013-12-13	BIS	ETF	926.0	938.712	916.0	916.0	843.0
2013-12-13	BIV	ETF	83.0	83.17	82.97	83.09	265400.0
2013-12-13	BIZD	ETF	21.07	21.07	20.76	20.87	4300.0
2013-12-13	BJK	ETF	51.66	51.76	51.45	51.59	8200.0
2013-12-13	BKF	ETF	37.34	37.3936	37.14	37.26	80618.0
2013-12-13	BKLN	ETF	24.78	24.78	24.75	24.77	2147100.0
2013-12-13	BLV	ETF	82.4	82.58	82.23	82.41	28500.0
2013-12-13	BMVP	ETF	22.0	22.063	21.936	22.01	10797.0
2013-12-13	BND	ETF	80.43	80.47	80.38	80.43	1117500.0

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

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