PREVIEW / etf_daily / 2012-05-31

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-31.parquet
  size:    38 KB
  rows:    931

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-31	SPY	ETF	131.71	132.45	130.34	131.47	196186000.0
2012-05-31	QQQ	ETF	62.25	62.41	61.59	62.06	55260021.0
2012-05-31	IWM	ETF	76.27	76.59	75.07	76.11	59563900.0
2012-05-31	DIA	ETF	124.02	124.74	123.01	123.7	7793500.0
2012-05-31	GLD	ETF	152.03	152.71	150.62	151.62	10114300.0
2012-05-31	TLT	ETF	127.03	129.08	126.67	127.6	31174500.0
2012-05-31	AAXJ	ETF	50.67	51.06	50.37	50.71	408800.0
2012-05-31	ACTV	ETF	14.05	14.18	13.95	14.04	454631.0
2012-05-31	ACWI	ETF	42.41	42.54	41.88	42.33	787700.0
2012-05-31	ACWV	ETF	53.16	53.45	52.38	52.88	21100.0
2012-05-31	ACWX	ETF	35.61	35.83	35.2591	35.69	662545.0
2012-05-31	ADRE	ETF	36.2	36.47	35.818	36.4	27490.0
2012-05-31	AFK	ETF	27.4	27.68	27.2756	27.58	32636.0
2012-05-31	AGEM	ETF	19.93	20.03	19.93	20.03	306.0
2012-05-31	AGG	ETF	111.45	111.62	111.35	111.56	2984100.0
2012-05-31	AGQ	ETF	160.12	162.28	155.52	158.0	281850.0
2012-05-31	AGZ	ETF	113.45	113.6	113.39	113.43	40442.0
2012-05-31	AIA	ETF	40.4	40.46	40.1248	40.41	16840.0
2012-05-31	AIQ	ETF	5.2	5.5	4.8505	5.2	96798.0
2012-05-31	AIS	ETF	2.83	2.831	2.65	2.72	1354051.0
2012-05-31	AIVI	ETF	36.59	36.72	36.06	36.52	51700.0
2012-05-31	AMJ	ETF	36.81	36.9399	36.3155	36.54	928900.0
2012-05-31	AMLP	ETF	79.0	79.35	78.4	78.65	302320.0
2012-05-31	ANGL	ETF	25.03	25.14	25.03	25.14	800.0
2012-05-31	AOA	ETF	34.0	34.08	33.8	34.0	6300.0
2012-05-31	AOK	ETF	29.65	29.65	29.58	29.64	8405.0
2012-05-31	AOM	ETF	30.35	30.369	30.25	30.34	14335.0
2012-05-31	AOR	ETF	31.78	31.95	31.7	31.88	5592.0
2012-05-31	ARB	ETF	33.66	33.76	32.68	33.44	272030.0
2012-05-31	ARGT	ETF	15.42	15.6	15.42	15.5	700.0
2012-05-31	ASEA	ETF	14.75	14.89	14.65	14.89	4400.0
2012-05-31	AWAY	ETF	23.94	24.16	23.26	23.5	1415223.0
2012-05-31	BAB	ETF	30.0	30.12	29.932	30.04	162950.0
2012-05-31	BAL	ETF	43.994	44.26	43.84	44.03	15300.0
2012-05-31	BALT	ETF	3.71	3.76	3.59	3.7	150493.0
2012-05-31	BBH	ETF	45.74	45.74	45.08	45.36	11300.0
2012-05-31	BCM	ETF	40.85	40.85	40.41	40.46	19306.0
2012-05-31	BIB	ETF	11.915	11.9875	11.6837	11.9317	29640.0
2012-05-31	BICK	ETF	21.67	21.97	21.67	21.91	8844.0
2012-05-31	BIL	ETF	91.66	91.66	91.64	91.66	292550.0
2012-05-31	BIS	ETF	3580.8	3588.8	3544.0	3574.4	18.45
2012-05-31	BIV	ETF	88.84	89.12	88.82	88.98	230400.0
2012-05-31	BJK	ETF	31.94	31.94	31.44	31.89	5500.0
2012-05-31	BKF	ETF	34.83	35.09	34.4778	34.97	84794.0
2012-05-31	BKLN	ETF	24.23	24.26	24.07	24.14	128600.0
2012-05-31	BLV	ETF	95.29	96.19	95.16	95.67	75400.0
2012-05-31	BMVP	ETF	14.493	14.593	14.409	14.527	6161.0
2012-05-31	BND	ETF	84.49	84.64	84.42	84.51	1459100.0
2012-05-31	BNO	ETF	36.48	36.535	35.86	35.97	60600.0
2012-05-31	BOIL	ETF	737200.0	795400.0	731000.0	746200.0	8.6

> showing 50 of 931 rows — these rows as CSV

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