PREVIEW / etf_daily / 2019-10-25

all etf daily files

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

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-25	SPY	ETF	299.74	302.2	299.68	301.6	45205400.0
2019-10-25	QQQ	ETF	193.09	195.74	193.05	195.64	21507115.0
2019-10-25	IWM	ETF	153.91	155.53	153.9	155.0	10531500.0
2019-10-25	DIA	ETF	267.72	270.12	267.63	269.6	1825200.0
2019-10-25	GLD	ETF	142.79	142.83	141.4	141.86	6011500.0
2019-10-25	TLT	ETF	139.53	139.55	138.31	138.52	5669800.0
2019-10-25	AAAU	ETF	15.13	15.13	14.98	15.02	212900.0
2019-10-25	AADR	ETF	49.69	49.69	49.49	49.63	29600.0
2019-10-25	AAXJ	ETF	68.57	69.15	68.57	69.12	467400.0
2019-10-25	ACES	ETF	31.5	31.509	31.093	31.493	6500.0
2019-10-25	ACIO	ETF	24.844	24.844	24.837	24.837	300.0
2019-10-25	ACSI	ETF	34.3379	34.5446	34.3373	34.5446	1169.0
2019-10-25	ACTX	ETF	10.1481	11.8001	8.2601	8.3781	1646.0
2019-10-25	ACWF	ETF	29.54	29.7403	29.54	29.6977	18474.0
2019-10-25	ACWI	ETF	75.03	75.53	75.02	75.41	1268100.0
2019-10-25	ACWV	ETF	95.11	95.11	94.87	94.92	181700.0
2019-10-25	ACWX	ETF	47.15	47.3846	47.15	47.35	599021.0
2019-10-25	ADRE	ETF	39.96	40.4089	39.96	40.4089	7152.0
2019-10-25	AFIF	ETF	9.78	9.78	9.6801	9.69	24216.0
2019-10-25	AFK	ETF	20.4532	20.4592	20.35	20.412	7727.0
2019-10-25	AFTY	ETF	17.357	17.498	17.357	17.479	3900.0
2019-10-25	AGG	ETF	112.84	112.85	112.52	112.62	2486600.0
2019-10-25	AGGY	ETF	52.11	52.15	52.03	52.06	129900.0
2019-10-25	AGNG	ETF	22.01	22.08	21.94	22.08	11900.0
2019-10-25	AGQ	ETF	33.71	33.8	32.2	32.93	493800.0
2019-10-25	AGZ	ETF	116.21	116.27	115.9605	116.02	17278.0
2019-10-25	AGZD	ETF	23.875	23.925	23.85	23.865	6800.0
2019-10-25	AIA	ETF	60.75	61.13	60.75	61.12	16134.0
2019-10-25	AIEQ	ETF	26.34	26.562	26.333	26.524	13400.0
2019-10-25	AIQ	ETF	16.04	16.2073	16.04	16.1751	6020.0
2019-10-25	AIRR	ETF	27.827	27.827	27.747	27.813	1900.0
2019-10-25	AIVI	ETF	41.61	41.69	41.6	41.69	4100.0
2019-10-25	ALTY	ETF	14.862	14.87	14.818	14.85	6600.0
2019-10-25	AMJ	ETF	22.15	22.21	22.01	22.16	1125418.0
2019-10-25	AMLP	ETF	43.25	43.6	43.15	43.25	6850220.0
2019-10-25	AMUB	ETF	13.971	13.971	13.971	13.971	0.0
2019-10-25	AMZA	ETF	46.0	46.2	45.6	46.2	60250.0
2019-10-25	ANGL	ETF	29.38	29.42	29.38	29.41	212200.0
2019-10-25	AOA	ETF	55.47	55.75	55.47	55.7	35800.0
2019-10-25	AOK	ETF	35.7	35.76	35.7	35.7351	71603.0
2019-10-25	AOM	ETF	39.34	39.41	39.27	39.36	193446.0
2019-10-25	AOR	ETF	46.29	46.4304	46.2448	46.43	65265.0
2019-10-25	ARGT	ETF	22.39	22.68	22.39	22.5	120000.0
2019-10-25	ARKF	ETF	22.0	22.235	22.0	22.228	11900.0
2019-10-25	ARKG	ETF	28.3	28.62	28.01	28.55	105200.0
2019-10-25	ARKK	ETF	42.46	43.58	42.197	43.52	176500.0
2019-10-25	ARKQ	ETF	32.88	33.7	32.829	33.69	13200.0
2019-10-25	ARKW	ETF	49.98	51.64	49.98	51.61	73200.0
2019-10-25	ASEA	ETF	15.73	15.8	15.73	15.8	4100.0
2019-10-25	ASET	ETF	30.25	30.25	30.25	30.25	117.0

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

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