PREVIEW / etf_daily / 2012-04-23

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-23.parquet
  size:    39 KB
  rows:    937

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-04-23	SPY	ETF	136.54	136.91	135.94	136.79	171844900.0
2012-04-23	QQQ	ETF	65.08	65.18	64.49	65.08	70514110.0
2012-04-23	IWM	ETF	78.98	79.16	78.31	79.1	62477000.0
2012-04-23	DIA	ETF	128.74	129.08	128.16	129.02	5180000.0
2012-04-23	GLD	ETF	158.2	159.18	157.88	159.07	8876800.0
2012-04-23	TLT	ETF	118.11	118.41	117.79	117.92	5170100.0
2012-04-23	AADR	ETF	29.93	30.07	29.83	29.87	2700.0
2012-04-23	AAXJ	ETF	55.06	55.22	54.65	55.18	682300.0
2012-04-23	ACTV	ETF	16.55	16.74	16.21	16.67	320030.0
2012-04-23	ACWI	ETF	45.51	45.7	45.29	45.67	546200.0
2012-04-23	ACWX	ETF	39.27	39.28	38.92	39.26	129647.0
2012-04-23	ADRE	ETF	40.49	40.75	40.261	40.75	15010.0
2012-04-23	AFK	ETF	29.12	29.31	29.0	29.17	7845.0
2012-04-23	AGEM	ETF	22.3035	22.38	22.3035	22.38	725.0
2012-04-23	AGG	ETF	110.74	110.74	110.53	110.59	787100.0
2012-04-23	AGQ	ETF	195.68	197.64	192.48	197.36	479775.0
2012-04-23	AGZ	ETF	112.98	112.98	112.8415	112.9	12009.0
2012-04-23	AIA	ETF	43.69	43.69	43.18	43.56	56818.0
2012-04-23	AIQ	ETF	7.0	7.0	6.6	6.6	14083.0
2012-04-23	AIS	ETF	2.93	2.98	2.89	2.92	793270.0
2012-04-23	AIVI	ETF	39.43	39.49	39.11	39.45	35700.0
2012-04-23	AMJ	ETF	38.87	39.52	38.87	39.44	1274066.0
2012-04-23	AMLP	ETF	82.9	83.55	82.9	83.4	328760.0
2012-04-23	ANGL	ETF	25.54	25.55	25.28	25.48	2300.0
2012-04-23	AOA	ETF	35.47	35.5	35.33	35.44	12500.0
2012-04-23	AOK	ETF	29.93	29.979	29.88	29.9488	34379.0
2012-04-23	AOM	ETF	30.9	30.91	30.8	30.88	18819.0
2012-04-23	AOR	ETF	32.72	32.779	32.62	32.73	21843.0
2012-04-23	ARB	ETF	38.47	38.47	37.96	38.06	308343.0
2012-04-23	ARGT	ETF	18.26	18.3	17.92	18.28	2750.0
2012-04-23	ASEA	ETF	15.96	16.04	15.95	16.02	4100.0
2012-04-23	AWAY	ETF	23.67	23.94	23.17	23.93	399406.0
2012-04-23	BAB	ETF	29.5	29.59	29.5	29.57	351631.0
2012-04-23	BAL	ETF	56.54	57.86	56.34	57.79	71347.0
2012-04-23	BALT	ETF	4.52	4.6	4.38	4.4	164677.0
2012-04-23	BBH	ETF	44.42	44.75	44.2	44.75	32700.0
2012-04-23	BCM	ETF	44.01	44.262	43.968	44.262	19619.0
2012-04-23	BIB	ETF	11.49	11.5687	11.28	11.5512	39296.0
2012-04-23	BICK	ETF	25.07	25.18	24.956	25.18	3627.0
2012-04-23	BIL	ETF	91.64	91.66	91.64	91.66	1436350.0
2012-04-23	BIS	ETF	3798.4	3809.6	3748.8	3748.8	33.75
2012-04-23	BIV	ETF	87.88	87.9	87.79	87.81	229500.0
2012-04-23	BJK	ETF	36.07	36.21	35.8	36.17	15200.0
2012-04-23	BKF	ETF	39.78	39.85	39.36	39.83	202067.0
2012-04-23	BKLN	ETF	24.37	24.45	24.37	24.43	110800.0
2012-04-23	BLNG	ETF	49.42	49.42	49.42	49.42	914.0
2012-04-23	BLV	ETF	91.63	91.88	91.15	91.19	206900.0
2012-04-23	BMVP	ETF	15.19	15.19	15.08	15.18	4455.0
2012-04-23	BND	ETF	83.89	83.89	83.77	83.83	843700.0
2012-04-23	BNO	ETF	41.45	41.865	41.355	41.845	57800.0

> showing 50 of 937 rows — these rows as CSV

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