PREVIEW / etf_daily / 2013-12-04

all etf daily files

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

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-04	SPY	ETF	179.1	180.48	178.35	179.73	123033000.0
2013-12-04	QQQ	ETF	85.06	85.77	84.78	85.49	37193220.0
2013-12-04	IWM	ETF	111.31	112.42	110.37	111.53	40609500.0
2013-12-04	DIA	ETF	158.46	159.52	157.83	158.76	7138200.0
2013-12-04	GLD	ETF	118.33	120.76	118.16	119.96	9110700.0
2013-12-04	TLT	ETF	102.75	103.05	102.38	102.72	8502700.0
2013-12-04	AADR	ETF	36.56	36.56	36.35	36.35	400.0
2013-12-04	AAXJ	ETF	59.86	60.4	59.71	60.19	626100.0
2013-12-04	ACWI	ETF	56.02	56.3	55.74	56.15	1026300.0
2013-12-04	ACWV	ETF	63.31	63.69	63.25	63.62	30500.0
2013-12-04	ACWX	ETF	45.38	45.62	45.2576	45.57	182946.0
2013-12-04	ADRE	ETF	37.07	37.25	36.91	37.2	38416.0
2013-12-04	AFK	ETF	30.6	30.75	30.53	30.75	13674.0
2013-12-04	AGG	ETF	106.61	106.77	106.59	106.68	1205300.0
2013-12-04	AGQ	ETF	62.52	66.24	62.36	65.24	597800.0
2013-12-04	AGZ	ETF	111.2439	111.374	111.1501	111.2	6308.0
2013-12-04	AIA	ETF	48.56	48.66	48.26	48.65	17338.0
2013-12-04	AIQ	ETF	26.38	27.419	25.8	26.16	19702.0
2013-12-04	AIVI	ETF	46.0	46.25	45.85	46.23	10700.0
2013-12-04	ALTL	ETF	31.9899	31.9899	31.9899	31.9899	500.0
2013-12-04	AMJ	ETF	45.04	45.2	44.47	44.61	1027990.0
2013-12-04	AMLP	ETF	87.5	87.7	86.55	86.8	585960.0
2013-12-04	ANGL	ETF	26.85	27.08	26.85	27.04	2600.0
2013-12-04	AOA	ETF	43.41	43.66	43.32	43.55	19500.0
2013-12-04	AOK	ETF	31.71	31.79	31.67	31.733	30541.0
2013-12-04	AOM	ETF	33.9	34.006	33.8551	33.92	46336.0
2013-12-04	AOR	ETF	37.77	37.9644	37.74	37.9	30939.0
2013-12-04	ARGT	ETF	19.82	19.88	19.63	19.88	3600.0
2013-12-04	ASEA	ETF	16.07	16.2	16.05	16.2	7000.0
2013-12-04	ASHR	ETF	25.91	26.08	25.86	26.05	483500.0
2013-12-04	ATMP	ETF	26.27	26.27	26.11	26.18	20600.0
2013-12-04	AVIV	ETF	24.19	24.96	24.0	24.8	93195.0
2013-12-04	AWAY	ETF	38.01	38.66	37.4	38.31	2205254.0
2013-12-04	BAB	ETF	27.48	27.48	27.34	27.42	409003.0
2013-12-04	BAL	ETF	49.4	49.7692	49.4	49.49	3371.0
2013-12-04	BALT	ETF	4.85	5.12	4.84	5.05	899814.0
2013-12-04	BBH	ETF	86.25	86.7	85.64	86.5	45400.0
2013-12-04	BCM	ETF	39.57	39.59	39.57	39.59	312750.0
2013-12-04	BFOR	ETF	7.2175	7.26	7.16	7.2125	116400.0
2013-12-04	BIB	ETF	34.8575	35.9825	34.635	35.515	195552.0
2013-12-04	BICK	ETF	24.37	24.39	24.3699	24.37	1644.0
2013-12-04	BIL	ETF	91.58	91.58	91.56	91.58	329300.0
2013-12-04	BIS	ETF	888.0	902.4	876.8	876.8	498.5
2013-12-04	BIV	ETF	83.01	83.17	83.0	83.1	195700.0
2013-12-04	BIZD	ETF	21.13	21.23	20.98	21.23	17700.0
2013-12-04	BJK	ETF	50.0	50.88	50.0	50.74	43400.0
2013-12-04	BKF	ETF	37.51	37.88	37.427	37.81	77661.0
2013-12-04	BKLN	ETF	24.84	24.85	24.81	24.83	3274600.0
2013-12-04	BLV	ETF	81.83	81.88	81.45	81.62	81300.0
2013-12-04	BMVP	ETF	22.227	22.355	22.02	22.2	8050.0

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

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