PREVIEW / etf_daily / 2011-08-31

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-31.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-31	SPY	ETF	122.46	123.51	121.3	122.22	301828400.0
2011-08-31	QQQ	ETF	55.29	55.74	54.6	55.06	60899245.0
2011-08-31	IWM	ETF	73.2	73.89	71.9	72.65	70313900.0
2011-08-31	DIA	ETF	116.16	116.97	115.12	115.95	8390900.0
2011-08-31	GLD	ETF	177.73	179.16	176.33	177.72	16054400.0
2011-08-31	TLT	ETF	108.81	108.96	107.03	107.03	12186000.0
2011-08-31	AADR	ETF	29.55	29.76	29.51	29.76	1400.0
2011-08-31	AAXJ	ETF	56.3	56.62	55.86	56.16	475900.0
2011-08-31	ACTV	ETF	16.65	16.67	15.92	16.18	68161.0
2011-08-31	ACWI	ETF	43.84	44.08	43.4	43.68	567200.0
2011-08-31	ACWX	ETF	39.96	40.28	39.79	39.97	446511.0
2011-08-31	ADRE	ETF	42.15	42.41	42.0	42.39	65746.0
2011-08-31	AFK	ETF	29.5	29.89	29.5	29.7	11066.0
2011-08-31	AGEM	ETF	23.65	23.73	23.55	23.55	2740.0
2011-08-31	AGG	ETF	109.78	109.88	109.49	109.5	2444400.0
2011-08-31	AGQ	ETF	451.98	460.96	442.14	449.58	617550.0
2011-08-31	AGZ	ETF	112.49	112.5	112.2801	112.42	28469.0
2011-08-31	AIA	ETF	42.22	42.4229	42.07	42.31	126221.0
2011-08-31	AIQ	ETF	7.5	8.2	7.5	7.95	59039.0
2011-08-31	AIS	ETF	2.49	2.52	2.42	2.44	679663.0
2011-08-31	AIVI	ETF	42.44	42.8	42.28	42.53	33400.0
2011-08-31	AMJ	ETF	35.99	35.99	35.282	35.49	1924316.0
2011-08-31	AMLP	ETF	78.15	78.4	77.45	77.85	110720.0
2011-08-31	AOA	ETF	33.14	33.32	32.8	33.09	26200.0
2011-08-31	AOK	ETF	29.2	29.22	29.105	29.14	29157.0
2011-08-31	AOM	ETF	29.99	30.05	29.89	29.93	28252.0
2011-08-31	AOR	ETF	31.23	31.259	31.038	31.092	9290.0
2011-08-31	ARB	ETF	37.32	38.0	36.75	37.55	201436.0
2011-08-31	ARGT	ETF	25.52	25.62	25.12	25.14	3150.0
2011-08-31	ASEA	ETF	16.25	16.29	16.1	16.14	3700.0
2011-08-31	AWAY	ETF	41.54	42.61	40.35	41.84	134688.0
2011-08-31	BAB	ETF	27.77	27.77	27.35	27.406	128937.0
2011-08-31	BAL	ETF	65.99	66.3178	64.95	65.38	20785.0
2011-08-31	BALT	ETF	5.05	5.27	5.0	5.14	315623.0
2011-08-31	BBH	ETF	33.0633	33.21	32.8167	33.0633	25200.0
2011-08-31	BCM	ETF	48.8	48.81	48.73	48.81	1435.0
2011-08-31	BIB	ETF	7.69	7.7693	7.4259	7.5525	96312.0
2011-08-31	BICK	ETF	27.39	27.66	27.39	27.51	19921.0
2011-08-31	BIL	ETF	91.72	91.72	91.7	91.72	523750.0
2011-08-31	BIS	ETF	6705.6	6705.6	6672.0	6672.0	5.35
2011-08-31	BITS	ETF	22.0	22.32	21.28	22.12	8342.0
2011-08-31	BIV	ETF	88.25	88.28	87.61	87.69	294300.0
2011-08-31	BJK	ETF	33.79	33.84	33.21	33.53	12100.0
2011-08-31	BKF	ETF	42.06	42.33	41.6	42.0	315915.0
2011-08-31	BKLN	ETF	23.08	23.19	22.92	23.1	231700.0
2011-08-31	BLNG	ETF	57.5	57.57	57.5	57.57	734.0
2011-08-31	BLV	ETF	87.57	87.9	86.9	86.95	128900.0
2011-08-31	BMVP	ETF	13.81	13.8967	13.6995	13.7167	3376.0
2011-08-31	BND	ETF	83.63	83.64	83.34	83.4	2267600.0
2011-08-31	BNO	ETF	38.165	38.48	38.115	38.275	38000.0

> showing 50 of 875 rows — these rows as CSV

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