PREVIEW / etf_daily / 2011-11-25

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-25.parquet
  size:    35 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-11-25	SPY	ETF	116.38	117.7	116.2	116.34	99557000.0
2011-11-25	QQQ	ETF	53.09	53.67	52.87	52.88	25447855.0
2011-11-25	IWM	ETF	67.05	68.04	66.62	66.62	28167900.0
2011-11-25	DIA	ETF	112.28	113.46	112.14	112.14	3532100.0
2011-11-25	GLD	ETF	163.33	165.2	163.29	163.4	6098000.0
2011-11-25	TLT	ETF	121.8	121.87	120.74	120.8	4311900.0
2011-11-25	AAXJ	ETF	48.34	48.7	48.07	48.07	106500.0
2011-11-25	ACTV	ETF	12.96	13.23	12.77	13.04	57559.0
2011-11-25	ACWI	ETF	39.45	39.98	39.41	39.45	236800.0
2011-11-25	ACWX	ETF	34.71	35.07	34.57	34.57	137973.0
2011-11-25	ADRE	ETF	36.9	37.24	36.72	36.72	38088.0
2011-11-25	AFK	ETF	25.7	25.98	25.6	25.672	3134.0
2011-11-25	AGEM	ETF	20.09	20.27	20.052	20.052	2200.0
2011-11-25	AGG	ETF	109.79	109.86	109.58	109.63	764800.0
2011-11-25	AGQ	ETF	217.6	227.28	216.44	216.68	340375.0
2011-11-25	AGZ	ETF	112.59	112.66	112.3845	112.63	6322.0
2011-11-25	AIA	ETF	37.91	38.2059	37.79	37.79	11610.0
2011-11-25	AIQ	ETF	5.6	6.0	5.55	5.65	9956.0
2011-11-25	AIS	ETF	2.55	2.6	2.49	2.54	921731.0
2011-11-25	AIVI	ETF	37.2	37.58	37.1	37.1	51200.0
2011-11-25	AMJ	ETF	35.78	36.23	35.71	35.95	316885.0
2011-11-25	AMLP	ETF	78.75	79.0	78.65	78.75	43040.0
2011-11-25	AOA	ETF	31.17	31.21	31.09	31.09	1600.0
2011-11-25	AOK	ETF	28.75	28.86	28.75	28.8	3641.0
2011-11-25	AOM	ETF	29.19	29.23	29.1	29.1	1260.0
2011-11-25	AOR	ETF	29.86	29.9455	29.86	29.881	9905.0
2011-11-25	ARB	ETF	36.45	36.9	36.2	36.2	72237.0
2011-11-25	ARGT	ETF	21.08	21.08	20.94	20.94	300.0
2011-11-25	ASEA	ETF	14.0	14.15	14.0	14.01	1600.0
2011-11-25	AWAY	ETF	27.54	27.54	26.6	26.76	41863.0
2011-11-25	BAB	ETF	28.93	28.99	28.75	28.87	206570.0
2011-11-25	BAL	ETF	56.74	56.91	55.73	55.84	12935.0
2011-11-25	BALT	ETF	4.48	4.61	4.39	4.39	47636.0
2011-11-25	BBH	ETF	33.57	33.93	33.57	33.57	30300.0
2011-11-25	BCM	ETF	43.3516	43.3516	43.3516	43.3516	150.0
2011-11-25	BIB	ETF	7.4337	7.4337	7.3327	7.3525	7200.0
2011-11-25	BICK	ETF	22.61	22.72	22.33	22.4001	6096.0
2011-11-25	BIL	ETF	91.7	91.7	91.68	91.7	268300.0
2011-11-25	BIS	ETF	6259.2	6296.0	6249.6	6296.0	2.625
2011-11-25	BITS	ETF	21.52	21.6	21.52	21.6	2424.0
2011-11-25	BIV	ETF	87.7	87.7	87.2	87.35	49000.0
2011-11-25	BJK	ETF	28.94	29.1	28.74	28.74	5800.0
2011-11-25	BKF	ETF	35.3	35.53	35.03	35.03	109255.0
2011-11-25	BKLN	ETF	23.62	23.78	23.62	23.74	84900.0
2011-11-25	BLV	ETF	92.61	92.85	91.61	91.61	41600.0
2011-11-25	BMVP	ETF	12.6567	12.6567	12.6567	12.6567	170.0
2011-11-25	BND	ETF	83.62	83.79	83.62	83.66	1453300.0
2011-11-25	BNO	ETF	36.985	37.285	36.69	36.69	78000.0
2011-11-25	BRF	ETF	39.51	39.9099	39.28	39.47	68996.0
2011-11-25	BSCE	ETF	20.77	20.82	20.75	20.75	5884.0

> showing 50 of 854 rows — these rows as CSV

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