PREVIEW / etf_daily / 2011-07-20

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-20.parquet
  size:    36 KB
  rows:    864

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-07-20	SPY	ETF	133.07	133.15	132.42	132.65	137145400.0
2011-07-20	QQQ	ETF	59.18	59.19	58.5	58.6	57084229.0
2011-07-20	IWM	ETF	83.35	83.42	82.65	83.18	40277400.0
2011-07-20	DIA	ETF	125.77	125.83	125.26	125.46	3291800.0
2011-07-20	GLD	ETF	154.22	156.02	154.11	156.02	14559300.0
2011-07-20	TLT	ETF	96.72	96.84	95.87	96.07	9673300.0
2011-07-20	AADR	ETF	30.94	31.07	30.94	31.04	2100.0
2011-07-20	AAXJ	ETF	61.89	62.13	61.78	61.9	167000.0
2011-07-20	ACTV	ETF	18.56	18.56	17.91	18.13	35247.0
2011-07-20	ACWI	ETF	47.99	48.02	47.73	47.84	544500.0
2011-07-20	ACWX	ETF	44.1	44.157	43.81	44.03	33019.0
2011-07-20	ADRE	ETF	45.59	45.75	45.51	45.59	28362.0
2011-07-20	AFK	ETF	31.54	31.84	31.54	31.75	29080.0
2011-07-20	AGEM	ETF	25.84	25.87	25.7453	25.79	688.0
2011-07-20	AGG	ETF	107.55	107.8	107.47	107.49	627300.0
2011-07-20	AGQ	ETF	397.92	432.0	391.82	431.48	1078600.0
2011-07-20	AGZ	ETF	110.8272	110.97	110.8272	110.95	6380.0
2011-07-20	AIA	ETF	46.49	46.649	46.46	46.47	17472.0
2011-07-20	AIQ	ETF	17.25	17.45	17.25	17.35	8127.0
2011-07-20	AIS	ETF	2.42	2.42	2.31	2.33	945712.0
2011-07-20	AIVI	ETF	45.35	45.59	45.16	45.33	92900.0
2011-07-20	AMJ	ETF	37.35	37.59	37.25	37.26	856073.0
2011-07-20	AMLP	ETF	80.45	80.5	80.2	80.25	117000.0
2011-07-20	AOA	ETF	36.0	36.0	35.79	35.92	6800.0
2011-07-20	AOK	ETF	29.48	29.49	29.44	29.476	13693.0
2011-07-20	AOM	ETF	30.7	30.74	30.68	30.72	45699.0
2011-07-20	AOR	ETF	32.74	32.74	32.63	32.6598	17218.0
2011-07-20	ARB	ETF	40.78	41.31	40.1	41.0	166440.0
2011-07-20	ARGT	ETF	29.56	29.58	29.56	29.58	450.0
2011-07-20	ASEA	ETF	17.02	17.03	16.9	17.01	9700.0
2011-07-20	AWAY	ETF	41.29	41.29	40.5	40.67	60139.0
2011-07-20	BAB	ETF	26.64	26.64	26.5	26.51	175108.0
2011-07-20	BAL	ETF	61.89	63.17	60.62	63.03	103498.0
2011-07-20	BALT	ETF	5.02	5.33	5.01	5.19	129711.0
2011-07-20	BBH	ETF	35.1667	35.1667	34.87	34.9	28800.0
2011-07-20	BIB	ETF	9.8788	9.8788	9.54	9.6237	50912.0
2011-07-20	BICK	ETF	31.55	31.7588	31.4801	31.69	24415.0
2011-07-20	BIL	ETF	91.7	91.72	91.7	91.7	162650.0
2011-07-20	BIS	ETF	5910.4	5937.6	5860.8	5931.2	29.4
2011-07-20	BITS	ETF	22.8	22.8	21.8	22.48	794.0
2011-07-20	BIV	ETF	85.22	85.22	85.02	85.08	61900.0
2011-07-20	BJK	ETF	35.55	35.55	35.29	35.48	18600.0
2011-07-20	BKF	ETF	46.76	46.76	46.45	46.46	118591.0
2011-07-20	BKLN	ETF	24.74	24.82	24.74	24.82	80400.0
2011-07-20	BLNG	ETF	51.27	51.27	51.27	51.27	500.0
2011-07-20	BLV	ETF	81.81	81.98	81.4	81.52	11300.0
2011-07-20	BMVP	ETF	15.7267	15.7267	15.6151	15.6567	9368.0
2011-07-20	BND	ETF	81.88	81.92	81.76	81.8	822100.0
2011-07-20	BNO	ETF	39.515	39.535	39.19	39.5	63400.0
2011-07-20	BRF	ETF	53.05	53.24	52.69	52.96	231854.0

> showing 50 of 864 rows — these rows as CSV

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