PREVIEW / etf_daily / 2011-02-16

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-16.parquet
  size:    35 KB
  rows:    823

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-02-16	SPY	ETF	133.46	134.01	133.19	133.85	130183500.0
2011-02-16	QQQ	ETF	58.64	59.04	58.63	58.881	53061305.0
2011-02-16	IWM	ETF	82.21	82.82	82.18	82.68	38284700.0
2011-02-16	DIA	ETF	122.49	123.06	122.37	122.88	5680000.0
2011-02-16	GLD	ETF	134.23	134.86	133.45	134.1	12822800.0
2011-02-16	TLT	ETF	89.87	90.32	89.34	89.63	8446300.0
2011-02-16	AAXJ	ETF	61.07	61.26	60.83	61.05	776800.0
2011-02-16	ACWI	ETF	48.53	48.91	48.53	48.86	203000.0
2011-02-16	ACWX	ETF	45.16	45.65	45.16	45.59	106944.0
2011-02-16	ADRE	ETF	46.75	47.1	46.75	47.0	41433.0
2011-02-16	AFK	ETF	33.85	33.95	33.58	33.9	27889.0
2011-02-16	AGG	ETF	104.48	104.65	104.4	104.48	474800.0
2011-02-16	AGQ	ETF	308.62	313.08	299.14	306.58	475350.0
2011-02-16	AGZ	ETF	109.26	109.26	108.7	108.72	14385.0
2011-02-16	AIA	ETF	46.37	46.44	46.18	46.35	86221.0
2011-02-16	AIQ	ETF	20.65	21.4	20.45	21.3	13451.0
2011-02-16	AIS	ETF	1.65	1.68	1.62	1.64	402336.0
2011-02-16	AIVI	ETF	46.02	46.32	45.84	46.22	17800.0
2011-02-16	AMJ	ETF	38.28	38.31	38.15	38.25	1001053.0
2011-02-16	AMLP	ETF	81.85	82.1	81.55	81.65	123920.0
2011-02-16	AOA	ETF	35.88	36.03	35.84	36.02	17200.0
2011-02-16	AOK	ETF	29.0	29.01	28.97	28.9801	6413.0
2011-02-16	AOM	ETF	30.41	30.46	30.39	30.4408	27760.0
2011-02-16	AOR	ETF	32.43	32.54	32.43	32.54	15205.0
2011-02-16	ARB	ETF	43.09	44.14	43.03	43.59	231377.0
2011-02-16	BAB	ETF	24.71	24.84	24.67	24.75	293089.0
2011-02-16	BAL	ETF	101.34	106.08	100.73	103.93	183127.0
2011-02-16	BALT	ETF	8.84	9.01	8.8	8.97	181813.0
2011-02-16	BBH	ETF	33.9167	34.0067	33.8	33.9633	207300.0
2011-02-16	BIB	ETF	7.78	7.78	7.7411	7.7411	3600.0
2011-02-16	BICK	ETF	31.4	31.53	31.279	31.5	31349.0
2011-02-16	BIL	ETF	91.72	91.72	91.7	91.72	136800.0
2011-02-16	BIS	ETF	8123.2	8123.2	8123.2	8123.2	2.0
2011-02-16	BITS	ETF	26.8	27.0	26.4	27.0	1158.0
2011-02-16	BIV	ETF	81.69	81.74	81.38	81.6	76500.0
2011-02-16	BJK	ETF	32.32	32.58	32.32	32.54	28000.0
2011-02-16	BKF	ETF	47.44	47.99	47.32	47.93	167718.0
2011-02-16	BLV	ETF	76.97	77.34	76.91	77.0	25000.0
2011-02-16	BMVP	ETF	15.59	15.7213	15.59	15.7213	17347.0
2011-02-16	BND	ETF	79.5	79.64	79.42	79.53	635400.0
2011-02-16	BNO	ETF	34.5	34.58	34.01	34.58	62400.0
2011-02-16	BRF	ETF	52.98	53.51	52.8	53.42	175432.0
2011-02-16	BSCE	ETF	20.78	20.8	20.72	20.7326	23862.0
2011-02-16	BSV	ETF	80.0	80.06	79.96	80.0	473500.0
2011-02-16	BTF	ETF	86.64999999999999	86.95	86.25	86.95	12975.400000000001
2011-02-16	BWX	ETF	28.89	29.195	28.89	29.085	198122.0
2011-02-16	BWZ	ETF	37.35	38.05	37.02	37.31	110886.0
2011-02-16	BZQ	ETF	2648.0	2662.4	2590.4	2598.4	518.0
2011-02-16	CEF	ETF	20.27	20.38	20.07	20.17	807300.0
2011-02-16	CEW	ETF	22.37	22.41	22.31	22.36	2108818.0

> showing 50 of 823 rows — these rows as CSV

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