PREVIEW / etf_daily / 2012-02-22

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-22.parquet
  size:    38 KB
  rows:    912

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
2012-02-22	SPY	ETF	136.26	136.55	135.79	136.03	124455300.0
2012-02-22	QQQ	ETF	63.49	63.68	63.23	63.32	43174694.0
2012-02-22	IWM	ETF	81.97	82.36	81.5	81.58	42626900.0
2012-02-22	DIA	ETF	129.23	129.5	128.85	129.14	6092200.0
2012-02-22	GLD	ETF	170.4	173.17	170.19	172.94	16676500.0
2012-02-22	TLT	ETF	115.89	116.76	115.81	116.74	7736800.0
2012-02-22	AADR	ETF	30.41	30.41	30.41	30.41	300.0
2012-02-22	AAXJ	ETF	57.8	57.81	57.52	57.78	148200.0
2012-02-22	ACTV	ETF	15.97	16.0	15.59	15.75	206886.0
2012-02-22	ACWI	ETF	46.31	46.39	46.19	46.29	417900.0
2012-02-22	ACWV	ETF	53.14	53.2	53.14	53.2	1400.0
2012-02-22	ACWX	ETF	40.73	40.86	40.64	40.76	235845.0
2012-02-22	ADRE	ETF	43.45	43.606	43.37	43.52	70232.0
2012-02-22	AFK	ETF	29.18	29.519	29.18	29.44	3279.0
2012-02-22	AGEM	ETF	23.8	23.8725	23.777	23.777	1755.0
2012-02-22	AGG	ETF	110.34	110.48	110.28	110.48	975200.0
2012-02-22	AGQ	ETF	246.92	253.76	246.28	252.4	719300.0
2012-02-22	AGZ	ETF	112.68	112.87	112.64	112.87	17039.0
2012-02-22	AIA	ETF	45.06	45.13	44.9184	45.09	14368.0
2012-02-22	AIQ	ETF	7.05	7.75	7.0	7.35	19836.0
2012-02-22	AIS	ETF	2.62	2.72	2.62	2.67	1207583.0
2012-02-22	AIVI	ETF	41.96	42.12	41.87	42.0	112300.0
2012-02-22	AMJ	ETF	41.41	41.42	40.95	41.28	1361803.0
2012-02-22	AMLP	ETF	85.65	85.65	84.9	85.55	310560.0
2012-02-22	AOA	ETF	35.84	35.89	35.71	35.77	12500.0
2012-02-22	AOK	ETF	30.01	30.08	30.01	30.08	16949.0
2012-02-22	AOM	ETF	30.96	31.06	30.96	31.04	18987.0
2012-02-22	AOR	ETF	32.94	32.96	32.855	32.9	33349.0
2012-02-22	ARB	ETF	34.48	35.02	34.31	34.69	180997.0
2012-02-22	ARGT	ETF	23.44	23.44	23.44	23.44	750.0
2012-02-22	ASEA	ETF	16.0	16.06	15.95	16.02	19300.0
2012-02-22	AWAY	ETF	25.39	26.24	25.071	26.05	475156.0
2012-02-22	BAB	ETF	29.14	29.27	29.112	29.27	147678.0
2012-02-22	BAL	ETF	56.22	56.22	55.0	55.36	18116.0
2012-02-22	BALT	ETF	4.64	4.64	4.37	4.37	211938.0
2012-02-22	BBH	ETF	41.4	41.92	41.32	41.79	109700.0
2012-02-22	BCM	ETF	46.33	46.33	46.33	46.33	270.0
2012-02-22	BIB	ETF	10.6913	10.8212	10.5439	10.7677	79560.0
2012-02-22	BICK	ETF	28.0	28.27	27.91	27.9921	12777.0
2012-02-22	BIL	ETF	91.64	91.66	91.64	91.64	105350.0
2012-02-22	BIS	ETF	4153.6	4163.2	4096.0	4106.976	33.7
2012-02-22	BITS	ETF	21.92	21.92	21.92	21.92	25.0
2012-02-22	BIV	ETF	87.51	87.72	87.44	87.69	238900.0
2012-02-22	BJK	ETF	34.15	34.2	33.95	34.06	515400.0
2012-02-22	BKF	ETF	43.39	43.47	43.2	43.44	147727.0
2012-02-22	BKLN	ETF	24.42	24.45	24.42	24.44	120700.0
2012-02-22	BLNG	ETF	53.57	53.7185	53.57	53.7185	300.0
2012-02-22	BLV	ETF	90.46	91.0	90.44	90.97	23400.0
2012-02-22	BMVP	ETF	15.235	15.263	15.235	15.257	1254.0
2012-02-22	BND	ETF	83.59	83.76	83.52	83.74	1847600.0

> showing 50 of 912 rows — these rows as CSV

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