PREVIEW / etf_daily / 2012-08-24

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-24.parquet
  size:    38 KB
  rows:    929

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-24	SPY	ETF	140.31	141.83	140.22	141.51	99481200.0
2012-08-24	QQQ	ETF	67.72	68.45	67.6	68.29	38384751.0
2012-08-24	IWM	ETF	80.34	81.07	80.11	80.74	25676100.0
2012-08-24	DIA	ETF	130.21	131.56	130.06	131.38	4202400.0
2012-08-24	GLD	ETF	161.87	162.35	161.33	161.97	8497200.0
2012-08-24	TLT	ETF	125.47	125.56	124.67	124.81	5001400.0
2012-08-24	AAXJ	ETF	53.91	54.06	53.53	53.95	174100.0
2012-08-24	ACTV	ETF	10.93	11.06	10.9	10.99	324507.0
2012-08-24	ACWI	ETF	45.41	45.88	45.4	45.8	459500.0
2012-08-24	ACWV	ETF	55.76	56.14	55.76	56.01	5500.0
2012-08-24	ACWX	ETF	38.24	38.644	38.201	38.47	82972.0
2012-08-24	ADRE	ETF	38.17	38.45	37.98	38.29	45100.0
2012-08-24	AFK	ETF	29.36	29.36	29.16	29.35	51424.0
2012-08-24	AGEM	ETF	21.648	21.79	21.648	21.6944	1860.0
2012-08-24	AGG	ETF	111.98	111.98	111.79	111.82	649600.0
2012-08-24	AGQ	ETF	185.12	187.72	184.12	187.32	314525.0
2012-08-24	AGZ	ETF	113.58	113.72	113.52	113.52	13664.0
2012-08-24	AIA	ETF	42.43	42.7	42.2901	42.66	35769.0
2012-08-24	AIQ	ETF	6.8	7.3	6.8	6.8	19625.0
2012-08-24	AIVI	ETF	39.4	39.85	39.4	39.65	111800.0
2012-08-24	AMJ	ETF	39.15	39.1999	39.0	39.11	359718.0
2012-08-24	AMLP	ETF	81.1	81.2	80.95	81.0	361800.0
2012-08-24	ANGL	ETF	26.66	26.66	26.59	26.59	800.0
2012-08-24	AOA	ETF	35.88	36.17	35.88	36.17	6500.0
2012-08-24	AOK	ETF	30.21	30.248	30.2	30.23	6462.0
2012-08-24	AOM	ETF	31.176	31.2897	31.1703	31.26	44988.0
2012-08-24	AOR	ETF	33.1552	33.328	33.1552	33.3	16744.0
2012-08-24	ARB	ETF	36.0	36.16	35.65	36.0	63991.0
2012-08-24	ARGT	ETF	17.12	17.12	17.12	17.12	250.0
2012-08-24	ASEA	ETF	16.42	16.48	16.39	16.42	5000.0
2012-08-24	AWAY	ETF	24.02	24.19	23.76	24.0	151255.0
2012-08-24	BAB	ETF	30.19	30.2	30.06	30.11	307777.0
2012-08-24	BAL	ETF	50.01	52.52	49.496	49.74	5500.0
2012-08-24	BALT	ETF	3.06	3.14	3.03	3.03	28271.0
2012-08-24	BBH	ETF	50.28	50.92	50.28	50.81	153300.0
2012-08-24	BCM	ETF	45.84	45.84	45.8095	45.8095	452.0
2012-08-24	BIB	ETF	14.0538	14.3725	14.0538	14.2688	34608.0
2012-08-24	BICK	ETF	22.8	23.03	22.8	22.892	4719.0
2012-08-24	BIL	ETF	91.64	91.64	91.62	91.62	131200.0
2012-08-24	BIS	ETF	2883.2	2884.256	2827.2	2849.52	96.5
2012-08-24	BIV	ETF	89.55	89.57	89.35	89.39	182600.0
2012-08-24	BJK	ETF	32.04	32.27	32.03	32.16	7400.0
2012-08-24	BKF	ETF	36.41	36.74	36.24	36.62	195791.0
2012-08-24	BKLN	ETF	24.7	24.76	24.7	24.75	355500.0
2012-08-24	BLV	ETF	96.55	96.55	95.97	96.06	130500.0
2012-08-24	BMVP	ETF	15.8467	15.9347	15.8467	15.9317	3952.0
2012-08-24	BND	ETF	84.86	84.86	84.69	84.72	3865000.0
2012-08-24	BNO	ETF	41.23	41.475	40.705	40.775	74800.0
2012-08-24	BOIL	ETF	857400.0	866600.0	805600.0	808000.0	12.0
2012-08-24	BOND	ETF	107.47	107.53	107.35	107.36	300800.0

> showing 50 of 929 rows — these rows as CSV

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