PREVIEW / etf_daily / 2011-08-03

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-03.parquet
  size:    37 KB
  rows:    875

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-03	SPY	ETF	125.66	126.31	123.53	126.17	370830800.0
2011-08-03	QQQ	ETF	56.37	56.88	55.35	56.81	103612298.0
2011-08-03	IWM	ETF	76.69	77.35	74.88	77.26	114910400.0
2011-08-03	DIA	ETF	118.6	118.89	116.83	118.8	16594800.0
2011-08-03	GLD	ETF	162.36	162.86	161.34	161.49	27823700.0
2011-08-03	TLT	ETF	101.57	103.42	101.36	101.74	21179700.0
2011-08-03	AAXJ	ETF	60.8	60.97	59.84	60.79	517000.0
2011-08-03	ACTV	ETF	17.78	17.82	16.58	17.33	563415.0
2011-08-03	ACWI	ETF	45.79	45.79	44.92	45.78	802800.0
2011-08-03	ACWX	ETF	42.53	42.5995	41.72	42.47	158664.0
2011-08-03	ADRE	ETF	44.33	44.45	43.49	44.17	126828.0
2011-08-03	AFK	ETF	30.95	31.2	30.48	30.91	27971.0
2011-08-03	AGEM	ETF	24.93	24.93	24.46	24.89	25440.0
2011-08-03	AGG	ETF	108.69	108.95	108.61	108.69	1237500.0
2011-08-03	AGQ	ETF	450.52	472.0	448.02	462.88	1363150.0
2011-08-03	AGZ	ETF	111.4899	111.54	111.33	111.42	6575.0
2011-08-03	AIA	ETF	45.1	45.1	44.22	45.01	72114.0
2011-08-03	AIQ	ETF	16.1	16.595	16.1	16.35	21555.0
2011-08-03	AIS	ETF	2.305	2.35	2.23	2.26	939975.0
2011-08-03	AIVI	ETF	44.13	44.13	43.26	43.9	40500.0
2011-08-03	AMJ	ETF	36.53	36.76	35.8	36.31	1113073.0
2011-08-03	AMLP	ETF	79.95	79.95	78.75	79.45	172840.0
2011-08-03	AOA	ETF	34.2	34.24	33.56	34.24	24900.0
2011-08-03	AOK	ETF	29.27	29.32	29.24	29.24	15662.0
2011-08-03	AOM	ETF	30.38	30.38	30.186	30.3245	21023.0
2011-08-03	AOR	ETF	31.8	31.83	31.45	31.8	74296.0
2011-08-03	ARB	ETF	38.09	39.66	37.99	39.03	311645.0
2011-08-03	ARGT	ETF	28.6	28.62	28.26	28.62	4150.0
2011-08-03	ASEA	ETF	17.2	17.3	16.9	17.3	16400.0
2011-08-03	AWAY	ETF	35.2	36.449	33.06	34.15	483492.0
2011-08-03	BAB	ETF	27.41	27.51	27.32	27.44	193973.0
2011-08-03	BAL	ETF	64.85	66.1	64.41	64.76	87447.0
2011-08-03	BALT	ETF	4.88	5.15	4.88	5.1	164177.0
2011-08-03	BBH	ETF	33.4033	33.4033	32.42	33.12	89100.0
2011-08-03	BCM	ETF	48.02	48.02	47.55	47.74	3668.0
2011-08-03	BIB	ETF	8.2137	8.2975	7.675	8.2475	426016.0
2011-08-03	BICK	ETF	29.88	29.91	29.31	29.88	32582.0
2011-08-03	BIL	ETF	91.72	91.72	91.7	91.72	681150.0
2011-08-03	BIS	ETF	6956.8	7144.0	6836.8	6836.8	19.45
2011-08-03	BITS	ETF	20.72	20.8	20.68	20.8	784.0
2011-08-03	BIV	ETF	86.49	86.82	86.49	86.6	226600.0
2011-08-03	BJK	ETF	35.31	35.76	34.55	35.76	198700.0
2011-08-03	BKF	ETF	45.26	45.3999	44.32	45.01	225834.0
2011-08-03	BKLN	ETF	24.55	24.6	24.5	24.57	69300.0
2011-08-03	BLNG	ETF	53.65	53.85	53.4199	53.4199	1400.0
2011-08-03	BLV	ETF	85.49	86.5	85.21	85.47	74000.0
2011-08-03	BMVP	ETF	14.37	14.41	14.0	14.41	50768.0
2011-08-03	BND	ETF	82.74	82.95	82.69	82.71	1389200.0
2011-08-03	BNO	ETF	38.585	38.585	37.745	37.805	184800.0
2011-08-03	BOSS	ETF	66.8	68.79	66.8	68.79	200.0

> showing 50 of 875 rows — these rows as CSV

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