PREVIEW / etf_daily / 2012-04-04

all etf daily files

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

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-04	SPY	ETF	140.22	140.34	139.34	139.86	146896000.0
2012-04-04	QQQ	ETF	67.73	67.76	66.91	67.3	54087961.0
2012-04-04	IWM	ETF	82.37	82.43	81.45	81.94	65172400.0
2012-04-04	DIA	ETF	130.66	130.77	129.95	130.51	10402500.0
2012-04-04	GLD	ETF	157.7	158.03	156.58	157.21	15975600.0
2012-04-04	TLT	ETF	111.77	112.12	111.41	112.1	10095600.0
2012-04-04	AAXJ	ETF	56.05	56.13	55.7	56.0	186900.0
2012-04-04	ACTV	ETF	16.79	16.79	16.42	16.6	328905.0
2012-04-04	ACWI	ETF	46.65	46.65	46.27	46.41	467600.0
2012-04-04	ACWV	ETF	53.93	54.16	53.92	53.97	5800.0
2012-04-04	ACWX	ETF	40.05	40.13	39.76	39.93	139534.0
2012-04-04	ADRE	ETF	41.67	41.82	41.4508	41.48	21490.0
2012-04-04	AFK	ETF	29.09	29.09	28.64	28.86	8108.0
2012-04-04	AGEM	ETF	23.0079	23.0079	23.0079	23.0079	280.0
2012-04-04	AGG	ETF	109.35	109.41	109.21	109.38	1137200.0
2012-04-04	AGQ	ETF	207.2	209.32	200.2	203.04	793750.0
2012-04-04	AGZ	ETF	112.09	112.48	112.05	112.44	22709.0
2012-04-04	AIA	ETF	44.49	44.49	44.1486	44.32	7762.0
2012-04-04	AIQ	ETF	7.25	7.5	7.25	7.4	15642.0
2012-04-04	AIS	ETF	3.24	3.28	3.22	3.26	951464.0
2012-04-04	AIVI	ETF	40.75	40.75	40.34	40.46	63900.0
2012-04-04	AMJ	ETF	39.37	39.4	38.97	39.07	1059803.0
2012-04-04	AMLP	ETF	82.85	83.3	82.8	82.9	295840.0
2012-04-04	AOA	ETF	36.12	36.18	35.96	36.11	18000.0
2012-04-04	AOK	ETF	30.01	30.01	29.9001	29.93	7831.0
2012-04-04	AOM	ETF	31.09	31.1	30.9631	31.05	23483.0
2012-04-04	AOR	ETF	33.16	33.33	32.981	33.11	37516.0
2012-04-04	ARB	ETF	36.85	37.28	36.5	36.7	238726.0
2012-04-04	ARGT	ETF	20.42	20.46	20.12	20.12	850.0
2012-04-04	ASEA	ETF	16.1	16.11	16.01	16.11	3200.0
2012-04-04	AWAY	ETF	23.37	23.6	23.222	23.34	235971.0
2012-04-04	BAB	ETF	29.0	29.16	28.9901	29.09	95162.0
2012-04-04	BAL	ETF	55.51	55.51	54.0	54.37	48596.0
2012-04-04	BALT	ETF	4.36	4.42	4.26	4.36	84182.0
2012-04-04	BBH	ETF	44.61	44.61	43.9	44.15	78000.0
2012-04-04	BCM	ETF	45.03	45.03	44.78	44.92	1485.0
2012-04-04	BIB	ETF	12.1237	12.1237	11.7575	11.9187	57152.0
2012-04-04	BICK	ETF	26.25	26.3	26.1	26.16	10599.0
2012-04-04	BIL	ETF	91.64	91.64	91.62	91.62	319850.0
2012-04-04	BIS	ETF	3667.2	3667.2	3657.6	3657.6	3.75
2012-04-04	BIV	ETF	86.31	86.44	86.24	86.36	144700.0
2012-04-04	BJK	ETF	35.8	35.91	35.54	35.63	16800.0
2012-04-04	BKF	ETF	40.71	40.78	40.45	40.67	121398.0
2012-04-04	BKLN	ETF	24.55	24.57	24.46	24.53	201200.0
2012-04-04	BLV	ETF	88.15	88.35	87.92	88.35	32600.0
2012-04-04	BMVP	ETF	15.583	15.583	15.513	15.548	11832.0
2012-04-04	BND	ETF	82.95	82.95	82.69	82.92	1045100.0
2012-04-04	BNO	ETF	43.65	43.78	43.025	43.095	96800.0
2012-04-04	BOIL	ETF	788000.0	805000.0	757000.0	759000.0	6.0
2012-04-04	BOND	ETF	101.4	101.7	101.4	101.64	175051.0

> showing 50 of 921 rows — these rows as CSV

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