PREVIEW / etf_daily / 2011-03-16

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-16.parquet
  size:    36 KB
  rows:    834

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-03-16	SPY	ETF	128.15	128.57	125.28	126.18	468670300.0
2011-03-16	QQQ	ETF	55.03	55.34	53.77	54.15	176506630.0
2011-03-16	IWM	ETF	78.68	79.64	77.76	78.25	126014500.0
2011-03-16	DIA	ETF	117.99	118.21	115.51	116.16	16469000.0
2011-03-16	GLD	ETF	136.52	137.2	135.8	136.24	13392500.0
2011-03-16	TLT	ETF	93.37	94.94	93.08	93.93	24294200.0
2011-03-16	AADR	ETF	29.28	29.29	28.55	28.68	31600.0
2011-03-16	AAXJ	ETF	59.85	59.85	58.29	58.77	987700.0
2011-03-16	ACWI	ETF	46.36	46.36	44.9	45.34	793400.0
2011-03-16	ACWX	ETF	42.75	42.85	41.4	41.82	151227.0
2011-03-16	ADRE	ETF	45.93	46.01	44.65	44.98	102958.0
2011-03-16	AFK	ETF	31.57	31.57	30.3615	30.8	29736.0
2011-03-16	AGG	ETF	105.96	106.54	105.86	106.03	1012200.0
2011-03-16	AGQ	ETF	381.22	392.42	364.88	371.5	701250.0
2011-03-16	AGZ	ETF	110.02	110.2999	109.881	110.07	282671.0
2011-03-16	AIA	ETF	44.76	44.9	43.77	43.95	36887.0
2011-03-16	AIQ	ETF	19.65	20.2	19.5	19.85	20794.0
2011-03-16	AIS	ETF	1.56	1.59	1.54	1.55	432854.0
2011-03-16	AIVI	ETF	44.02	44.09	42.5	42.87	25300.0
2011-03-16	AMJ	ETF	35.98	36.49	35.77	36.28	1143923.0
2011-03-16	AMLP	ETF	79.25	79.9	78.85	79.6	119240.0
2011-03-16	AOA	ETF	34.58	34.69	34.0	34.11	28600.0
2011-03-16	AOK	ETF	29.0	29.03	28.91	28.91	11204.0
2011-03-16	AOM	ETF	30.12	30.1472	29.95	29.97	17671.0
2011-03-16	AOR	ETF	31.79	31.79	31.424	31.5599	17701.0
2011-03-16	ARB	ETF	36.19	36.62	35.29	35.63	273519.0
2011-03-16	ARGT	ETF	29.02	29.02	28.1	28.22	1550.0
2011-03-16	ASEA	ETF	14.85	14.85	14.7	14.75	3000.0
2011-03-16	BAB	ETF	25.38	25.55	25.29	25.43	170634.0
2011-03-16	BAL	ETF	101.13	101.59	95.3915	96.0	125261.0
2011-03-16	BALT	ETF	8.75	8.88	8.57	8.78	157677.0
2011-03-16	BBH	ETF	34.0233	34.3333	33.89	34.03	27300.0
2011-03-16	BIB	ETF	7.4375	7.4375	7.4375	7.4375	800.0
2011-03-16	BICK	ETF	31.1	31.43	30.48	30.57	48053.0
2011-03-16	BIL	ETF	91.72	91.74	91.72	91.74	122300.0
2011-03-16	BITS	ETF	25.28	25.28	24.72	24.72	475.0
2011-03-16	BIV	ETF	83.51	84.03	83.37	83.45	258600.0
2011-03-16	BJK	ETF	30.09	30.19	29.37	29.66	23600.0
2011-03-16	BKF	ETF	47.49	47.68	46.23	46.76	361864.0
2011-03-16	BKLN	ETF	24.65	24.67	24.45	24.53	66100.0
2011-03-16	BLV	ETF	79.08	80.0	78.91	79.37	27800.0
2011-03-16	BMVP	ETF	14.82	14.92	14.55	14.66	25307.0
2011-03-16	BND	ETF	80.67	81.16	80.59	80.84	875800.0
2011-03-16	BNO	ETF	36.61	37.155	36.545	36.855	213400.0
2011-03-16	BOSS	ETF	44.35	44.87	44.35	44.87	200.0
2011-03-16	BRF	ETF	52.46	52.82	51.37	51.67	332388.0
2011-03-16	BSCE	ETF	20.98	21.0	20.96	21.0	10874.0
2011-03-16	BSV	ETF	80.65	80.79	80.61	80.68	1132600.0
2011-03-16	BTF	ETF	81.35	82.24999999999999	80.85000000000001	81.64999999999999	9844.400000000001
2011-03-16	BWX	ETF	30.01	30.45	29.8208	30.07	373474.0

> showing 50 of 834 rows — these rows as CSV

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