PREVIEW / etf_daily / 2011-11-17

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-17.parquet
  size:    37 KB
  rows:    885

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-17	SPY	ETF	123.85	124.16	121.23	122.11	331219600.0
2011-11-17	QQQ	ETF	57.02	57.04	55.48	55.83	101706803.0
2011-11-17	IWM	ETF	72.95	73.44	71.27	72.0	78923500.0
2011-11-17	DIA	ETF	119.06	119.51	116.79	117.83	10984300.0
2011-11-17	GLD	ETF	170.04	170.3	166.39	167.1	28468900.0
2011-11-17	TLT	ETF	118.04	120.16	118.04	119.37	9907900.0
2011-11-17	AAXJ	ETF	51.97	52.04	50.39	50.66	349400.0
2011-11-17	ACTV	ETF	15.49	15.84	15.01	15.16	75267.0
2011-11-17	ACWI	ETF	42.31	42.49	41.43	41.65	472500.0
2011-11-17	ACWV	ETF	49.43	49.52	49.43	49.5	2200.0
2011-11-17	ACWX	ETF	37.45	37.557	36.72	36.85	256273.0
2011-11-17	ADRE	ETF	40.32	40.46	39.21	39.34	40714.0
2011-11-17	AFK	ETF	27.7	27.7	26.99	27.13	26556.0
2011-11-17	AGEM	ETF	22.17	22.17	21.49	21.49	2597.0
2011-11-17	AGG	ETF	109.66	109.85	109.5	109.64	1670000.0
2011-11-17	AGQ	ETF	247.04	247.96	217.16	223.76	1125625.0
2011-11-17	AGZ	ETF	112.1819	112.4052	112.14	112.31	167516.0
2011-11-17	AIA	ETF	40.63	40.79	39.56	39.77	65944.0
2011-11-17	AIQ	ETF	6.0	6.15	5.9	5.95	20850.0
2011-11-17	AIS	ETF	2.57	2.7	2.52	2.68	2692906.0
2011-11-17	AIVI	ETF	40.06	40.2	39.26	39.41	69400.0
2011-11-17	AMJ	ETF	37.18	37.43	36.91	37.24	900998.0
2011-11-17	AMLP	ETF	79.5	79.7	78.95	79.65	206880.0
2011-11-17	AOA	ETF	32.82	32.85	32.28	32.39	10900.0
2011-11-17	AOK	ETF	29.15	29.1688	29.04	29.07	21682.0
2011-11-17	AOM	ETF	29.77	29.84	29.6	29.65	20635.0
2011-11-17	AOR	ETF	30.99	31.01	30.63	30.72	13571.0
2011-11-17	ARB	ETF	40.56	41.03	39.61	39.82	112555.0
2011-11-17	ARGT	ETF	22.1	22.1	22.1	22.1	150.0
2011-11-17	ASEA	ETF	14.76	14.76	14.42	14.44	5800.0
2011-11-17	AWAY	ETF	32.2	32.525	31.01	31.64	119111.0
2011-11-17	BAB	ETF	28.41	28.82	28.3491	28.57	369011.0
2011-11-17	BAL	ETF	61.74	61.74	59.6	59.91	34831.0
2011-11-17	BALT	ETF	5.27	5.28	5.1008	5.2	75005.0
2011-11-17	BBH	ETF	34.5067	34.5733	34.0367	34.1033	9300.0
2011-11-17	BCM	ETF	44.24	44.24	44.24	44.24	1740.0
2011-11-17	BIB	ETF	7.0488	7.0774	6.8193	6.8655	11240.0
2011-11-17	BICK	ETF	24.68	24.87	24.06	24.1689	30919.0
2011-11-17	BIL	ETF	91.68	91.7	91.68	91.7	843800.0
2011-11-17	BIS	ETF	6804.8	6864.32	6651.2	6761.6	96.0
2011-11-17	BITS	ETF	21.44	23.0	20.6	21.6	13888.0
2011-11-17	BIV	ETF	87.65	87.88	87.51	87.75	196400.0
2011-11-17	BJK	ETF	31.04	31.09	30.23	30.34	13800.0
2011-11-17	BKF	ETF	39.09	39.268	37.46	37.56	235312.0
2011-11-17	BKLN	ETF	24.06	24.06	23.91	24.02	131000.0
2011-11-17	BLV	ETF	91.12	92.22	91.08	91.78	39000.0
2011-11-17	BMVP	ETF	13.52	13.56	13.27	13.29	5974.0
2011-11-17	BND	ETF	83.6	83.75	83.52	83.67	1147800.0
2011-11-17	BNO	ETF	37.87	38.04	37.36	37.445	272200.0
2011-11-17	BOIL	ETF	2898000.0	3000000.0	2636000.0	3000000.0	0.2

> showing 50 of 885 rows — these rows as CSV

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