PREVIEW / etf_daily / 2020-03-26

all etf daily files

  file:    by_date/etf_daily/2020/2020-03-26.parquet
  size:    75 KB
  rows:    1,966

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-03-26	SPY	ETF	249.52	262.8	249.05	261.2	257632800.0
2020-03-26	QQQ	ETF	183.87	192.72	183.61	191.9	79887564.0
2020-03-26	IWM	ETF	111.54	117.6	111.2	116.81	51657600.0
2020-03-26	DIA	ETF	214.43	225.87	214.01	225.07	16071900.0
2020-03-26	GLD	ETF	153.31	154.81	152.08	153.24	12778200.0
2020-03-26	TLT	ETF	164.0	165.68	162.27	163.34	10576200.0
2020-03-26	AAAU	ETF	16.45	16.53	16.23	16.4	212400.0
2020-03-26	AADR	ETF	41.2	42.29	41.2	42.09	19600.0
2020-03-26	AAXJ	ETF	59.62	61.59	59.48	61.35	1985700.0
2020-03-26	ABEQ	ETF	20.285	20.595	20.285	20.55	7400.0
2020-03-26	ACES	ETF	29.44	30.42	29.28	29.88	42600.0
2020-03-26	ACIO	ETF	22.633	22.8	22.57	22.57	132100.0
2020-03-26	ACSI	ETF	27.715	28.5672	27.715	28.5672	1215.0
2020-03-26	ACTX	ETF	3.3925	5.31	3.245	5.31	1641.0
2020-03-26	ACWF	ETF	23.53	24.64	23.53	24.64	136260.0
2020-03-26	ACWI	ETF	60.99	63.76	60.89	63.54	13227500.0
2020-03-26	ACWV	ETF	78.61	81.98	78.02	81.9	798100.0
2020-03-26	ACWX	ETF	37.11	38.48	37.11	38.45	4881594.0
2020-03-26	ADME	ETF	28.15	28.607	28.15	28.607	43000.0
2020-03-26	ADRE	ETF	34.2456	34.4905	34.1609	34.4905	8499.0
2020-03-26	AESR	ETF	8.39	8.44	8.06	8.312	696300.0
2020-03-26	AFIF	ETF	9.5496	9.65	9.465	9.6094	1636748.0
2020-03-26	AFK	ETF	12.97	13.6355	12.7	12.98	43892.0
2020-03-26	AFLG	ETF	15.33	16.094	15.33	16.094	3800.0
2020-03-26	AFMC	ETF	14.35	14.48	14.24	14.468	12800.0
2020-03-26	AFTY	ETF	15.014	15.37	15.014	15.363	2300.0
2020-03-26	AGG	ETF	114.2	115.39	114.2	115.08	16611400.0
2020-03-26	AGGY	ETF	50.82	50.94	50.43	50.82	347100.0
2020-03-26	AGNG	ETF	19.1	19.722	19.1	19.63	10800.0
2020-03-26	AGQ	ETF	20.26	20.64	19.5	19.7	360500.0
2020-03-26	AGZ	ETF	120.63	120.63	119.51	119.885	139432.0
2020-03-26	AGZD	ETF	22.54	22.97	22.52	22.77	68200.0
2020-03-26	AIA	ETF	55.86	57.9025	55.86	57.78	222403.0
2020-03-26	AIEQ	ETF	21.73	22.577	21.73	22.577	30700.0
2020-03-26	AIQ	ETF	15.23	15.9313	15.23	15.9313	32809.0
2020-03-26	AIRR	ETF	19.07	20.29	18.995	20.29	55700.0
2020-03-26	AIVI	ETF	30.9	31.94	30.86	31.92	44100.0
2020-03-26	ALTY	ETF	8.4	9.449	8.4	8.991	8100.0
2020-03-26	AMJ	ETF	9.01	9.72	8.74	9.1	5862399.0
2020-03-26	AMLP	ETF	17.05	18.5	16.55	17.4	13023940.0
2020-03-26	AMOM	ETF	22.768	22.768	22.768	22.768	100.0
2020-03-26	AMUB	ETF	5.58	5.92	5.58	5.7548	12449.0
2020-03-26	AMZA	ETF	11.4	12.0	10.8	11.4	94160.0
2020-03-26	ANGL	ETF	24.44	25.39	24.14	25.05	1916300.0
2020-03-26	AOA	ETF	46.66	48.31	46.61	48.16	298400.0
2020-03-26	AOK	ETF	33.24	33.96	33.24	33.94	263041.0
2020-03-26	AOM	ETF	35.97	36.86	35.9285	36.76	490451.0
2020-03-26	AOR	ETF	40.57	42.0151	40.5428	41.65	568253.0
2020-03-26	ARCM	ETF	99.37	99.37	99.118	99.195	500.0
2020-03-26	ARGT	ETF	16.63	17.31	16.51	16.66	34700.0

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

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