PREVIEW / etf_daily / 2014-03-20

all etf daily files

  file:    by_date/etf_daily/2014/2014-03-20.parquet
  size:    43 KB
  rows:    1,063

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-03-20	SPY	ETF	186.25	187.89	185.92	187.75	117241000.0
2014-03-20	QQQ	ETF	89.78	90.56	89.58	90.29	31634538.0
2014-03-20	IWM	ETF	118.73	119.54	118.16	119.16	33212900.0
2014-03-20	DIA	ETF	161.85	163.47	161.48	163.3	6616200.0
2014-03-20	GLD	ETF	127.78	128.41	127.58	127.86	7690800.0
2014-03-20	TLT	ETF	107.09	107.63	106.99	107.07	5224400.0
2014-03-20	AADR	ETF	37.33	37.33	37.17	37.17	800.0
2014-03-20	AAXJ	ETF	55.93	56.51	55.86	56.45	504800.0
2014-03-20	ACWI	ETF	56.74	57.16	56.59	57.11	766700.0
2014-03-20	ACWV	ETF	62.95	63.13	62.76	63.08	58800.0
2014-03-20	ACWX	ETF	44.69	45.13	44.68	45.06	335268.0
2014-03-20	ADRE	ETF	34.15	34.64	34.15	34.545	6975.0
2014-03-20	AFK	ETF	30.55	31.16	30.55	30.94	34916.0
2014-03-20	AGG	ETF	107.45	107.53	107.39	107.44	1100600.0
2014-03-20	AGQ	ETF	67.85	68.49	67.35	67.52	417400.0
2014-03-20	AGZ	ETF	111.45	111.49	111.37	111.37	5030.0
2014-03-20	AIA	ETF	43.26	43.65	43.1101	43.54	14785.0
2014-03-20	AIQ	ETF	28.96	29.8	28.96	29.57	12569.0
2014-03-20	AIRR	ETF	19.9	19.9	19.78	19.83	45400.0
2014-03-20	AIVI	ETF	48.01	48.48	48.01	48.44	24300.0
2014-03-20	ALTL	ETF	33.82	33.82	33.77	33.79	5237.0
2014-03-20	AMJ	ETF	45.8	46.13	45.54	46.09	418020.0
2014-03-20	AMLP	ETF	87.3	87.5	86.8	87.5	563880.0
2014-03-20	ANGL	ETF	27.76	27.78	27.73	27.77	4400.0
2014-03-20	AOA	ETF	44.64	44.86	44.51	44.84	45500.0
2014-03-20	AOK	ETF	32.13	32.2	32.1	32.16	50933.0
2014-03-20	AOM	ETF	34.45	34.56	34.42	34.5	33414.0
2014-03-20	AOR	ETF	38.57	38.81	38.5501	38.81	36402.0
2014-03-20	ARGT	ETF	19.07	19.09	19.05	19.05	4700.0
2014-03-20	ASEA	ETF	15.3	15.51	15.3	15.41	524100.0
2014-03-20	ASHR	ETF	21.27	21.31	21.13	21.27	137200.0
2014-03-20	ATMP	ETF	27.12	27.38	27.07	27.37	94200.0
2014-03-20	AVIV	ETF	24.8	24.8	24.4	24.56	35507.0
2014-03-20	AWAY	ETF	42.05	43.05	41.47	41.5	927475.0
2014-03-20	BAB	ETF	28.51	28.57	28.4201	28.46	102261.0
2014-03-20	BAL	ETF	57.95	58.07	57.52	57.6001	11741.0
2014-03-20	BALT	ETF	6.74	6.8099	6.5	6.56	561681.0
2014-03-20	BBH	ETF	99.37	99.75	98.62	99.01	56700.0
2014-03-20	BCM	ETF	40.47	40.518	40.4	40.518	3854.0
2014-03-20	BFOR	ETF	7.6375	7.6825	7.605	7.6725	99200.0
2014-03-20	BIB	ETF	48.5	48.7499	47.38	47.865	242372.0
2014-03-20	BICK	ETF	22.93	23.1399	22.93	23.1399	1680.0
2014-03-20	BIL	ETF	91.54	91.56	91.54	91.54	71650.0
2014-03-20	BIS	ETF	609.6	613.92	596.8	609.6	4810.0
2014-03-20	BIV	ETF	82.88	83.11	82.88	83.07	138800.0
2014-03-20	BIZD	ETF	20.51	20.64	20.51	20.63	5200.0
2014-03-20	BJK	ETF	52.38	52.49	51.86	52.24	20700.0
2014-03-20	BKF	ETF	33.49	33.9395	33.42	33.75	105809.0
2014-03-20	BKLN	ETF	24.78	24.8	24.76	24.8	2663200.0
2014-03-20	BLV	ETF	85.21	85.48	85.17	85.24	44900.0

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

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