PREVIEW / etf_daily / 2012-02-06

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-06.parquet
  size:    38 KB
  rows:    914

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-02-06	SPY	ETF	133.98	134.51	133.83	134.45	107694500.0
2012-02-06	QQQ	ETF	61.82	62.02	61.66	62.0	28541034.0
2012-02-06	IWM	ETF	82.57	82.93	82.37	82.68	34516000.0
2012-02-06	DIA	ETF	127.83	128.19	127.68	128.12	3852400.0
2012-02-06	GLD	ETF	166.96	167.68	166.61	167.18	8807400.0
2012-02-06	TLT	ETF	116.69	117.8	116.34	117.73	6180600.0
2012-02-06	AAXJ	ETF	56.47	56.66	56.32	56.6	256300.0
2012-02-06	ACTV	ETF	15.28	15.3	15.05	15.21	73987.0
2012-02-06	ACWI	ETF	45.56	45.71	45.46	45.71	630000.0
2012-02-06	ACWV	ETF	53.5	53.5	52.58	52.58	700.0
2012-02-06	ACWX	ETF	40.05	40.276	40.0	40.21	199663.0
2012-02-06	ADRE	ETF	43.5	43.7	43.32	43.64	46150.0
2012-02-06	AFK	ETF	28.98	28.99	28.78	28.95	25151.0
2012-02-06	AGEM	ETF	23.8	23.987	23.79	23.967	4061.0
2012-02-06	AGG	ETF	110.52	110.64	110.4	110.64	1854400.0
2012-02-06	AGQ	ETF	237.8	245.36	237.2	242.32	488925.0
2012-02-06	AGZ	ETF	113.07	113.0882	112.78	112.78	77021.0
2012-02-06	AIA	ETF	43.41	43.64	43.39	43.582	42788.0
2012-02-06	AIQ	ETF	6.7	6.8	6.4	6.75	58500.0
2012-02-06	AIS	ETF	2.72	2.78	2.67	2.74	1663045.0
2012-02-06	AIVI	ETF	41.25	41.39	41.12	41.39	98400.0
2012-02-06	AMJ	ETF	40.12	40.24	40.02	40.24	1079981.0
2012-02-06	AMLP	ETF	84.85	84.9	84.55	84.9	411860.0
2012-02-06	AOA	ETF	35.4	35.5	35.36	35.5	8400.0
2012-02-06	AOK	ETF	29.91	30.0	29.91	30.0	85292.0
2012-02-06	AOM	ETF	30.8	30.91	30.8	30.91	69346.0
2012-02-06	AOR	ETF	32.65	32.72	32.6375	32.69	17876.0
2012-02-06	ARB	ETF	34.62	34.78	33.98	34.17	329251.0
2012-02-06	ARGT	ETF	23.22	23.54	23.2	23.54	1400.0
2012-02-06	ASEA	ETF	15.93	15.96	15.87	15.92	39400.0
2012-02-06	AWAY	ETF	26.73	27.32	26.66	27.11	410558.0
2012-02-06	BAB	ETF	29.11	29.24	29.0552	29.24	161541.0
2012-02-06	BAL	ETF	59.83	60.15	59.41	59.65	12457.0
2012-02-06	BALT	ETF	4.09	4.35	4.09	4.28	217638.0
2012-02-06	BBH	ETF	43.39	44.2467	43.2533	44.22	25500.0
2012-02-06	BCM	ETF	45.38	45.659	45.38	45.607	3038.0
2012-02-06	BIB	ETF	11.4238	11.94	11.3725	11.7622	170968.0
2012-02-06	BICK	ETF	27.65	27.65	27.43	27.518	17359.0
2012-02-06	BIL	ETF	91.64	91.66	91.64	91.66	184900.0
2012-02-06	BIS	ETF	3969.6	3969.6	3808.0	3808.0	25.35
2012-02-06	BITS	ETF	22.4	22.6	22.04	22.2	4248.0
2012-02-06	BIV	ETF	87.93	87.93	87.72	87.8	393200.0
2012-02-06	BJK	ETF	33.9	33.92	33.71	33.83	7200.0
2012-02-06	BKF	ETF	42.47	42.87	42.47	42.78	3297576.0
2012-02-06	BKLN	ETF	24.54	24.54	24.45	24.48	139500.0
2012-02-06	BLV	ETF	90.68	91.38	90.56	91.38	37700.0
2012-02-06	BMVP	ETF	14.83	14.87	14.82	14.87	7319.0
2012-02-06	BND	ETF	83.79	83.89	83.73	83.84	2564400.0
2012-02-06	BNO	ETF	39.905	40.57	39.85	40.5	139600.0
2012-02-06	BOIL	ETF	1376000.0	1418000.0	1305000.0	1407000.0	4.2

> showing 50 of 914 rows — these rows as CSV

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