PREVIEW / etf_daily / 2011-08-30

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-30.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-08-30	SPY	ETF	120.83	122.43	119.26	121.68	241315700.0
2011-08-30	QQQ	ETF	54.39	55.3	54.11	54.97	61617815.0
2011-08-30	IWM	ETF	71.9	73.27	71.12	72.8	67801600.0
2011-08-30	DIA	ETF	114.83	116.16	114.13	115.35	10480300.0
2011-08-30	GLD	ETF	177.7	179.31	176.66	179.1	23441000.0
2011-08-30	TLT	ETF	108.43	109.15	108.25	108.71	9508700.0
2011-08-30	AADR	ETF	29.01	29.39	28.96	29.26	2900.0
2011-08-30	AAXJ	ETF	55.08	55.62	54.8	55.27	232000.0
2011-08-30	ACTV	ETF	16.51	17.0	16.46	16.53	49360.0
2011-08-30	ACWI	ETF	43.0	43.5	42.72	43.28	778700.0
2011-08-30	ACWX	ETF	39.13	39.566	38.95	39.35	32737.0
2011-08-30	ADRE	ETF	41.16	41.8404	41.08	41.62	71456.0
2011-08-30	AFK	ETF	29.0	29.41	29.0	29.41	12698.0
2011-08-30	AGEM	ETF	23.07	23.15	23.07	23.15	795.0
2011-08-30	AGG	ETF	109.55	109.77	109.42	109.6	1108200.0
2011-08-30	AGQ	ETF	446.66	451.8	433.7	448.44	530350.0
2011-08-30	AGZ	ETF	112.31	112.52	112.31	112.45	18875.0
2011-08-30	AIA	ETF	41.39	41.66	41.0	41.46	29256.0
2011-08-30	AIQ	ETF	7.5	7.6	7.45	7.5	28624.0
2011-08-30	AIS	ETF	2.42	2.49	2.37	2.48	529811.0
2011-08-30	AIVI	ETF	41.65	41.99	41.22	41.82	29000.0
2011-08-30	AMJ	ETF	34.99	35.35	34.77	35.28	1087059.0
2011-08-30	AMLP	ETF	77.25	78.15	76.45	77.4	110780.0
2011-08-30	AOA	ETF	32.64	33.0	32.56	32.83	14000.0
2011-08-30	AOK	ETF	29.0	29.12	29.0	29.08	19631.0
2011-08-30	AOM	ETF	29.79	29.87	29.7	29.87	10858.0
2011-08-30	AOR	ETF	30.85	31.08	30.48	30.98	41171.0
2011-08-30	ARB	ETF	36.5	37.4	35.97	37.09	102559.0
2011-08-30	ARGT	ETF	24.84	25.26	24.84	25.26	450.0
2011-08-30	ASEA	ETF	15.96	16.06	15.87	16.05	9600.0
2011-08-30	AWAY	ETF	39.33	43.63	39.33	41.0	203621.0
2011-08-30	BAB	ETF	27.52	27.71	27.52	27.67	115678.0
2011-08-30	BAL	ETF	64.48	66.18	64.48	65.4	24210.0
2011-08-30	BALT	ETF	4.77	5.05	4.71	4.99	227312.0
2011-08-30	BBH	ETF	32.6267	33.0933	32.6267	33.01	16200.0
2011-08-30	BCM	ETF	48.51	48.64	48.51	48.61	560.0
2011-08-30	BIB	ETF	7.245	7.5862	7.2375	7.565	76432.0
2011-08-30	BICK	ETF	26.6	27.3	26.6	27.22	51978.0
2011-08-30	BIL	ETF	91.7	91.72	91.7	91.72	952000.0
2011-08-30	BIS	ETF	6744.0	6744.0	6656.96	6668.8	19.05
2011-08-30	BITS	ETF	21.88	22.2	21.48	21.76	875.0
2011-08-30	BIV	ETF	87.9	88.04	87.8	87.89	100700.0
2011-08-30	BJK	ETF	32.83	33.28	32.7	33.2	6500.0
2011-08-30	BKF	ETF	40.97	41.59	40.77	41.42	160093.0
2011-08-30	BKLN	ETF	22.95	22.95	22.76	22.94	177500.0
2011-08-30	BLV	ETF	86.93	87.54	86.93	87.41	60300.0
2011-08-30	BMVP	ETF	13.69	13.69	13.69	13.69	456.0
2011-08-30	BND	ETF	83.43	83.57	83.23	83.51	830500.0
2011-08-30	BNO	ETF	37.63	38.165	37.51	38.1	90400.0
2011-08-30	BRF	ETF	49.89	51.09	49.7801	50.69	117033.0

> showing 50 of 864 rows — these rows as CSV

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