PREVIEW / etf_daily / 2012-03-13

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-13.parquet
  size:    38 KB
  rows:    925

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-13	SPY	ETF	138.32	140.13	138.09	140.06	184090500.0
2012-03-13	QQQ	ETF	65.42	66.26	65.27	66.26	61558511.0
2012-03-13	IWM	ETF	82.06	83.09	81.4	83.06	60998100.0
2012-03-13	DIA	ETF	130.05	131.77	129.85	131.68	8699500.0
2012-03-13	GLD	ETF	163.94	165.41	161.43	162.3	20047000.0
2012-03-13	TLT	ETF	115.27	115.41	113.89	113.91	14413600.0
2012-03-13	AADR	ETF	30.48	30.58	30.48	30.58	900.0
2012-03-13	AAXJ	ETF	57.61	58.42	57.37	58.35	316000.0
2012-03-13	ACTV	ETF	17.0	17.74	16.9402	17.74	403893.0
2012-03-13	ACWI	ETF	46.77	47.29	46.68	47.27	475500.0
2012-03-13	ACWV	ETF	53.97	53.97	53.97	53.97	700.0
2012-03-13	ACWX	ETF	40.8	41.35	40.77	41.32	191030.0
2012-03-13	ADRE	ETF	42.68	43.67	42.6736	43.67	31305.0
2012-03-13	AFK	ETF	29.73	29.97	29.52	29.97	28760.0
2012-03-13	AGEM	ETF	24.01	24.22	24.01	24.22	624.0
2012-03-13	AGG	ETF	110.22	110.23	109.9	109.92	1444700.0
2012-03-13	AGQ	ETF	232.52	239.24	228.4	231.4	889900.0
2012-03-13	AGZ	ETF	112.7367	112.79	112.5	112.5	23178.0
2012-03-13	AIA	ETF	45.39	45.8352	45.201	45.83	5486.0
2012-03-13	AIQ	ETF	6.75	7.0	6.5	7.0	12821.0
2012-03-13	AIS	ETF	2.76	2.92	2.67	2.89	1536800.0
2012-03-13	AIVI	ETF	41.7	42.11	41.57	42.08	77900.0
2012-03-13	AMJ	ETF	40.53	40.53	40.05	40.27	1885956.0
2012-03-13	AMLP	ETF	84.55	84.95	84.2	84.5	346380.0
2012-03-13	AOA	ETF	36.08	36.45	36.08	36.45	11800.0
2012-03-13	AOK	ETF	30.08	30.17	30.08	30.165	39477.0
2012-03-13	AOM	ETF	31.1799	31.2899	31.15	31.2899	171099.0
2012-03-13	AOR	ETF	33.11	33.36	33.08	33.3599	96581.0
2012-03-13	ARB	ETF	34.76	35.3214	34.5	35.29	279171.0
2012-03-13	ASEA	ETF	15.76	15.99	15.76	15.99	8300.0
2012-03-13	AWAY	ETF	26.0	26.65	25.89	26.58	357296.0
2012-03-13	BAB	ETF	29.31	29.34	29.14	29.19	217280.0
2012-03-13	BAL	ETF	53.62	53.96	53.45	53.7	20535.0
2012-03-13	BALT	ETF	4.01	4.06	3.91	4.02	121778.0
2012-03-13	BBH	ETF	42.79	42.91	42.39	42.91	32600.0
2012-03-13	BCM	ETF	46.15	46.41	46.15	46.28	5496.0
2012-03-13	BIB	ETF	11.3187	11.375	11.2088	11.3075	100416.0
2012-03-13	BICK	ETF	27.21	27.63	27.21	27.58	9205.0
2012-03-13	BIL	ETF	91.66	91.66	91.64	91.66	205350.0
2012-03-13	BIS	ETF	3860.8	3905.6	3843.2	3843.2	33.75
2012-03-13	BITS	ETF	20.72	22.0	20.08	21.6	4118.0
2012-03-13	BIV	ETF	87.57	87.57	87.23	87.26	209800.0
2012-03-13	BJK	ETF	35.07	35.58	35.06	35.58	93400.0
2012-03-13	BKF	ETF	42.76	43.67	42.72	43.67	54991.0
2012-03-13	BKLN	ETF	24.56	24.56	24.51	24.54	141100.0
2012-03-13	BLV	ETF	90.34	90.38	89.66	89.73	59400.0
2012-03-13	BMVP	ETF	15.24	15.42	15.24	15.42	43156.0
2012-03-13	BND	ETF	83.46	83.54	83.33	83.33	1346400.0
2012-03-13	BNO	ETF	43.9	44.34	43.75	44.11	70400.0
2012-03-13	BOIL	ETF	919000.0	1024000.0	902000.0	998000.0	11.6

> showing 50 of 925 rows — these rows as CSV

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