PREVIEW / etf_daily / 2011-07-25

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-25.parquet
  size:    36 KB
  rows:    869

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-25	SPY	ETF	133.3	134.49	133.16	133.83	136653800.0
2011-07-25	QQQ	ETF	59.13	59.81	59.02	59.48	48916065.0
2011-07-25	IWM	ETF	83.02	83.76	82.75	83.06	49764900.0
2011-07-25	DIA	ETF	125.34	126.34	125.13	125.76	5236200.0
2011-07-25	GLD	ETF	157.6	157.8	156.72	157.34	13036200.0
2011-07-25	TLT	ETF	94.97	96.05	94.83	95.0	10869400.0
2011-07-25	AADR	ETF	31.42	31.56	31.36	31.56	2200.0
2011-07-25	AAXJ	ETF	62.24	62.83	62.24	62.56	244800.0
2011-07-25	ACTV	ETF	17.92	18.03	17.9	17.99	61416.0
2011-07-25	ACWI	ETF	48.39	48.69	48.31	48.47	1089300.0
2011-07-25	ACWX	ETF	44.72	44.88	44.6	44.71	96538.0
2011-07-25	ADRE	ETF	46.03	46.492	46.03	46.31	55711.0
2011-07-25	AFK	ETF	32.08	32.19	31.84	32.1	83431.0
2011-07-25	AGEM	ETF	26.05	26.07	26.05	26.05	2400.0
2011-07-25	AGG	ETF	107.29	107.56	107.21	107.24	1154600.0
2011-07-25	AGQ	ETF	441.66	446.5	425.68	435.86	854650.0
2011-07-25	AGZ	ETF	110.7945	110.891	110.7501	110.7888	8750.0
2011-07-25	AIA	ETF	46.67	47.03	46.67	46.86	26264.0
2011-07-25	AIQ	ETF	17.25	17.35	16.7	16.9	18075.0
2011-07-25	AIS	ETF	2.59	2.59	2.5	2.5	1657700.0
2011-07-25	AIVI	ETF	46.4	46.45	46.19	46.3	13300.0
2011-07-25	AMJ	ETF	37.08	37.49	36.93	37.06	1243132.0
2011-07-25	AMLP	ETF	80.45	80.45	79.95	80.15	96080.0
2011-07-25	AOA	ETF	36.0	36.3	36.0	36.12	12900.0
2011-07-25	AOK	ETF	29.4608	29.542	29.4608	29.49	5937.0
2011-07-25	AOM	ETF	30.81	30.8855	30.81	30.8156	8094.0
2011-07-25	AOR	ETF	32.79	32.9	32.7807	32.811	12803.0
2011-07-25	ARB	ETF	41.99	42.98	41.6	42.47	103008.0
2011-07-25	ARGT	ETF	29.98	30.04	29.84	29.84	1950.0
2011-07-25	ASEA	ETF	17.21	17.26	17.19	17.21	14200.0
2011-07-25	AWAY	ETF	40.5	41.618	40.5	40.98	56590.0
2011-07-25	BAB	ETF	26.47	26.694	26.45	26.56	126385.0
2011-07-25	BAL	ETF	60.7	60.85	59.0	59.8	72138.0
2011-07-25	BALT	ETF	5.11	5.18	4.95	4.95	100865.0
2011-07-25	BBH	ETF	35.29	35.4867	35.03	35.03	17700.0
2011-07-25	BCM	ETF	48.51	48.52	48.364	48.364	2620.0
2011-07-25	BIB	ETF	10.0363	10.0363	9.7015	9.7015	59576.0
2011-07-25	BICK	ETF	31.75	32.009	31.75	31.918	8201.0
2011-07-25	BIL	ETF	91.72	91.72	91.7	91.72	72300.0
2011-07-25	BIS	ETF	5816.0	5884.8	5780.8	5884.8	8.55
2011-07-25	BITS	ETF	21.788	22.3604	21.36	22.256	3338.0
2011-07-25	BIV	ETF	84.69	85.08	84.66	84.79	200000.0
2011-07-25	BJK	ETF	36.43	36.63	36.35	36.45	21800.0
2011-07-25	BKF	ETF	47.09	47.414	47.01	47.29	96118.0
2011-07-25	BKLN	ETF	24.78	24.87	24.78	24.81	70200.0
2011-07-25	BLV	ETF	80.69	81.15	80.63	80.84	24300.0
2011-07-25	BMVP	ETF	15.68	15.783	15.667	15.713	9871.0
2011-07-25	BND	ETF	81.61	81.8	81.53	81.57	797600.0
2011-07-25	BNO	ETF	39.135	39.535	39.135	39.32	35000.0
2011-07-25	BRF	ETF	54.47	55.0	54.25	54.54	161775.0

> showing 50 of 869 rows — these rows as CSV

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