PREVIEW / etf_daily / 2011-05-20

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-20.parquet
  size:    36 KB
  rows:    847

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-05-20	SPY	ETF	134.33	134.68	133.36	133.61	182594900.0
2011-05-20	QQQ	ETF	58.15	58.21	57.69	57.765	44703175.0
2011-05-20	IWM	ETF	83.25	83.45	82.29	82.86	56016800.0
2011-05-20	DIA	ETF	125.51	125.66	124.57	124.85	6881200.0
2011-05-20	GLD	ETF	145.82	147.78	144.9	147.49	23187900.0
2011-05-20	TLT	ETF	95.02	95.41	94.72	95.32	5602300.0
2011-05-20	AADR	ETF	31.33	31.33	31.33	31.33	200.0
2011-05-20	AAXJ	ETF	62.91	62.99	62.36	62.58	333400.0
2011-05-20	ACWI	ETF	48.9	48.97	48.48	48.66	130500.0
2011-05-20	ACWX	ETF	45.37	45.446	44.946	45.09	41240.0
2011-05-20	ADRE	ETF	45.73	45.9128	45.4	45.68	36477.0
2011-05-20	AFK	ETF	32.95	33.08	32.63	32.8199	15035.0
2011-05-20	AGG	ETF	106.94	107.04	106.91	106.99	938500.0
2011-05-20	AGQ	ETF	339.5	350.94	328.0	343.88	1464650.0
2011-05-20	AGZ	ETF	110.54	110.61	110.24	110.32	32275.0
2011-05-20	AIA	ETF	47.72	47.72	47.4299	47.48	44350.0
2011-05-20	AIQ	ETF	20.5	21.35	20.05	20.95	31957.0
2011-05-20	AIS	ETF	1.74	1.75	1.7101	1.73	428207.0
2011-05-20	AIVI	ETF	48.36	48.36	47.79	47.83	7100.0
2011-05-20	AMJ	ETF	37.0	37.12	36.7	37.07	615051.0
2011-05-20	AMLP	ETF	79.25	79.5	78.9	79.45	183300.0
2011-05-20	AOA	ETF	36.28	36.33	36.07	36.18	5900.0
2011-05-20	AOK	ETF	29.4064	29.45	29.4	29.44	2705.0
2011-05-20	AOM	ETF	30.88	30.88	30.78	30.8035	12913.0
2011-05-20	AOR	ETF	32.8	32.95	32.76	32.81	8694.0
2011-05-20	ARB	ETF	42.68	43.03	41.47	42.18	131598.0
2011-05-20	ARGT	ETF	29.5	29.64	29.5	29.64	250.0
2011-05-20	ASEA	ETF	16.47	16.49	16.37	16.47	17400.0
2011-05-20	BAB	ETF	26.31	26.42	26.28	26.41	109880.0
2011-05-20	BAL	ETF	85.34	86.858	83.19	86.71	67989.0
2011-05-20	BALT	ETF	6.62	6.62	6.5	6.52	156610.0
2011-05-20	BBH	ETF	35.4533	35.7067	35.3667	35.5	32700.0
2011-05-20	BIB	ETF	10.015	10.015	9.7562	9.9475	57752.0
2011-05-20	BICK	ETF	32.59	32.59	32.28	32.329	14357.0
2011-05-20	BIL	ETF	91.72	91.72	91.7	91.72	443400.0
2011-05-20	BITS	ETF	23.36	23.6	22.4	23.6	244.0
2011-05-20	BIV	ETF	83.98	84.09	83.93	84.09	98100.0
2011-05-20	BJK	ETF	34.24	34.3	34.03	34.18	1700.0
2011-05-20	BKF	ETF	47.44	47.49	47.07	47.2	155958.0
2011-05-20	BKLN	ETF	25.18	25.18	25.14	25.16	101000.0
2011-05-20	BLV	ETF	81.16	81.43	80.99	81.43	20100.0
2011-05-20	BMVP	ETF	15.86	15.86	15.73	15.78	2986.0
2011-05-20	BND	ETF	81.26	81.39	81.26	81.32	752700.0
2011-05-20	BNO	ETF	36.92	37.51	36.17	37.505	130600.0
2011-05-20	BRF	ETF	55.27	55.42	54.74	55.08	117892.0
2011-05-20	BSCE	ETF	21.11	21.14	21.11	21.14	13429.0
2011-05-20	BSV	ETF	80.89	80.93	80.86	80.88	558800.0
2011-05-20	BTF	ETF	83.69999999999999	84.49999999999999	83.178	84.42099999999999	3448.8
2011-05-20	BWX	ETF	30.61	30.61	30.395	30.455	295552.0
2011-05-20	BWZ	ETF	38.9	38.93	38.57	38.571	26937.0

> showing 50 of 847 rows — these rows as CSV

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