PREVIEW / etf_daily / 2022-06-01

all etf daily files

  file:    by_date/etf_daily/2022/2022-06-01.parquet
  size:    102 KB
  rows:    2,746

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
2022-06-01	SPY	ETF	415.17	416.24	406.93	409.59	86585800.0
2022-06-01	QQQ	ETF	310.47	312.65	303.73	306.0	65341653.0
2022-06-01	IWM	ETF	186.27	186.94	181.77	184.26	28352100.0
2022-06-01	DIA	ETF	332.41	332.95	326.1	328.36	3721400.0
2022-06-01	GLD	ETF	172.21	172.53	171.39	172.23	6946500.0
2022-06-01	TLT	ETF	117.03	117.34	115.69	116.22	15544800.0
2022-06-01	AAA	ETF	24.425	24.425	24.425	24.425	51.0
2022-06-01	AAAU	ETF	18.33	18.37	18.25	18.35	800800.0
2022-06-01	AADR	ETF	56.15	56.42	56.0	56.0	800.0
2022-06-01	AAXJ	ETF	72.05	72.17	70.86	71.11	855900.0
2022-06-01	ABEQ	ETF	28.88	29.03	28.81	28.91	112600.0
2022-06-01	ACES	ETF	53.25	53.32	51.48	51.96	118700.0
2022-06-01	ACIO	ETF	29.84	30.13	29.84	29.9	390300.0
2022-06-01	ACSI	ETF	45.1307	45.1307	45.1307	45.1307	93.0
2022-06-01	ACT	ETF	24.37	24.8348	23.92	24.06	454253.0
2022-06-01	ACTV	ETF	32.525	32.87	32.44	32.709	6596.0
2022-06-01	ACTX	ETF	0.7	0.7	0.7	0.7	3000.0
2022-06-01	ACVF	ETF	31.48	31.48	30.85	30.89	5000.0
2022-06-01	ACWF	ETF	34.77	34.77	34.12	34.326	10538.0
2022-06-01	ACWI	ETF	92.78	92.89	90.95	91.46	3117700.0
2022-06-01	ACWV	ETF	99.52	99.6	98.09	98.48	200500.0
2022-06-01	ACWX	ETF	49.95	49.97	49.03	49.21	1532846.0
2022-06-01	ADFI	ETF	8.72	8.74	8.718	8.725	7700.0
2022-06-01	ADIV	ETF	15.029	15.029	14.84	14.853	7800.0
2022-06-01	ADME	ETF	38.0	40.61	37.11	37.24	94000.0
2022-06-01	ADRE	ETF	41.75	41.75	40.93	41.17	5416.0
2022-06-01	AEMB	ETF	40.32	40.41	40.32	40.37	400.0
2022-06-01	AESR	ETF	12.27	12.27	12.06	12.154	14700.0
2022-06-01	AFIF	ETF	9.02	9.02	9.0	9.0098	15074.0
2022-06-01	AFK	ETF	19.24	19.24	18.72	18.84	10298.0
2022-06-01	AFLG	ETF	24.62	24.675	24.55	24.675	400.0
2022-06-01	AFMC	ETF	23.18	23.338	23.18	23.338	100.0
2022-06-01	AFSM	ETF	24.149	24.149	24.149	24.149	100.0
2022-06-01	AFTY	ETF	17.28	17.28	17.08	17.096	3700.0
2022-06-01	AGG	ETF	103.39	103.53	102.75	102.86	8056700.0
2022-06-01	AGGH	ETF	23.75	23.75	23.7205	23.7205	138.0
2022-06-01	AGGY	ETF	45.82	45.89	45.52	45.58	151900.0
2022-06-01	AGNG	ETF	25.62	25.781	25.57	25.781	6400.0
2022-06-01	AGOV	ETF	80.1485	80.5415	80.1485	80.3449	1087.0
2022-06-01	AGOX	ETF	22.27	22.34	21.964	22.121	77700.0
2022-06-01	AGQ	ETF	29.13	29.38	28.58	29.04	473900.0
2022-06-01	AGZ	ETF	110.7	110.73	110.24	110.31	23556.0
2022-06-01	AGZD	ETF	23.06	23.09	22.97	23.02	68400.0
2022-06-01	AHHX	ETF	9.25	9.27	9.2	9.2181	1569.0
2022-06-01	AHYB	ETF	45.66	45.71	45.625	45.625	2300.0
2022-06-01	AIA	ETF	65.99	66.105	64.89	65.15	173842.0
2022-06-01	AIEQ	ETF	34.55	34.55	33.81	34.176	8900.0
2022-06-01	AIQ	ETF	22.96	23.11	22.42	22.58	15191.0
2022-06-01	AIRR	ETF	40.41	40.425	39.699	40.14	10400.0
2022-06-01	AIVI	ETF	39.8	39.8	39.25	39.4	3800.0

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

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