PREVIEW / etf_daily / 2012-06-20

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-20.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-06-20	SPY	ETF	135.71	136.1	134.27	135.48	206451800.0
2012-06-20	QQQ	ETF	64.36	64.57	63.81	64.29	51389682.0
2012-06-20	IWM	ETF	78.67	79.08	77.98	78.53	54642300.0
2012-06-20	DIA	ETF	128.12	128.49	127.11	127.96	9212800.0
2012-06-20	GLD	ETF	156.0	157.37	154.26	155.97	16970200.0
2012-06-20	TLT	ETF	124.57	126.51	124.09	126.04	13720300.0
2012-06-20	AADR	ETF	28.75	28.75	28.75	28.75	100.0
2012-06-20	AAXJ	ETF	53.23	53.35	52.75	53.23	1326700.0
2012-06-20	ACTV	ETF	15.93	16.32	15.81	16.24	533582.0
2012-06-20	ACWI	ETF	44.22	44.54	43.96	44.25	1376600.0
2012-06-20	ACWV	ETF	54.99	54.99	54.81	54.81	1100.0
2012-06-20	ACWX	ETF	37.47	37.77	37.17	37.46	226483.0
2012-06-20	ADRE	ETF	37.94	38.0601	37.62	37.93	56344.0
2012-06-20	AFK	ETF	27.71	27.88	27.6	27.7299	17677.0
2012-06-20	AGEM	ETF	20.99	20.99	20.89	20.98	2125.0
2012-06-20	AGG	ETF	111.07	111.21	110.88	111.05	1256100.0
2012-06-20	AGQ	ETF	161.64	167.2	156.0	159.92	705175.0
2012-06-20	AGZ	ETF	113.47	113.59	113.36	113.501	11821.0
2012-06-20	AIA	ETF	41.8	41.8	41.4799	41.6	17598.0
2012-06-20	AIQ	ETF	4.4305	4.7	4.35	4.426	11121.0
2012-06-20	AIVI	ETF	38.41	38.74	38.15	38.47	46200.0
2012-06-20	AMJ	ETF	36.88	37.05	36.75	36.91	1625626.0
2012-06-20	AMLP	ETF	79.05	79.2	78.8	78.95	439360.0
2012-06-20	ANGL	ETF	25.35	25.35	25.33	25.33	4400.0
2012-06-20	AOA	ETF	35.07	35.11	34.9	35.01	4600.0
2012-06-20	AOK	ETF	29.9	29.92	29.8545	29.9	13225.0
2012-06-20	AOM	ETF	30.84	30.84	30.7518	30.81	17958.0
2012-06-20	AOR	ETF	32.5782	32.64	32.48	32.48	22366.0
2012-06-20	ARB	ETF	35.54	35.62	34.66	35.2	74928.0
2012-06-20	ARGT	ETF	15.96	15.96	15.96	15.96	150.0
2012-06-20	ASEA	ETF	15.4	15.44	15.28	15.39	22300.0
2012-06-20	AWAY	ETF	21.15	22.38	21.13	21.98	444855.0
2012-06-20	BAB	ETF	29.64	29.78	29.53	29.73	137322.0
2012-06-20	BAL	ETF	47.6	47.7639	46.969	47.75	17787.0
2012-06-20	BALT	ETF	3.36	3.53	3.36	3.51	100750.0
2012-06-20	BBH	ETF	46.6	46.86	46.4	46.47	5600.0
2012-06-20	BCM	ETF	40.72	40.72	40.623	40.623	1954.0
2012-06-20	BIB	ETF	12.9675	12.9698	12.7127	12.8749	123144.0
2012-06-20	BICK	ETF	22.9	22.9	22.731	22.731	5205.0
2012-06-20	BIL	ETF	91.62	91.64	91.62	91.62	124100.0
2012-06-20	BIS	ETF	3272.0	3292.8	3264.0	3289.6	221.5
2012-06-20	BIV	ETF	88.56	88.8	88.41	88.63	324800.0
2012-06-20	BJK	ETF	32.62	32.88	32.6	32.7	4700.0
2012-06-20	BKF	ETF	36.55	36.72	36.19	36.51	130920.0
2012-06-20	BKLN	ETF	24.23	24.24	24.17	24.23	281000.0
2012-06-20	BLNG	ETF	47.69	47.69	47.69	47.69	400.0
2012-06-20	BLV	ETF	94.3	95.52	94.03	95.02	43800.0
2012-06-20	BMVP	ETF	15.09	15.11	15.05	15.11	5602.0
2012-06-20	BND	ETF	84.19	84.3	84.06	84.16	1274100.0
2012-06-20	BNO	ETF	33.755	33.815	32.775	32.83	170600.0

> showing 50 of 936 rows — these rows as CSV

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