PREVIEW / etf_daily / 2020-11-23

all etf daily files

  file:    by_date/etf_daily/2020/2020-11-23.parquet
  size:    80 KB
  rows:    2,127

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-11-23	SPY	ETF	357.28	358.82	354.87	357.46	63230600.0
2020-11-23	QQQ	ETF	291.41	292.75	288.07	290.39	26875588.0
2020-11-23	IWM	ETF	179.25	181.99	178.73	180.82	24816000.0
2020-11-23	DIA	ETF	294.26	296.65	293.48	295.89	2855600.0
2020-11-23	GLD	ETF	175.1	175.24	171.78	172.23	15510600.0
2020-11-23	TLT	ETF	160.82	160.99	160.28	160.77	11300000.0
2020-11-23	AAA	ETF	25.04	25.04	25.04	25.04	222.0
2020-11-23	AAAU	ETF	18.6	18.6	18.24	18.28	1023300.0
2020-11-23	AADR	ETF	57.55	57.55	56.64	56.95	2100.0
2020-11-23	AAXJ	ETF	86.63	86.63	85.75	85.9	1400400.0
2020-11-23	ABEQ	ETF	24.6	24.6	24.557	24.587	1000.0
2020-11-23	ACES	ETF	66.97	68.67	66.69	68.67	124300.0
2020-11-23	ACIO	ETF	27.07	27.19	27.054	27.1	19300.0
2020-11-23	ACSI	ETF	41.54	41.61	41.53	41.61	763.0
2020-11-23	ACTV	ETF	28.81	29.0698	28.8	29.065	3508.0
2020-11-23	ACTX	ETF	2.5	2.75	2.5	2.75	988.0
2020-11-23	ACVF	ETF	26.53	26.53	26.38	26.455	2200.0
2020-11-23	ACWF	ETF	32.07	32.07	31.921	32.02	2198.0
2020-11-23	ACWI	ETF	86.91	87.1	86.25	86.67	4984800.0
2020-11-23	ACWV	ETF	95.66	95.78	95.01	95.27	213400.0
2020-11-23	ACWX	ETF	51.08	51.12	50.68	50.85	1450483.0
2020-11-23	ADME	ETF	34.79	34.79	34.46	34.64	21600.0
2020-11-23	ADRE	ETF	53.99	53.99	53.63	53.9461	15694.0
2020-11-23	AESR	ETF	11.41	11.42	11.395	11.395	1600.0
2020-11-23	AFIF	ETF	9.77	9.83	9.77	9.8	12525.0
2020-11-23	AFK	ETF	19.54	19.79	19.47	19.6601	207691.0
2020-11-23	AFSM	ETF	20.41	20.462	20.41	20.425	1000.0
2020-11-23	AFTY	ETF	22.0	22.0	21.732	21.793	1000.0
2020-11-23	AGG	ETF	118.28	118.3	118.17	118.26	4739000.0
2020-11-23	AGGY	ETF	53.82	53.89	53.81	53.89	81900.0
2020-11-23	AGNG	ETF	26.51	26.51	26.377	26.377	1300.0
2020-11-23	AGQ	ETF	43.22	43.26	40.92	41.49	1345800.0
2020-11-23	AGZ	ETF	120.77	120.89	120.77	120.85	30825.0
2020-11-23	AGZD	ETF	23.67	23.67	23.47	23.49	9400.0
2020-11-23	AIA	ETF	82.89	82.94	82.18	82.37	493390.0
2020-11-23	AIEQ	ETF	32.47	32.9	32.47	32.84	17400.0
2020-11-23	AIQ	ETF	25.5	25.565	25.2501	25.4047	24043.0
2020-11-23	AIRR	ETF	31.518	31.915	31.518	31.82	41200.0
2020-11-23	AIVI	ETF	39.15	39.15	38.86	38.95	4400.0
2020-11-23	ALTL	ETF	29.32	30.01	29.32	29.97	6811.0
2020-11-23	ALTY	ETF	11.53	11.62	11.53	11.6	11800.0
2020-11-23	AMJ	ETF	13.98	14.47	13.97	14.42	1533746.0
2020-11-23	AMLP	ETF	25.15	26.19	25.13	26.07	4498400.0
2020-11-23	AMNA	ETF	25.36	25.36	25.36	25.36	50.0
2020-11-23	AMND	ETF	27.07	27.1326	27.07	27.1326	200.0
2020-11-23	AMOM	ETF	37.24	37.27	37.13	37.27	1900.0
2020-11-23	AMTR	ETF	28.48	28.68	28.43	28.6017	18067.0
2020-11-23	AMUB	ETF	8.85	9.09	8.85	9.0516	6568.0
2020-11-23	AMZA	ETF	18.08	19.1	18.08	19.0	145100.0
2020-11-23	ANEW	ETF	39.58	39.58	39.083	39.196	9500.0

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

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