PREVIEW / etf_daily / 2012-03-07

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-07.parquet
  size:    38 KB
  rows:    930

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-07	SPY	ETF	135.06	135.91	134.93	135.69	143692200.0
2012-03-07	QQQ	ETF	63.86	64.21	63.77	64.06	42741792.0
2012-03-07	IWM	ETF	78.91	79.56	78.78	79.48	57456300.0
2012-03-07	DIA	ETF	127.64	128.45	127.46	128.23	5736200.0
2012-03-07	GLD	ETF	162.76	164.02	162.51	163.63	9553300.0
2012-03-07	TLT	ETF	117.46	117.61	116.81	116.91	5567500.0
2012-03-07	AADR	ETF	29.49	29.89	29.49	29.89	600.0
2012-03-07	AAXJ	ETF	56.0	56.26	55.8	56.17	235100.0
2012-03-07	ACTV	ETF	15.67	15.91	15.51	15.87	329202.0
2012-03-07	ACWI	ETF	45.6	45.88	45.5	45.78	556300.0
2012-03-07	ACWV	ETF	53.21	53.22	53.11	53.21	1800.0
2012-03-07	ACWX	ETF	39.87	40.06	39.73	40.01	116146.0
2012-03-07	ADRE	ETF	42.17	42.4062	41.956	42.38	46551.0
2012-03-07	AFK	ETF	29.858	29.94	29.59	29.94	6375.0
2012-03-07	AGEM	ETF	23.23	23.3141	23.23	23.2968	1723.0
2012-03-07	AGG	ETF	110.55	110.56	110.42	110.46	836100.0
2012-03-07	AGQ	ETF	228.28	237.0	226.12	234.0	551225.0
2012-03-07	AGZ	ETF	112.91	113.02	112.79	112.879	23462.0
2012-03-07	AIA	ETF	43.82	44.01	43.66	44.01	13959.0
2012-03-07	AIQ	ETF	6.55	6.65	6.45	6.6	7377.0
2012-03-07	AIS	ETF	2.69	2.76	2.68	2.75	1526255.0
2012-03-07	AIVI	ETF	40.86	41.07	40.69	41.04	44600.0
2012-03-07	AMJ	ETF	40.03	40.45	40.03	40.42	535232.0
2012-03-07	AMLP	ETF	84.35	84.85	84.25	84.7	286480.0
2012-03-07	AOA	ETF	35.4	35.54	35.33	35.54	15200.0
2012-03-07	AOK	ETF	29.89	29.965	29.87	29.93	16667.0
2012-03-07	AOM	ETF	30.88	30.919	30.791	30.91	20294.0
2012-03-07	AOR	ETF	32.62	32.73	32.62	32.73	10376.0
2012-03-07	ARB	ETF	33.17	33.29	33.01	33.2	90442.0
2012-03-07	ARGT	ETF	21.98	22.04	21.8	22.02	2450.0
2012-03-07	ASEA	ETF	15.63	15.68	15.55	15.64	8700.0
2012-03-07	AWAY	ETF	26.03	26.18	25.7	25.86	122146.0
2012-03-07	BAB	ETF	29.56	29.57	29.46	29.54	145916.0
2012-03-07	BAL	ETF	55.14	55.51	54.66	54.7	22724.0
2012-03-07	BALT	ETF	3.98	3.99	3.83	3.88	186340.0
2012-03-07	BBH	ETF	41.54	41.7	41.37	41.55	57500.0
2012-03-07	BCM	ETF	45.5	45.8588	45.5	45.796	40746.0
2012-03-07	BIB	ETF	10.75	10.855	10.75	10.8492	16880.0
2012-03-07	BICK	ETF	26.46	26.71	26.46	26.6425	9510.0
2012-03-07	BIL	ETF	91.64	91.66	91.64	91.64	125400.0
2012-03-07	BIS	ETF	4115.2	4115.2	4064.64	4067.2	38.1
2012-03-07	BITS	ETF	20.96	20.96	18.84	19.6	8388.0
2012-03-07	BIV	ETF	87.91	87.92	87.75	87.85	242900.0
2012-03-07	BJK	ETF	33.87	34.28	33.87	34.26	10100.0
2012-03-07	BKF	ETF	41.9	42.04	41.73	41.97	337877.0
2012-03-07	BKLN	ETF	24.49	24.51	24.44	24.48	128100.0
2012-03-07	BLNG	ETF	51.88	51.88	51.88	51.88	400.0
2012-03-07	BLV	ETF	91.49	91.49	91.12	91.23	76400.0
2012-03-07	BMVP	ETF	14.9	14.99	14.9	14.98	6427.0
2012-03-07	BND	ETF	83.74	83.78	83.67	83.73	809900.0

> showing 50 of 930 rows — these rows as CSV

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