PREVIEW / etf_daily / 2013-12-12

all etf daily files

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

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-12	SPY	ETF	178.64	178.86	177.76	178.13	115565000.0
2013-12-12	QQQ	ETF	85.24	85.4201	84.9	84.96	33662597.0
2013-12-12	IWM	ETF	109.7	110.25	109.36	109.84	37706200.0
2013-12-12	DIA	ETF	158.21	158.43	157.07	157.47	7078700.0
2013-12-12	GLD	ETF	118.61	118.82	118.03	118.29	8810800.0
2013-12-12	TLT	ETF	103.03	103.16	102.63	102.71	6208600.0
2013-12-12	AAXJ	ETF	59.52	59.58	59.17	59.22	1282400.0
2013-12-12	ACWI	ETF	55.62	55.78	55.37	55.49	9388300.0
2013-12-12	ACWV	ETF	63.21	63.21	62.65	62.75	39400.0
2013-12-12	ACWX	ETF	45.13	45.15	44.89	45.01	380522.0
2013-12-12	ADRE	ETF	36.9	36.9	36.5901	36.7	7317.0
2013-12-12	AFK	ETF	30.789	30.789	30.42	30.48	12087.0
2013-12-12	AGG	ETF	106.72	106.72	106.57	106.6	2260000.0
2013-12-12	AGQ	ETF	63.96	64.2	63.2	63.8	548500.0
2013-12-12	AGZ	ETF	111.0	111.0	110.8939	110.8939	39959.0
2013-12-12	AIA	ETF	47.71	47.71	47.38	47.432	24276.0
2013-12-12	AIQ	ETF	20.55	21.779	20.55	21.48	76482.0
2013-12-12	AIVI	ETF	45.65	45.81	45.5	45.51	85000.0
2013-12-12	AMJ	ETF	43.72	43.93	43.36	43.7	417675.0
2013-12-12	AMLP	ETF	85.65	85.75	85.0	85.5	473000.0
2013-12-12	ANGL	ETF	27.15	27.15	27.1	27.1	700.0
2013-12-12	AOA	ETF	43.22	43.3	43.08	43.15	91500.0
2013-12-12	AOK	ETF	31.68	31.6862	31.6	31.65	20327.0
2013-12-12	AOM	ETF	33.85	33.85	33.75	33.75	113784.0
2013-12-12	AOR	ETF	37.68	37.712	37.6	37.67	102710.0
2013-12-12	ARGT	ETF	19.65	19.65	19.35	19.57	23100.0
2013-12-12	ASEA	ETF	15.82	15.89	15.8	15.8	443200.0
2013-12-12	ASHR	ETF	25.17	25.26	25.1	25.19	179000.0
2013-12-12	ATMP	ETF	25.47	25.71	25.46	25.7	24900.0
2013-12-12	AVIV	ETF	24.03	24.24	23.83	23.85	91409.0
2013-12-12	AWAY	ETF	36.58	37.62	36.41	37.43	6334211.0
2013-12-12	BAB	ETF	27.57	27.57	27.48	27.49	105014.0
2013-12-12	BAL	ETF	51.83	52.16	51.5	52.16	4046.0
2013-12-12	BALT	ETF	5.48	5.62	5.35	5.46	898941.0
2013-12-12	BBH	ETF	84.11	85.32	84.05	84.68	65800.0
2013-12-12	BCM	ETF	39.52	39.52	39.4	39.41	59921.0
2013-12-12	BFOR	ETF	7.1425	7.1675	7.1125	7.14	202400.0
2013-12-12	BIB	ETF	33.3225	34.6675	33.3225	34.2125	205856.0
2013-12-12	BICK	ETF	24.31	24.31	24.09	24.1	674.0
2013-12-12	BIL	ETF	91.58	91.58	91.56	91.58	1124650.0
2013-12-12	BIS	ETF	925.96	925.96	906.004	911.44	252.0
2013-12-12	BIV	ETF	83.06	83.1	82.94	83.0	614300.0
2013-12-12	BIZD	ETF	20.94	21.0	20.87	20.96	3800.0
2013-12-12	BJK	ETF	51.34	51.66	51.25	51.29	11300.0
2013-12-12	BKF	ETF	37.23	37.289	37.032	37.2	65221.0
2013-12-12	BKLN	ETF	24.87	24.87	24.84	24.84	3637700.0
2013-12-12	BLV	ETF	82.24	82.28	82.06	82.14	29200.0
2013-12-12	BMVP	ETF	21.953	22.051	21.953	21.993	7650.0
2013-12-12	BND	ETF	80.42	80.47	80.33	80.34	1917600.0
2013-12-12	BNDX	ETF	49.83	49.85	49.75	49.82	234900.0

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

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