PREVIEW / etf_daily / 2011-03-17

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-17.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-17	SPY	ETF	128.0	128.39	127.1	127.85	254303700.0
2011-03-17	QQQ	ETF	55.01	55.24	54.1294	54.65	94434308.0
2011-03-17	IWM	ETF	79.33	79.44	78.42	78.42	63992800.0
2011-03-17	DIA	ETF	117.45	117.98	116.91	117.69	7902300.0
2011-03-17	GLD	ETF	136.56	137.08	136.25	136.97	9117400.0
2011-03-17	TLT	ETF	93.24	93.61	92.76	93.21	10528500.0
2011-03-17	AADR	ETF	29.09	29.1	29.02	29.02	900.0
2011-03-17	AAXJ	ETF	59.31	59.4	58.74	59.1	222300.0
2011-03-17	ACWI	ETF	46.34	46.5	45.82	46.05	731900.0
2011-03-17	ACWX	ETF	43.16	43.24	42.79	43.02	1436802.0
2011-03-17	ADRE	ETF	45.64	45.674	45.16	45.33	46538.0
2011-03-17	AFK	ETF	31.6	31.6	30.785	31.26	14047.0
2011-03-17	AGG	ETF	105.87	106.08	105.74	105.96	584800.0
2011-03-17	AGQ	ETF	376.0	383.06	369.72	374.9	472300.0
2011-03-17	AGZ	ETF	110.09	110.09	109.56	109.67	173099.0
2011-03-17	AIA	ETF	44.62	44.85	44.25	44.4696	442870.0
2011-03-17	AIQ	ETF	20.2	20.2	19.75	19.8	11601.0
2011-03-17	AIS	ETF	1.57	1.59	1.54	1.55	365927.0
2011-03-17	AIVI	ETF	44.25	44.42	44.08	44.35	16100.0
2011-03-17	AMJ	ETF	36.62	36.81	36.45	36.76	1254023.0
2011-03-17	AMLP	ETF	80.05	80.35	79.75	80.25	115600.0
2011-03-17	AOA	ETF	34.65	34.7	34.46	34.57	20000.0
2011-03-17	AOK	ETF	29.04	29.04	28.99	28.99	14644.0
2011-03-17	AOM	ETF	30.18	30.18	30.104	30.126	16372.0
2011-03-17	AOR	ETF	31.86	31.87	31.74	31.76	28667.0
2011-03-17	ARB	ETF	36.29	36.36	35.56	35.58	171697.0
2011-03-17	ARGT	ETF	28.7	28.76	28.7	28.76	150.0
2011-03-17	ASEA	ETF	14.92	14.98	14.88	14.88	2400.0
2011-03-17	BAB	ETF	25.41	25.52	25.282	25.42	107405.0
2011-03-17	BAL	ETF	97.2	102.87	97.18	101.2	621334.0
2011-03-17	BALT	ETF	9.45	9.48	8.85	8.89	141778.0
2011-03-17	BBH	ETF	34.4933	34.61	34.38	34.4067	26100.0
2011-03-17	BICK	ETF	31.14	31.14	30.703	30.83	19278.0
2011-03-17	BIL	ETF	91.74	91.74	91.72	91.74	595450.0
2011-03-17	BIS	ETF	8006.4	8011.2	7969.6	8011.2	57.5
2011-03-17	BITS	ETF	25.0	25.16	24.76	24.92	2742.0
2011-03-17	BIV	ETF	83.45	83.51	83.09	83.4	232700.0
2011-03-17	BJK	ETF	29.98	30.12	29.81	29.89	7100.0
2011-03-17	BKF	ETF	47.13	47.186	46.55	46.73	287971.0
2011-03-17	BKLN	ETF	24.67	24.69	24.6	24.67	79900.0
2011-03-17	BLV	ETF	79.07	79.18	78.73	79.04	22900.0
2011-03-17	BMVP	ETF	14.8633	14.9397	14.8	14.8733	8036.0
2011-03-17	BND	ETF	80.69	80.79	80.55	80.72	540100.0
2011-03-17	BNO	ETF	37.57	38.285	37.52	38.175	361600.0
2011-03-17	BRF	ETF	52.17	52.42	51.31	51.43	139493.0
2011-03-17	BSCE	ETF	20.95	21.0098	20.95	21.0	5568.0
2011-03-17	BSV	ETF	80.71	80.75	80.64	80.73	807000.0
2011-03-17	BTF	ETF	82.3	83.05	81.85	82.39999999999999	4099.0
2011-03-17	BWX	ETF	30.345	30.345	30.095	30.12	304818.0
2011-03-17	BWZ	ETF	38.47	38.4899	38.1801	38.4899	13954.0

> showing 50 of 832 rows — these rows as CSV

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