PREVIEW / etf_daily / 2012-05-04

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-04.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-05-04	SPY	ETF	138.52	139.3	136.92	137.0	193927300.0
2012-05-04	QQQ	ETF	65.75	66.3524	64.69	64.7	107553920.0
2012-05-04	IWM	ETF	80.07	80.55	78.94	79.09	75093300.0
2012-05-04	DIA	ETF	131.13	131.32	129.97	130.09	5934300.0
2012-05-04	GLD	ETF	158.82	159.98	158.57	159.47	11389600.0
2012-05-04	TLT	ETF	117.48	118.19	117.4	118.14	6367300.0
2012-05-04	AADR	ETF	29.65	29.65	29.57	29.57	3600.0
2012-05-04	AAXJ	ETF	55.99	56.01	55.46	55.54	118600.0
2012-05-04	ACTV	ETF	16.0	16.32	15.11	15.29	501507.0
2012-05-04	ACWI	ETF	46.03	46.04	45.46	45.5	558900.0
2012-05-04	ACWV	ETF	54.53	54.53	54.02	54.21	8500.0
2012-05-04	ACWX	ETF	39.48	39.52	38.99	39.07	341776.0
2012-05-04	ADRE	ETF	40.85	40.85	40.16	40.25	25445.0
2012-05-04	AFK	ETF	29.96	29.99	29.47	29.52	13303.0
2012-05-04	AGEM	ETF	22.07	22.07	22.07	22.07	250.0
2012-05-04	AGG	ETF	110.66	110.7	110.57	110.67	611500.0
2012-05-04	AGQ	ETF	187.0	191.92	186.36	189.64	358250.0
2012-05-04	AGZ	ETF	112.95	113.0	112.9199	112.9601	6895.0
2012-05-04	AIA	ETF	44.65	44.65	44.34	44.39	8717.0
2012-05-04	AIQ	ETF	7.1	7.5	7.05	7.4	19242.0
2012-05-04	AIS	ETF	3.02	3.06	2.95	2.95	1066889.0
2012-05-04	AIVI	ETF	39.99	39.99	39.56	39.62	37100.0
2012-05-04	AMJ	ETF	39.54	39.85	39.35	39.83	1197021.0
2012-05-04	AMLP	ETF	83.5	83.9	83.05	83.8	458000.0
2012-05-04	ANGL	ETF	25.51	25.51	25.43	25.45	45500.0
2012-05-04	AOA	ETF	35.86	35.86	35.5	35.56	16600.0
2012-05-04	AOK	ETF	30.09	30.09	29.9706	30.02	58552.0
2012-05-04	AOM	ETF	31.05	31.08	30.952	30.97	12681.0
2012-05-04	AOR	ETF	33.03	33.03	32.8	32.81	101135.0
2012-05-04	ARB	ETF	36.74	36.74	35.86	36.24	366935.0
2012-05-04	ARGT	ETF	17.82	17.82	17.56	17.66	5350.0
2012-05-04	ASEA	ETF	16.28	16.28	16.13	16.14	28500.0
2012-05-04	AWAY	ETF	25.45	25.73	25.33	25.5	367245.0
2012-05-04	BAB	ETF	29.49	29.6	29.48	29.6	115961.0
2012-05-04	BAL	ETF	55.49	55.49	54.63	54.78	27774.0
2012-05-04	BALT	ETF	4.21	4.25	4.05	4.05	119610.0
2012-05-04	BBH	ETF	45.61	45.61	44.86	44.86	13400.0
2012-05-04	BCM	ETF	43.46	43.65	43.398	43.6	2747.0
2012-05-04	BIB	ETF	11.875	11.875	11.6237	11.6237	54840.0
2012-05-04	BICK	ETF	24.75	24.926	24.58	24.63	13056.0
2012-05-04	BIL	ETF	91.64	91.66	91.64	91.64	111350.0
2012-05-04	BIS	ETF	3569.6	3707.2	3569.6	3707.2	24.8
2012-05-04	BIV	ETF	88.01	88.11	87.93	88.09	255300.0
2012-05-04	BJK	ETF	36.27	36.27	35.87	35.92	17100.0
2012-05-04	BKF	ETF	39.36	39.36	38.6891	38.78	259275.0
2012-05-04	BKLN	ETF	24.71	24.78	24.65	24.77	470300.0
2012-05-04	BLV	ETF	91.5	91.85	91.48	91.79	28200.0
2012-05-04	BMVP	ETF	15.39	15.39	15.19	15.21	3194.0
2012-05-04	BND	ETF	83.9	83.96	83.85	83.94	633500.0
2012-05-04	BNO	ETF	40.205	42.1	39.41	39.905	115600.0

> showing 50 of 937 rows — these rows as CSV

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