PREVIEW / etf_daily / 2015-10-19

all etf daily files

  file:    by_date/etf_daily/2015/2015-10-19.parquet
  size:    48 KB
  rows:    1,211

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
2015-10-19	SPY	ETF	202.5	203.37	202.13	203.37	76523900.0
2015-10-19	QQQ	ETF	107.98	108.81	107.74	108.74	23776270.0
2015-10-19	IWM	ETF	114.9	116.21	114.65	115.64	24949500.0
2015-10-19	DIA	ETF	171.28	172.13	171.04	172.12	4859800.0
2015-10-19	GLD	ETF	112.64	112.69	111.89	112.02	3959400.0
2015-10-19	TLT	ETF	123.79	123.97	122.91	123.59	6238400.0
2015-10-19	AADR	ETF	37.61	37.99	37.61	37.99	1400.0
2015-10-19	AAXJ	ETF	57.64	57.75	57.46	57.64	781100.0
2015-10-19	ACTX	ETF	11.5051	11.8001	9.4401	10.6201	839.0
2015-10-19	ACWI	ETF	57.41	57.52	57.26	57.49	1040400.0
2015-10-19	ACWV	ETF	70.17	70.34	70.06	70.34	117900.0
2015-10-19	ACWX	ETF	41.82	41.8627	41.69	41.84	250090.0
2015-10-19	ADRE	ETF	30.26	30.49	30.26	30.4001	9439.0
2015-10-19	AFK	ETF	21.23	21.23	20.91	20.93	13949.0
2015-10-19	AFTY	ETF	16.06	16.06	15.87	15.88	14600.0
2015-10-19	AGG	ETF	109.78	109.9	109.65	109.88	1534900.0
2015-10-19	AGQ	ETF	36.48	36.6	35.51	35.96	144600.0
2015-10-19	AGZ	ETF	114.14	114.155	113.6	114.0604	11837.0
2015-10-19	AGZD	ETF	23.975	24.01	23.94	23.94	6000.0
2015-10-19	AIA	ETF	46.02	46.09	45.876	46.01	7893.0
2015-10-19	AIQ	ETF	10.08	10.25	9.88	10.02	24343.0
2015-10-19	AIRR	ETF	16.13	16.144	16.06	16.08	8100.0
2015-10-19	AIVI	ETF	40.93	40.95	40.77	40.86	10000.0
2015-10-19	AMJ	ETF	34.03	34.22	33.56	33.93	1894949.0
2015-10-19	AMLP	ETF	69.85	70.0	68.75	69.45	1111300.0
2015-10-19	AMZA	ETF	151.4	151.4	146.7	147.5	930.0
2015-10-19	ANGL	ETF	26.01	26.03	25.93	26.03	9700.0
2015-10-19	AOA	ETF	45.65	45.76	45.55	45.76	39100.0
2015-10-19	AOK	ETF	32.14	32.2	32.091	32.18	43533.0
2015-10-19	AOM	ETF	34.65	34.68	34.51	34.68	74965.0
2015-10-19	AOR	ETF	39.48	39.56	39.416	39.56	51394.0
2015-10-19	ARGT	ETF	17.73	17.73	17.4	17.4	3200.0
2015-10-19	ARKG	ETF	19.29	19.69	19.29	19.36	4600.0
2015-10-19	ARKK	ETF	19.8	19.81	19.74	19.81	600.0
2015-10-19	ARKQ	ETF	18.41	18.41	18.41	18.41	100.0
2015-10-19	ARKW	ETF	22.38	22.38	22.24	22.33	400.0
2015-10-19	ASEA	ETF	13.45	13.45	13.33	13.33	7200.0
2015-10-19	ASHR	ETF	35.64	35.82	35.51	35.59	1854900.0
2015-10-19	ASHS	ETF	43.28	43.28	42.41	42.56	38300.0
2015-10-19	ATMP	ETF	23.46	23.46	23.04	23.19	29400.0
2015-10-19	AWAY	ETF	28.82	29.15	28.67	28.92	548802.0
2015-10-19	BAB	ETF	29.26	29.39	29.11	29.27	167928.0
2015-10-19	BAL	ETF	42.7201	42.77	42.108	42.15	8154.0
2015-10-19	BBC	ETF	27.41	28.507	26.86	27.93	36013.0
2015-10-19	BBH	ETF	118.25	120.89	116.96	119.45	192800.0
2015-10-19	BBP	ETF	29.63	30.305	29.0	29.86	6800.0
2015-10-19	BCM	ETF	27.048	27.05	27.045	27.0499	2516.0
2015-10-19	BFOR	ETF	7.7475	7.8125	7.7475	7.78	35600.0
2015-10-19	BIB	ETF	62.3	65.3	60.3605	63.37	2057817.0
2015-10-19	BICK	ETF	20.55	20.55	20.5499	20.5499	251.0

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

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