PREVIEW / etf_daily / 2020-06-26

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-26.parquet
  size:    76 KB
  rows:    2,030

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-06-26	SPY	ETF	306.16	306.39	299.42	300.05	127961000.0
2020-06-26	QQQ	ETF	245.75	245.96	239.68	240.22	52824554.0
2020-06-26	IWM	ETF	139.48	139.83	136.49	136.67	39100100.0
2020-06-26	DIA	ETF	255.65	256.05	249.7	250.38	5331400.0
2020-06-26	GLD	ETF	164.87	166.56	164.22	166.54	9753500.0
2020-06-26	TLT	ETF	164.25	165.32	164.18	165.25	12119300.0
2020-06-26	AAAU	ETF	17.49	17.67	17.42	17.67	335100.0
2020-06-26	AADR	ETF	52.74	52.74	52.2	52.28	7100.0
2020-06-26	AAXJ	ETF	69.78	69.78	68.86	69.2	492900.0
2020-06-26	ABEQ	ETF	21.969	21.969	21.969	21.969	100.0
2020-06-26	ACES	ETF	38.33	38.33	36.8	36.8	57200.0
2020-06-26	ACIO	ETF	24.93	24.93	24.826	24.826	700.0
2020-06-26	ACSI	ETF	32.3107	32.3107	32.3107	32.3107	100.0
2020-06-26	ACTX	ETF	3.304	3.3335	3.304	3.3335	139.0
2020-06-26	ACWF	ETF	27.52	27.63	27.19	27.235	131111.0
2020-06-26	ACWI	ETF	73.64	73.65	72.29	72.41	1669500.0
2020-06-26	ACWV	ETF	87.31	87.34	86.37	86.51	314800.0
2020-06-26	ACWX	ETF	43.47	43.47	42.88	42.94	2848042.0
2020-06-26	ADME	ETF	31.79	31.79	31.46	31.46	5400.0
2020-06-26	ADRE	ETF	39.89	39.89	38.8503	39.4201	2563.0
2020-06-26	AESR	ETF	9.709	9.75	9.64	9.64	14100.0
2020-06-26	AFIF	ETF	9.8	9.8366	9.8	9.825	39717.0
2020-06-26	AFK	ETF	16.29	16.29	16.07	16.09	3578.0
2020-06-26	AFLG	ETF	18.43	18.43	18.304	18.304	400.0
2020-06-26	AFMC	ETF	16.37	16.37	16.334	16.334	100.0
2020-06-26	AFSM	ETF	16.07	16.111	16.07	16.111	200.0
2020-06-26	AFTY	ETF	16.64	16.64	16.61	16.617	1200.0
2020-06-26	AGG	ETF	117.99	118.08	117.85	118.01	5683400.0
2020-06-26	AGGY	ETF	53.67	53.77	53.67	53.73	82400.0
2020-06-26	AGNG	ETF	24.104	24.104	24.073	24.073	600.0
2020-06-26	AGQ	ETF	27.43	28.41	26.66	27.88	1237100.0
2020-06-26	AGZ	ETF	121.2	121.2	120.97	120.97	32009.0
2020-06-26	AGZD	ETF	23.675	23.7	23.505	23.51	39400.0
2020-06-26	AIA	ETF	65.15	65.15	64.511	64.7	33088.0
2020-06-26	AIEQ	ETF	27.81	27.87	27.5	27.5	15700.0
2020-06-26	AIQ	ETF	20.6	20.605	20.264	20.31	8976.0
2020-06-26	AIRR	ETF	22.801	22.979	22.76	22.979	6900.0
2020-06-26	AIVI	ETF	35.71	35.71	35.15	35.22	5100.0
2020-06-26	ALTL	ETF	23.34	25.94	23.22	23.2411	1074647.0
2020-06-26	ALTY	ETF	10.75	10.75	10.525	10.551	12000.0
2020-06-26	AMJ	ETF	13.66	13.66	12.93	13.11	1690522.0
2020-06-26	AMLP	ETF	25.33	25.33	24.04	24.29	3490800.0
2020-06-26	AMNA	ETF	23.46	23.46	23.03	23.1099	1100.0
2020-06-26	AMOM	ETF	28.921	28.921	28.921	28.921	100.0
2020-06-26	AMUB	ETF	8.39	8.48	8.13	8.2178	18707.0
2020-06-26	AMZA	ETF	18.31	18.31	16.95	17.22	131700.0
2020-06-26	ANGL	ETF	28.69	28.94	28.25	28.43	1161900.0
2020-06-26	AOA	ETF	54.61	54.73	53.92	54.01	29000.0
2020-06-26	AOK	ETF	36.35	36.35	36.06	36.15	289913.0
2020-06-26	AOM	ETF	39.81	39.91	39.47	39.56	205628.0

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

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