PREVIEW / etf_daily / 2012-06-05

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-05.parquet
  size:    38 KB
  rows:    927

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-06-05	SPY	ETF	127.85	129.26	127.78	129.07	164149400.0
2012-06-05	QQQ	ETF	60.65	61.24	60.63	61.12	47916880.0
2012-06-05	IWM	ETF	73.26	74.67	73.21	74.6	48270600.0
2012-06-05	DIA	ETF	120.64	121.32	120.52	121.09	6619900.0
2012-06-05	GLD	ETF	156.92	157.27	156.42	157.14	8095300.0
2012-06-05	TLT	ETF	128.53	128.64	127.59	127.6	12482800.0
2012-06-05	AAXJ	ETF	49.44	49.74	49.34	49.63	266000.0
2012-06-05	ACTV	ETF	13.87	14.27	13.81	14.27	816403.0
2012-06-05	ACWI	ETF	41.4	41.72	41.37	41.69	691800.0
2012-06-05	ACWV	ETF	52.5	52.5	51.89	52.17	3000.0
2012-06-05	ACWX	ETF	35.03	35.26	34.97	35.22	759794.0
2012-06-05	ADRE	ETF	35.75	35.9201	35.63	35.81	32535.0
2012-06-05	AFK	ETF	27.06	27.09	26.83	27.01	51280.0
2012-06-05	AGEM	ETF	19.6	19.62	19.5727	19.61	817.0
2012-06-05	AGG	ETF	111.17	111.33	111.1	111.11	951100.0
2012-06-05	AGQ	ETF	164.48	167.12	163.84	166.88	220325.0
2012-06-05	AGZ	ETF	113.54	113.54	113.3001	113.464	15518.0
2012-06-05	AIA	ETF	39.24	39.42	39.24	39.42	5465.0
2012-06-05	AIQ	ETF	4.955	5.05	4.8005	5.05	12135.0
2012-06-05	AIS	ETF	2.84	2.93	2.8	2.92	634030.0
2012-06-05	AIVI	ETF	36.04	36.24	36.01	36.21	60000.0
2012-06-05	AMJ	ETF	35.09	35.87	35.0201	35.79	1173398.0
2012-06-05	AMLP	ETF	76.0	77.75	76.0	77.65	473360.0
2012-06-05	ANGL	ETF	24.81	24.81	24.81	24.81	300.0
2012-06-05	AOA	ETF	33.28	33.56	33.28	33.56	7100.0
2012-06-05	AOK	ETF	29.4	29.46	29.3959	29.46	19890.0
2012-06-05	AOM	ETF	29.93	30.129	29.93	30.09	12048.0
2012-06-05	AOR	ETF	31.4218	31.55	31.4218	31.53	5541.0
2012-06-05	ARB	ETF	34.43	34.578	33.92	33.94	230260.0
2012-06-05	ARGT	ETF	15.16	15.16	15.16	15.16	3200.0
2012-06-05	ASEA	ETF	14.49	14.55	14.44	14.5	36900.0
2012-06-05	AWAY	ETF	21.28	21.38	20.82	21.24	562555.0
2012-06-05	BAB	ETF	30.06	30.11	29.96	30.01	271656.0
2012-06-05	BAL	ETF	42.64	42.76	41.2391	41.41	13621.0
2012-06-05	BALT	ETF	3.35	3.48	3.35	3.45	75946.0
2012-06-05	BBH	ETF	44.13	44.78	44.13	44.67	14900.0
2012-06-05	BCM	ETF	40.3033	40.33	40.181	40.259	3471.0
2012-06-05	BIB	ETF	11.235	11.5962	11.235	11.5962	15760.0
2012-06-05	BICK	ETF	21.3	21.4264	21.1938	21.4	2359.0
2012-06-05	BIL	ETF	91.64	91.66	91.64	91.66	383300.0
2012-06-05	BIS	ETF	3793.6	3793.6	3702.4	3736.0	19.7
2012-06-05	BIV	ETF	88.7	88.76	88.56	88.57	571600.0
2012-06-05	BJK	ETF	30.26	30.79	30.22	30.79	20700.0
2012-06-05	BKF	ETF	34.32	34.48	34.146	34.27	104810.0
2012-06-05	BKLN	ETF	23.77	23.89	23.7	23.89	544300.0
2012-06-05	BLV	ETF	95.68	95.72	95.2	95.25	86600.0
2012-06-05	BMVP	ETF	13.97	14.2	13.97	14.2	27162.0
2012-06-05	BND	ETF	84.34	84.37	84.22	84.24	2069200.0
2012-06-05	BNO	ETF	34.79	35.03	34.78	34.885	59800.0
2012-06-05	BOIL	ETF	776400.0	779200.0	748200.0	753000.0	6.0

> showing 50 of 927 rows — these rows as CSV

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