PREVIEW / etf_daily / 2014-01-24

all etf daily files

  file:    by_date/etf_daily/2014/2014-01-24.parquet
  size:    43 KB
  rows:    1,071

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
2014-01-24	SPY	ETF	181.6	181.66	178.83	178.89	208677100.0
2014-01-24	QQQ	ETF	88.06	88.18	86.71	86.74	64334902.0
2014-01-24	IWM	ETF	115.69	115.74	113.22	113.45	53591900.0
2014-01-24	DIA	ETF	160.71	160.89	158.48	158.48	14663200.0
2014-01-24	GLD	ETF	122.06	122.5	121.55	122.29	8515700.0
2014-01-24	TLT	ETF	107.19	107.49	106.99	107.48	11122200.0
2014-01-24	AADR	ETF	36.68	36.68	36.18	36.18	9400.0
2014-01-24	AAXJ	ETF	56.69	56.83	55.97	56.0	463100.0
2014-01-24	ACWI	ETF	56.36	56.36	55.48	55.5	1650100.0
2014-01-24	ACWV	ETF	61.92	62.15	61.57	61.62	78900.0
2014-01-24	ACWX	ETF	45.21	45.21	44.53	44.53	500989.0
2014-01-24	ADRE	ETF	34.61	34.61	34.1	34.1	87028.0
2014-01-24	AFK	ETF	31.0	31.0	30.3	30.31	68241.0
2014-01-24	AGG	ETF	107.48	107.65	107.46	107.58	783200.0
2014-01-24	AGQ	ETF	67.21	67.73	64.56	65.72	1202300.0
2014-01-24	AGZ	ETF	111.34	111.45	111.32	111.39	18626.0
2014-01-24	AGZD	ETF	24.95	24.95	24.95	24.95	400.0
2014-01-24	AIA	ETF	44.62	44.62	44.06	44.09	42262.0
2014-01-24	AIQ	ETF	27.68	27.98	27.5	27.91	28861.0
2014-01-24	AIVI	ETF	46.89	46.93	46.3	46.32	19600.0
2014-01-24	ALTL	ETF	32.16	32.16	32.002	32.002	1545.0
2014-01-24	AMJ	ETF	46.06	46.48	45.84	45.98	1361339.0
2014-01-24	AMLP	ETF	88.65	88.65	88.0	88.3	503320.0
2014-01-24	ANGL	ETF	27.14	27.14	27.0	27.11	2000.0
2014-01-24	AOA	ETF	44.02	44.02	43.52	43.54	41400.0
2014-01-24	AOK	ETF	32.01	32.01	31.8	31.8	22827.0
2014-01-24	AOM	ETF	34.22	34.22	33.97	33.97	56107.0
2014-01-24	AOR	ETF	38.27	38.27	37.85	37.85	33563.0
2014-01-24	ARGT	ETF	18.4	18.4	17.51	17.52	25900.0
2014-01-24	ASEA	ETF	14.95	14.95	14.72	14.74	16400.0
2014-01-24	ASHR	ETF	23.45	23.45	23.07	23.13	431600.0
2014-01-24	ATMP	ETF	27.2	27.23	26.99	27.07	65100.0
2014-01-24	AVIV	ETF	24.28	24.53	24.02	24.24	151413.0
2014-01-24	AWAY	ETF	41.61	41.61	39.87	40.83	1598790.0
2014-01-24	BAB	ETF	27.97	28.0	27.909	27.98	150460.0
2014-01-24	BAL	ETF	55.22	55.22	54.6	54.7	4877.0
2014-01-24	BALT	ETF	5.64	5.64	5.195	5.21	2601824.0
2014-01-24	BBH	ETF	97.37	98.0	95.8	95.8	222300.0
2014-01-24	BCM	ETF	39.13	39.1461	39.04	39.12	183448.0
2014-01-24	BFOR	ETF	7.365	7.365	7.2	7.205	435200.0
2014-01-24	BIB	ETF	45.345	46.165	43.3827	43.495	625148.0
2014-01-24	BICK	ETF	23.07	23.07	22.66	22.66	3933.0
2014-01-24	BIL	ETF	91.54	91.56	91.54	91.54	142100.0
2014-01-24	BIS	ETF	676.0	706.4	675.04	706.4	4873.0
2014-01-24	BIV	ETF	83.08	83.21	82.98	83.1	198000.0
2014-01-24	BIZD	ETF	21.17	21.17	21.05	21.06	4000.0
2014-01-24	BJK	ETF	51.64	51.8	50.33	50.36	52600.0
2014-01-24	BKF	ETF	35.0	35.0	34.49	34.54	158371.0
2014-01-24	BKLN	ETF	24.93	24.94	24.9	24.92	3546200.0
2014-01-24	BLV	ETF	84.68	84.85	84.47	84.85	30900.0

> showing 50 of 1,071 rows — these rows as CSV

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