PREVIEW / etf_daily / 2011-11-14

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-14.parquet
  size:    37 KB
  rows:    884

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-11-14	SPY	ETF	126.19	127.45	124.92	125.46	159258300.0
2011-11-14	QQQ	ETF	57.69	58.01	57.28	57.49	44617602.0
2011-11-14	IWM	ETF	74.1	74.27	72.77	73.31	61114200.0
2011-11-14	DIA	ETF	121.33	121.57	120.18	120.71	7391200.0
2011-11-14	GLD	ETF	173.74	173.86	172.59	173.2	5886400.0
2011-11-14	TLT	ETF	116.39	117.6	116.21	117.51	9252600.0
2011-11-14	AADR	ETF	28.31	28.61	28.31	28.5	9700.0
2011-11-14	AAXJ	ETF	53.3	53.33	52.57	52.95	380400.0
2011-11-14	ACTV	ETF	15.12	15.229	14.25	14.4	188540.0
2011-11-14	ACWI	ETF	43.11	43.33	42.82	43.06	234800.0
2011-11-14	ACWV	ETF	50.54	50.54	50.46	50.46	200.0
2011-11-14	ACWX	ETF	38.24	38.33	37.81	38.03	116615.0
2011-11-14	ADRE	ETF	40.98	41.0	40.64	40.84	39064.0
2011-11-14	AFK	ETF	28.23	28.23	27.89	27.89	13948.0
2011-11-14	AGEM	ETF	22.8	22.8	22.442	22.51	5825.0
2011-11-14	AGG	ETF	109.96	110.01	109.75	109.88	1189600.0
2011-11-14	AGQ	ETF	269.76	270.68	261.2	266.32	248825.0
2011-11-14	AGZ	ETF	112.25	112.58	112.1208	112.33	96986.0
2011-11-14	AIA	ETF	41.66	41.72	41.18	41.27	21379.0
2011-11-14	AIQ	ETF	6.45	6.6	6.3	6.3	13570.0
2011-11-14	AIS	ETF	2.34	2.34	2.3	2.32	292054.0
2011-11-14	AIVI	ETF	40.99	41.04	40.49	40.67	49600.0
2011-11-14	AMJ	ETF	36.91	37.51	36.91	37.39	1769378.0
2011-11-14	AMLP	ETF	79.0	79.5	79.0	79.35	173420.0
2011-11-14	AOA	ETF	33.44	33.44	33.09	33.17	10700.0
2011-11-14	AOK	ETF	29.3599	29.3599	29.27	29.275	27841.0
2011-11-14	AOM	ETF	30.19	30.19	29.93	30.0036	15597.0
2011-11-14	AOR	ETF	31.42	31.43	31.17	31.24	46280.0
2011-11-14	ARB	ETF	41.08	41.23	40.18	40.65	110568.0
2011-11-14	ARGT	ETF	23.2	23.2	23.0	23.0	2800.0
2011-11-14	ASEA	ETF	15.05	15.08	14.91	15.08	5500.0
2011-11-14	AWAY	ETF	33.12	33.39	32.58	32.8	57694.0
2011-11-14	BAB	ETF	28.4	28.58	28.357	28.54	77214.0
2011-11-14	BAL	ETF	59.84	60.12	59.8	60.0	12680.0
2011-11-14	BALT	ETF	5.56	5.63	5.36	5.4	44259.0
2011-11-14	BBH	ETF	35.3	35.3	35.0833	35.1767	30000.0
2011-11-14	BCM	ETF	45.23	45.27	45.02	45.18	9958.0
2011-11-14	BIB	ETF	7.2488	7.2488	7.1562	7.1564	14752.0
2011-11-14	BICK	ETF	25.47	25.51	25.29	25.45	8656.0
2011-11-14	BIL	ETF	91.7	91.7	91.68	91.7	649000.0
2011-11-14	BITS	ETF	22.6	22.6	21.32	21.68	2316.0
2011-11-14	BIV	ETF	87.75	87.91	87.62	87.77	116700.0
2011-11-14	BJK	ETF	31.1	31.39	31.04	31.12	24300.0
2011-11-14	BKF	ETF	40.05	40.11	39.5	39.83	70920.0
2011-11-14	BKLN	ETF	24.14	24.29	24.09	24.17	35400.0
2011-11-14	BLNG	ETF	54.33	54.33	54.33	54.33	300.0
2011-11-14	BLV	ETF	91.07	91.48	90.86	91.28	15400.0
2011-11-14	BMVP	ETF	13.92	13.9267	13.78	13.8306	3654.0
2011-11-14	BND	ETF	83.66	83.68	83.47	83.6	1279600.0
2011-11-14	BNO	ETF	38.89	38.905	38.3	38.475	202000.0

> showing 50 of 884 rows — these rows as CSV

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