PREVIEW / etf_daily / 2012-03-16

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-16.parquet
  size:    38 KB
  rows:    923

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-03-16	SPY	ETF	140.36	140.48	140.0	140.3	152893500.0
2012-03-16	QQQ	ETF	66.65	66.67	66.36	66.52	53023027.0
2012-03-16	IWM	ETF	83.22	83.27	82.65	83.0	42045800.0
2012-03-16	DIA	ETF	132.53	132.61	132.02	132.05	5047200.0
2012-03-16	GLD	ETF	160.08	161.54	159.92	161.3	12549200.0
2012-03-16	TLT	ETF	110.5	111.44	110.2	111.43	13427200.0
2012-03-16	AADR	ETF	30.94	30.94	30.84	30.84	1000.0
2012-03-16	AAXJ	ETF	57.76	57.99	57.55	57.88	2541400.0
2012-03-16	ACTV	ETF	16.89	17.01	16.66	16.83	1014336.0
2012-03-16	ACWI	ETF	47.48	47.64	47.46	47.48	497700.0
2012-03-16	ACWV	ETF	54.0	54.0	53.85	53.86	500.0
2012-03-16	ACWX	ETF	41.46	41.64	41.451	41.49	127486.0
2012-03-16	ADRE	ETF	43.05	43.31	43.05	43.17	23214.0
2012-03-16	AFK	ETF	29.67	30.01	29.67	29.8783	125598.0
2012-03-16	AGEM	ETF	23.92	24.04	23.92	24.0301	1200.0
2012-03-16	AGG	ETF	109.15	109.32	109.06	109.28	933900.0
2012-03-16	AGQ	ETF	222.48	224.44	219.8	221.44	423575.0
2012-03-16	AGZ	ETF	112.19	112.319	112.18	112.24	38324.0
2012-03-16	AIA	ETF	45.39	45.39	45.2699	45.39	3357.0
2012-03-16	AIQ	ETF	8.2	8.7	7.6	7.75	82463.0
2012-03-16	AIS	ETF	2.77	2.86	2.76	2.82	1344068.0
2012-03-16	AIVI	ETF	42.28	42.41	42.25	42.34	34000.0
2012-03-16	AMJ	ETF	39.56	40.04	39.39	39.71	2693965.0
2012-03-16	AMLP	ETF	83.6	83.95	83.25	83.85	275420.0
2012-03-16	AOA	ETF	36.61	36.63	36.53	36.58	10400.0
2012-03-16	AOK	ETF	30.14	30.15	30.1	30.1	19397.0
2012-03-16	AOM	ETF	31.2501	31.31	31.25	31.3	26347.0
2012-03-16	AOR	ETF	33.42	33.44	33.368	33.4	41215.0
2012-03-16	ARB	ETF	35.92	35.97	35.33	35.96	248336.0
2012-03-16	ASEA	ETF	16.17	16.17	16.07	16.12	14000.0
2012-03-16	AWAY	ETF	26.35	26.38	25.61	26.22	520037.0
2012-03-16	BAB	ETF	28.64	28.7	28.51	28.7	510035.0
2012-03-16	BAL	ETF	53.17	53.35	52.82	53.27	12471.0
2012-03-16	BALT	ETF	3.93	4.25	3.92	4.1	437696.0
2012-03-16	BBH	ETF	43.23	43.23	42.97	43.04	5000.0
2012-03-16	BCM	ETF	46.13	46.32	46.1299	46.32	2300.0
2012-03-16	BIB	ETF	11.5712	11.7613	11.4775	11.5013	21600.0
2012-03-16	BICK	ETF	27.33	27.53	27.33	27.509	8058.0
2012-03-16	BIL	ETF	91.64	91.66	91.64	91.64	501150.0
2012-03-16	BIS	ETF	3827.2	3827.2	3792.0	3792.0	20.6
2012-03-16	BITS	ETF	17.96	17.96	17.32	17.96	6195.0
2012-03-16	BIV	ETF	86.37	86.6	86.26	86.56	263100.0
2012-03-16	BJK	ETF	35.9	35.9	35.75	35.82	20300.0
2012-03-16	BKF	ETF	42.9	43.1	42.752	43.06	488235.0
2012-03-16	BKLN	ETF	24.48	24.51	24.48	24.48	192600.0
2012-03-16	BLNG	ETF	51.01	51.01	51.01	51.01	875.0
2012-03-16	BLV	ETF	87.92	88.32	87.62	88.23	97200.0
2012-03-16	BMVP	ETF	15.46	15.46	15.42	15.42	10240.0
2012-03-16	BND	ETF	82.7	82.91	82.65	82.85	1452700.0
2012-03-16	BNO	ETF	43.49	44.3	43.49	44.28	171200.0

> showing 50 of 923 rows — these rows as CSV

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