PREVIEW / etf_daily / 2012-05-23

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-23.parquet
  size:    38 KB
  rows:    945

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-23	SPY	ETF	131.25	132.46	129.99	132.27	204958400.0
2012-05-23	QQQ	ETF	61.93	62.71	61.37	62.56	56951072.0
2012-05-23	IWM	ETF	75.25	76.64	74.69	76.48	66981800.0
2012-05-23	DIA	ETF	123.95	124.8	122.82	124.71	8600000.0
2012-05-23	GLD	ETF	151.5	151.84	148.84	151.62	18854500.0
2012-05-23	TLT	ETF	123.55	124.52	123.36	123.41	11744900.0
2012-05-23	AADR	ETF	27.96	27.96	27.94	27.94	3500.0
2012-05-23	AAXJ	ETF	50.53	50.66	49.76	50.6	1200000.0
2012-05-23	ACTV	ETF	13.09	13.165	12.7	13.06	183388.0
2012-05-23	ACWI	ETF	42.59	42.81	42.08	42.76	678000.0
2012-05-23	ACWV	ETF	52.25	52.4	52.12	52.4	15000.0
2012-05-23	ACWX	ETF	36.0	36.1	35.47	36.1	106809.0
2012-05-23	ADRE	ETF	36.32	36.59	35.73	36.59	16492.0
2012-05-23	AFK	ETF	27.69	28.13	27.5	28.13	72431.0
2012-05-23	AGEM	ETF	20.03	20.04	19.7135	19.7135	3503.0
2012-05-23	AGG	ETF	110.95	111.01	110.82	110.84	696000.0
2012-05-23	AGQ	ETF	158.32	159.96	151.08	159.44	722325.0
2012-05-23	AGZ	ETF	113.2	113.37	113.11	113.29	8546.0
2012-05-23	AIA	ETF	40.31	40.34	39.7208	40.28	28203.0
2012-05-23	AIQ	ETF	5.2	5.4	5.195	5.25	8083.0
2012-05-23	AIS	ETF	2.93	3.0	2.91	2.93	603996.0
2012-05-23	AIVI	ETF	37.42	37.42	36.79	37.29	41000.0
2012-05-23	AMJ	ETF	37.73	37.95	37.16	37.83	1379521.0
2012-05-23	AMLP	ETF	79.5	79.9	78.8	79.65	344440.0
2012-05-23	ANGL	ETF	25.06	25.09	24.8	24.83	17000.0
2012-05-23	AOA	ETF	34.07	34.26	33.74	34.26	10000.0
2012-05-23	AOK	ETF	29.59	29.63	29.47	29.62	30384.0
2012-05-23	AOM	ETF	30.28	30.3682	30.16	30.3682	7762.0
2012-05-23	AOR	ETF	31.8	31.95	31.662	31.95	57858.0
2012-05-23	ARB	ETF	35.1	35.76	34.93	35.5	151005.0
2012-05-23	ARGT	ETF	16.02	16.1	15.86	16.1	650.0
2012-05-23	ASEA	ETF	15.02	15.02	14.78	15.0	48000.0
2012-05-23	AWAY	ETF	24.45	24.93	23.72	24.78	670700.0
2012-05-23	BAB	ETF	29.67	29.86	29.67	29.74	476906.0
2012-05-23	BAL	ETF	45.07	45.13	43.58	44.72	78066.0
2012-05-23	BALT	ETF	3.8	3.94	3.76	3.92	64108.0
2012-05-23	BBH	ETF	45.43	45.62	45.06	45.56	18000.0
2012-05-23	BCM	ETF	41.19	41.269	40.94	41.269	26304.0
2012-05-23	BIB	ETF	11.8663	11.919	11.53	11.919	104216.0
2012-05-23	BICK	ETF	21.67	21.67	21.39	21.6036	12584.0
2012-05-23	BIL	ETF	91.62	91.64	91.62	91.62	128000.0
2012-05-23	BIS	ETF	3601.6	3631.36	3580.8	3580.8	25.65
2012-05-23	BIV	ETF	88.17	88.28	88.12	88.12	255000.0
2012-05-23	BJK	ETF	31.38	31.77	31.14	31.77	14800.0
2012-05-23	BKF	ETF	34.49	34.66	33.8501	34.66	104495.0
2012-05-23	BKLN	ETF	24.3	24.35	24.19	24.25	238000.0
2012-05-23	BLV	ETF	93.87	94.23	93.6	93.6	58000.0
2012-05-23	BMVP	ETF	14.43	14.51	14.34	14.51	1883.0
2012-05-23	BND	ETF	84.06	84.12	84.02	84.02	1218300.0
2012-05-23	BNO	ETF	37.84	37.875	37.235	37.515	84000.0

> showing 50 of 945 rows — these rows as CSV

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