PREVIEW / etf_daily / 2011-02-17

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-17.parquet
  size:    35 KB
  rows:    827

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-17	SPY	ETF	133.46	134.43	133.34	134.25	109810500.0
2011-02-17	QQQ	ETF	58.6	58.975	58.55	58.86	38361846.0
2011-02-17	IWM	ETF	82.6	83.51	82.45	83.26	34891200.0
2011-02-17	DIA	ETF	122.65	123.34	122.57	123.16	4856500.0
2011-02-17	GLD	ETF	134.74	135.16	134.47	135.04	11322200.0
2011-02-17	TLT	ETF	90.02	90.18	89.66	89.77	6732500.0
2011-02-17	AADR	ETF	30.3	30.65	30.3	30.6	2600.0
2011-02-17	AAXJ	ETF	61.18	61.44	61.01	61.44	219600.0
2011-02-17	ACWI	ETF	48.86	49.09	48.74	49.01	333100.0
2011-02-17	ACWX	ETF	45.58	45.86	45.54	45.78	56184.0
2011-02-17	ADRE	ETF	46.89	47.31	46.89	47.31	39078.0
2011-02-17	AFK	ETF	33.9	33.95	33.9	33.93	9051.0
2011-02-17	AGG	ETF	104.7	104.82	104.66	104.73	606300.0
2011-02-17	AGQ	ETF	310.1	329.12	309.06	328.34	562300.0
2011-02-17	AGZ	ETF	108.88	109.04	108.74	108.74	186031.0
2011-02-17	AIA	ETF	46.18	46.56	46.18	46.5	129867.0
2011-02-17	AIQ	ETF	21.15	21.5	20.7	21.45	10692.0
2011-02-17	AIS	ETF	1.64	1.66	1.6	1.66	404693.0
2011-02-17	AIVI	ETF	46.17	46.57	46.17	46.54	10400.0
2011-02-17	AMJ	ETF	38.35	38.35	38.01	38.25	429835.0
2011-02-17	AMLP	ETF	81.8	81.85	81.45	81.8	115480.0
2011-02-17	AOA	ETF	35.95	36.18	35.95	36.16	12000.0
2011-02-17	AOK	ETF	28.98	29.08	28.96	29.04	9578.0
2011-02-17	AOM	ETF	30.46	30.54	30.459	30.5299	16997.0
2011-02-17	AOR	ETF	32.55	32.65	32.55	32.63	12793.0
2011-02-17	ARB	ETF	43.49	44.05	43.3	43.85	183542.0
2011-02-17	ASEA	ETF	15.14	15.1899	15.14	15.1899	39144.0
2011-02-17	BAB	ETF	24.88	24.88	24.75	24.806	258574.0
2011-02-17	BAL	ETF	106.31	111.6599	106.31	111.0	314220.0
2011-02-17	BALT	ETF	9.15	9.4	9.15	9.34	307985.0
2011-02-17	BBH	ETF	33.8333	34.06	33.8333	33.87	12300.0
2011-02-17	BICK	ETF	31.32	31.715	31.32	31.64	18539.0
2011-02-17	BIL	ETF	91.7	91.72	91.7	91.72	68250.0
2011-02-17	BITS	ETF	27.24	27.24	26.96	27.2	325.0
2011-02-17	BIV	ETF	81.97	81.97	81.77	81.84	79600.0
2011-02-17	BJK	ETF	32.57	32.83	32.57	32.83	18700.0
2011-02-17	BKF	ETF	47.87	47.95	47.58	47.89	243994.0
2011-02-17	BLV	ETF	77.19	77.33	77.05	77.18	16800.0
2011-02-17	BMVP	ETF	15.65	15.8	15.65	15.79	9739.0
2011-02-17	BND	ETF	79.67	79.73	79.63	79.65	561800.0
2011-02-17	BNO	ETF	34.585	34.615	34.07	34.305	105200.0
2011-02-17	BRF	ETF	53.17	53.692	53.09	53.68	350173.0
2011-02-17	BSCE	ETF	20.7401	20.82	20.74	20.81	23462.0
2011-02-17	BSV	ETF	80.09	80.16	80.06	80.13	422700.0
2011-02-17	BTF	ETF	86.75	89.14999999999999	86.461	87.05	12711.400000000001
2011-02-17	BWX	ETF	29.195	29.385	29.15	29.31	408670.0
2011-02-17	BWZ	ETF	37.22	37.689	37.2	37.44	102643.0
2011-02-17	BZQ	ETF	2608.0	2616.0	2540.8	2561.6	212.0
2011-02-17	CEF	ETF	20.32	20.6	20.26	20.6	903000.0
2011-02-17	CEW	ETF	22.4	22.54	22.38	22.54	629470.0

> showing 50 of 827 rows — these rows as CSV

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