PREVIEW / etf_daily / 2012-06-28

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-28.parquet
  size:    38 KB
  rows:    930

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-06-28	SPY	ETF	132.29	132.99	131.28	132.79	169242100.0
2012-06-28	QQQ	ETF	62.42	62.47	61.54	62.2	49793383.0
2012-06-28	IWM	ETF	76.78	77.37	76.12	77.31	58183700.0
2012-06-28	DIA	ETF	125.02	125.86	124.25	125.8	6460100.0
2012-06-28	GLD	ETF	151.9	152.16	150.15	151.05	8755600.0
2012-06-28	TLT	ETF	127.3	127.48	126.79	126.85	5257800.0
2012-06-28	AADR	ETF	27.66	27.72	27.66	27.72	200.0
2012-06-28	AAXJ	ETF	50.71	50.84	50.34	50.75	1205100.0
2012-06-28	ACTV	ETF	15.19	15.32	14.76	14.96	349785.0
2012-06-28	ACWI	ETF	42.33	42.62	42.12	42.59	1512900.0
2012-06-28	ACWV	ETF	54.46	54.46	53.4	53.83	14300.0
2012-06-28	ACWX	ETF	35.69	35.9355	35.48	35.91	276495.0
2012-06-28	ADRE	ETF	35.82	36.0	35.58	36.0	41334.0
2012-06-28	AFK	ETF	26.98	28.54	26.9	27.19	21536.0
2012-06-28	AGEM	ETF	20.07	20.18	20.03	20.09	10746.0
2012-06-28	AGG	ETF	111.53	111.56	111.42	111.45	1180400.0
2012-06-28	AGQ	ETF	145.12	145.36	137.8	141.04	571350.0
2012-06-28	AGZ	ETF	113.63	113.66	113.44	113.52	23533.0
2012-06-28	AIA	ETF	39.86	39.9791	39.58	39.9791	8630.0
2012-06-28	AIQ	ETF	4.7	5.0	4.4	4.5	2680.0
2012-06-28	AIVI	ETF	36.25	36.7	36.21	36.7	65400.0
2012-06-28	AMJ	ETF	36.77	37.99	36.77	37.86	2527904.0
2012-06-28	AMLP	ETF	78.6	79.0	78.25	78.9	460300.0
2012-06-28	ANGL	ETF	25.3	25.4	25.28	25.4	10500.0
2012-06-28	AOA	ETF	34.01	34.08	33.86	34.06	15300.0
2012-06-28	AOK	ETF	29.73	29.77	29.67	29.77	6430.0
2012-06-28	AOM	ETF	30.2899	30.32	30.1818	30.32	17196.0
2012-06-28	AOR	ETF	31.87	31.87	31.7118	31.85	14959.0
2012-06-28	ARB	ETF	34.48	34.95	34.17	34.86	70254.0
2012-06-28	ARGT	ETF	15.54	15.54	15.48	15.48	300.0
2012-06-28	ASEA	ETF	15.17	15.21	15.08	15.18	45500.0
2012-06-28	AWAY	ETF	21.14	21.719	21.01	21.38	444546.0
2012-06-28	BAB	ETF	29.96	29.96	29.82	29.83	244771.0
2012-06-28	BAL	ETF	44.27	46.2	44.27	46.19	14912.0
2012-06-28	BALT	ETF	3.22	3.31	3.2	3.26	86841.0
2012-06-28	BBH	ETF	47.52	47.52	45.4	45.86	24400.0
2012-06-28	BCM	ETF	40.0	40.1328	40.0	40.1328	1805.0
2012-06-28	BIB	ETF	12.9012	12.9238	12.145	12.2837	52040.0
2012-06-28	BICK	ETF	21.41	21.54	21.37	21.4564	2511.0
2012-06-28	BIL	ETF	91.66	91.66	91.64	91.66	348850.0
2012-06-28	BIS	ETF	3288.0	3420.672	3270.944	3377.6	26.7
2012-06-28	BIV	ETF	88.87	89.05	88.84	88.97	180900.0
2012-06-28	BJK	ETF	30.95	31.09	30.83	30.96	6300.0
2012-06-28	BKF	ETF	34.09	34.27	33.84	34.24	136655.0
2012-06-28	BKLN	ETF	24.28	24.32	24.23	24.31	234800.0
2012-06-28	BLV	ETF	95.84	96.05	95.66	95.74	27500.0
2012-06-28	BMVP	ETF	14.8	14.83	14.77	14.83	2163.0
2012-06-28	BND	ETF	84.45	84.5	84.41	84.44	916300.0
2012-06-28	BNO	ETF	32.885	32.95	32.26	32.585	121400.0
2012-06-28	BOIL	ETF	904000.0	916800.0	811800.0	880200.0	18.8

> showing 50 of 930 rows — these rows as CSV

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