PREVIEW / etf_daily / 2012-09-12

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-12.parquet
  size:    39 KB
  rows:    949

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-09-12	SPY	ETF	144.39	144.55	143.9	144.39	87640900.0
2012-09-12	QQQ	ETF	68.68	68.81	68.21	68.632	42212157.0
2012-09-12	IWM	ETF	84.49	84.65	83.9	84.49	29751700.0
2012-09-12	DIA	ETF	133.46	133.65	133.08	133.37	1953900.0
2012-09-12	GLD	ETF	168.84	168.87	167.25	167.92	9945400.0
2012-09-12	TLT	ETF	122.22	122.41	121.68	122.01	7040900.0
2012-09-12	AADR	ETF	29.74	29.74	29.69	29.72	3200.0
2012-09-12	AAXJ	ETF	54.68	54.92	54.63	54.87	171700.0
2012-09-12	ACTV	ETF	12.4	12.4	12.26	12.36	284372.0
2012-09-12	ACWI	ETF	46.98	47.02	46.8	46.93	708900.0
2012-09-12	ACWV	ETF	56.15	56.29	56.12	56.16	18300.0
2012-09-12	ACWX	ETF	39.55	39.73	39.49	39.62	176532.0
2012-09-12	ADRE	ETF	38.97	39.1	38.81	39.05	44293.0
2012-09-12	AFK	ETF	31.0	31.08	30.8956	31.0	22369.0
2012-09-12	AGEM	ETF	22.02	22.0965	22.02	22.0965	402.0
2012-09-12	AGG	ETF	111.66	111.69	111.52	111.57	1679500.0
2012-09-12	AGQ	ETF	225.04	225.2	207.44	217.96	749025.0
2012-09-12	AGZ	ETF	113.65	113.85	113.457	113.71	16550.0
2012-09-12	AIA	ETF	43.35	43.54	43.3	43.47	177521.0
2012-09-12	AIQ	ETF	7.2	7.2	6.9	6.95	5367.0
2012-09-12	AIVI	ETF	41.28	41.43	41.24	41.37	32200.0
2012-09-12	AMJ	ETF	39.45	39.79	39.45	39.71	352770.0
2012-09-12	AMLP	ETF	81.7	82.05	81.5	81.85	281740.0
2012-09-12	ANGL	ETF	26.35	26.38	26.2	26.33	113300.0
2012-09-12	AOA	ETF	36.94	36.94	36.81	36.86	11300.0
2012-09-12	AOK	ETF	30.45	30.47	30.4101	30.4101	5332.0
2012-09-12	AOM	ETF	31.656	31.656	31.6	31.61	15910.0
2012-09-12	AOR	ETF	33.84	33.845	33.75	33.8	16595.0
2012-09-12	ARB	ETF	38.15	38.43	37.93	38.1	72848.0
2012-09-12	ARGT	ETF	17.5	17.5	17.18	17.24	1250.0
2012-09-12	ASEA	ETF	16.51	16.55	16.47	16.53	6800.0
2012-09-12	AWAY	ETF	22.96	24.18	22.855	23.99	586979.0
2012-09-12	BAB	ETF	29.91	29.97	29.878	29.893	177279.0
2012-09-12	BAL	ETF	49.45	49.45	47.994	48.43	28613.0
2012-09-12	BALT	ETF	3.34	3.3509	3.286	3.32	5844.0
2012-09-12	BBH	ETF	52.49	52.65	52.13	52.29	13600.0
2012-09-12	BCM	ETF	46.81	46.93	46.81	46.93	400.0
2012-09-12	BIB	ETF	15.1375	15.2263	14.9062	15.0	27184.0
2012-09-12	BICK	ETF	23.08	23.2	23.01	23.04	55954.0
2012-09-12	BIL	ETF	91.62	91.64	91.62	91.62	192750.0
2012-09-12	BIS	ETF	2701.696	2701.696	2701.696	2701.696	0.625
2012-09-12	BIV	ETF	89.39	89.43	89.3	89.36	308200.0
2012-09-12	BJK	ETF	33.4	33.68	33.4	33.48	3200.0
2012-09-12	BKF	ETF	37.26	37.28	36.99	37.16	74172.0
2012-09-12	BKLN	ETF	24.99	25.0	24.94	24.99	3196700.0
2012-09-12	BLNG	ETF	52.13	52.13	52.13	52.13	2185.0
2012-09-12	BLV	ETF	95.01	95.1	94.69	94.96	99300.0
2012-09-12	BMVP	ETF	16.16	16.22	16.16	16.17	29083.0
2012-09-12	BND	ETF	84.55	84.57	84.48	84.53	808600.0
2012-09-12	BNO	ETF	41.605	41.75	41.475	41.585	67600.0

> showing 50 of 949 rows — these rows as CSV

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