PREVIEW / etf_daily / 2019-10-29

all etf daily files

  file:    by_date/etf_daily/2019/2019-10-29.parquet
  size:    70 KB
  rows:    1,854

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-29	SPY	ETF	303.0	304.23	302.86	303.21	44284900.0
2019-10-29	QQQ	ETF	197.24	197.535	196.01	196.04	18569675.0
2019-10-29	IWM	ETF	156.01	157.34	155.86	156.85	11978300.0
2019-10-29	DIA	ETF	270.47	271.6	270.31	270.87	2884600.0
2019-10-29	GLD	ETF	140.0	140.63	139.78	140.25	3835400.0
2019-10-29	TLT	ETF	137.62	137.74	137.17	137.35	5296600.0
2019-10-29	AAAU	ETF	14.84	14.87	14.81	14.85	41800.0
2019-10-29	AADR	ETF	49.65	49.92	49.6	49.92	6300.0
2019-10-29	AAXJ	ETF	69.29	69.47	69.25	69.31	389200.0
2019-10-29	ACES	ETF	31.72	31.72	31.5	31.54	20400.0
2019-10-29	ACIO	ETF	24.928	24.928	24.864	24.864	4900.0
2019-10-29	ACSI	ETF	34.6218	34.64	34.6016	34.6016	867.0
2019-10-29	ACTX	ETF	8.8501	8.856	8.8501	8.8501	13.0
2019-10-29	ACWF	ETF	29.82	29.97	29.81	29.851	7962.0
2019-10-29	ACWI	ETF	75.65	75.92	75.57	75.77	1343600.0
2019-10-29	ACWV	ETF	94.8	95.18	94.67	95.04	325700.0
2019-10-29	ACWX	ETF	47.4	47.54	47.385	47.48	1224281.0
2019-10-29	ADRE	ETF	40.74	40.74	40.5799	40.5799	1129.0
2019-10-29	AFIF	ETF	9.7159	9.7159	9.7	9.7	1930.0
2019-10-29	AFK	ETF	20.54	20.54	20.5	20.515	1048.0
2019-10-29	AFTY	ETF	17.4	17.445	17.4	17.425	1000.0
2019-10-29	AGG	ETF	112.48	112.5	112.35	112.39	2384700.0
2019-10-29	AGGY	ETF	52.01	52.01	51.95	51.97	102500.0
2019-10-29	AGNG	ETF	22.39	22.61	22.314	22.47	4900.0
2019-10-29	AGQ	ETF	31.49	32.32	31.46	32.03	138200.0
2019-10-29	AGZ	ETF	115.93	115.93	115.8001	115.88	21162.0
2019-10-29	AGZD	ETF	23.91	23.91	23.84	23.895	5600.0
2019-10-29	AIA	ETF	61.12	61.2707	61.1145	61.13	5713.0
2019-10-29	AIEQ	ETF	26.66	26.731	26.57	26.69	13800.0
2019-10-29	AIQ	ETF	16.37	16.37	16.23	16.24	17435.0
2019-10-29	AIRR	ETF	27.88	28.1	27.751	28.02	7200.0
2019-10-29	AIVI	ETF	41.6	41.68	41.6	41.66	3000.0
2019-10-29	ALTY	ETF	14.796	14.83	14.796	14.83	1800.0
2019-10-29	AMJ	ETF	21.89	21.98	21.72	21.77	2743956.0
2019-10-29	AMLP	ETF	42.8	43.1	42.6	42.7	4740240.0
2019-10-29	AMUB	ETF	13.7511	13.7511	13.7511	13.7511	0.0
2019-10-29	AMZA	ETF	45.4	45.5	44.6	45.0	90250.0
2019-10-29	ANGL	ETF	29.39	29.41	29.35	29.35	267600.0
2019-10-29	AOA	ETF	55.8	55.94	55.75	55.81	25200.0
2019-10-29	AOK	ETF	35.73	35.789	35.72	35.74	46606.0
2019-10-29	AOM	ETF	39.35	39.4	39.33	39.33	78370.0
2019-10-29	AOR	ETF	46.45	46.54	46.45	46.47	52225.0
2019-10-29	ARCM	ETF	100.28	100.28	100.225	100.225	400.0
2019-10-29	ARGT	ETF	21.95	22.24	21.7	22.16	58400.0
2019-10-29	ARKF	ETF	22.4	22.41	22.282	22.286	3300.0
2019-10-29	ARKG	ETF	29.51	29.778	29.34	29.66	165500.0
2019-10-29	ARKK	ETF	44.48	44.65	44.177	44.32	401500.0
2019-10-29	ARKQ	ETF	34.02	34.02	33.73	33.73	5000.0
2019-10-29	ARKW	ETF	52.0	52.0	51.35	51.36	39800.0
2019-10-29	ASEA	ETF	15.8	15.87	15.8	15.86	3200.0

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

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