PREVIEW / etf_daily / 2020-04-21

all etf daily files

  file:    by_date/etf_daily/2020/2020-04-21.parquet
  size:    74 KB
  rows:    1,954

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-04-21	SPY	ETF	276.73	278.04	272.02	273.04	126385700.0
2020-04-21	QQQ	ETF	210.63	211.16	203.63	204.89	72932771.0
2020-04-21	IWM	ETF	117.42	119.24	116.48	117.74	31608900.0
2020-04-21	DIA	ETF	231.33	233.34	229.41	230.22	6571400.0
2020-04-21	GLD	ETF	157.6	159.21	157.04	158.61	12478100.0
2020-04-21	TLT	ETF	171.93	172.15	170.78	171.29	7850700.0
2020-04-21	AAAU	ETF	16.88	16.88	16.65	16.82	402100.0
2020-04-21	AADR	ETF	43.58	43.76	43.09	43.41	4100.0
2020-04-21	AAXJ	ETF	61.76	61.9	61.2	61.2	663100.0
2020-04-21	ABEQ	ETF	21.19	21.19	20.98	21.009	13200.0
2020-04-21	ACES	ETF	30.87	30.93	29.95	30.28	23300.0
2020-04-21	ACIO	ETF	23.38	23.409	23.299	23.299	4200.0
2020-04-21	ACSI	ETF	29.63	29.63	29.5839	29.5839	200.0
2020-04-21	ACTX	ETF	5.428	5.428	5.074	5.192	108.0
2020-04-21	ACWF	ETF	25.22	25.32	24.86	24.9698	18776.0
2020-04-21	ACWI	ETF	65.6	65.93	64.67	64.77	6007700.0
2020-04-21	ACWV	ETF	84.77	85.16	83.97	84.21	401900.0
2020-04-21	ACWX	ETF	38.27	38.5199	37.9299	38.01	2826290.0
2020-04-21	ADME	ETF	29.516	29.516	29.24	29.29	3500.0
2020-04-21	ADRE	ETF	34.95	35.06	34.6	34.8893	6866.0
2020-04-21	AESR	ETF	8.87	8.875	8.762	8.762	556400.0
2020-04-21	AFIF	ETF	10.22	10.22	9.78	9.81	1761366.0
2020-04-21	AFK	ETF	13.67	13.67	13.41	13.4515	16562.0
2020-04-21	AFLG	ETF	16.75	16.75	16.662	16.662	200.0
2020-04-21	AFTY	ETF	15.23	15.251	15.15	15.251	2400.0
2020-04-21	AGG	ETF	117.43	117.44	117.07	117.14	4660500.0
2020-04-21	AGGY	ETF	53.27	53.27	52.98	53.03	214300.0
2020-04-21	AGNG	ETF	22.1	22.1	21.893	22.01	4600.0
2020-04-21	AGQ	ETF	19.44	20.38	19.21	20.18	390200.0
2020-04-21	AGZ	ETF	120.96	120.96	120.56	120.64	61148.0
2020-04-21	AGZD	ETF	23.405	23.685	23.38	23.38	19800.0
2020-04-21	AIA	ETF	57.42	57.49	56.7581	56.91	79823.0
2020-04-21	AIEQ	ETF	25.0	25.018	24.35	24.58	18800.0
2020-04-21	AIQ	ETF	17.08	17.08	16.55	16.6821	11695.0
2020-04-21	AIRR	ETF	19.65	19.846	19.502	19.76	9300.0
2020-04-21	AIVI	ETF	31.58	31.86	31.39	31.54	17100.0
2020-04-21	ALTY	ETF	9.24	9.297	9.131	9.245	4400.0
2020-04-21	AMJ	ETF	10.99	11.31	10.74	11.26	4259909.0
2020-04-21	AMLP	ETF	20.65	21.45	20.3	21.45	7038200.0
2020-04-21	AMUB	ETF	6.94	7.0746	6.81	7.0746	21466.0
2020-04-21	AMZA	ETF	12.69	13.8	12.69	13.56	137000.0
2020-04-21	ANGL	ETF	26.6	26.76	26.3	26.39	1106600.0
2020-04-21	AOA	ETF	49.75	49.75	48.89	49.09	206300.0
2020-04-21	AOK	ETF	34.75	34.8226	34.44	34.59	227566.0
2020-04-21	AOM	ETF	37.62	37.63	37.3001	37.42	118227.0
2020-04-21	AOR	ETF	42.85	42.85	42.31	42.37	215753.0
2020-04-21	ARGT	ETF	17.29	17.33	16.8	16.98	29700.0
2020-04-21	ARKF	ETF	22.72	22.748	22.09	22.31	46000.0
2020-04-21	ARKG	ETF	38.42	38.489	36.91	37.75	338600.0
2020-04-21	ARKK	ETF	51.99	52.26	49.75	50.61	710900.0

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

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