PREVIEW / etf_daily / 2011-02-18

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-18.parquet
  size:    35 KB
  rows:    831

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-18	SPY	ETF	134.37	134.69	134.06	134.53	130002400.0
2011-02-18	QQQ	ETF	58.88	58.97	58.51	58.73	44341725.0
2011-02-18	IWM	ETF	83.45	83.77	83.04	83.35	39514200.0
2011-02-18	DIA	ETF	122.97	123.64	122.82	123.6	6320900.0
2011-02-18	GLD	ETF	135.17	135.8	134.88	135.41	15890100.0
2011-02-18	TLT	ETF	89.42	89.55	89.08	89.49	6080700.0
2011-02-18	AADR	ETF	30.72	30.8	30.72	30.8	1100.0
2011-02-18	AAXJ	ETF	61.75	61.76	61.43	61.59	252700.0
2011-02-18	ACWI	ETF	49.1	49.27	49.0	49.24	153000.0
2011-02-18	ACWX	ETF	45.75	45.9981	45.72	45.92	70347.0
2011-02-18	ADRE	ETF	47.26	47.45	47.18	47.29	41204.0
2011-02-18	AFK	ETF	34.06	34.12	33.95	33.96	23643.0
2011-02-18	AGG	ETF	104.57	104.72	104.5	104.69	694400.0
2011-02-18	AGQ	ETF	329.54	351.52	329.28	344.54	819050.0
2011-02-18	AGZ	ETF	108.88	108.95	108.68	108.88	23693.0
2011-02-18	AIA	ETF	46.98	47.0	46.69	46.88	94139.0
2011-02-18	AIQ	ETF	21.55	21.7	21.35	21.55	13282.0
2011-02-18	AIS	ETF	1.68	1.69	1.62	1.64	347347.0
2011-02-18	AIVI	ETF	46.65	46.87	46.5	46.76	16400.0
2011-02-18	AMJ	ETF	38.29	38.55	38.25	38.25	1379290.0
2011-02-18	AMLP	ETF	81.9	82.25	81.8	82.05	160260.0
2011-02-18	AOA	ETF	36.16	36.24	36.1	36.14	17800.0
2011-02-18	AOK	ETF	29.08	29.1199	29.03	29.1	26607.0
2011-02-18	AOM	ETF	30.53	30.58	30.48	30.559	13727.0
2011-02-18	AOR	ETF	32.57	32.7	32.57	32.6401	16229.0
2011-02-18	ARB	ETF	43.88	44.09	43.45	43.53	142194.0
2011-02-18	ASEA	ETF	15.31	15.31	15.21	15.27	27100.0
2011-02-18	BAB	ETF	24.85	24.88	24.75	24.88	132205.0
2011-02-18	BAL	ETF	100.83	100.83	96.83	98.06	394833.0
2011-02-18	BALT	ETF	9.34	9.52	9.16	9.45	176852.0
2011-02-18	BBH	ETF	33.84	34.03	33.75	33.8467	15000.0
2011-02-18	BIB	ETF	7.76	7.76	7.76	7.76	800.0
2011-02-18	BICK	ETF	31.6	31.934	31.6	31.7	37280.0
2011-02-18	BIL	ETF	91.7	91.72	91.7	91.7	93750.0
2011-02-18	BIS	ETF	8044.8	8044.8	7755.2	7755.2	1.875
2011-02-18	BITS	ETF	27.6	27.88	27.04	27.64	2423.0
2011-02-18	BIV	ETF	81.75	81.94	81.59	81.93	84900.0
2011-02-18	BJK	ETF	32.81	32.81	32.5	32.62	37400.0
2011-02-18	BKF	ETF	47.88	48.02	47.6801	47.93	116141.0
2011-02-18	BLV	ETF	76.79	77.02	76.61	76.99	19400.0
2011-02-18	BMVP	ETF	15.78	15.84	15.76	15.79	5127.0
2011-02-18	BND	ETF	79.56	79.68	79.5	79.65	555800.0
2011-02-18	BNO	ETF	33.66	34.33	33.6	34.235	74200.0
2011-02-18	BOSS	ETF	48.395	48.395	47.69	47.69	100.0
2011-02-18	BRF	ETF	53.56	54.0	53.38	54.0	244479.0
2011-02-18	BSCE	ETF	20.83	20.88	20.77	20.88	83767.0
2011-02-18	BSV	ETF	80.1	80.22	80.07	80.22	530500.0
2011-02-18	BTF	ETF	86.4	88.05	86.4	87.2	9520.6
2011-02-18	BWX	ETF	29.27	29.435	29.27	29.425	300836.0
2011-02-18	BWZ	ETF	37.3573	37.98	37.3573	37.63	415777.0

> showing 50 of 831 rows — these rows as CSV

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