PREVIEW / etf_daily / 2012-02-13

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-13.parquet
  size:    38 KB
  rows:    913

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-13	SPY	ETF	135.32	135.52	134.74	135.36	115841900.0
2012-02-13	QQQ	ETF	62.93	63.13	62.65	63.05	36810183.0
2012-02-13	IWM	ETF	82.11	82.43	81.61	82.32	38574100.0
2012-02-13	DIA	ETF	128.68	128.77	128.08	128.59	4654100.0
2012-02-13	GLD	ETF	167.33	167.94	166.74	167.51	7088900.0
2012-02-13	TLT	ETF	116.6	117.37	116.43	117.14	6422900.0
2012-02-13	AADR	ETF	30.02	30.02	30.02	30.02	600.0
2012-02-13	AAXJ	ETF	56.99	57.08	56.66	56.79	921100.0
2012-02-13	ACTV	ETF	15.49	15.5	15.43	15.49	138324.0
2012-02-13	ACWI	ETF	45.91	45.98	45.72	45.94	425600.0
2012-02-13	ACWX	ETF	40.31	40.41	40.17	40.28	90744.0
2012-02-13	ADRE	ETF	43.44	43.68	43.31	43.59	38972.0
2012-02-13	AFK	ETF	29.12	29.38	29.12	29.35	20257.0
2012-02-13	AGG	ETF	110.48	110.55	110.39	110.45	914800.0
2012-02-13	AGQ	ETF	241.88	244.4	238.68	242.44	303350.0
2012-02-13	AGZ	ETF	112.71	113.02	112.71	112.83	84092.0
2012-02-13	AIA	ETF	43.94	43.9894	43.75	43.97	8568.0
2012-02-13	AIQ	ETF	6.85	7.3495	6.85	7.05	24523.0
2012-02-13	AIS	ETF	2.64	2.65	2.54	2.6	867054.0
2012-02-13	AIVI	ETF	41.59	41.59	41.24	41.44	214600.0
2012-02-13	AMJ	ETF	40.44	40.55	40.34	40.55	1275697.0
2012-02-13	AMLP	ETF	84.1	84.25	83.95	84.2	361040.0
2012-02-13	AOA	ETF	35.58	35.68	35.52	35.64	16400.0
2012-02-13	AOK	ETF	30.02	30.02	29.94	30.02	68957.0
2012-02-13	AOM	ETF	30.96	30.97	30.862	30.96	18276.0
2012-02-13	AOR	ETF	32.77	32.83	32.749	32.816	51432.0
2012-02-13	ARB	ETF	35.58	36.27	35.39	35.39	256194.0
2012-02-13	ARGT	ETF	23.0	23.0	22.9	22.94	1250.0
2012-02-13	ASEA	ETF	15.81	15.9	15.75	15.84	16600.0
2012-02-13	AWAY	ETF	26.37	27.0	25.78	26.46	254451.0
2012-02-13	BAB	ETF	29.28	29.37	29.21	29.29	172752.0
2012-02-13	BAL	ETF	56.84	56.93	55.868	56.14	8310.0
2012-02-13	BALT	ETF	4.26	4.38	4.18	4.33	264241.0
2012-02-13	BBH	ETF	43.1667	44.1333	43.1667	44.0667	30000.0
2012-02-13	BCM	ETF	45.69	45.69	45.63	45.67	2144.0
2012-02-13	BIB	ETF	11.3987	11.737	11.3987	11.7174	66816.0
2012-02-13	BICK	ETF	27.86	27.8788	27.6	27.69	12799.0
2012-02-13	BIL	ETF	91.64	91.66	91.64	91.64	638600.0
2012-02-13	BIS	ETF	3876.8	3878.416	3801.6	3801.6	72.0
2012-02-13	BITS	ETF	22.24	22.36	21.76	21.76	400.0
2012-02-13	BIV	ETF	87.7	87.85	87.58	87.76	234000.0
2012-02-13	BJK	ETF	33.52	33.69	33.43	33.57	28500.0
2012-02-13	BKF	ETF	42.76	43.01	42.534	42.93	131990.0
2012-02-13	BKLN	ETF	24.55	24.58	24.49	24.57	88500.0
2012-02-13	BLV	ETF	90.82	91.11	90.5	90.84	90800.0
2012-02-13	BMVP	ETF	15.05	15.11	14.99	15.07	36937.0
2012-02-13	BND	ETF	83.73	83.76	83.63	83.69	933300.0
2012-02-13	BNO	ETF	41.08	41.145	40.795	40.885	82600.0
2012-02-13	BOIL	ETF	1280000.0	1320000.0	1276000.0	1296000.0	5.4
2012-02-13	BRF	ETF	44.64	46.38	44.27	44.86	330315.0

> showing 50 of 913 rows — these rows as CSV

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