PREVIEW / etf_daily / 2021-09-20

all etf daily files

  file:    by_date/etf_daily/2021/2021-09-20.parquet
  size:    94 KB
  rows:    2,493

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
2021-09-20	SPY	ETF	434.88	436.56	428.86	434.04	166445500.0
2021-09-20	QQQ	ETF	367.46	369.25	360.93	365.7	76203202.0
2021-09-20	IWM	ETF	217.45	218.99	214.22	217.19	44958500.0
2021-09-20	DIA	ETF	340.22	342.16	335.99	339.4	10010600.0
2021-09-20	GLD	ETF	164.29	165.28	164.07	164.94	7566600.0
2021-09-20	TLT	ETF	150.57	151.37	150.23	151.02	14660400.0
2021-09-20	AAA	ETF	25.0061	25.01	25.005	25.005	610.0
2021-09-20	AAAU	ETF	17.48	17.57	17.46	17.55	245900.0
2021-09-20	AADR	ETF	63.34	63.7	63.07	63.7	3600.0
2021-09-20	AAXJ	ETF	84.86	85.14	83.74	84.37	1299900.0
2021-09-20	ABEQ	ETF	26.86	26.91	26.65	26.905	3500.0
2021-09-20	ACES	ETF	67.66	67.99	66.01	66.81	134500.0
2021-09-20	ACIO	ETF	30.35	30.35	29.95	30.18	56700.0
2021-09-20	ACSI	ETF	49.485	49.6707	49.159	49.6707	1560.0
2021-09-20	ACT	ETF	19.48	20.42	19.25	19.85	1069152.0
2021-09-20	ACTV	ETF	37.03	37.03	36.4173	36.8211	4757.0
2021-09-20	ACTX	ETF	1.05	1.05	0.9825	0.99	6160.0
2021-09-20	ACVF	ETF	32.61	32.75	32.01	32.35	31000.0
2021-09-20	ACWF	ETF	37.67	37.68	37.22	37.58	30440.0
2021-09-20	ACWI	ETF	100.84	101.35	99.82	100.95	3431700.0
2021-09-20	ACWV	ETF	104.32	104.97	103.82	104.48	119300.0
2021-09-20	ACWX	ETF	55.59	55.85	55.2	55.69	2248104.0
2021-09-20	ADFI	ETF	9.77	9.77	9.75	9.75	1100.0
2021-09-20	ADIV	ETF	17.1	17.1	17.06	17.06	700.0
2021-09-20	ADME	ETF	39.84	40.08	39.7	40.07	32300.0
2021-09-20	ADRE	ETF	49.0	49.0	47.9543	48.48	16035.0
2021-09-20	AESR	ETF	13.83	13.83	13.6	13.76	16500.0
2021-09-20	AFIF	ETF	9.69	9.71	9.69	9.7	15034.0
2021-09-20	AFK	ETF	20.53	20.58	20.3	20.4877	27892.0
2021-09-20	AFLG	ETF	25.6	25.733	25.6	25.733	2300.0
2021-09-20	AFMC	ETF	24.855	25.082	24.855	25.082	3300.0
2021-09-20	AFSM	ETF	25.59	25.632	25.565	25.632	1800.0
2021-09-20	AFTY	ETF	19.64	19.64	19.4	19.498	7500.0
2021-09-20	AGG	ETF	116.02	116.17	115.98	116.09	5464700.0
2021-09-20	AGGY	ETF	52.7	52.74	52.63	52.73	85800.0
2021-09-20	AGNG	ETF	29.88	30.169	29.659	29.86	4800.0
2021-09-20	AGOV	ETF	100.2	100.265	100.2	100.265	442.0
2021-09-20	AGOX	ETF	25.91	25.91	25.4	25.71	38000.0
2021-09-20	AGQ	ETF	32.5	33.15	32.11	32.37	1212600.0
2021-09-20	AGZ	ETF	118.96	119.1142	118.96	119.02	18840.0
2021-09-20	AGZD	ETF	23.485	23.495	23.42	23.425	73400.0
2021-09-20	AIA	ETF	77.9	78.35	76.997	77.54	111563.0
2021-09-20	AIEQ	ETF	41.87	42.136	41.214	41.737	30300.0
2021-09-20	AIQ	ETF	30.68	30.8197	30.12	30.49	38225.0
2021-09-20	AIRR	ETF	39.99	40.333	39.59	40.23	119000.0
2021-09-20	AIVI	ETF	41.79	41.87	41.54	41.87	12700.0
2021-09-20	ALTL	ETF	42.13	42.33	41.8228	42.16	22098.0
2021-09-20	ALTY	ETF	13.5	13.5	13.24	13.38	21700.0
2021-09-20	AMJ	ETF	17.36	17.4	16.9	17.15	817830.0
2021-09-20	AMLP	ETF	31.82	31.94	30.95	31.37	3908100.0

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

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