PREVIEW / etf_daily / 2012-08-07

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-07.parquet
  size:    38 KB
  rows:    938

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-07	SPY	ETF	140.18	140.92	140.03	140.32	109545100.0
2012-08-07	QQQ	ETF	66.38	66.92	66.28	66.65	28222362.0
2012-08-07	IWM	ETF	79.85	80.57	79.64	79.94	50064000.0
2012-08-07	DIA	ETF	131.32	131.89	131.29	131.38	3584500.0
2012-08-07	GLD	ETF	156.37	156.63	156.01	156.28	5923300.0
2012-08-07	TLT	ETF	125.96	126.13	125.43	125.83	6613600.0
2012-08-07	AADR	ETF	29.31	29.31	29.31	29.31	400.0
2012-08-07	AAXJ	ETF	54.04	54.38	53.99	54.12	197200.0
2012-08-07	ACTV	ETF	11.32	11.48	11.03	11.3	417925.0
2012-08-07	ACWI	ETF	45.31	45.64	45.31	45.43	719400.0
2012-08-07	ACWV	ETF	55.9	56.67	55.71	55.71	54700.0
2012-08-07	ACWX	ETF	38.36	38.61	38.36	38.44	82391.0
2012-08-07	ADRE	ETF	38.71	38.99	38.71	38.72	44235.0
2012-08-07	AFK	ETF	29.07	29.0799	28.97	29.008	14662.0
2012-08-07	AGEM	ETF	22.05	22.185	22.05	22.185	765.0
2012-08-07	AGG	ETF	111.84	111.91	111.81	111.86	1733100.0
2012-08-07	AGQ	ETF	157.68	158.72	156.52	157.8	199500.0
2012-08-07	AGZ	ETF	113.49	113.66	113.46	113.52	8935.0
2012-08-07	AIA	ETF	42.98	43.3701	42.98	43.11	21450.0
2012-08-07	AIQ	ETF	5.0	7.5	5.0	5.95	109244.0
2012-08-07	AIVI	ETF	39.49	39.67	39.43	39.5	32900.0
2012-08-07	AMJ	ETF	39.73	39.84	39.54	39.6	1148657.0
2012-08-07	AMLP	ETF	81.6	81.95	81.25	81.3	452040.0
2012-08-07	ANGL	ETF	26.05	26.1	26.05	26.1	1400.0
2012-08-07	AOA	ETF	35.83	35.97	35.83	35.87	13400.0
2012-08-07	AOK	ETF	30.21	30.222	30.1938	30.2	5687.0
2012-08-07	AOM	ETF	31.2	31.26	31.17	31.17	34710.0
2012-08-07	AOR	ETF	33.13	33.22	33.13	33.17	4826.0
2012-08-07	ARB	ETF	35.96	36.62	35.77	36.01	167064.0
2012-08-07	ARGT	ETF	17.3	17.52	17.1	17.5	1500.0
2012-08-07	ASEA	ETF	16.35	16.48	16.34	16.42	8700.0
2012-08-07	AWAY	ETF	24.41	24.8	24.14	24.25	322166.0
2012-08-07	BAB	ETF	30.25	30.25	30.1	30.16	188343.0
2012-08-07	BAL	ETF	49.7	50.26	49.61	49.65	16377.0
2012-08-07	BALT	ETF	3.4	3.45	3.34	3.38	36286.0
2012-08-07	BBH	ETF	49.87	50.16	49.77	49.91	36500.0
2012-08-07	BCM	ETF	44.2984	44.2984	44.1901	44.1901	362.0
2012-08-07	BIB	ETF	13.99	14.005	13.7426	13.92	24120.0
2012-08-07	BICK	ETF	23.29	23.38	23.2401	23.25	7549.0
2012-08-07	BIL	ETF	91.64	91.66	91.62	91.64	545300.0
2012-08-07	BIS	ETF	2958.4	2958.4	2912.0	2928.0	8.0
2012-08-07	BIV	ETF	89.47	89.5	89.26	89.4	303100.0
2012-08-07	BJK	ETF	30.92	31.42	30.92	31.31	2600.0
2012-08-07	BKF	ETF	36.93	37.26	36.93	36.98	42360.0
2012-08-07	BKLN	ETF	24.7	24.74	24.66	24.73	476400.0
2012-08-07	BLV	ETF	96.8	96.8	96.37	96.59	93600.0
2012-08-07	BMVP	ETF	15.78	15.85	15.78	15.82	29772.0
2012-08-07	BND	ETF	84.69	84.69	84.56	84.65	1753600.0
2012-08-07	BNO	ETF	39.28	39.935	39.26	39.695	72200.0
2012-08-07	BOIL	ETF	941200.0	988800.0	941200.0	969200.0	11.0

> showing 50 of 938 rows — these rows as CSV

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