PREVIEW / etf_daily / 2011-06-03

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-03.parquet
  size:    36 KB
  rows:    849

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
2011-06-03	SPY	ETF	130.15	131.42	130.08	130.42	234690200.0
2011-06-03	QQQ	ETF	56.56	56.99	56.27	56.35	57773681.0
2011-06-03	IWM	ETF	80.81	81.73	80.69	80.88	76493800.0
2011-06-03	DIA	ETF	120.88	122.0	120.84	121.32	6224000.0
2011-06-03	GLD	ETF	150.28	150.66	149.62	150.22	12606400.0
2011-06-03	TLT	ETF	96.58	96.6	95.57	96.33	10644100.0
2011-06-03	AAXJ	ETF	62.58	63.23	62.43	62.74	204600.0
2011-06-03	ACTV	ETF	18.05	18.54	18.02	18.25	171415.0
2011-06-03	ACWI	ETF	48.14	48.75	48.13	48.46	217300.0
2011-06-03	ACWX	ETF	45.0	45.68	44.99	45.46	71605.0
2011-06-03	ADRE	ETF	46.1	46.82	46.1	46.423	53234.0
2011-06-03	AFK	ETF	32.99	33.29	32.99	33.21	17487.0
2011-06-03	AGG	ETF	107.53	107.53	107.17	107.32	522300.0
2011-06-03	AGQ	ETF	351.7	368.36	349.5	363.64	1188750.0
2011-06-03	AGZ	ETF	110.83	110.96	110.706	110.75	36290.0
2011-06-03	AIA	ETF	47.69	48.109	47.682	47.99	12858.0
2011-06-03	AIQ	ETF	20.35	21.0	20.25	20.65	31617.0
2011-06-03	AIS	ETF	1.81	1.83	1.75	1.81	831623.0
2011-06-03	AIVI	ETF	47.82	48.6	47.75	48.36	40800.0
2011-06-03	AMJ	ETF	36.18	36.35	35.8752	36.28	448331.0
2011-06-03	AMLP	ETF	78.8	79.0	78.35	79.0	91200.0
2011-06-03	AOA	ETF	35.57	35.79	35.52	35.66	18900.0
2011-06-03	AOK	ETF	29.32	29.36	29.3	29.3152	8283.0
2011-06-03	AOM	ETF	30.6	30.7816	30.6	30.7	71955.0
2011-06-03	AOR	ETF	32.5499	32.66	32.5444	32.6036	7591.0
2011-06-03	ARB	ETF	40.64	40.64	38.99	39.06	174005.0
2011-06-03	ARGT	ETF	28.8	29.02	28.8	29.0	600.0
2011-06-03	ASEA	ETF	16.28	16.53	16.28	16.31	6300.0
2011-06-03	BAB	ETF	26.68	26.7001	26.52	26.61	141329.0
2011-06-03	BAL	ETF	93.08	93.14	89.07	89.65	105998.0
2011-06-03	BALT	ETF	6.16	6.32	6.13	6.3	242454.0
2011-06-03	BBH	ETF	34.5433	34.8767	34.24	34.5967	121800.0
2011-06-03	BIB	ETF	9.8262	9.8571	9.625	9.6713	234320.0
2011-06-03	BICK	ETF	32.03	32.535	32.03	32.3007	24833.0
2011-06-03	BIL	ETF	91.7	91.72	91.7	91.7	62750.0
2011-06-03	BIS	ETF	6017.6	6036.8	5924.8	6000.0	16.9
2011-06-03	BITS	ETF	22.32	22.64	22.0	22.0	625.0
2011-06-03	BIV	ETF	84.84	84.85	84.56	84.71	140000.0
2011-06-03	BJK	ETF	34.01	34.31	33.99	34.01	4200.0
2011-06-03	BKF	ETF	47.69	48.34	47.67	48.05	102762.0
2011-06-03	BKLN	ETF	25.07	25.07	25.03	25.06	144800.0
2011-06-03	BLV	ETF	81.73	81.73	81.06	81.46	24000.0
2011-06-03	BMVP	ETF	15.4	15.53	15.3233	15.42	19835.0
2011-06-03	BND	ETF	81.83	81.83	81.54	81.67	747300.0
2011-06-03	BNO	ETF	37.875	38.625	37.875	38.61	19400.0
2011-06-03	BRF	ETF	56.81	57.97	56.73	57.97	83679.0
2011-06-03	BSCE	ETF	21.18	21.18	21.08	21.17	7280.0
2011-06-03	BSV	ETF	81.15	81.17	81.07	81.13	393900.0
2011-06-03	BTF	ETF	83.05	83.85	82.69999999999999	83.39999999999999	2352.0
2011-06-03	BWX	ETF	31.22	31.605	31.15	31.335	1445220.0

> showing 50 of 849 rows — these rows as CSV

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