PREVIEW / etf_daily / 2012-05-01

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-01.parquet
  size:    38 KB
  rows:    934

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-05-01	SPY	ETF	139.79	141.66	139.63	140.74	138832200.0
2012-05-01	QQQ	ETF	66.68	67.63	66.59	66.87	37643735.0
2012-05-01	IWM	ETF	81.56	82.97	81.29	81.55	60493600.0
2012-05-01	DIA	ETF	131.85	133.14	131.4	132.53	5453200.0
2012-05-01	GLD	ETF	162.09	162.18	160.89	161.32	7414800.0
2012-05-01	TLT	ETF	117.43	117.62	116.07	116.43	7214300.0
2012-05-01	AAXJ	ETF	56.28	56.89	56.11	56.54	146000.0
2012-05-01	ACTV	ETF	16.72	17.01	16.68	16.81	194520.0
2012-05-01	ACWI	ETF	46.54	47.15	46.54	46.89	516300.0
2012-05-01	ACWV	ETF	54.66	55.16	54.58	54.95	68500.0
2012-05-01	ACWX	ETF	40.05	40.51	40.05	40.31	68872.0
2012-05-01	ADRE	ETF	41.16	41.65	41.16	41.39	18661.0
2012-05-01	AFK	ETF	29.96	30.09	29.86	30.09	15947.0
2012-05-01	AGG	ETF	110.46	110.5	110.26	110.33	772800.0
2012-05-01	AGQ	ETF	202.28	203.44	197.64	198.4	217325.0
2012-05-01	AGZ	ETF	112.96	112.99	112.8	112.9595	8853.0
2012-05-01	AIA	ETF	45.03	45.51	44.93	45.18	32364.0
2012-05-01	AIQ	ETF	6.7	7.65	6.7	7.45	35879.0
2012-05-01	AIS	ETF	3.16	3.25	3.1	3.13	1518939.0
2012-05-01	AIVI	ETF	40.66	40.88	40.55	40.88	63800.0
2012-05-01	AMJ	ETF	39.95	40.35	39.95	40.1	1239178.0
2012-05-01	AMLP	ETF	83.8	84.25	83.8	84.2	536020.0
2012-05-01	ANGL	ETF	25.23	25.52	25.23	25.44	121700.0
2012-05-01	AOA	ETF	36.34	36.52	36.33	36.47	8700.0
2012-05-01	AOK	ETF	30.15	30.29	30.15	30.23	1466799.0
2012-05-01	AOM	ETF	31.25	31.387	31.214	31.3	37034.0
2012-05-01	AOR	ETF	33.27	33.5	33.24	33.4	33800.0
2012-05-01	ARB	ETF	37.96	38.62	37.5	37.66	287099.0
2012-05-01	ARGT	ETF	18.9	19.22	18.44	18.98	6650.0
2012-05-01	ASEA	ETF	16.36	16.39	16.32	16.32	11200.0
2012-05-01	AWAY	ETF	25.86	26.25	25.37	26.07	792812.0
2012-05-01	BAB	ETF	29.45	29.49	29.29	29.37	259393.0
2012-05-01	BAL	ETF	55.55	55.85	55.538	55.67	66077.0
2012-05-01	BALT	ETF	4.63	4.65	4.29	4.3	294114.0
2012-05-01	BBH	ETF	45.9	46.16	45.79	45.79	7500.0
2012-05-01	BCM	ETF	44.92	45.18	44.92	45.1112	10743.0
2012-05-01	BIB	ETF	12.2513	12.4656	11.855	12.4002	37112.0
2012-05-01	BICK	ETF	25.43	25.6863	25.42	25.52	4118.0
2012-05-01	BIL	ETF	91.64	91.66	91.64	91.66	219500.0
2012-05-01	BIS	ETF	3544.0	3548.8	3486.4	3511.04	30.05
2012-05-01	BIV	ETF	87.92	87.92	87.61	87.72	322600.0
2012-05-01	BJK	ETF	36.8	36.9	36.64	36.64	6400.0
2012-05-01	BKF	ETF	40.11	40.6	39.96	40.35	104710.0
2012-05-01	BKLN	ETF	24.6	24.65	24.59	24.65	794400.0
2012-05-01	BLV	ETF	91.5	91.6	90.82	91.07	80000.0
2012-05-01	BMVP	ETF	15.59	15.8	15.59	15.7	13483.0
2012-05-01	BND	ETF	83.82	83.82	83.58	83.61	1993800.0
2012-05-01	BNO	ETF	41.93	42.31	41.825	42.155	19600.0
2012-05-01	BOIL	ETF	773000.0	802000.0	754000.0	790000.0	12.4
2012-05-01	BOND	ETF	103.54	103.57	103.3	103.43	242457.0

> showing 50 of 934 rows — these rows as CSV

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