PREVIEW / etf_daily / 2021-06-04

all etf daily files

  file:    by_date/etf_daily/2021/2021-06-04.parquet
  size:    88 KB
  rows:    2,345

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-06-04	SPY	ETF	420.75	422.92	418.84	422.6	55938800.0
2021-06-04	QQQ	ETF	331.85	336.0582	331.78	335.6	38736545.0
2021-06-04	IWM	ETF	227.56	228.06	226.21	227.4	19395800.0
2021-06-04	DIA	ETF	347.07	347.99	346.54	347.9	2594200.0
2021-06-04	GLD	ETF	176.65	177.57	176.61	177.16	8375300.0
2021-06-04	TLT	ETF	138.52	139.9	138.52	139.9	15773700.0
2021-06-04	AAA	ETF	25.01	25.01	24.995	24.995	238.0
2021-06-04	AAAU	ETF	18.78	18.87	18.78	18.83	294300.0
2021-06-04	AADR	ETF	67.37	67.37	67.37	67.37	1700.0
2021-06-04	AAXJ	ETF	95.31	95.58	95.26	95.58	429700.0
2021-06-04	ABEQ	ETF	28.335	28.335	28.335	28.335	100.0
2021-06-04	ACES	ETF	68.82	69.53	68.82	69.0	34600.0
2021-06-04	ACIO	ETF	29.56	29.91	29.56	29.892	6800.0
2021-06-04	ACSI	ETF	49.048	49.048	49.048	49.048	197.0
2021-06-04	ACTV	ETF	39.395	39.47	39.23	39.3925	6764.0
2021-06-04	ACVF	ETF	31.35	31.58	31.35	31.55	4600.0
2021-06-04	ACWF	ETF	38.62	38.7159	38.62	38.7159	8024.0
2021-06-04	ACWI	ETF	101.14	101.55	101.12	101.49	1121600.0
2021-06-04	ACWV	ETF	103.8	103.98	103.65	103.95	181300.0
2021-06-04	ACWX	ETF	59.03	59.16	58.96	59.14	437624.0
2021-06-04	ADFI	ETF	9.68	9.72	9.68	9.7	600.0
2021-06-04	ADIV	ETF	19.05	19.085	19.05	19.085	1100.0
2021-06-04	ADME	ETF	38.89	38.96	38.845	38.955	5900.0
2021-06-04	ADRE	ETF	57.2126	57.65	57.2126	57.65	5028.0
2021-06-04	AESR	ETF	13.34	13.363	13.32	13.363	5400.0
2021-06-04	AFIF	ETF	9.77	9.78	9.7576	9.78	14408.0
2021-06-04	AFK	ETF	22.82	22.9686	22.74	22.94	12050.0
2021-06-04	AFLG	ETF	25.253	25.253	25.253	25.253	100.0
2021-06-04	AFMC	ETF	25.603	25.603	25.603	25.603	800.0
2021-06-04	AFTY	ETF	24.29	24.38	24.278	24.37	15200.0
2021-06-04	AGG	ETF	114.39	114.68	114.22	114.68	4535800.0
2021-06-04	AGGY	ETF	51.73	51.87	51.73	51.87	113200.0
2021-06-04	AGNG	ETF	29.14	29.28	29.06	29.28	6300.0
2021-06-04	AGOX	ETF	25.94	26.01	25.915	25.995	9400.0
2021-06-04	AGQ	ETF	52.51	53.0	52.43	52.72	972300.0
2021-06-04	AGZ	ETF	118.19	118.38	118.19	118.32	68750.0
2021-06-04	AGZD	ETF	23.5	23.54	23.485	23.515	38400.0
2021-06-04	AIA	ETF	92.41	92.99	92.41	92.92	36333.0
2021-06-04	AIEQ	ETF	38.07	38.479	38.07	38.32	16100.0
2021-06-04	AIQ	ETF	28.98	29.33	28.9	29.25	12878.0
2021-06-04	AIRR	ETF	42.07	42.13	41.69	42.13	44600.0
2021-06-04	AIVI	ETF	44.85	44.98	44.85	44.97	2200.0
2021-06-04	ALTL	ETF	41.66	41.66	41.4725	41.56	29805.0
2021-06-04	ALTY	ETF	13.58	13.6	13.54	13.6	27600.0
2021-06-04	AMJ	ETF	19.65	19.65	19.385	19.59	325478.0
2021-06-04	AMLP	ETF	36.13	36.17	35.68	35.98	2331300.0
2021-06-04	AMNA	ETF	34.4996	34.4996	34.4996	34.4996	0.0
2021-06-04	AMND	ETF	36.3273	36.3273	36.3273	36.3273	7.0
2021-06-04	AMOM	ETF	34.86	35.28	34.86	35.2	15500.0
2021-06-04	AMPS	ETF	9.835	9.835	9.78	9.78	126496.0

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

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