PREVIEW / etf_daily / 2016-02-23

all etf daily files

  file:    by_date/etf_daily/2016/2016-02-23.parquet
  size:    49 KB
  rows:    1,227

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
2016-02-23	SPY	ETF	194.0	194.32	192.18	192.32	111455300.0
2016-02-23	QQQ	ETF	102.67	102.96	101.51	101.58	29869660.0
2016-02-23	IWM	ETF	101.24	101.49	100.55	100.64	29857100.0
2016-02-23	DIA	ETF	165.61	165.76	163.84	164.15	6052800.0
2016-02-23	GLD	ETF	116.68	117.42	116.52	117.22	9033400.0
2016-02-23	TLT	ETF	129.88	131.74	129.78	131.47	8320700.0
2016-02-23	AADR	ETF	35.97	35.97	35.9	35.9	400.0
2016-02-23	AAXJ	ETF	49.65	49.69	49.21	49.24	396800.0
2016-02-23	ACTX	ETF	5.31	5.31	4.13	4.13	1225.0
2016-02-23	ACWI	ETF	52.47	52.52	51.96	51.97	1554500.0
2016-02-23	ACWV	ETF	69.53	69.65	69.25	69.34	379100.0
2016-02-23	ACWX	ETF	36.79	36.87	36.44	36.44	452348.0
2016-02-23	ADRE	ETF	27.5	27.5	27.06	27.14	3216.0
2016-02-23	AFK	ETF	16.9782	16.9782	16.7999	16.8799	30938.0
2016-02-23	AFTY	ETF	12.08	12.08	11.96	11.96	3600.0
2016-02-23	AGG	ETF	109.63	110.0	109.52	109.84	2337800.0
2016-02-23	AGGY	ETF	49.619	49.759	49.6	49.73	4200.0
2016-02-23	AGQ	ETF	32.41	32.73	32.23	32.48	159100.0
2016-02-23	AGZ	ETF	114.42	114.65	114.27	114.56	14013.0
2016-02-23	AGZD	ETF	23.545	23.545	23.545	23.545	10800.0
2016-02-23	AIA	ETF	39.43	39.47	39.1	39.1	47671.0
2016-02-23	AIQ	ETF	7.09	7.1585	6.89	6.89	9122.0
2016-02-23	AIRR	ETF	15.09	15.09	14.98	14.98	400.0
2016-02-23	AIVI	ETF	36.54	36.57	36.16	36.21	23500.0
2016-02-23	AMJ	ETF	25.45	25.48	24.57	24.64	3673615.0
2016-02-23	AMLP	ETF	50.0	50.0	48.1	48.3	3005360.0
2016-02-23	AMZA	ETF	82.7	82.7	78.5	78.7	10710.0
2016-02-23	ANGL	ETF	23.71	23.93	23.71	23.86	74800.0
2016-02-23	AOA	ETF	42.82	42.82	42.45	42.49	65500.0
2016-02-23	AOK	ETF	31.3	31.31	31.23	31.27	33516.0
2016-02-23	AOM	ETF	33.49	33.52	33.3601	33.43	108841.0
2016-02-23	AOR	ETF	37.61	37.61	37.385	37.42	310157.0
2016-02-23	ARGT	ETF	18.09	18.09	17.72	17.89	125500.0
2016-02-23	ARKG	ETF	16.38	16.38	16.38	16.38	100.0
2016-02-23	ARKK	ETF	16.3	16.3	16.3	16.3	200.0
2016-02-23	ARKQ	ETF	16.248	16.248	16.248	16.248	200.0
2016-02-23	ARKW	ETF	18.223	18.263	18.195	18.195	1100.0
2016-02-23	ASEA	ETF	12.26	12.26	12.2	12.2	900.0
2016-02-23	ASET	ETF	23.84	23.84	23.84	23.84	115.0
2016-02-23	ASHR	ETF	23.25	23.36	23.12	23.13	1368500.0
2016-02-23	ASHS	ETF	33.15	33.32	33.09	33.11	39100.0
2016-02-23	ATMP	ETF	16.71	16.72	16.32	16.46	138800.0
2016-02-23	BAB	ETF	30.0	30.1558	29.9501	30.14	143328.0
2016-02-23	BAL	ETF	38.13	38.189	37.8288	37.8288	14416.0
2016-02-23	BBC	ETF	18.45	18.45	17.59	17.59	9667.0
2016-02-23	BBH	ETF	101.99	103.23	100.68	100.71	54900.0
2016-02-23	BBP	ETF	23.51	23.69	23.095	23.098	2400.0
2016-02-23	BCM	ETF	23.26	23.26	23.111	23.14	21569.0
2016-02-23	BFOR	ETF	6.995	6.995	6.945	6.97	68400.0
2016-02-23	BIB	ETF	41.66	42.55	40.23	40.34	495134.0

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

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