PREVIEW / etf_daily / 2011-05-16

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-16.parquet
  size:    36 KB
  rows:    850

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-16	SPY	ETF	133.56	134.61	132.97	133.19	141675400.0
2011-05-16	QQQ	ETF	58.16	58.32	57.27	57.399	73140221.0
2011-05-16	IWM	ETF	82.96	83.89	82.22	82.29	68771600.0
2011-05-16	DIA	ETF	125.57	126.42	125.29	125.47	4399900.0
2011-05-16	GLD	ETF	145.88	146.67	145.19	145.37	10066800.0
2011-05-16	TLT	ETF	95.03	95.79	94.76	95.61	6053600.0
2011-05-16	AADR	ETF	31.24	31.24	31.24	31.24	200.0
2011-05-16	AAXJ	ETF	62.31	62.96	62.2	62.36	519500.0
2011-05-16	ACWI	ETF	48.62	49.01	48.33	48.46	350800.0
2011-05-16	ACWX	ETF	45.03	45.47	44.91	45.0	101629.0
2011-05-16	ADRE	ETF	45.26	46.04	45.25	45.35	53811.0
2011-05-16	AFK	ETF	32.35	32.7225	32.21	32.29	8351.0
2011-05-16	AGG	ETF	106.8	107.07	106.78	107.02	678100.0
2011-05-16	AGQ	ETF	337.04	350.16	316.5	317.4	1636900.0
2011-05-16	AGZ	ETF	110.1	110.2814	110.09	110.2714	17524.0
2011-05-16	AIA	ETF	47.24	47.5858	47.03	47.166	31295.0
2011-05-16	AIQ	ETF	20.8	20.95	20.15	20.15	21173.0
2011-05-16	AIS	ETF	1.7	1.75	1.68	1.68	654306.0
2011-05-16	AIVI	ETF	47.64	48.14	47.64	47.75	58000.0
2011-05-16	AMJ	ETF	36.48	36.7982	36.16	36.22	1067905.0
2011-05-16	AMLP	ETF	78.7	79.05	78.1	78.15	160840.0
2011-05-16	AOA	ETF	36.1	36.41	36.1	36.12	13100.0
2011-05-16	AOK	ETF	29.44	29.46	29.38	29.43	24532.0
2011-05-16	AOM	ETF	30.83	30.891	30.77	30.78	10482.0
2011-05-16	AOR	ETF	32.8201	32.99	32.778	32.79	12298.0
2011-05-16	ARB	ETF	41.49	42.19	41.07	41.68	166690.0
2011-05-16	ARGT	ETF	29.6	29.6	29.4	29.4	750.0
2011-05-16	ASEA	ETF	16.11	16.29	16.06	16.08	10300.0
2011-05-16	BAB	ETF	26.26	26.34	26.2	26.3	121908.0
2011-05-16	BAL	ETF	81.47	85.87	81.26	84.48	112443.0
2011-05-16	BALT	ETF	6.68	6.72	6.24	6.3	281766.0
2011-05-16	BBH	ETF	35.3533	35.4367	35.0633	35.1433	60000.0
2011-05-16	BIB	ETF	10.0563	10.0563	9.7598	9.7662	154272.0
2011-05-16	BICK	ETF	32.53	32.54	32.13	32.16	12777.0
2011-05-16	BIL	ETF	91.74	91.74	91.72	91.72	905750.0
2011-05-16	BIS	ETF	5979.2	5979.2	5952.0	5952.0	6.25
2011-05-16	BITS	ETF	20.72	22.3604	20.2804	20.48	4262.0
2011-05-16	BIV	ETF	83.88	84.06	83.76	84.04	75100.0
2011-05-16	BJK	ETF	34.24	34.3	33.63	33.63	24000.0
2011-05-16	BKF	ETF	46.87	47.51	46.805	46.91	134244.0
2011-05-16	BKLN	ETF	25.22	25.22	25.18	25.2	150900.0
2011-05-16	BLV	ETF	80.79	81.42	80.79	81.4	27500.0
2011-05-16	BMVP	ETF	15.8	15.91	15.76	15.76	5759.0
2011-05-16	BND	ETF	81.26	81.39	81.19	81.38	1271500.0
2011-05-16	BNO	ETF	37.605	37.75	36.74	36.74	276600.0
2011-05-16	BRF	ETF	55.9	56.48	55.4	55.88	179537.0
2011-05-16	BSCE	ETF	21.09	21.13	21.05	21.13	44755.0
2011-05-16	BSV	ETF	80.81	80.9	80.81	80.9	562200.0
2011-05-16	BTF	ETF	83.45	83.66749999999999	83.3505	83.3505	1242.4
2011-05-16	BWX	ETF	30.56	30.615	30.485	30.55	230410.0

> showing 50 of 850 rows — these rows as CSV

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