PREVIEW / etf_daily / 2014-03-31

all etf daily files

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

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-31	SPY	ETF	186.67	187.3	185.52	187.01	99745000.0
2014-03-31	QQQ	ETF	87.73	88.26	87.62	87.67	33924297.0
2014-03-31	IWM	ETF	115.04	116.68	114.63	116.34	44599200.0
2014-03-31	DIA	ETF	163.72	164.46	163.64	164.24	6368400.0
2014-03-31	GLD	ETF	124.52	124.79	123.57	123.61	12379200.0
2014-03-31	TLT	ETF	108.74	111.07	108.34	109.1	7488400.0
2014-03-31	AADR	ETF	37.7	37.7	37.7	37.7	200.0
2014-03-31	AAXJ	ETF	59.33	59.39	59.05	59.09	282700.0
2014-03-31	ACWI	ETF	58.12	58.24	58.02	58.14	1227500.0
2014-03-31	ACWV	ETF	64.32	64.43	64.13	64.35	20100.0
2014-03-31	ACWX	ETF	46.66	46.68	46.51	46.57	752322.0
2014-03-31	ADRE	ETF	36.37	36.52	36.322	36.3638	23706.0
2014-03-31	AFK	ETF	31.1	31.3799	31.04	31.11	59017.0
2014-03-31	AGG	ETF	107.83	107.98	107.74	107.91	1452200.0
2014-03-31	AGQ	ETF	64.21	64.7	63.73	64.12	228800.0
2014-03-31	AGZ	ETF	111.54	111.66	111.422	111.59	14058.0
2014-03-31	AIA	ETF	45.84	46.06	45.84	45.9137	19648.0
2014-03-31	AIQ	ETF	34.46	35.25	32.52	33.53	288299.0
2014-03-31	AIRR	ETF	19.48	19.67	19.473	19.61	10500.0
2014-03-31	AIVI	ETF	49.41	49.44	49.16	49.24	19800.0
2014-03-31	AMJ	ETF	46.41	46.54	46.08	46.54	362206.0
2014-03-31	AMLP	ETF	88.0	88.3	87.85	88.3	604480.0
2014-03-31	ANGL	ETF	28.55	29.3	27.47	27.47	10300.0
2014-03-31	AOA	ETF	45.29	45.39	45.22	45.36	15100.0
2014-03-31	AOK	ETF	32.38	32.39	32.31	32.39	45110.0
2014-03-31	AOM	ETF	34.71	34.8378	34.71	34.82	25654.0
2014-03-31	AOR	ETF	39.1	39.17	39.0425	39.14	37651.0
2014-03-31	ARGT	ETF	19.83	19.88	19.67	19.78	5600.0
2014-03-31	ASEA	ETF	16.03	16.06	15.96	16.02	7900.0
2014-03-31	ASHR	ETF	21.85	21.86	21.78	21.81	70700.0
2014-03-31	ATMP	ETF	27.56	27.73	27.56	27.73	14600.0
2014-03-31	AVIV	ETF	24.03	24.61	24.0	24.45	171177.0
2014-03-31	AWAY	ETF	38.21	38.42	37.54	37.67	1727044.0
2014-03-31	BAB	ETF	28.72	28.79	28.65	28.73	395776.0
2014-03-31	BAL	ETF	58.94	59.3	57.85	58.19	11086.0
2014-03-31	BALT	ETF	6.26	6.39	6.19	6.31	304662.0
2014-03-31	BBH	ETF	88.6	91.1	88.6	90.94	284900.0
2014-03-31	BCM	ETF	40.69	40.88	40.64	40.879	13034.0
2014-03-31	BFOR	ETF	7.54	7.605	7.5225	7.595	257200.0
2014-03-31	BIB	ETF	38.07	40.05	38.07	39.93	787500.0
2014-03-31	BICK	ETF	24.54	24.54	24.54	24.54	22.0
2014-03-31	BIL	ETF	91.56	91.56	91.54	91.54	425900.0
2014-03-31	BIS	ETF	747.2	753.2	712.4	712.8	11948.5
2014-03-31	BIV	ETF	83.13	83.33	83.1	83.33	227900.0
2014-03-31	BIZD	ETF	20.63	20.83	20.63	20.77	10400.0
2014-03-31	BJK	ETF	50.85	51.76	50.85	51.57	15100.0
2014-03-31	BKF	ETF	36.08	36.36	36.07	36.2201	126178.0
2014-03-31	BKLN	ETF	24.82	24.83	24.81	24.81	1259000.0
2014-03-31	BLV	ETF	86.46	86.75	86.15	86.73	123600.0
2014-03-31	BMVP	ETF	23.63	23.8	23.62	23.78	11135.0

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

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