PREVIEW / etf_daily / 2013-02-01

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-01.parquet
  size:    40 KB
  rows:    973

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
2013-02-01	SPY	ETF	150.65	151.42	150.39	151.24	131173000.0
2013-02-01	QQQ	ETF	67.34	67.78	67.07	67.66	53124521.0
2013-02-01	IWM	ETF	89.96	90.7	89.85	90.37	33925100.0
2013-02-01	DIA	ETF	139.29	139.89	139.04	139.74	5234900.0
2013-02-01	GLD	ETF	162.66	162.77	160.87	161.45	12904300.0
2013-02-01	TLT	ETF	117.73	117.85	115.51	115.54	10928600.0
2013-02-01	AADR	ETF	33.5	33.5	33.5	33.5	200.0
2013-02-01	AAXJ	ETF	60.74	60.9	60.5	60.8	1138400.0
2013-02-01	ACTV	ETF	5.61	5.91	5.56	5.82	616329.0
2013-02-01	ACWI	ETF	50.26	50.42	50.1	50.34	1962500.0
2013-02-01	ACWV	ETF	58.28	58.45	58.19	58.19	157500.0
2013-02-01	ACWX	ETF	43.3	43.54	43.24	43.49	256992.0
2013-02-01	ADRE	ETF	41.05	41.3	41.05	41.19	28751.0
2013-02-01	AFK	ETF	31.43	31.8	31.1264	31.35	40984.0
2013-02-01	AGEM	ETF	24.07	24.122	23.87	24.08	921.0
2013-02-01	AGG	ETF	110.38	110.39	109.92	109.94	1340000.0
2013-02-01	AGQ	ETF	194.8	195.36	188.2	192.2	432825.0
2013-02-01	AGZ	ETF	112.97	113.049	112.88	112.88	18262.0
2013-02-01	AIA	ETF	47.54	47.712	47.4473	47.67	25801.0
2013-02-01	AIQ	ETF	6.56	6.7	6.5302	6.7	47828.0
2013-02-01	AIVI	ETF	43.38	43.6	43.33	43.51	21200.0
2013-02-01	AMJ	ETF	43.44	43.4898	43.03	43.29	1538510.0
2013-02-01	AMLP	ETF	85.4	87.0	85.4	86.35	1072880.0
2013-02-01	ANGL	ETF	26.92	27.0	26.89	26.9	4900.0
2013-02-01	AOA	ETF	38.87	39.02	38.85	38.96	55400.0
2013-02-01	AOK	ETF	30.98	30.99	30.954	30.96	26633.0
2013-02-01	AOM	ETF	32.39	32.42	32.34	32.34	28819.0
2013-02-01	AOR	ETF	35.05	35.11	35.01	35.09	112074.0
2013-02-01	ARB	ETF	47.0	47.04	46.8601	47.0	332514.0
2013-02-01	ARGT	ETF	18.56	18.7	18.46	18.68	13300.0
2013-02-01	ASEA	ETF	17.13	17.15	17.05	17.12	70500.0
2013-02-01	AWAY	ETF	24.0	24.02	23.57	23.99	667460.0
2013-02-01	BAB	ETF	30.21	30.27	29.94	29.96	183303.0
2013-02-01	BAL	ETF	54.3699	54.49	54.06	54.2501	10043.0
2013-02-01	BALT	ETF	3.21	3.34	3.21	3.3	38071.0
2013-02-01	BBH	ETF	58.25	58.78	57.95	58.64	82400.0
2013-02-01	BCM	ETF	45.79	45.79	45.416	45.416	1310.0
2013-02-01	BIB	ETF	16.5	16.915	16.5	16.735	69012.0
2013-02-01	BICK	ETF	25.83	26.03	25.83	25.97	2430.0
2013-02-01	BIL	ETF	91.6	91.62	91.6	91.6	171650.0
2013-02-01	BIS	ETF	2329.2	2329.2	2268.0	2268.0	130.0
2013-02-01	BIV	ETF	87.35	87.37	86.83	86.83	297600.0
2013-02-01	BJK	ETF	39.02	39.3	38.92	39.28	12900.0
2013-02-01	BKF	ETF	42.09	42.2899	42.01	42.18	92581.0
2013-02-01	BKLN	ETF	25.14	25.14	25.12	25.13	2629600.0
2013-02-01	BLV	ETF	91.59	91.59	90.33	90.46	74600.0
2013-02-01	BMVP	ETF	17.6267	17.6994	17.5934	17.6723	30850.0
2013-02-01	BND	ETF	83.44	83.44	83.05	83.05	1840500.0
2013-02-01	BNO	ETF	43.23	43.58	43.17	43.45	57000.0
2013-02-01	BOIL	ETF	766200.0	781400.0	733800.0	740400.0	11.2

> showing 50 of 973 rows — these rows as CSV

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