PREVIEW / etf_daily / 2011-12-16

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-16.parquet
  size:    37 KB
  rows:    889

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
2011-12-16	SPY	ETF	122.23	122.95	121.3	121.59	220481400.0
2011-12-16	QQQ	ETF	54.88	55.61	54.77	54.86	60978710.0
2011-12-16	IWM	ETF	72.28	73.28	71.73	72.26	66225600.0
2011-12-16	DIA	ETF	119.1	119.4	117.89	118.22	7758400.0
2011-12-16	GLD	ETF	154.31	155.37	153.9	155.23	18124300.0
2011-12-16	TLT	ETF	121.38	122.62	121.29	122.32	9321900.0
2011-12-16	AADR	ETF	27.28	27.28	27.04	27.22	15600.0
2011-12-16	AAXJ	ETF	49.76	50.08	49.53	49.79	2074000.0
2011-12-16	ACTV	ETF	12.87	13.1	12.87	12.99	733489.0
2011-12-16	ACWI	ETF	41.58	41.74	41.14	41.35	827700.0
2011-12-16	ACWX	ETF	36.29	36.32	35.84	36.1	715843.0
2011-12-16	ADRE	ETF	37.42	37.5648	37.14	37.32	53201.0
2011-12-16	AFK	ETF	26.23	26.514	26.1	26.1661	11647.0
2011-12-16	AGEM	ETF	20.64	20.7	20.54	20.57	2578.0
2011-12-16	AGG	ETF	109.88	110.12	109.84	110.05	1182000.0
2011-12-16	AGQ	ETF	192.68	197.16	190.4	194.64	582425.0
2011-12-16	AGZ	ETF	112.81	113.46	112.81	112.95	36729.0
2011-12-16	AIA	ETF	39.37	39.53	39.09	39.13	38803.0
2011-12-16	AIQ	ETF	5.1	5.15	4.8015	4.9005	26040.0
2011-12-16	AIS	ETF	1.7	1.81	1.67	1.81	3179564.0
2011-12-16	AIVI	ETF	38.8	38.86	38.29	38.49	145700.0
2011-12-16	AMJ	ETF	37.45	37.56	37.3184	37.43	942757.0
2011-12-16	AMLP	ETF	80.8	81.05	80.7	80.95	185840.0
2011-12-16	AOA	ETF	32.42	32.42	32.26	32.41	6300.0
2011-12-16	AOK	ETF	29.07	29.24	29.07	29.17	43378.0
2011-12-16	AOM	ETF	29.74	29.8	29.67	29.68	15001.0
2011-12-16	AOR	ETF	30.74	30.85	30.724	30.77	4635.0
2011-12-16	ARB	ETF	35.0	35.94	35.0	35.42	235297.0
2011-12-16	ASEA	ETF	14.67	14.69	14.46	14.58	43900.0
2011-12-16	AWAY	ETF	23.99	23.99	23.06	23.3	528428.0
2011-12-16	BAB	ETF	28.64	28.83	28.4912	28.76	434677.0
2011-12-16	BAL	ETF	53.75	53.92	52.94	53.46	31467.0
2011-12-16	BALT	ETF	5.14	5.2	5.03	5.07	84752.0
2011-12-16	BBH	ETF	34.5467	35.0867	34.5333	34.5333	155100.0
2011-12-16	BCM	ETF	41.93	41.93	41.92	41.92	700.0
2011-12-16	BIB	ETF	8.0463	8.0463	7.9463	7.9463	20080.0
2011-12-16	BICK	ETF	23.06	23.19	22.84	22.85	14599.0
2011-12-16	BIL	ETF	91.68	91.68	91.66	91.68	264200.0
2011-12-16	BIS	ETF	5748.8	5748.8	5748.8	5748.8	3.125
2011-12-16	BITS	ETF	22.64	23.0	22.64	22.76	2579.0
2011-12-16	BIV	ETF	87.94	88.07	87.79	88.05	122400.0
2011-12-16	BJK	ETF	29.66	29.73	29.34	29.45	40600.0
2011-12-16	BKF	ETF	36.27	36.42	36.0	36.14	205735.0
2011-12-16	BKLN	ETF	23.63	23.77	23.61	23.65	102600.0
2011-12-16	BLV	ETF	92.25	92.97	92.25	92.67	49900.0
2011-12-16	BMVP	ETF	13.28	13.31	13.15	13.21	14276.0
2011-12-16	BND	ETF	83.92	84.06	83.92	84.05	1355900.0
2011-12-16	BNO	ETF	36.05	36.185	35.615	36.025	69400.0
2011-12-16	BRF	ETF	42.13	42.39	41.6	42.09	101397.0
2011-12-16	BSCE	ETF	20.76	20.84	20.7572	20.82	19945.0

> showing 50 of 889 rows — these rows as CSV

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