PREVIEW / etf_daily / 2012-05-25

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-25.parquet
  size:    38 KB
  rows:    914

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-25	SPY	ETF	132.48	132.85	131.78	132.1	135465600.0
2012-05-25	QQQ	ETF	62.21	62.3201	61.8899	62.07	32082832.0
2012-05-25	IWM	ETF	76.7	76.89	76.27	76.59	33847700.0
2012-05-25	DIA	ETF	124.93	125.1	123.97	124.26	6725100.0
2012-05-25	GLD	ETF	151.89	152.85	151.63	152.68	6212900.0
2012-05-25	TLT	ETF	123.43	123.54	123.14	123.4	4723600.0
2012-05-25	AAXJ	ETF	50.17	50.2	49.75	49.9	789700.0
2012-05-25	ACTV	ETF	13.76	13.96	13.71	13.88	300095.0
2012-05-25	ACWI	ETF	42.6	42.71	42.41	42.49	907100.0
2012-05-25	ACWV	ETF	52.61	52.73	52.61	52.66	4500.0
2012-05-25	ACWX	ETF	35.73	35.94	35.72	35.79	155328.0
2012-05-25	ADRE	ETF	36.38	36.62	36.37	36.41	43996.0
2012-05-25	AFK	ETF	27.94	28.09	27.85	27.86	23983.0
2012-05-25	AGEM	ETF	20.01	20.01	19.88	19.88	587.0
2012-05-25	AGG	ETF	110.84	110.95	110.81	110.92	454300.0
2012-05-25	AGQ	ETF	164.12	167.76	163.04	166.32	243550.0
2012-05-25	AGZ	ETF	113.2	113.34	112.93	113.05	30298.0
2012-05-25	AIA	ETF	39.88	39.88	39.71	39.71	9462.0
2012-05-25	AIQ	ETF	5.4	5.5	5.195	5.25	47049.0
2012-05-25	AIS	ETF	2.88	2.93	2.85	2.89	712455.0
2012-05-25	AIVI	ETF	36.94	37.24	36.92	36.99	78000.0
2012-05-25	AMJ	ETF	37.01	37.42	36.962	37.36	1158850.0
2012-05-25	AMLP	ETF	79.35	79.95	79.3	79.75	214880.0
2012-05-25	ANGL	ETF	25.0	25.06	25.0	25.02	2700.0
2012-05-25	AOA	ETF	34.3	34.3	34.12	34.15	24800.0
2012-05-25	AOK	ETF	29.6	29.61	29.55	29.59	11590.0
2012-05-25	AOM	ETF	30.3	30.368	30.26	30.29	16870.0
2012-05-25	AOR	ETF	31.99	31.9935	31.92	31.95	18448.0
2012-05-25	ARB	ETF	35.79	35.82	33.64	33.67	383786.0
2012-05-25	ARGT	ETF	16.12	16.14	16.04	16.14	450.0
2012-05-25	ASEA	ETF	14.72	14.74	14.68	14.68	10200.0
2012-05-25	AWAY	ETF	24.97	24.97	23.87	24.39	442536.0
2012-05-25	BAB	ETF	29.74	29.79	29.69	29.7	143531.0
2012-05-25	BAL	ETF	45.33	45.7	44.984	45.66	47039.0
2012-05-25	BALT	ETF	3.85	3.9386	3.79	3.8	48133.0
2012-05-25	BBH	ETF	46.15	46.24	45.91	46.16	17800.0
2012-05-25	BCM	ETF	41.52	41.534	41.451	41.53	6997.0
2012-05-25	BIB	ETF	12.1738	12.27	12.1436	12.2475	22472.0
2012-05-25	BICK	ETF	21.8	21.8	21.65	21.7001	7061.0
2012-05-25	BIL	ETF	91.64	91.66	91.64	91.66	730250.0
2012-05-25	BIS	ETF	3502.4	3502.4	3492.8	3492.8	9.4
2012-05-25	BIV	ETF	88.2	88.3	88.08	88.3	219500.0
2012-05-25	BJK	ETF	31.8	31.81	31.56	31.63	5000.0
2012-05-25	BKF	ETF	34.56	34.77	34.37	34.65	71690.0
2012-05-25	BKLN	ETF	24.24	24.32	24.24	24.32	179900.0
2012-05-25	BLV	ETF	93.64	93.83	93.45	93.83	23200.0
2012-05-25	BMVP	ETF	14.63	14.69	14.63	14.63	24010.0
2012-05-25	BND	ETF	83.99	84.06	83.98	84.03	738700.0
2012-05-25	BNO	ETF	37.715	37.83	37.675	37.775	51600.0
2012-05-25	BOIL	ETF	910600.0	914400.0	854400.0	877400.0	14.6

> showing 50 of 914 rows — these rows as CSV

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