PREVIEW / etf_daily / 2012-08-10

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-10.parquet
  size:    38 KB
  rows:    928

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-08-10	SPY	ETF	140.04	140.89	139.81	140.84	99792700.0
2012-08-10	QQQ	ETF	66.59	66.88	66.41	66.86	20320925.0
2012-08-10	IWM	ETF	79.77	80.05	79.5	79.92	26068400.0
2012-08-10	DIA	ETF	131.15	131.95	130.79	131.93	4410400.0
2012-08-10	GLD	ETF	156.9	157.82	156.65	157.18	4608000.0
2012-08-10	TLT	ETF	126.2	126.32	125.6	125.7	4670500.0
2012-08-10	AAXJ	ETF	54.19	54.64	54.12	54.64	286600.0
2012-08-10	ACTV	ETF	11.51	11.62	11.22	11.24	283646.0
2012-08-10	ACWI	ETF	45.33	45.64	45.19	45.62	800400.0
2012-08-10	ACWV	ETF	55.34	55.74	55.31	55.74	17900.0
2012-08-10	ACWX	ETF	38.28	38.61	38.19	38.59	75233.0
2012-08-10	ADRE	ETF	39.0	39.45	38.89	39.432	29354.0
2012-08-10	AFK	ETF	29.1	29.282	28.91	29.282	28676.0
2012-08-10	AGG	ETF	111.98	111.98	111.79	111.87	627400.0
2012-08-10	AGQ	ETF	154.32	160.28	153.56	157.68	227500.0
2012-08-10	AGZ	ETF	113.59	113.59	113.4501	113.455	6736.0
2012-08-10	AIA	ETF	43.39	43.6901	43.39	43.6901	14277.0
2012-08-10	AIQ	ETF	5.4	5.9	5.25	5.75	30484.0
2012-08-10	AIVI	ETF	38.97	39.36	38.81	39.36	30700.0
2012-08-10	AMJ	ETF	39.35	39.67	39.3001	39.67	407593.0
2012-08-10	AMLP	ETF	81.0	81.35	80.8	81.35	378100.0
2012-08-10	ANGL	ETF	26.35	26.35	26.34	26.34	1000.0
2012-08-10	AOA	ETF	35.79	35.97	35.76	35.97	13900.0
2012-08-10	AOK	ETF	30.152	30.19	30.152	30.17	36001.0
2012-08-10	AOM	ETF	31.17	31.23	31.0701	31.23	4387.0
2012-08-10	AOR	ETF	33.1	33.189	33.0127	33.189	29910.0
2012-08-10	ARB	ETF	35.89	36.28	35.53	36.06	143294.0
2012-08-10	ARGT	ETF	17.32	17.32	17.32	17.32	50.0
2012-08-10	ASEA	ETF	16.38	16.45	16.36	16.41	11100.0
2012-08-10	AWAY	ETF	23.92	24.05	23.45	23.96	220174.0
2012-08-10	BAB	ETF	30.18	30.22	30.1	30.1799	201033.0
2012-08-10	BAL	ETF	49.08	49.12	48.06	48.19	27845.0
2012-08-10	BALT	ETF	3.34	3.44	3.34	3.41	11939.0
2012-08-10	BBH	ETF	49.72	49.98	49.66	49.97	5700.0
2012-08-10	BCM	ETF	44.47	44.47	44.47	44.47	2330.0
2012-08-10	BIB	ETF	13.5188	13.692	13.5188	13.6251	9520.0
2012-08-10	BICK	ETF	23.31	23.4385	23.2174	23.424	1818.0
2012-08-10	BIL	ETF	91.62	91.64	91.62	91.62	246800.0
2012-08-10	BIV	ETF	89.41	89.45	89.26	89.32	162200.0
2012-08-10	BJK	ETF	30.75	31.0	30.75	30.9	2700.0
2012-08-10	BKF	ETF	36.91	37.266	36.82	37.24	77590.0
2012-08-10	BKLN	ETF	24.75	24.75	24.72	24.73	177500.0
2012-08-10	BLV	ETF	96.82	96.82	96.33	96.51	38100.0
2012-08-10	BMVP	ETF	15.79	15.86	15.76	15.86	7911.0
2012-08-10	BND	ETF	84.78	84.78	84.62	84.68	898300.0
2012-08-10	BNO	ETF	39.81	40.18	39.695	40.18	51400.0
2012-08-10	BOIL	ETF	901600.0	903400.0	861400.0	874200.0	14.8
2012-08-10	BOND	ETF	106.99	107.15	106.93	107.11	259258.0
2012-08-10	BRF	ETF	37.6	38.08	37.57	38.04	41768.0
2012-08-10	BSCE	ETF	21.2	21.25	21.2	21.25	36315.0

> showing 50 of 928 rows — these rows as CSV

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