PREVIEW / etf_daily / 2020-09-18

all etf daily files

  file:    by_date/etf_daily/2020/2020-09-18.parquet
  size:    79 KB
  rows:    2,083

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
2020-09-18	SPY	ETF	335.37	335.49	327.97	330.65	105877900.0
2020-09-18	QQQ	ETF	271.62	272.09	262.63	266.87	86251117.0
2020-09-18	IWM	ETF	153.98	155.29	151.14	153.29	38352800.0
2020-09-18	DIA	ETF	279.02	279.4	274.77	276.52	3156700.0
2020-09-18	GLD	ETF	183.07	184.09	182.64	183.2	9959700.0
2020-09-18	TLT	ETF	164.17	164.24	163.34	163.57	7246300.0
2020-09-18	AAA	ETF	24.9729	24.98	24.97	24.975	5340.0
2020-09-18	AAAU	ETF	19.43	19.52	19.38	19.44	319200.0
2020-09-18	AADR	ETF	56.7	56.7	56.26	56.26	400.0
2020-09-18	AAXJ	ETF	78.2	78.2	77.52	77.62	1147400.0
2020-09-18	ABEQ	ETF	23.78	23.8	23.628	23.628	3800.0
2020-09-18	ACES	ETF	52.6	52.62	51.53	52.12	27800.0
2020-09-18	ACIO	ETF	26.46	26.46	26.25	26.25	4200.0
2020-09-18	ACSI	ETF	36.5172	36.5172	36.5172	36.5172	135.0
2020-09-18	ACTX	ETF	2.478	2.6639	2.2715	2.5606	266.0
2020-09-18	ACWF	ETF	30.05	30.05	29.72	29.806	1726.0
2020-09-18	ACWI	ETF	80.78	80.78	79.42	79.9	2222700.0
2020-09-18	ACWV	ETF	92.66	92.73	91.82	91.96	177000.0
2020-09-18	ACWX	ETF	47.16	47.16	46.715	46.81	1718597.0
2020-09-18	ADFI	ETF	10.0	10.0	10.0	10.0	100.0
2020-09-18	ADME	ETF	33.35	33.46	32.9	33.06	8900.0
2020-09-18	ADRE	ETF	47.34	47.34	46.605	46.71	3876.0
2020-09-18	AESR	ETF	10.76	10.76	10.58	10.677	31100.0
2020-09-18	AFIF	ETF	9.8266	9.83	9.8	9.8	92237.0
2020-09-18	AFK	ETF	17.97	18.03	17.97	18.0	3334.0
2020-09-18	AFLG	ETF	20.05	20.05	19.955	19.955	1600.0
2020-09-18	AFSM	ETF	17.954	17.954	17.954	17.954	100.0
2020-09-18	AFTY	ETF	19.849	19.855	19.76	19.811	4100.0
2020-09-18	AGG	ETF	118.44	118.44	118.18	118.22	5149400.0
2020-09-18	AGGY	ETF	54.09	54.09	53.97	54.01	94000.0
2020-09-18	AGNG	ETF	25.827	25.86	25.64	25.72	1400.0
2020-09-18	AGQ	ETF	56.94	58.35	56.75	56.95	571300.0
2020-09-18	AGZ	ETF	121.33	121.33	121.0917	121.25	40852.0
2020-09-18	AGZD	ETF	23.53	23.54	23.5	23.5	89200.0
2020-09-18	AIA	ETF	73.0	73.0	72.46	72.59	71235.0
2020-09-18	AIEQ	ETF	29.91	30.1	29.55	29.71	5600.0
2020-09-18	AIQ	ETF	22.92	22.92	22.55	22.74	21385.0
2020-09-18	AIRR	ETF	26.55	26.55	26.038	26.135	4500.0
2020-09-18	AIVI	ETF	37.48	37.55	37.2	37.35	172700.0
2020-09-18	ALTL	ETF	25.08	25.08	24.7579	24.8919	1703.0
2020-09-18	ALTY	ETF	10.835	10.84	10.75	10.767	12100.0
2020-09-18	AMJ	ETF	11.72	11.72	11.455	11.54	1812940.0
2020-09-18	AMLP	ETF	21.56	21.65	21.11	21.35	2486500.0
2020-09-18	AMNA	ETF	23.07	23.22	23.02	23.1489	3000.0
2020-09-18	AMND	ETF	24.1843	24.1843	24.1843	24.1843	0.0
2020-09-18	AMOM	ETF	34.3	34.3	33.923	33.923	900.0
2020-09-18	AMUB	ETF	7.2921	7.2921	7.22	7.28	49253.0
2020-09-18	AMZA	ETF	15.13	15.13	14.71	14.94	181700.0
2020-09-18	ANGL	ETF	30.16	30.2	30.02	30.07	1098800.0
2020-09-18	AOA	ETF	58.67	58.67	57.94	58.13	39100.0

> showing 50 of 2,083 rows — these rows as CSV

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