PREVIEW / etf_daily / 2011-08-02

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-02.parquet
  size:    37 KB
  rows:    872

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-08-02	SPY	ETF	127.81	128.5	125.49	125.49	346653800.0
2011-08-02	QQQ	ETF	57.46	57.72	56.21	56.27	90851306.0
2011-08-02	IWM	ETF	78.92	79.68	76.61	76.75	95669600.0
2011-08-02	DIA	ETF	120.32	121.0	118.42	118.46	9644500.0
2011-08-02	GLD	ETF	159.33	161.62	158.97	161.52	24284500.0
2011-08-02	TLT	ETF	99.22	101.57	98.89	101.54	20850600.0
2011-08-02	AADR	ETF	30.48	30.48	30.22	30.22	800.0
2011-08-02	AAXJ	ETF	62.17	62.25	61.19	61.22	267900.0
2011-08-02	ACTV	ETF	17.98	18.33	17.5	17.51	645807.0
2011-08-02	ACWI	ETF	46.48	46.63	45.59	45.65	356100.0
2011-08-02	ACWX	ETF	42.95	43.31	42.33	42.34	101150.0
2011-08-02	ADRE	ETF	45.32	45.35	44.46	44.46	84951.0
2011-08-02	AFK	ETF	31.15	31.4	30.62	30.64	24737.0
2011-08-02	AGEM	ETF	25.69	25.69	25.12	25.12	4722.0
2011-08-02	AGG	ETF	108.29	108.67	108.14	108.58	1010600.0
2011-08-02	AGQ	ETF	431.4	446.24	422.22	445.6	830800.0
2011-08-02	AGZ	ETF	111.37	111.3715	111.15	111.3715	11636.0
2011-08-02	AIA	ETF	46.16	46.18	45.33	45.34	25463.0
2011-08-02	AIQ	ETF	16.95	17.2	16.1	16.1	28636.0
2011-08-02	AIS	ETF	2.48	2.48	2.3	2.3	1267891.0
2011-08-02	AIVI	ETF	44.21	44.46	43.57	43.61	58300.0
2011-08-02	AMJ	ETF	36.59	36.71	36.28	36.37	770936.0
2011-08-02	AMLP	ETF	79.7	79.8	79.3	79.45	231900.0
2011-08-02	AOA	ETF	34.76	34.81	34.23	34.23	11300.0
2011-08-02	AOK	ETF	29.38	29.5	29.33	29.34	24731.0
2011-08-02	AOM	ETF	30.54	30.54	30.35	30.35	40671.0
2011-08-02	AOR	ETF	32.1	32.13	31.816	31.816	17899.0
2011-08-02	ARB	ETF	38.24	38.82	37.78	38.06	267862.0
2011-08-02	ARGT	ETF	29.18	29.3	28.94	28.96	4000.0
2011-08-02	ASEA	ETF	17.51	17.51	17.32	17.34	2900.0
2011-08-02	AWAY	ETF	37.88	38.05	34.9	35.37	484802.0
2011-08-02	BAB	ETF	27.16	27.49	27.13	27.49	318129.0
2011-08-02	BAL	ETF	64.29	67.38	64.0	65.6	180242.0
2011-08-02	BALT	ETF	5.03	5.231	5.0	5.0	234802.0
2011-08-02	BBH	ETF	33.9133	34.3367	33.3833	33.3933	59100.0
2011-08-02	BCM	ETF	48.09	48.18	48.09	48.18	325.0
2011-08-02	BIB	ETF	8.875	8.94	8.2975	8.2975	268176.0
2011-08-02	BICK	ETF	30.8	30.8	30.24	30.24	17350.0
2011-08-02	BIL	ETF	91.7	91.72	91.68	91.72	1012600.0
2011-08-02	BIS	ETF	6600.0	6809.92	6600.0	6798.4	62.0
2011-08-02	BITS	ETF	21.52	21.68	21.0	21.0	3578.0
2011-08-02	BIV	ETF	86.12	86.61	86.03	86.47	106600.0
2011-08-02	BJK	ETF	36.43	36.57	35.39	35.39	42000.0
2011-08-02	BKF	ETF	46.26	46.4	45.41	45.41	89044.0
2011-08-02	BKLN	ETF	24.66	24.71	24.55	24.6	187200.0
2011-08-02	BLV	ETF	83.81	85.29	83.63	85.17	76200.0
2011-08-02	BMVP	ETF	14.79	14.8	14.36	14.36	12793.0
2011-08-02	BND	ETF	82.37	82.75	82.29	82.65	1295500.0
2011-08-02	BNO	ETF	38.87	39.565	38.705	38.76	243800.0
2011-08-02	BRF	ETF	52.55	52.73	51.54	51.58	220035.0

> showing 50 of 872 rows — these rows as CSV

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