PREVIEW / etf_daily / 2012-07-26

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-26.parquet
  size:    39 KB
  rows:    942

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
2012-07-26	SPY	ETF	135.89	136.46	135.26	136.17	156526500.0
2012-07-26	QQQ	ETF	63.44	63.73	62.97	63.37	41934261.0
2012-07-26	IWM	ETF	77.98	78.18	77.0	77.48	44745100.0
2012-07-26	DIA	ETF	128.17	129.03	127.93	128.58	8074000.0
2012-07-26	GLD	ETF	156.7	157.26	156.05	156.77	7343500.0
2012-07-26	TLT	ETF	131.53	131.78	130.9	130.95	6606200.0
2012-07-26	AADR	ETF	28.37	28.37	28.37	28.37	200.0
2012-07-26	AAXJ	ETF	51.52	51.77	51.3	51.58	261500.0
2012-07-26	ACTV	ETF	14.37	14.65	14.25	14.26	115596.0
2012-07-26	ACWI	ETF	43.51	43.76	43.4	43.66	195600.0
2012-07-26	ACWV	ETF	55.06	55.1	54.87	55.1	15000.0
2012-07-26	ACWX	ETF	36.56	36.71	36.48	36.67	219527.0
2012-07-26	ADRE	ETF	36.81	37.28	36.735	37.23	52537.0
2012-07-26	AFK	ETF	27.64	27.94	27.64	27.94	8699.0
2012-07-26	AGEM	ETF	20.911	21.14	20.911	21.09	3194.0
2012-07-26	AGG	ETF	112.66	112.69	112.62	112.63	857900.0
2012-07-26	AGQ	ETF	153.2	154.28	150.08	151.8	200775.0
2012-07-26	AGZ	ETF	114.02	114.13	113.98	114.09	6398.0
2012-07-26	AIA	ETF	40.87	40.88	40.6122	40.88	8434.0
2012-07-26	AIQ	ETF	4.0	4.0535	3.611	3.65	16498.0
2012-07-26	AIVI	ETF	37.11	37.27	37.0	37.26	44300.0
2012-07-26	AMJ	ETF	39.32	39.42	38.915	39.39	1551844.0
2012-07-26	AMLP	ETF	81.8	82.2	81.4	82.1	362460.0
2012-07-26	ANGL	ETF	25.78	25.78	25.58	25.58	1800.0
2012-07-26	AOA	ETF	34.84	34.93	34.76	34.87	11500.0
2012-07-26	AOK	ETF	29.92	29.9852	29.9101	29.98	9389.0
2012-07-26	AOM	ETF	30.8	30.82	30.7	30.81	21216.0
2012-07-26	AOR	ETF	32.48	32.51	32.358	32.51	11736.0
2012-07-26	ARB	ETF	35.75	35.98	35.402	35.72	84914.0
2012-07-26	ARGT	ETF	15.9	15.9	15.9	15.9	500.0
2012-07-26	ASEA	ETF	15.99	16.12	15.9	16.04	28800.0
2012-07-26	AWAY	ETF	20.85	23.04	20.85	22.42	1164067.0
2012-07-26	BAB	ETF	30.71	30.74	30.62	30.6699	172267.0
2012-07-26	BAL	ETF	46.16	47.5	45.9951	47.05	41229.0
2012-07-26	BALT	ETF	3.33	3.33	3.18	3.21	81207.0
2012-07-26	BBH	ETF	49.18	49.43	48.95	49.38	12400.0
2012-07-26	BCM	ETF	43.6399	43.6399	43.4301	43.4301	360.0
2012-07-26	BIB	ETF	13.875	14.2513	13.875	14.1074	166152.0
2012-07-26	BICK	ETF	21.53	21.79	21.5101	21.77	10975.0
2012-07-26	BIL	ETF	91.64	91.66	91.64	91.64	424850.0
2012-07-26	BIS	ETF	2992.0	2992.0	2857.76	2881.6	82.0
2012-07-26	BIV	ETF	90.21	90.22	90.11	90.17	184400.0
2012-07-26	BJK	ETF	29.65	29.74	29.31	29.64	13400.0
2012-07-26	BKF	ETF	34.88	35.14	34.67	35.14	165672.0
2012-07-26	BKLN	ETF	24.53	24.56	24.53	24.53	270900.0
2012-07-26	BLV	ETF	99.38	99.54	99.2	99.25	47600.0
2012-07-26	BMVP	ETF	15.1367	15.19	15.084	15.1328	4132.0
2012-07-26	BND	ETF	85.33	85.35	85.28	85.3	702700.0
2012-07-26	BNO	ETF	37.545	37.615	37.27	37.46	47600.0
2012-07-26	BOIL	ETF	1061600.0	1082800.0	1010000.0	1067000.0	8.2

> showing 50 of 942 rows — these rows as CSV

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