PREVIEW / etf_daily / 2013-12-05

all etf daily files

  file:    by_date/etf_daily/2013/2013-12-05.parquet
  size:    42 KB
  rows:    1,041

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-05	SPY	ETF	179.41	179.74	178.77	178.94	106934000.0
2013-12-05	QQQ	ETF	85.57	85.66	85.17	85.38	39829338.0
2013-12-05	IWM	ETF	111.49	112.02	111.15	111.61	37926700.0
2013-12-05	DIA	ETF	158.45	158.89	158.01	158.12	5823000.0
2013-12-05	GLD	ETF	118.2	119.24	117.41	118.3	10254700.0
2013-12-05	TLT	ETF	102.48	102.85	102.22	102.43	7445700.0
2013-12-05	AADR	ETF	37.51	37.52	37.45	37.45	1100.0
2013-12-05	AAXJ	ETF	60.21	60.23	59.84	59.92	582400.0
2013-12-05	ACWI	ETF	56.11	56.15	55.85	55.89	887600.0
2013-12-05	ACWV	ETF	63.59	63.61	63.13	63.16	49000.0
2013-12-05	ACWX	ETF	45.51	45.532	45.2901	45.34	166895.0
2013-12-05	ADRE	ETF	37.27	37.34	37.05	37.11	14525.0
2013-12-05	AFK	ETF	30.46	30.83	30.45	30.66	22174.0
2013-12-05	AGG	ETF	106.62	106.7	106.45	106.45	1882800.0
2013-12-05	AGQ	ETF	62.8	65.36	62.24	63.12	502725.0
2013-12-05	AGZ	ETF	111.25	111.3775	111.06	111.06	14689.0
2013-12-05	AIA	ETF	48.43	48.53	48.3	48.35	32055.0
2013-12-05	AIQ	ETF	26.11	26.2	23.41	23.86	87651.0
2013-12-05	AIVI	ETF	46.1	46.1	45.87	45.93	11300.0
2013-12-05	ALTL	ETF	31.7399	31.74	31.7	31.7	4702.0
2013-12-05	AMJ	ETF	44.42	44.53	44.17	44.25	1065898.0
2013-12-05	AMLP	ETF	86.85	87.3	86.1	86.2	582420.0
2013-12-05	ANGL	ETF	27.1	27.1	27.1	27.1	300.0
2013-12-05	AOA	ETF	43.49	43.52	43.39	43.39	39100.0
2013-12-05	AOK	ETF	31.75	31.75	31.691	31.7	10424.0
2013-12-05	AOM	ETF	33.84	33.94	33.84	33.9	75103.0
2013-12-05	AOR	ETF	37.81	37.89	37.767	37.799	52412.0
2013-12-05	ARGT	ETF	19.75	19.78	19.72	19.78	14400.0
2013-12-05	ASEA	ETF	16.05	16.06	15.98	15.99	9400.0
2013-12-05	ASHR	ETF	25.98	25.98	25.72	25.74	465600.0
2013-12-05	ATMP	ETF	26.04	26.04	25.98	26.02	4500.0
2013-12-05	AVIV	ETF	24.71	25.24	24.6201	24.86	81721.0
2013-12-05	AWAY	ETF	39.01	40.85	38.57	39.57	3170349.0
2013-12-05	BAB	ETF	27.38	27.43	27.32	27.38	478655.0
2013-12-05	BAL	ETF	49.59	49.77	49.39	49.3901	43592.0
2013-12-05	BALT	ETF	5.12	5.48	5.12	5.46	2585223.0
2013-12-05	BBH	ETF	86.37	86.69	85.99	86.38	23200.0
2013-12-05	BCM	ETF	39.421	39.421	39.41	39.41	2168.0
2013-12-05	BFOR	ETF	7.22	7.235	7.2	7.21	294000.0
2013-12-05	BIB	ETF	35.465	36.1944	35.355	35.745	197720.0
2013-12-05	BICK	ETF	24.38	24.53	24.38	24.53	2125.0
2013-12-05	BIL	ETF	91.58	91.58	91.56	91.58	139800.0
2013-12-05	BIS	ETF	887.2	891.96	876.0	889.6	136.0
2013-12-05	BIV	ETF	83.0	83.1	82.91	82.95	572800.0
2013-12-05	BIZD	ETF	21.09	21.14	21.09	21.09	9600.0
2013-12-05	BJK	ETF	50.42	51.11	50.42	50.85	17300.0
2013-12-05	BKF	ETF	37.6	37.859	37.6	37.65	27414.0
2013-12-05	BKLN	ETF	24.83	24.85	24.81	24.84	1350600.0
2013-12-05	BLV	ETF	81.58	81.72	81.39	81.44	127000.0
2013-12-05	BMVP	ETF	22.1867	22.1933	22.0687	22.0832	6086.0

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

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