PREVIEW / etf_daily / 2019-10-30

all etf daily files

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

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-30	SPY	ETF	303.43	304.55	301.99	304.14	49643900.0
2019-10-30	QQQ	ETF	196.42	197.32	195.29	196.99	21764311.0
2019-10-30	IWM	ETF	156.79	156.81	155.28	156.33	14451500.0
2019-10-30	DIA	ETF	270.87	271.99	269.88	271.74	2144700.0
2019-10-30	GLD	ETF	140.54	141.04	139.55	141.02	6992900.0
2019-10-30	TLT	ETF	137.77	139.45	137.77	139.36	10914100.0
2019-10-30	AAAU	ETF	14.89	14.93	14.83	14.93	93400.0
2019-10-30	AADR	ETF	50.07	50.56	49.92	50.56	8700.0
2019-10-30	AAXJ	ETF	69.21	69.6	68.97	69.54	1011400.0
2019-10-30	ACES	ETF	31.34	31.46	31.02	31.105	15100.0
2019-10-30	ACIO	ETF	24.95	24.97	24.95	24.958	17300.0
2019-10-30	ACSI	ETF	34.526	34.6125	34.46	34.6125	16400.0
2019-10-30	ACTX	ETF	8.8501	10.2661	8.2601	8.2601	30.0
2019-10-30	ACWF	ETF	29.7073	29.8736	29.67	29.8736	4808.0
2019-10-30	ACWI	ETF	75.7	76.04	75.39	75.95	2386700.0
2019-10-30	ACWV	ETF	95.09	95.69	95.0	95.63	206300.0
2019-10-30	ACWX	ETF	47.46	47.7	47.26	47.7	1013115.0
2019-10-30	ADRE	ETF	40.405	40.69	40.3807	40.69	11737.0
2019-10-30	AFIF	ETF	9.74	9.74	9.7037	9.7302	1554.0
2019-10-30	AFK	ETF	20.61	20.61	20.2	20.25	2922.0
2019-10-30	AFTY	ETF	17.3	17.42	17.29	17.416	1200.0
2019-10-30	AGG	ETF	112.45	112.75	112.43	112.71	2381400.0
2019-10-30	AGGY	ETF	51.95	52.1	51.95	52.09	235400.0
2019-10-30	AGNG	ETF	22.52	22.55	22.52	22.545	8000.0
2019-10-30	AGQ	ETF	32.16	32.3	31.18	32.27	227100.0
2019-10-30	AGZ	ETF	115.94	116.1199	115.58	116.0899	52436.0
2019-10-30	AGZD	ETF	23.895	23.965	23.865	23.965	14600.0
2019-10-30	AIA	ETF	61.02	61.39	60.85	61.39	18072.0
2019-10-30	AIEQ	ETF	26.62	26.768	26.581	26.7	8300.0
2019-10-30	AIQ	ETF	16.3	16.4455	16.28	16.4304	13109.0
2019-10-30	AIRR	ETF	28.03	28.2	27.99	28.2	7100.0
2019-10-30	AIVI	ETF	41.61	41.87	41.6	41.86	2000.0
2019-10-30	ALTY	ETF	14.85	14.87	14.78	14.86	24400.0
2019-10-30	AMJ	ETF	21.92	21.94	21.72	21.8	3810434.0
2019-10-30	AMLP	ETF	42.8	43.05	42.55	42.8	2970260.0
2019-10-30	AMUB	ETF	13.7479	13.7479	13.7479	13.7479	0.0
2019-10-30	AMZA	ETF	45.0	45.3	44.6	44.9	56080.0
2019-10-30	ANGL	ETF	29.39	29.4	29.3	29.39	296800.0
2019-10-30	AOA	ETF	55.85	56.03	55.66	56.03	28700.0
2019-10-30	AOK	ETF	35.77	35.8306	35.72	35.8235	58744.0
2019-10-30	AOM	ETF	39.37	39.49	39.26	39.44	140561.0
2019-10-30	AOR	ETF	46.48	46.63	46.3889	46.61	91488.0
2019-10-30	ARGT	ETF	22.15	22.15	21.85	22.1	30500.0
2019-10-30	ARKF	ETF	22.19	22.337	22.147	22.337	10900.0
2019-10-30	ARKG	ETF	29.79	29.98	29.475	29.98	121200.0
2019-10-30	ARKK	ETF	44.32	44.38	43.95	44.37	178200.0
2019-10-30	ARKQ	ETF	33.7	33.7	33.41	33.6	9500.0
2019-10-30	ARKW	ETF	51.39	51.635	51.17	51.5	48700.0
2019-10-30	ASEA	ETF	15.85	16.02	15.85	15.93	13100.0
2019-10-30	ASET	ETF	30.18	30.18	30.18	30.18	138.0

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

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