PREVIEW / etf_daily / 2019-10-28

all etf daily files

  file:    by_date/etf_daily/2019/2019-10-28.parquet
  size:    71 KB
  rows:    1,856

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
2019-10-28	SPY	ETF	302.94	303.85	302.91	303.3	42147000.0
2019-10-28	QQQ	ETF	196.57	197.83	196.55	197.57	18842303.0
2019-10-28	IWM	ETF	155.66	156.98	155.01	156.34	15392400.0
2019-10-28	DIA	ETF	270.78	271.58	270.19	270.81	1809600.0
2019-10-28	GLD	ETF	141.25	141.25	140.4	140.64	5442000.0
2019-10-28	TLT	ETF	137.58	137.58	136.99	137.26	11402100.0
2019-10-28	AAAU	ETF	14.95	14.95	14.87	14.89	158300.0
2019-10-28	AADR	ETF	49.37	49.89	49.37	49.7	10200.0
2019-10-28	AAXJ	ETF	69.43	69.83	69.43	69.65	1494100.0
2019-10-28	ACES	ETF	31.75	31.75	31.49	31.503	27500.0
2019-10-28	ACIO	ETF	24.95	24.95	24.92	24.925	4300.0
2019-10-28	ACSI	ETF	34.6656	34.6656	34.62	34.62	1811.0
2019-10-28	ACTX	ETF	8.3486	11.0921	8.3486	8.5551	710.0
2019-10-28	ACWF	ETF	29.78	29.88	29.78	29.8466	11349.0
2019-10-28	ACWI	ETF	75.69	75.91	75.68	75.86	1142600.0
2019-10-28	ACWV	ETF	95.07	95.1	94.83	94.83	162900.0
2019-10-28	ACWX	ETF	47.45	47.61	47.44	47.6	906490.0
2019-10-28	ADRE	ETF	40.61	40.9208	40.61	40.8345	4132.0
2019-10-28	AFIF	ETF	9.6929	9.7	9.6601	9.68	11071.0
2019-10-28	AFK	ETF	20.48	20.5391	20.47	20.5175	1760.0
2019-10-28	AFTY	ETF	17.512	17.54	17.51	17.529	2700.0
2019-10-28	AGG	ETF	112.42	112.44	112.31	112.38	2948300.0
2019-10-28	AGGY	ETF	51.98	52.0	51.93	51.99	227300.0
2019-10-28	AGNG	ETF	22.13	22.292	22.13	22.292	3100.0
2019-10-28	AGQ	ETF	32.57	32.57	31.97	32.11	208900.0
2019-10-28	AGZ	ETF	115.89	115.89	115.7968	115.8353	13530.0
2019-10-28	AGZD	ETF	23.935	23.965	23.915	23.915	15600.0
2019-10-28	AIA	ETF	61.56	61.75	61.56	61.74	16119.0
2019-10-28	AIEQ	ETF	26.64	26.699	26.569	26.69	16400.0
2019-10-28	AIQ	ETF	16.34	16.355	16.25	16.34	24449.0
2019-10-28	AIRR	ETF	27.88	28.15	27.88	28.061	5600.0
2019-10-28	AIVI	ETF	41.8	41.83	41.74	41.78	2700.0
2019-10-28	ALTY	ETF	14.86	14.893	14.813	14.82	7500.0
2019-10-28	AMJ	ETF	22.19	22.33	21.83	21.83	1220117.0
2019-10-28	AMLP	ETF	43.45	43.85	42.8	42.9	2853600.0
2019-10-28	AMOM	ETF	26.17	26.17	26.165	26.165	200.0
2019-10-28	AMUB	ETF	13.7819	13.7819	13.7819	13.7819	2.0
2019-10-28	AMZA	ETF	46.2	46.6	45.4	45.5	62370.0
2019-10-28	ANGL	ETF	29.44	29.44	29.39	29.4	264400.0
2019-10-28	AOA	ETF	55.73	55.93	55.73	55.85	33500.0
2019-10-28	AOK	ETF	35.73	35.7596	35.7001	35.7205	71441.0
2019-10-28	AOM	ETF	39.35	39.41	39.33	39.35	86070.0
2019-10-28	AOR	ETF	46.45	46.5359	46.45	46.45	97593.0
2019-10-28	ARGT	ETF	22.59	22.75	21.96	22.0	137600.0
2019-10-28	ARKF	ETF	22.32	22.54	22.32	22.49	7800.0
2019-10-28	ARKG	ETF	28.69	29.521	28.69	29.46	92600.0
2019-10-28	ARKK	ETF	43.74	44.761	43.74	44.64	239400.0
2019-10-28	ARKQ	ETF	33.87	34.209	33.87	34.05	19100.0
2019-10-28	ARKW	ETF	51.9	52.73	51.9	52.54	58000.0
2019-10-28	ASEA	ETF	15.74	15.8	15.74	15.8	2100.0

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

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