PREVIEW / etf_daily / 2012-07-20

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-20.parquet
  size:    38 KB
  rows:    932

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
2012-07-20	SPY	ETF	136.95	137.16	136.32	136.47	142904500.0
2012-07-20	QQQ	ETF	65.09	65.1	64.21	64.235	40572549.0
2012-07-20	IWM	ETF	79.33	79.46	78.81	78.93	42314300.0
2012-07-20	DIA	ETF	128.35	128.66	127.81	128.04	7435600.0
2012-07-20	GLD	ETF	152.97	154.0	152.75	153.67	8583800.0
2012-07-20	TLT	ETF	129.6	130.3	129.42	130.06	6365900.0
2012-07-20	AADR	ETF	27.97	27.97	27.97	27.97	200.0
2012-07-20	AAXJ	ETF	52.04	52.2	51.78	51.94	247200.0
2012-07-20	ACTV	ETF	14.84	14.99	14.77	14.95	120206.0
2012-07-20	ACWI	ETF	43.91	43.92	43.68	43.7	779900.0
2012-07-20	ACWV	ETF	56.16	56.16	55.0	55.04	24600.0
2012-07-20	ACWX	ETF	36.76	36.79	36.57	36.61	79257.0
2012-07-20	ADRE	ETF	37.33	37.4	37.15	37.2	37312.0
2012-07-20	AFK	ETF	28.3	28.3	28.0092	28.04	10026.0
2012-07-20	AGG	ETF	112.39	112.55	112.39	112.42	602200.0
2012-07-20	AGQ	ETF	145.04	150.8	144.72	149.52	262475.0
2012-07-20	AGZ	ETF	113.99	114.01	113.894	114.0	9330.0
2012-07-20	AIA	ETF	41.09	41.16	40.8535	40.91	26265.0
2012-07-20	AIQ	ETF	4.25	4.45	4.0	4.0	6647.0
2012-07-20	AIVI	ETF	37.32	37.37	37.12	37.16	40100.0
2012-07-20	AMJ	ETF	39.86	40.18	39.82	40.0	914306.0
2012-07-20	AMLP	ETF	82.75	83.0	82.6	82.7	379880.0
2012-07-20	ANGL	ETF	25.97	25.97	25.84	25.9	4600.0
2012-07-20	AOA	ETF	35.08	35.08	34.94	34.94	21100.0
2012-07-20	AOK	ETF	29.97	30.02	29.9601	29.97	10646.0
2012-07-20	AOM	ETF	30.85	30.88	30.79	30.83	34618.0
2012-07-20	AOR	ETF	32.64	32.66	32.5201	32.57	19814.0
2012-07-20	ARB	ETF	35.8	36.3	35.73	35.96	158129.0
2012-07-20	ARGT	ETF	15.7	15.7	15.7	15.7	50.0
2012-07-20	ASEA	ETF	15.9	16.01	15.89	15.9	7000.0
2012-07-20	AWAY	ETF	21.8	22.3763	21.44	22.13	334376.0
2012-07-20	BAB	ETF	30.37	30.5	30.34	30.5	144947.0
2012-07-20	BAL	ETF	47.84	48.43	47.65	48.42	9563.0
2012-07-20	BALT	ETF	3.43	3.4989	3.4	3.46	28992.0
2012-07-20	BBH	ETF	49.26	49.59	48.74	48.81	16800.0
2012-07-20	BCM	ETF	44.18	44.25	44.1	44.25	5966.0
2012-07-20	BIB	ETF	13.745	13.755	13.7175	13.755	5600.0
2012-07-20	BICK	ETF	21.99	22.009	21.87	21.87	5126.0
2012-07-20	BIL	ETF	91.62	91.64	91.62	91.62	121750.0
2012-07-20	BIS	ETF	2996.8	2998.4	2974.4	2992.32	25.0
2012-07-20	BIV	ETF	90.04	90.1	89.96	90.0	257000.0
2012-07-20	BJK	ETF	31.4	31.4	31.09	31.19	6200.0
2012-07-20	BKF	ETF	35.61	35.64	35.25	35.41	124639.0
2012-07-20	BKLN	ETF	24.56	24.56	24.54	24.55	254900.0
2012-07-20	BLV	ETF	98.53	98.87	98.38	98.78	88800.0
2012-07-20	BMVP	ETF	15.3333	15.3367	15.2533	15.2666	6559.0
2012-07-20	BND	ETF	85.14	85.2	85.11	85.16	881700.0
2012-07-20	BNO	ETF	37.795	38.0	37.665	37.865	195600.0
2012-07-20	BOIL	ETF	1036800.0	1065000.0	1005200.0	1060800.0	10.2
2012-07-20	BOND	ETF	107.26	107.42	107.21	107.4	483475.0

> showing 50 of 932 rows — these rows as CSV

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