PREVIEW / etf_daily / 2014-03-17

all etf daily files

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

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-17	SPY	ETF	185.59	186.77	185.51	186.33	98359500.0
2014-03-17	QQQ	ETF	89.24	89.91	89.19	89.45	28476800.0
2014-03-17	IWM	ETF	118.22	119.1	117.88	118.06	41561600.0
2014-03-17	DIA	ETF	161.4	162.67	161.33	162.37	6641400.0
2014-03-17	GLD	ETF	132.73	133.22	131.22	131.64	14626800.0
2014-03-17	TLT	ETF	108.18	108.3	107.67	107.71	7381900.0
2014-03-17	AADR	ETF	37.13	37.6	37.13	37.55	14000.0
2014-03-17	AAXJ	ETF	57.2	57.51	57.2	57.32	299500.0
2014-03-17	ACWI	ETF	56.86	57.24	56.81	57.14	677200.0
2014-03-17	ACWV	ETF	63.46	63.52	63.3	63.34	24100.0
2014-03-17	ACWX	ETF	45.17	45.4599	45.17	45.41	279755.0
2014-03-17	ADRE	ETF	34.2	34.331	34.1901	34.22	7976.0
2014-03-17	AFK	ETF	31.23	31.31	31.05	31.11	14041.0
2014-03-17	AGG	ETF	107.91	107.98	107.83	107.87	590800.0
2014-03-17	AGQ	ETF	74.36	75.42	73.21	73.25	444000.0
2014-03-17	AGZ	ETF	111.98	112.007	111.6801	111.7	22499.0
2014-03-17	AIA	ETF	44.3	44.43	44.3	44.43	3323.0
2014-03-17	AIQ	ETF	29.45	29.75	29.01	29.69	16823.0
2014-03-17	AIRR	ETF	19.77	19.77	19.67	19.67	8200.0
2014-03-17	AIVI	ETF	48.41	48.69	48.41	48.68	10800.0
2014-03-17	AMJ	ETF	45.9	46.23	45.5001	46.19	391478.0
2014-03-17	AMLP	ETF	87.35	87.65	87.0	87.5	638360.0
2014-03-17	ANGL	ETF	27.5	27.5	27.48	27.5	1700.0
2014-03-17	AOA	ETF	44.64	44.87	44.64	44.81	14300.0
2014-03-17	AOK	ETF	32.23	32.27	32.21	32.22	27831.0
2014-03-17	AOM	ETF	34.57	34.6124	34.45	34.59	28895.0
2014-03-17	AOR	ETF	38.83	38.86	38.7301	38.86	10915.0
2014-03-17	ARGT	ETF	18.77	19.15	18.77	19.13	2600.0
2014-03-17	ASEA	ETF	15.77	15.88	15.77	15.88	3900.0
2014-03-17	ASHR	ETF	21.97	22.05	21.92	22.0	167300.0
2014-03-17	ATMP	ETF	27.8	27.8	27.25	27.45	20200.0
2014-03-17	AVIV	ETF	25.05	25.2	24.9	25.01	225072.0
2014-03-17	AWAY	ETF	43.17	43.8	42.71	43.07	1041797.0
2014-03-17	BAB	ETF	28.64	28.645	28.56	28.57	81235.0
2014-03-17	BAL	ETF	57.38	57.73	57.33	57.33	7016.0
2014-03-17	BALT	ETF	6.67	6.9	6.5	6.64	542343.0
2014-03-17	BBH	ETF	98.44	99.74	97.96	98.13	173300.0
2014-03-17	BCM	ETF	40.98	40.99	40.66	40.66	33231.0
2014-03-17	BFOR	ETF	7.5975	7.655	7.5975	7.605	204800.0
2014-03-17	BIB	ETF	47.59	48.62	46.815	46.99	472028.0
2014-03-17	BICK	ETF	23.18	23.189	23.115	23.115	10682.0
2014-03-17	BIL	ETF	91.54	91.56	91.54	91.54	504750.0
2014-03-17	BIS	ETF	610.8	625.196	600.0	622.54	8642.0
2014-03-17	BIV	ETF	83.61	83.65	83.45	83.52	251400.0
2014-03-17	BIZD	ETF	20.63	20.63	20.52	20.57	9300.0
2014-03-17	BJK	ETF	53.4	53.89	53.4	53.67	36200.0
2014-03-17	BKF	ETF	33.35	33.53	33.35	33.46	37511.0
2014-03-17	BKLN	ETF	24.79	24.79	24.78	24.78	1436200.0
2014-03-17	BLV	ETF	85.67	85.78	85.5	85.57	169300.0
2014-03-17	BMVP	ETF	23.427	23.55	23.427	23.451	5462.0

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

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