PREVIEW / etf_daily / 2011-03-21

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-21.parquet
  size:    35 KB
  rows:    832

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-21	SPY	ETF	129.35	130.01	129.2	129.74	153992600.0
2011-03-21	QQQ	ETF	55.29	55.78	54.4956	55.5	57419948.0
2011-03-21	IWM	ETF	80.48	81.32	80.36	81.3	50638200.0
2011-03-21	DIA	ETF	119.55	120.52	119.55	120.07	7615000.0
2011-03-21	GLD	ETF	139.5	139.91	138.97	139.14	13742500.0
2011-03-21	TLT	ETF	93.13	93.18	92.57	92.91	10542900.0
2011-03-21	AADR	ETF	29.73	29.73	29.73	29.73	1000.0
2011-03-21	AAXJ	ETF	60.29	60.54	60.05	60.45	168300.0
2011-03-21	ACWI	ETF	47.16	47.48	47.0	47.4	356100.0
2011-03-21	ACWX	ETF	44.44	44.63	44.27	44.58	125488.0
2011-03-21	ADRE	ETF	46.02	46.23	46.02	46.11	60639.0
2011-03-21	AFK	ETF	31.62	32.0	31.41	31.85	12186.0
2011-03-21	AGG	ETF	105.87	105.88	105.55	105.67	460900.0
2011-03-21	AGQ	ETF	409.28	417.5	406.16	415.5	510950.0
2011-03-21	AGZ	ETF	110.08	110.08	109.49	109.5101	12685.0
2011-03-21	AIA	ETF	45.6	45.68	45.44	45.545	30156.0
2011-03-21	AIQ	ETF	20.05	20.15	19.9	20.0	16347.0
2011-03-21	AIS	ETF	1.63	1.66	1.61	1.66	364837.0
2011-03-21	AIVI	ETF	45.58	46.03	45.51	46.0	15000.0
2011-03-21	AMJ	ETF	36.96	37.33	36.91	37.33	1432578.0
2011-03-21	AMLP	ETF	80.55	80.95	80.4	80.95	173560.0
2011-03-21	AOA	ETF	35.21	35.37	35.18	35.33	30500.0
2011-03-21	AOK	ETF	29.16	29.16	29.11	29.16	12583.0
2011-03-21	AOM	ETF	30.4075	30.44	30.3812	30.43	33405.0
2011-03-21	AOR	ETF	32.2	32.27	32.1996	32.24	37263.0
2011-03-21	ARB	ETF	36.35	37.09	36.35	36.9	112936.0
2011-03-21	ARGT	ETF	29.5	29.5	29.18	29.18	900.0
2011-03-21	ASEA	ETF	15.34	15.34	15.33	15.33	700.0
2011-03-21	BAB	ETF	25.43	25.43	25.3	25.35	128860.0
2011-03-21	BAL	ETF	103.09	104.28	102.0	103.77	257952.0
2011-03-21	BALT	ETF	8.98	9.191	8.76	8.85	149381.0
2011-03-21	BBH	ETF	34.6533	34.8	34.4533	34.4533	56100.0
2011-03-21	BIB	ETF	7.6375	7.6375	7.6375	7.6375	800.0
2011-03-21	BICK	ETF	31.35	31.609	31.35	31.49	10276.0
2011-03-21	BIL	ETF	91.72	91.74	91.72	91.74	102350.0
2011-03-21	BIS	ETF	7828.8	7828.8	7627.2	7627.2	6.9
2011-03-21	BITS	ETF	24.92	25.0	24.56	25.0	2231.0
2011-03-21	BIV	ETF	83.38	83.38	82.79	82.97	99700.0
2011-03-21	BJK	ETF	30.79	31.13	30.79	31.12	21200.0
2011-03-21	BKF	ETF	47.8	47.93	47.52	47.57	123672.0
2011-03-21	BKLN	ETF	24.9	24.9	24.8	24.88	48900.0
2011-03-21	BLV	ETF	78.47	79.04	78.47	78.88	13000.0
2011-03-21	BMVP	ETF	15.067	15.212	15.067	15.187	41095.0
2011-03-21	BND	ETF	80.65	80.65	80.4	80.48	813800.0
2011-03-21	BNO	ETF	38.32	38.375	38.09	38.09	85600.0
2011-03-21	BRF	ETF	52.52	52.5585	52.15	52.15	158960.0
2011-03-21	BSCE	ETF	20.91	20.97	20.91	20.97	11534.0
2011-03-21	BSV	ETF	80.56	80.63	80.52	80.54	443300.0
2011-03-21	BTF	ETF	84.39999999999999	84.89999999999999	83.6	84.25	7345.400000000001
2011-03-21	BWX	ETF	30.38	30.38	30.155	30.295	221624.0

> showing 50 of 832 rows — these rows as CSV

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