PREVIEW / etf_daily / 2011-07-28

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-28.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-07-28	SPY	ETF	130.6	131.77	130.01	130.22	207939900.0
2011-07-28	QQQ	ETF	58.1	58.93	57.89	58.19	61031804.0
2011-07-28	IWM	ETF	79.96	80.97	79.69	79.84	67439400.0
2011-07-28	DIA	ETF	122.82	123.66	122.07	122.28	7454600.0
2011-07-28	GLD	ETF	157.54	157.6	156.11	157.32	11369100.0
2011-07-28	TLT	ETF	96.11	96.31	95.71	96.02	7081600.0
2011-07-28	AAXJ	ETF	62.83	62.88	62.29	62.4	115800.0
2011-07-28	ACTV	ETF	17.98	18.19	17.98	18.01	95387.0
2011-07-28	ACWI	ETF	47.52	47.74	47.18	47.28	2530000.0
2011-07-28	ACWX	ETF	44.03	44.24	43.78	43.8	90143.0
2011-07-28	ADRE	ETF	45.68	45.9736	45.53	45.56	52907.0
2011-07-28	AFK	ETF	31.61	31.74	31.33	31.5799	8820.0
2011-07-28	AGEM	ETF	25.63	25.81	25.62	25.66	12593.0
2011-07-28	AGG	ETF	107.51	107.63	107.41	107.52	823600.0
2011-07-28	AGQ	ETF	433.24	435.16	413.58	423.94	840350.0
2011-07-28	AGZ	ETF	110.77	110.87	110.6	110.74	11344.0
2011-07-28	AIA	ETF	46.98	47.12	46.75	46.7775	36083.0
2011-07-28	AIQ	ETF	16.7	16.975	16.45	16.8	14930.0
2011-07-28	AIS	ETF	2.32	2.4	2.3	2.33	840276.0
2011-07-28	AIVI	ETF	45.57	45.82	45.32	45.38	12000.0
2011-07-28	AMJ	ETF	36.02	36.4	36.0	36.18	3222399.0
2011-07-28	AMLP	ETF	79.0	79.4	78.75	79.0	70740.0
2011-07-28	AOA	ETF	35.26	35.58	35.17	35.17	13500.0
2011-07-28	AOK	ETF	29.34	29.4392	29.33	29.33	35239.0
2011-07-28	AOM	ETF	30.55	30.69	30.5499	30.5499	9869.0
2011-07-28	AOR	ETF	32.31	32.4899	32.26	32.27	12500.0
2011-07-28	ARB	ETF	40.64	40.92	39.81	39.86	123901.0
2011-07-28	ASEA	ETF	17.33	17.46	17.31	17.31	7500.0
2011-07-28	AWAY	ETF	42.46	43.48	39.0	41.39	401866.0
2011-07-28	BAB	ETF	26.74	26.7899	26.68	26.68	198810.0
2011-07-28	BAL	ETF	63.41	63.99	62.48	63.85	93067.0
2011-07-28	BALT	ETF	5.55	5.69	5.51	5.6	144817.0
2011-07-28	BBH	ETF	34.3667	35.0133	34.3333	34.5133	61800.0
2011-07-28	BIB	ETF	8.9075	9.3465	8.9075	8.985	142352.0
2011-07-28	BICK	ETF	31.24	31.51	31.22	31.22	8909.0
2011-07-28	BIL	ETF	91.7	91.72	91.7	91.72	802800.0
2011-07-28	BIS	ETF	6296.0	6316.8	6187.2	6187.2	10.0
2011-07-28	BITS	ETF	21.36	21.56	20.84	21.56	1175.0
2011-07-28	BIV	ETF	85.01	85.17	84.96	85.03	91800.0
2011-07-28	BJK	ETF	36.59	36.91	36.44	36.44	17200.0
2011-07-28	BKF	ETF	46.66	46.864	46.39	46.5	132960.0
2011-07-28	BKLN	ETF	24.82	24.82	24.74	24.79	77900.0
2011-07-28	BLNG	ETF	51.6	52.0	51.6	52.0	1544.0
2011-07-28	BLV	ETF	81.62	81.79	81.41	81.62	24100.0
2011-07-28	BMVP	ETF	15.16	15.26	15.01	15.02	44581.0
2011-07-28	BND	ETF	81.74	81.88	81.7	81.84	1649000.0
2011-07-28	BNO	ETF	39.355	39.625	39.15	39.18	56400.0
2011-07-28	BRF	ETF	52.66	53.27	52.46	52.51	123539.0
2011-07-28	BSCE	ETF	21.18	21.21	21.14	21.2	12508.0
2011-07-28	BSV	ETF	81.18	81.25	81.18	81.21	374400.0

> showing 50 of 864 rows — these rows as CSV

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