PREVIEW / etf_daily / 2011-08-04

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-04.parquet
  size:    37 KB
  rows:    876

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-04	SPY	ETF	124.42	124.62	120.06	120.26	520721800.0
2011-08-04	QQQ	ETF	55.98	56.09	54.17	54.17	132829925.0
2011-08-04	IWM	ETF	76.07	76.21	72.59	72.6	130904800.0
2011-08-04	DIA	ETF	117.32	117.57	113.56	113.71	19368300.0
2011-08-04	GLD	ETF	163.61	163.87	159.68	160.64	40380300.0
2011-08-04	TLT	ETF	102.38	105.55	102.27	105.36	34076600.0
2011-08-04	AADR	ETF	29.43	29.43	28.85	28.85	900.0
2011-08-04	AAXJ	ETF	59.2	59.43	57.92	58.05	774700.0
2011-08-04	ACTV	ETF	17.13	17.7	16.74	17.28	244420.0
2011-08-04	ACWI	ETF	44.8	44.82	43.08	43.23	1457500.0
2011-08-04	ACWX	ETF	41.14	41.19	39.84	39.85	862208.0
2011-08-04	ADRE	ETF	43.09	43.32	41.86	41.86	203645.0
2011-08-04	AFK	ETF	30.38	30.38	29.0	29.03	25533.0
2011-08-04	AGEM	ETF	23.98	23.98	23.39	23.39	5126.0
2011-08-04	AGG	ETF	108.8	109.37	108.76	109.27	1585700.0
2011-08-04	AGQ	ETF	475.24	477.44	392.08	395.26	2346400.0
2011-08-04	AGZ	ETF	111.5	111.82	111.436	111.7976	69137.0
2011-08-04	AIA	ETF	43.97	43.97	42.81	42.89	76467.0
2011-08-04	AIQ	ETF	16.2	16.35	15.5	15.55	18036.0
2011-08-04	AIS	ETF	2.29	2.29	1.93	1.98	3123137.0
2011-08-04	AIVI	ETF	42.75	42.75	41.01	41.11	44600.0
2011-08-04	AMJ	ETF	35.99	36.31	34.87	34.94	1575223.0
2011-08-04	AMLP	ETF	79.45	79.5	77.7	78.0	152720.0
2011-08-04	AOA	ETF	33.72	33.72	32.57	32.62	171100.0
2011-08-04	AOK	ETF	29.24	29.24	29.01	29.07	168287.0
2011-08-04	AOM	ETF	30.09	30.09	29.73	29.73	136281.0
2011-08-04	AOR	ETF	31.49	31.51	30.79	30.79	136816.0
2011-08-04	ARB	ETF	38.31	38.54	36.85	36.86	199663.0
2011-08-04	ARGT	ETF	27.66	27.66	26.96	26.96	2000.0
2011-08-04	ASEA	ETF	16.97	17.03	16.55	16.65	14900.0
2011-08-04	AWAY	ETF	33.85	34.62	33.29	33.73	206627.0
2011-08-04	BAB	ETF	27.54	27.8199	27.52	27.79	415620.0
2011-08-04	BAL	ETF	63.84	65.43	63.56	64.39	92599.0
2011-08-04	BALT	ETF	5.02	5.03	4.8	4.82	197814.0
2011-08-04	BBH	ETF	32.6667	32.6667	31.48	31.48	48300.0
2011-08-04	BCM	ETF	46.52	46.52	46.31	46.31	615.0
2011-08-04	BIB	ETF	7.6963	7.6988	6.9375	6.9575	361240.0
2011-08-04	BICK	ETF	29.14	29.14	28.01	28.01	84614.0
2011-08-04	BIL	ETF	91.72	91.72	91.7	91.72	1335150.0
2011-08-04	BIS	ETF	7118.4	7945.6	7118.4	7926.72	26.95
2011-08-04	BITS	ETF	20.8	21.52	19.6	20.88	1000.0
2011-08-04	BIV	ETF	86.69	87.33	86.6	87.21	153300.0
2011-08-04	BJK	ETF	34.87	34.87	33.29	33.31	52300.0
2011-08-04	BKF	ETF	43.93	43.99	42.5	42.51	289678.0
2011-08-04	BKLN	ETF	24.45	24.51	24.24	24.26	146600.0
2011-08-04	BLNG	ETF	53.8285	53.8285	52.37	52.6268	1120.0
2011-08-04	BLV	ETF	85.7	87.26	85.59	87.23	79100.0
2011-08-04	BMVP	ETF	14.14	14.14	13.56	13.56	17984.0
2011-08-04	BND	ETF	82.83	83.22	82.77	83.21	1100600.0
2011-08-04	BNO	ETF	37.44	37.44	35.8	35.925	453200.0

> showing 50 of 876 rows — these rows as CSV

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