PREVIEW / etf_daily / 2011-09-15

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-15.parquet
  size:    36 KB
  rows:    867

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-09-15	SPY	ETF	120.65	121.47	119.4	121.43	326777200.0
2011-09-15	QQQ	ETF	55.97	56.28	55.39	56.18	83536091.0
2011-09-15	IWM	ETF	71.07	71.44	69.99	71.41	74213100.0
2011-09-15	DIA	ETF	113.43	114.33	112.83	114.26	9646000.0
2011-09-15	GLD	ETF	174.61	174.85	172.56	174.4	20897000.0
2011-09-15	TLT	ETF	111.98	112.49	111.43	111.43	8884000.0
2011-09-15	AADR	ETF	28.38	28.5	28.3	28.5	84300.0
2011-09-15	AAXJ	ETF	53.03	53.37	52.65	53.22	219900.0
2011-09-15	ACTV	ETF	15.76	15.76	14.99	15.55	64268.0
2011-09-15	ACWI	ETF	42.11	42.45	41.82	42.4	1145600.0
2011-09-15	ACWX	ETF	37.85	37.996	37.506	37.95	175983.0
2011-09-15	ADRE	ETF	40.62	40.738	40.29	40.68	225082.0
2011-09-15	AFK	ETF	28.91	28.92	28.5	28.92	11866.0
2011-09-15	AGEM	ETF	22.51	22.52	22.41	22.52	6251.0
2011-09-15	AGG	ETF	109.84	109.92	109.68	109.68	1046700.0
2011-09-15	AGQ	ETF	417.0	422.2	400.66	411.44	448900.0
2011-09-15	AGZ	ETF	112.39	112.8297	112.33	112.39	9945.0
2011-09-15	AIA	ETF	40.42	40.56	40.07	40.41	45871.0
2011-09-15	AIQ	ETF	6.7	6.8	6.65	6.75	16640.0
2011-09-15	AIS	ETF	2.3	2.3	2.22	2.24	643627.0
2011-09-15	AIVI	ETF	40.47	42.32	39.95	40.51	395000.0
2011-09-15	AMJ	ETF	35.31	35.7	34.97	35.33	718557.0
2011-09-15	AMLP	ETF	77.45	77.75	76.6	77.6	188680.0
2011-09-15	AOA	ETF	32.42	32.55	32.2	32.54	2800.0
2011-09-15	AOK	ETF	29.06	29.08	28.99	29.08	20261.0
2011-09-15	AOM	ETF	29.682	29.76	29.6644	29.76	5432.0
2011-09-15	AOR	ETF	30.68	30.83	30.59	30.78	13368.0
2011-09-15	ARB	ETF	36.5	36.85	35.67	36.19	71389.0
2011-09-15	ARGT	ETF	23.32	23.4	23.32	23.38	250.0
2011-09-15	ASEA	ETF	15.17	15.28	15.17	15.28	5100.0
2011-09-15	AWAY	ETF	42.56	42.56	40.412	42.04	76026.0
2011-09-15	BAB	ETF	28.16	28.28	28.02	28.22	165933.0
2011-09-15	BAL	ETF	69.98	70.82	67.82	69.51	124546.0
2011-09-15	BALT	ETF	5.46	5.5	5.285	5.38	92048.0
2011-09-15	BBH	ETF	33.4367	33.6533	33.3733	33.6267	38100.0
2011-09-15	BCM	ETF	47.03	47.03	47.03	47.03	600.0
2011-09-15	BIB	ETF	7.855	7.855	7.5663	7.7425	25744.0
2011-09-15	BICK	ETF	25.69	25.76	25.41	25.76	217889.0
2011-09-15	BIL	ETF	91.7	91.72	91.68	91.68	923750.0
2011-09-15	BIS	ETF	6513.6	6513.6	6425.6	6425.6	2.5
2011-09-15	BITS	ETF	20.56	20.76	20.52	20.68	650.0
2011-09-15	BIV	ETF	87.61	87.74	87.33	87.64	127900.0
2011-09-15	BJK	ETF	31.95	32.14	31.7	31.96	74500.0
2011-09-15	BKF	ETF	39.45	39.59	39.081	39.47	209931.0
2011-09-15	BKLN	ETF	23.48	23.49	23.38	23.42	88700.0
2011-09-15	BLV	ETF	88.84	88.97	88.4	88.4	51400.0
2011-09-15	BMVP	ETF	13.4367	13.5667	13.3949	13.5467	9870.0
2011-09-15	BND	ETF	83.56	83.63	83.48	83.56	1146400.0
2011-09-15	BNO	ETF	37.94	38.035	37.68	37.8	127400.0
2011-09-15	BRF	ETF	47.51	47.82	46.89	47.16	118352.0

> showing 50 of 867 rows — these rows as CSV

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