PREVIEW / etf_daily / 2011-09-12

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-12.parquet
  size:    37 KB
  rows:    873

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-12	SPY	ETF	114.47	116.76	114.05	116.67	305793500.0
2011-09-12	QQQ	ETF	52.61	53.9	52.57	53.86	65972996.0
2011-09-12	IWM	ETF	66.38	68.25	66.37	68.08	100109900.0
2011-09-12	DIA	ETF	108.37	110.55	108.15	110.51	10062000.0
2011-09-12	GLD	ETF	178.73	178.99	175.33	176.67	21812800.0
2011-09-12	TLT	ETF	113.57	114.25	113.1	113.83	7602200.0
2011-09-12	AADR	ETF	27.87	27.87	27.87	27.87	200.0
2011-09-12	AAXJ	ETF	52.38	53.19	51.79	53.13	715400.0
2011-09-12	ACTV	ETF	14.25	14.95	14.0701	14.39	34999.0
2011-09-12	ACWI	ETF	40.28	40.88	39.95	40.88	714300.0
2011-09-12	ACWX	ETF	36.14	36.64	35.89	36.64	155776.0
2011-09-12	ADRE	ETF	39.32	39.77	38.86	39.74	72390.0
2011-09-12	AFK	ETF	28.75	28.98	28.5	28.98	12150.0
2011-09-12	AGEM	ETF	22.0293	22.05	21.69	21.87	1390.0
2011-09-12	AGG	ETF	110.19	110.19	109.84	109.94	1038000.0
2011-09-12	AGQ	ETF	433.8	442.36	408.8	419.98	558250.0
2011-09-12	AGZ	ETF	112.91	113.49	112.51	112.77	18842.0
2011-09-12	AIA	ETF	39.65	40.12	39.38	40.09	47211.0
2011-09-12	AIQ	ETF	6.15	6.45	6.0	6.35	12737.0
2011-09-12	AIS	ETF	2.23	2.32	2.2	2.28	548714.0
2011-09-12	AIVI	ETF	38.27	38.71	37.75	38.69	102300.0
2011-09-12	AMJ	ETF	34.2901	34.83	34.1371	34.71	788926.0
2011-09-12	AMLP	ETF	77.1	77.1	75.9	76.6	92760.0
2011-09-12	AOA	ETF	30.88	31.19	30.83	31.19	6500.0
2011-09-12	AOK	ETF	28.72	28.88	28.72	28.88	23052.0
2011-09-12	AOM	ETF	29.21	29.32	29.18	29.32	82781.0
2011-09-12	AOR	ETF	29.78	30.13	29.72	30.13	11291.0
2011-09-12	ARB	ETF	32.81	34.57	32.77	34.54	113826.0
2011-09-12	ARGT	ETF	23.26	23.26	22.88	22.88	300.0
2011-09-12	ASEA	ETF	15.37	15.56	15.31	15.56	29500.0
2011-09-12	AWAY	ETF	39.55	43.08	39.0	40.15	46376.0
2011-09-12	BAB	ETF	28.22	28.39	28.2001	28.33	186903.0
2011-09-12	BAL	ETF	69.38	69.93	68.86	69.93	70052.0
2011-09-12	BALT	ETF	4.95	5.04	4.92	5.02	105298.0
2011-09-12	BBH	ETF	31.2733	31.9533	31.2733	31.9533	37200.0
2011-09-12	BCM	ETF	47.42	47.67	47.31	47.31	745.0
2011-09-12	BIB	ETF	7.0462	7.25	6.9763	7.25	30488.0
2011-09-12	BICK	ETF	25.01	25.4	24.758	25.4	33718.0
2011-09-12	BIL	ETF	91.68	91.7	91.68	91.7	287700.0
2011-09-12	BIS	ETF	6886.4	6886.4	6886.4	6886.4	0.625
2011-09-12	BITS	ETF	21.16	21.4	19.92	20.36	2429.0
2011-09-12	BIV	ETF	88.34	88.48	88.01	88.23	108200.0
2011-09-12	BJK	ETF	31.82	31.87	31.22	31.87	13800.0
2011-09-12	BKF	ETF	38.63	39.11	38.14	39.08	358306.0
2011-09-12	BKLN	ETF	23.5	23.5	23.16	23.3	86000.0
2011-09-12	BLNG	ETF	57.23	57.24	57.138	57.138	834.0
2011-09-12	BLV	ETF	89.7	90.11	89.54	89.83	77000.0
2011-09-12	BMVP	ETF	12.82	13.02	12.74	13.02	5555.0
2011-09-12	BND	ETF	83.83	83.85	83.54	83.63	2441200.0
2011-09-12	BNO	ETF	36.96	37.53	36.69	37.28	123400.0

> showing 50 of 873 rows — these rows as CSV

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