PREVIEW / etf_daily / 2012-05-30

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-30.parquet
  size:    38 KB
  rows:    935

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-30	SPY	ETF	132.56	133.69	131.49	131.76	162370400.0
2012-05-30	QQQ	ETF	62.29	62.55	61.6773	62.33	56431798.0
2012-05-30	IWM	ETF	76.9	77.04	76.11	76.21	47891500.0
2012-05-30	DIA	ETF	124.53	124.61	123.74	123.99	6874300.0
2012-05-30	GLD	ETF	149.74	152.38	148.53	151.91	16764800.0
2012-05-30	TLT	ETF	125.32	126.32	125.3	126.14	17170800.0
2012-05-30	AADR	ETF	28.06	28.06	28.06	28.06	100.0
2012-05-30	AAXJ	ETF	50.91	50.91	50.41	50.58	952400.0
2012-05-30	ACTV	ETF	14.13	14.14	13.97	14.05	464269.0
2012-05-30	ACWI	ETF	42.58	42.6	42.22	42.28	1037000.0
2012-05-30	ACWV	ETF	52.85	52.85	52.49	52.76	69800.0
2012-05-30	ACWX	ETF	35.79	35.79	35.47	35.52	106562.0
2012-05-30	ADRE	ETF	36.36	36.3814	36.2	36.27	45854.0
2012-05-30	AFK	ETF	27.43	27.43	27.1	27.2501	41388.0
2012-05-30	AGEM	ETF	19.84	19.84	19.83	19.83	1860.0
2012-05-30	AGG	ETF	111.2	111.3	111.11	111.23	547100.0
2012-05-30	AGQ	ETF	156.2	162.8	153.88	160.08	371525.0
2012-05-30	AGZ	ETF	113.35	113.44	113.2001	113.43	5740.0
2012-05-30	AIA	ETF	40.28	40.28	39.98	40.16	8779.0
2012-05-30	AIQ	ETF	5.175	5.25	5.1	5.15	6789.0
2012-05-30	AIS	ETF	2.84	2.88	2.82	2.82	852259.0
2012-05-30	AIVI	ETF	36.63	36.63	36.25	36.34	26500.0
2012-05-30	AMJ	ETF	37.26	37.53	36.7709	36.89	1363997.0
2012-05-30	AMLP	ETF	80.0	80.0	79.1	79.25	285240.0
2012-05-30	ANGL	ETF	25.08	25.09	24.89	24.89	31000.0
2012-05-30	AOA	ETF	34.26	34.26	34.07	34.1	6900.0
2012-05-30	AOK	ETF	29.6	29.62	29.56	29.62	12334.0
2012-05-30	AOM	ETF	30.38	30.38	30.291	30.32	16877.0
2012-05-30	AOR	ETF	31.95	31.97	31.845	31.86	8170.0
2012-05-30	ARB	ETF	33.86	33.95	33.15	33.5	123791.0
2012-05-30	ARGT	ETF	15.76	15.76	15.66	15.66	1600.0
2012-05-30	ASEA	ETF	14.85	14.89	14.72	14.72	37900.0
2012-05-30	AWAY	ETF	24.6	24.818	23.57	23.96	262757.0
2012-05-30	BAB	ETF	29.89	29.979	29.78	29.96	201063.0
2012-05-30	BAL	ETF	44.78	44.792	43.56	44.04	17847.0
2012-05-30	BALT	ETF	3.73	3.79	3.68	3.71	61261.0
2012-05-30	BBH	ETF	45.67	45.92	45.55	45.86	7700.0
2012-05-30	BCM	ETF	40.87	40.87	40.87	40.87	193.0
2012-05-30	BIB	ETF	12.145	12.145	11.9437	12.1391	34976.0
2012-05-30	BICK	ETF	21.99	21.99	21.864	21.904	5259.0
2012-05-30	BIL	ETF	91.66	91.66	91.64	91.66	433500.0
2012-05-30	BIS	ETF	3517.344	3553.6	3505.6	3505.6	21.45
2012-05-30	BIV	ETF	88.51	88.77	88.51	88.75	291500.0
2012-05-30	BJK	ETF	32.26	32.26	31.83	31.94	5800.0
2012-05-30	BKF	ETF	34.81	34.9	34.69	34.88	60701.0
2012-05-30	BKLN	ETF	24.24	24.27	24.14	24.14	213400.0
2012-05-30	BLV	ETF	94.63	95.0	94.6	94.85	46800.0
2012-05-30	BMVP	ETF	14.67	14.67	14.6	14.61	2975.0
2012-05-30	BND	ETF	84.23	84.37	84.21	84.35	693800.0
2012-05-30	BNO	ETF	36.885	36.885	36.41	36.43	64000.0

> showing 50 of 935 rows — these rows as CSV

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