PREVIEW / etf_daily / 2012-08-21

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-21.parquet
  size:    38 KB
  rows:    936

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-08-21	SPY	ETF	142.54	143.09	141.45	141.76	105581100.0
2012-08-21	QQQ	ETF	68.63	68.88	67.88	68.15	41390936.0
2012-08-21	IWM	ETF	81.93	82.71	81.19	81.48	43743800.0
2012-08-21	DIA	ETF	132.57	133.02	131.57	131.77	4094500.0
2012-08-21	GLD	ETF	158.81	159.2	158.69	158.83	11833100.0
2012-08-21	TLT	ETF	121.47	122.45	120.66	122.39	9532700.0
2012-08-21	AAXJ	ETF	54.59	54.72	54.17	54.29	503900.0
2012-08-21	ACTV	ETF	11.28	11.63	11.27	11.41	291888.0
2012-08-21	ACWI	ETF	46.26	46.39	45.9	46.0	279700.0
2012-08-21	ACWV	ETF	56.18	56.26	55.81	56.02	150700.0
2012-08-21	ACWX	ETF	39.01	39.23	38.82	38.9	114238.0
2012-08-21	ADRE	ETF	39.06	39.33	38.651	38.71	56159.0
2012-08-21	AFK	ETF	29.432	29.6	29.33	29.37	28085.0
2012-08-21	AGEM	ETF	22.02	22.03	21.95	21.95	2146.0
2012-08-21	AGG	ETF	111.18	111.35	111.04	111.34	738600.0
2012-08-21	AGQ	ETF	170.12	173.64	170.0	170.96	518800.0
2012-08-21	AGZ	ETF	113.26	113.35	113.131	113.25	18702.0
2012-08-21	AIA	ETF	43.245	43.3	42.9	42.9	12253.0
2012-08-21	AIQ	ETF	6.9	7.3	6.45	6.45	19824.0
2012-08-21	AIVI	ETF	40.07	40.3	39.93	39.99	82700.0
2012-08-21	AMJ	ETF	40.29	40.29	39.92	40.02	998881.0
2012-08-21	AMLP	ETF	81.95	82.25	81.5	81.6	383200.0
2012-08-21	ANGL	ETF	26.35	26.35	26.22	26.22	900.0
2012-08-21	AOA	ETF	36.32	36.46	36.14	36.14	9700.0
2012-08-21	AOK	ETF	30.2228	30.23	30.15	30.16	11667.0
2012-08-21	AOM	ETF	31.26	31.35	31.2124	31.26	37157.0
2012-08-21	AOR	ETF	33.33	33.439	33.2679	33.2748	8652.0
2012-08-21	ARB	ETF	36.66	37.35	36.2611	36.58	105400.0
2012-08-21	ARGT	ETF	17.28	17.44	17.28	17.44	300.0
2012-08-21	ASEA	ETF	16.59	16.59	16.4	16.4	4100.0
2012-08-21	AWAY	ETF	24.78	25.04	24.7	25.02	615338.0
2012-08-21	BAB	ETF	29.72	29.79	29.55	29.76	638345.0
2012-08-21	BAL	ETF	49.92	51.11	49.92	51.05	66072.0
2012-08-21	BALT	ETF	3.05	3.17	3.01	3.07	61564.0
2012-08-21	BBH	ETF	49.86	50.1	49.59	49.76	25600.0
2012-08-21	BIB	ETF	13.8413	13.8413	13.6039	13.6538	17560.0
2012-08-21	BICK	ETF	23.37	23.49	23.2201	23.25	14377.0
2012-08-21	BIL	ETF	91.62	91.64	91.62	91.62	152550.0
2012-08-21	BIS	ETF	2968.0	2968.0	2934.72	2934.72	9.4
2012-08-21	BIV	ETF	88.7	88.83	88.54	88.82	209100.0
2012-08-21	BJK	ETF	32.5	32.7	32.26	32.34	6100.0
2012-08-21	BKF	ETF	37.2	37.5	36.756	36.86	48816.0
2012-08-21	BKLN	ETF	24.68	24.7	24.66	24.7	161800.0
2012-08-21	BLV	ETF	94.21	94.6	93.68	94.53	48600.0
2012-08-21	BMVP	ETF	16.2008	16.2008	16.04	16.04	2425.0
2012-08-21	BND	ETF	84.24	84.34	84.12	84.34	661500.0
2012-08-21	BNO	ETF	41.46	41.575	41.205	41.215	73000.0
2012-08-21	BOIL	ETF	857200.0	870800.0	800000.0	857600.0	15.6
2012-08-21	BOND	ETF	106.69	106.74	106.6	106.74	460887.0
2012-08-21	BRF	ETF	38.77	39.26	38.63	38.66	176100.0

> showing 50 of 936 rows — these rows as CSV

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