PREVIEW / etf_daily / 2015-10-05

all etf daily files

  file:    by_date/etf_daily/2015/2015-10-05.parquet
  size:    49 KB
  rows:    1,220

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-05	SPY	ETF	196.46	198.74	196.33	198.47	126320800.0
2015-10-05	QQQ	ETF	104.78	105.78	104.55	105.5	32853533.0
2015-10-05	IWM	ETF	111.66	113.45	111.54	113.27	45220500.0
2015-10-05	DIA	ETF	165.74	167.78	165.49	167.58	6342100.0
2015-10-05	GLD	ETF	109.14	109.38	108.46	108.77	5490200.0
2015-10-05	TLT	ETF	123.72	123.83	122.78	122.87	11362700.0
2015-10-05	AADR	ETF	36.65	37.03	36.65	37.03	2000.0
2015-10-05	AAXJ	ETF	54.74	55.38	54.63	55.33	933400.0
2015-10-05	ACTX	ETF	13.5701	14.7501	10.6201	11.8001	1696.0
2015-10-05	ACWF	ETF	23.06	23.08	23.06	23.08	925.0
2015-10-05	ACWI	ETF	55.53	56.09	55.45	56.04	3140400.0
2015-10-05	ACWV	ETF	68.38	68.93	68.25	68.85	29300.0
2015-10-05	ACWX	ETF	40.35	40.77	40.31	40.74	5998692.0
2015-10-05	ADRE	ETF	29.1	29.58	29.1	29.54	10787.0
2015-10-05	AFK	ETF	20.27	20.5799	20.27	20.54	10866.0
2015-10-05	AFTY	ETF	15.61	15.72	15.43	15.66	9600.0
2015-10-05	AGG	ETF	109.63	109.68	109.37	109.38	4604500.0
2015-10-05	AGGY	ETF	49.944	49.944	49.944	49.944	100.0
2015-10-05	AGQ	ETF	35.29	35.58	34.5	35.18	340300.0
2015-10-05	AGZ	ETF	114.03	114.155	113.74	113.94	1061341.0
2015-10-05	AGZD	ETF	23.94	23.975	23.815	23.895	28800.0
2015-10-05	AIA	ETF	43.14	43.75	43.14	43.63	229009.0
2015-10-05	AIQ	ETF	10.09	10.7	10.08	10.47	40795.0
2015-10-05	AIRR	ETF	15.42	15.996	15.42	15.99	18700.0
2015-10-05	AIVI	ETF	39.3	39.64	39.3	39.6	16300.0
2015-10-05	ALTY	ETF	14.16	14.16	14.152	14.152	200.0
2015-10-05	AMJ	ETF	32.8	33.87	32.75	33.79	3995298.0
2015-10-05	AMLP	ETF	67.5	69.65	67.4	69.15	1819100.0
2015-10-05	AMZA	ETF	149.2	157.4	149.2	155.9	2070.0
2015-10-05	ANGL	ETF	25.54	25.69	25.34	25.61	16600.0
2015-10-05	AOA	ETF	44.5	44.85	44.5	44.85	85900.0
2015-10-05	AOK	ETF	31.82	31.8674	31.68	31.78	29654.0
2015-10-05	AOM	ETF	34.05	34.25	34.05	34.2	102279.0
2015-10-05	AOR	ETF	38.79	38.91	38.59	38.91	355112.0
2015-10-05	ARGT	ETF	16.58	16.87	16.58	16.87	8600.0
2015-10-05	ARKG	ETF	19.36	19.36	19.36	19.36	100.0
2015-10-05	ARKK	ETF	19.52	19.52	19.52	19.52	100.0
2015-10-05	ARKQ	ETF	18.01	18.01	18.01	18.01	100.0
2015-10-05	ARKW	ETF	22.01	22.01	22.01	22.01	1200.0
2015-10-05	ASEA	ETF	12.35	12.52	12.35	12.47	17800.0
2015-10-05	ASHR	ETF	33.68	33.98	33.51	33.85	2002300.0
2015-10-05	ASHS	ETF	37.62	38.54	37.62	38.33	60700.0
2015-10-05	ATMP	ETF	22.56	23.13	22.56	23.06	82400.0
2015-10-05	AWAY	ETF	27.75	28.13	27.5	27.825	956142.0
2015-10-05	BAB	ETF	29.41	29.41	29.2445	29.28	314829.0
2015-10-05	BAL	ETF	40.5	41.25	40.5	41.09	5921.0
2015-10-05	BBC	ETF	28.37	29.0	27.21	28.14	29393.0
2015-10-05	BBH	ETF	119.8	120.73	116.57	117.92	182600.0
2015-10-05	BBP	ETF	29.65	29.95	28.78	29.2	11500.0
2015-10-05	BCM	ETF	27.12	27.12	27.0728	27.12	1039.0

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

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