PREVIEW / etf_daily / 2011-08-08

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-08.parquet
  size:    37 KB
  rows:    878

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
2011-08-08	SPY	ETF	116.91	120.12	112.02	112.26	702263900.0
2011-08-08	QQQ	ETF	52.21	53.12	50.59	50.59	204804043.0
2011-08-08	IWM	ETF	69.01	71.41	65.08	65.12	170159700.0
2011-08-08	DIA	ETF	111.27	113.03	108.02	108.07	30395700.0
2011-08-08	GLD	ETF	165.48	167.61	164.76	167.12	43002400.0
2011-08-08	TLT	ETF	103.18	105.79	102.95	105.55	38259500.0
2011-08-08	AADR	ETF	27.24	27.71	25.57	26.96	10600.0
2011-08-08	AAXJ	ETF	55.27	55.69	52.74	53.15	445500.0
2011-08-08	ACTV	ETF	16.77	16.81	14.04	14.7	401843.0
2011-08-08	ACWI	ETF	42.1	42.4	40.11	40.38	1069200.0
2011-08-08	ACWX	ETF	38.59	39.012	36.95	37.02	342192.0
2011-08-08	ADRE	ETF	39.75	40.07	37.71	38.281	343387.0
2011-08-08	AFK	ETF	28.24	28.51	27.07	27.2	55671.0
2011-08-08	AGEM	ETF	22.37	22.62	21.381	21.74	65880.0
2011-08-08	AGG	ETF	108.68	108.8	108.51	108.6	2068500.0
2011-08-08	AGQ	ETF	412.8	417.4	393.52	403.46	1116600.0
2011-08-08	AGZ	ETF	111.59	111.92	111.55	111.92	16114.0
2011-08-08	AIA	ETF	40.93	41.07	39.2	39.22	62310.0
2011-08-08	AIQ	ETF	15.0	15.45	13.75	13.75	31663.0
2011-08-08	AIS	ETF	1.92	2.02	1.8	1.8	2187589.0
2011-08-08	AIVI	ETF	40.47	40.83	38.57	38.75	93700.0
2011-08-08	AMJ	ETF	32.74	33.38	31.52	31.93	4298356.0
2011-08-08	AMLP	ETF	72.75	74.2	69.55	70.6	446440.0
2011-08-08	AOA	ETF	31.5	31.9	30.33	30.33	30200.0
2011-08-08	AOK	ETF	28.79	28.79	28.5	28.57	86743.0
2011-08-08	AOM	ETF	29.36	29.48	28.96	28.96	96334.0
2011-08-08	AOR	ETF	30.13	30.3584	29.42	29.42	71404.0
2011-08-08	ARB	ETF	35.7	37.18	33.3	33.32	295197.0
2011-08-08	ARGT	ETF	25.52	25.52	24.0	24.0	2400.0
2011-08-08	ASEA	ETF	16.0	16.03	15.38	15.48	12800.0
2011-08-08	AWAY	ETF	31.8	33.31	31.67	31.67	376159.0
2011-08-08	BAB	ETF	26.92	27.2	25.87	25.98	1128371.0
2011-08-08	BAL	ETF	62.08	62.2534	59.5	59.6	101280.0
2011-08-08	BALT	ETF	4.6	4.6	3.95	4.06	299222.0
2011-08-08	BBH	ETF	31.7267	31.7267	30.2667	30.3267	108000.0
2011-08-08	BCM	ETF	45.73	45.73	45.07	45.08	10370.0
2011-08-08	BIB	ETF	6.2962	6.5725	4.2412	5.9675	524352.0
2011-08-08	BICK	ETF	26.57	26.8642	25.36	25.7103	75281.0
2011-08-08	BIL	ETF	91.7	91.72	91.7	91.72	560600.0
2011-08-08	BIS	ETF	8417.6	9020.8	8417.6	9020.8	24.3
2011-08-08	BITS	ETF	19.8	20.96	19.44	20.176	2934.0
2011-08-08	BIV	ETF	86.56	87.46	86.5	86.75	371000.0
2011-08-08	BJK	ETF	31.86	32.36	29.95	30.23	83200.0
2011-08-08	BKF	ETF	40.36	40.7	38.18	38.77	572406.0
2011-08-08	BKLN	ETF	23.57	23.88	22.95	22.99	146000.0
2011-08-08	BLV	ETF	85.39	86.8	84.97	86.02	99400.0
2011-08-08	BMVP	ETF	13.0767	13.14	12.35	12.3621	17801.0
2011-08-08	BND	ETF	82.62	83.18	82.62	83.06	4990000.0
2011-08-08	BNO	ETF	34.01	35.805	34.01	34.615	133400.0
2011-08-08	BOSS	ETF	63.0	63.39	62.81	62.81	200.0

> showing 50 of 878 rows — these rows as CSV

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