PREVIEW / etf_daily / 2012-04-03

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-03.parquet
  size:    38 KB
  rows:    922

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-04-03	SPY	ETF	141.64	141.88	140.43	141.26	155806700.0
2012-04-03	QQQ	ETF	68.31	68.55	67.85	68.23	45539655.0
2012-04-03	IWM	ETF	83.66	84.0	82.93	83.27	52012300.0
2012-04-03	DIA	ETF	132.15	132.4	131.05	131.67	6098700.0
2012-04-03	GLD	ETF	163.23	163.23	159.17	159.89	16822300.0
2012-04-03	TLT	ETF	113.01	113.44	110.57	110.58	14774300.0
2012-04-03	AADR	ETF	31.43	31.43	31.4	31.4	1200.0
2012-04-03	AAXJ	ETF	57.1	57.4	56.65	57.01	383300.0
2012-04-03	ACTV	ETF	16.75	16.98	16.75	16.9	206355.0
2012-04-03	ACWI	ETF	47.57	47.65	47.01	47.21	414300.0
2012-04-03	ACWV	ETF	54.91	54.91	54.91	54.91	100.0
2012-04-03	ACWX	ETF	41.2	41.23	40.59	40.78	121971.0
2012-04-03	ADRE	ETF	42.73	42.75	42.091	42.32	30255.0
2012-04-03	AFK	ETF	29.57	29.57	29.2	29.38	21973.0
2012-04-03	AGEM	ETF	23.6662	23.6662	23.6662	23.6662	1000.0
2012-04-03	AGG	ETF	109.71	109.79	109.07	109.15	767100.0
2012-04-03	AGQ	ETF	227.12	231.2	220.0	221.12	894100.0
2012-04-03	AGZ	ETF	112.22	112.4	112.22	112.39	43139.0
2012-04-03	AIA	ETF	45.3	45.3	44.84	44.97	7854.0
2012-04-03	AIQ	ETF	7.65	7.7	7.35	7.4	7946.0
2012-04-03	AIS	ETF	3.23	3.28	3.2	3.26	902365.0
2012-04-03	AIVI	ETF	41.93	41.94	41.23	41.43	46100.0
2012-04-03	AMJ	ETF	39.14	39.51	39.13	39.49	3984279.0
2012-04-03	AMLP	ETF	82.95	83.55	82.8	83.4	316220.0
2012-04-03	AOA	ETF	36.62	36.68	36.36	36.48	17500.0
2012-04-03	AOK	ETF	30.15	30.22	30.038	30.07	25078.0
2012-04-03	AOM	ETF	31.37	31.37	31.148	31.22	36109.0
2012-04-03	AOR	ETF	33.48	33.51	33.238	33.33	13304.0
2012-04-03	ARB	ETF	37.59	38.0	37.16	37.3	228768.0
2012-04-03	ARGT	ETF	20.86	20.96	20.84	20.96	1200.0
2012-04-03	ASEA	ETF	16.43	16.43	16.32	16.34	6000.0
2012-04-03	AWAY	ETF	23.7	24.34	23.3	23.54	278269.0
2012-04-03	BAB	ETF	29.19	29.22	28.8805	28.96	87465.0
2012-04-03	BAL	ETF	56.92	57.0099	56.09	56.24	35503.0
2012-04-03	BALT	ETF	4.29	4.48	4.29	4.44	251724.0
2012-04-03	BBH	ETF	44.89	44.89	44.44	44.78	10100.0
2012-04-03	BCM	ETF	45.95	45.95	45.614	45.614	200.0
2012-04-03	BIB	ETF	12.1275	12.34	12.1275	12.2078	19296.0
2012-04-03	BICK	ETF	26.92	26.98	26.56	26.6	9432.0
2012-04-03	BIL	ETF	91.62	91.64	91.62	91.64	871100.0
2012-04-03	BIS	ETF	3571.2	3571.2	3571.2	3571.2	6.65
2012-04-03	BIV	ETF	86.67	86.8	86.09	86.13	187000.0
2012-04-03	BJK	ETF	36.34	36.4	36.07	36.07	8600.0
2012-04-03	BKF	ETF	41.68	41.85	41.09	41.42	125844.0
2012-04-03	BKLN	ETF	24.57	24.6	24.51	24.55	127200.0
2012-04-03	BLNG	ETF	51.245	51.245	51.245	51.245	534.0
2012-04-03	BLV	ETF	89.05	89.2	87.62	87.71	39300.0
2012-04-03	BMVP	ETF	15.69	15.7	15.61	15.66	1625.0
2012-04-03	BND	ETF	83.12	83.14	82.65	82.69	962700.0
2012-04-03	BNO	ETF	44.19	44.25	43.75	43.885	46400.0

> showing 50 of 922 rows — these rows as CSV

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