PREVIEW / etf_daily / 2011-06-27

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-27.parquet
  size:    36 KB
  rows:    854

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-06-27	SPY	ETF	126.89	128.43	126.64	127.94	168904700.0
2011-06-27	QQQ	ETF	54.43	55.53	54.32	55.245	49968854.0
2011-06-27	IWM	ETF	79.91	80.72	79.46	80.56	51195400.0
2011-06-27	DIA	ETF	119.27	120.73	119.08	120.2	4488800.0
2011-06-27	GLD	ETF	145.93	146.4	145.2	145.73	11602500.0
2011-06-27	TLT	ETF	96.85	96.87	95.55	95.65	9331300.0
2011-06-27	AAXJ	ETF	59.79	60.37	59.66	60.16	391200.0
2011-06-27	ACTV	ETF	15.98	17.25	15.9	17.15	139214.0
2011-06-27	ACWI	ETF	46.19	46.64	46.0	46.49	197200.0
2011-06-27	ACWX	ETF	42.77	43.27	42.77	43.18	103119.0
2011-06-27	ADRE	ETF	44.43	44.95	44.38	44.83	47022.0
2011-06-27	AFK	ETF	31.16	31.69	31.16	31.5	41700.0
2011-06-27	AGEM	ETF	25.61	25.61	25.61	25.61	136.0
2011-06-27	AGG	ETF	107.7	107.7	107.36	107.44	730600.0
2011-06-27	AGQ	ETF	313.92	318.0	305.36	307.0	708250.0
2011-06-27	AGZ	ETF	110.97	111.03	110.86	110.94	8620.0
2011-06-27	AIA	ETF	45.37	45.7	45.21	45.62	15010.0
2011-06-27	AIQ	ETF	19.15	19.45	19.1	19.2	17291.0
2011-06-27	AIS	ETF	2.11	2.15	2.035	2.1	1351366.0
2011-06-27	AIVI	ETF	44.77	45.34	44.74	45.22	56900.0
2011-06-27	AMJ	ETF	36.36	36.55	36.22	36.42	750983.0
2011-06-27	AMLP	ETF	79.0	79.55	79.0	79.45	127920.0
2011-06-27	AOA	ETF	34.64	34.95	34.64	34.83	8800.0
2011-06-27	AOK	ETF	29.24	29.25	29.2	29.25	23907.0
2011-06-27	AOM	ETF	30.22	30.3	30.16	30.24	27233.0
2011-06-27	AOR	ETF	31.87	32.03	31.83	32.0	6076.0
2011-06-27	ARB	ETF	38.3	39.08	37.8	39.01	108165.0
2011-06-27	ARGT	ETF	28.68	28.98	28.68	28.96	2700.0
2011-06-27	ASEA	ETF	15.91	15.91	15.91	15.91	400.0
2011-06-27	BAB	ETF	26.53	26.581	26.4	26.4	332578.0
2011-06-27	BAL	ETF	72.71	76.81	72.15	75.42	41963.0
2011-06-27	BALT	ETF	5.97	6.02	5.91	6.01	72152.0
2011-06-27	BBH	ETF	34.6667	35.1867	34.6567	35.1467	52800.0
2011-06-27	BCM	ETF	45.33	45.33	45.33	45.33	100.0
2011-06-27	BIB	ETF	8.9362	9.1675	8.875	9.1675	26040.0
2011-06-27	BICK	ETF	30.78	33.5	30.62	31.04	200751.0
2011-06-27	BIL	ETF	91.72	91.72	91.7	91.7	126950.0
2011-06-27	BIS	ETF	6284.8	6286.4	6284.8	6286.4	3.75
2011-06-27	BITS	ETF	21.24	21.48	21.2	21.48	1264.0
2011-06-27	BIV	ETF	85.47	85.49	84.99	85.14	126400.0
2011-06-27	BJK	ETF	32.27	32.73	32.17	32.72	4200.0
2011-06-27	BKF	ETF	45.97	46.45	45.8116	46.29	81123.0
2011-06-27	BKLN	ETF	24.72	24.74	24.68	24.69	132200.0
2011-06-27	BLV	ETF	81.79	81.79	80.82	81.0	56500.0
2011-06-27	BMVP	ETF	15.0319	15.2584	15.0124	15.2584	6437.0
2011-06-27	BND	ETF	82.04	82.04	81.77	81.81	704000.0
2011-06-27	BNO	ETF	34.715	35.57	34.665	35.535	181400.0
2011-06-27	BRF	ETF	55.05	55.62	54.86	55.4	326544.0
2011-06-27	BSCE	ETF	21.21	21.24	21.21	21.221	22475.0
2011-06-27	BSV	ETF	81.41	81.43	81.29	81.31	447700.0

> showing 50 of 854 rows — these rows as CSV

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