PREVIEW / etf_daily / 2011-03-23

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-23.parquet
  size:    35 KB
  rows:    833

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-03-23	SPY	ETF	128.93	130.0	128.32	129.66	148603100.0
2011-03-23	QQQ	ETF	55.19	55.87	54.82	55.71	60365084.0
2011-03-23	IWM	ETF	80.69	81.36	79.85	81.12	58044700.0
2011-03-23	DIA	ETF	119.68	120.91	119.44	120.63	6693400.0
2011-03-23	GLD	ETF	139.61	140.55	139.55	140.34	11541000.0
2011-03-23	TLT	ETF	93.85	93.88	92.93	93.1	8358000.0
2011-03-23	AADR	ETF	29.94	29.95	29.94	29.95	500.0
2011-03-23	AAXJ	ETF	60.58	61.03	60.27	60.83	173300.0
2011-03-23	ACWI	ETF	47.33	47.7	47.04	47.5	379000.0
2011-03-23	ACWX	ETF	44.21	44.6	44.01	44.43	419012.0
2011-03-23	ADRE	ETF	46.34	46.9552	46.304	46.81	55485.0
2011-03-23	AFK	ETF	32.2	32.51	32.0	32.47	32414.0
2011-03-23	AGG	ETF	105.83	105.85	105.58	105.63	472300.0
2011-03-23	AGQ	ETF	423.16	444.48	421.74	443.84	618200.0
2011-03-23	AGZ	ETF	109.87	109.87	109.36	109.4101	30127.0
2011-03-23	AIA	ETF	45.51	45.869	45.34	45.75	36305.0
2011-03-23	AIQ	ETF	20.3	20.75	19.95	20.75	20832.0
2011-03-23	AIS	ETF	1.63	1.66	1.6	1.65	173977.0
2011-03-23	AIVI	ETF	45.49	45.79	45.38	45.79	1700.0
2011-03-23	AMJ	ETF	37.45	37.66	37.22	37.31	947713.0
2011-03-23	AMLP	ETF	81.3	81.6	80.7	80.85	171140.0
2011-03-23	AOA	ETF	35.08	35.3	34.98	35.28	10600.0
2011-03-23	AOK	ETF	29.12	29.12	29.05	29.084	9514.0
2011-03-23	AOM	ETF	30.36	30.42	30.28	30.39	19303.0
2011-03-23	AOR	ETF	32.15	32.25	32.028	32.18	20701.0
2011-03-23	ARB	ETF	37.25	37.7	37.06	37.54	146319.0
2011-03-23	ARGT	ETF	29.26	29.26	29.16	29.22	1000.0
2011-03-23	ASEA	ETF	15.44	15.52	15.39	15.52	1900.0
2011-03-23	BAB	ETF	25.44	25.49	25.32	25.36	155247.0
2011-03-23	BAL	ETF	105.66	106.29	102.5045	104.65	184097.0
2011-03-23	BALT	ETF	8.88	9.11	8.82	9.02	112045.0
2011-03-23	BBH	ETF	34.3	34.7067	34.3	34.6133	33000.0
2011-03-23	BIB	ETF	7.5663	7.6988	7.5663	7.6988	1600.0
2011-03-23	BICK	ETF	31.73	31.93	31.55	31.8	28491.0
2011-03-23	BIL	ETF	91.7	91.72	91.7	91.72	156950.0
2011-03-23	BIS	ETF	7848.0	7848.0	7772.8	7772.8	3.75
2011-03-23	BITS	ETF	24.92	24.92	24.24	24.84	2072.0
2011-03-23	BIV	ETF	82.86	82.9	82.58	82.63	171500.0
2011-03-23	BJK	ETF	30.78	31.09	30.67	31.04	5400.0
2011-03-23	BKF	ETF	47.98	48.74	47.97	48.74	290709.0
2011-03-23	BKLN	ETF	24.95	24.96	24.78	24.94	43500.0
2011-03-23	BLV	ETF	79.32	79.43	78.8	78.83	30200.0
2011-03-23	BMVP	ETF	15.0	15.2	15.0	15.19	17348.0
2011-03-23	BND	ETF	80.59	80.62	80.39	80.42	1049500.0
2011-03-23	BNO	ETF	38.36	38.6	38.25	38.285	414000.0
2011-03-23	BRF	ETF	52.73	53.41	52.59	53.25	157777.0
2011-03-23	BSCE	ETF	20.97	20.97	20.94	20.96	2714.0
2011-03-23	BSV	ETF	80.51	80.55	80.45	80.48	399200.0
2011-03-23	BTF	ETF	83.35000000000001	83.69999999999999	83.05	83.69999999999999	1997.0
2011-03-23	BWX	ETF	30.16	30.275	30.0406	30.25	243192.0

> showing 50 of 833 rows — these rows as CSV

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