PREVIEW / etf_daily / 2022-06-03

all etf daily files

  file:    by_date/etf_daily/2022/2022-06-03.parquet
  size:    101 KB
  rows:    2,726

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-03	SPY	ETF	412.4	414.04	409.51	410.54	71874300.0
2022-06-03	QQQ	ETF	309.03	310.47	304.92	306.2	60914684.0
2022-06-03	IWM	ETF	187.29	187.96	185.79	187.06	18972100.0
2022-06-03	DIA	ETF	329.87	331.73	328.73	329.35	4150900.0
2022-06-03	GLD	ETF	173.53	173.97	172.25	172.58	5519400.0
2022-06-03	TLT	ETF	115.09	116.06	114.87	116.03	15330400.0
2022-06-03	AAA	ETF	24.435	24.435	24.435	24.435	21.0
2022-06-03	AAAU	ETF	18.49	18.53	18.35	18.38	3588400.0
2022-06-03	AADR	ETF	57.0	57.0	56.11	56.66	1600.0
2022-06-03	AAXJ	ETF	71.58	71.72	71.03	71.14	1073000.0
2022-06-03	ABEQ	ETF	29.06	29.06	28.9	28.902	2600.0
2022-06-03	ACES	ETF	53.55	54.56	53.05	53.54	210200.0
2022-06-03	ACIO	ETF	30.19	30.19	30.02	30.12	59500.0
2022-06-03	ACSI	ETF	44.9735	44.9735	44.9735	44.9735	94.0
2022-06-03	ACT	ETF	24.54	25.05	24.26	24.98	482385.0
2022-06-03	ACTV	ETF	32.84	32.86	32.75	32.8006	14634.0
2022-06-03	ACTX	ETF	0.75	0.998	0.75	0.998	1405.0
2022-06-03	ACVF	ETF	31.04	31.18	30.99	31.088	2000.0
2022-06-03	ACWF	ETF	34.421	34.4664	34.29	34.31	22045.0
2022-06-03	ACWI	ETF	92.19	92.48	91.57	91.75	2106100.0
2022-06-03	ACWV	ETF	98.49	98.95	98.42	98.59	188900.0
2022-06-03	ACWX	ETF	49.61	49.7	49.32	49.42	3044039.0
2022-06-03	ADFI	ETF	8.725	8.75	8.705	8.705	12300.0
2022-06-03	ADIV	ETF	14.81	14.81	14.81	14.81	100.0
2022-06-03	ADME	ETF	37.449	37.667	37.401	37.43	27700.0
2022-06-03	ADRE	ETF	41.58	41.58	41.1895	41.34	4995.0
2022-06-03	AEMB	ETF	40.53	40.53	40.53	40.53	100.0
2022-06-03	AESR	ETF	12.17	12.26	12.15	12.21	39100.0
2022-06-03	AFIF	ETF	9.05	9.06	9.04	9.05	35579.0
2022-06-03	AFK	ETF	19.42	19.5	19.15	19.15	4055.0
2022-06-03	AFLG	ETF	24.68	24.68	24.642	24.678	1000.0
2022-06-03	AFSM	ETF	24.455	24.455	24.455	24.455	100.0
2022-06-03	AFTY	ETF	17.33	17.33	17.328	17.328	300.0
2022-06-03	AGG	ETF	102.67	102.91	102.64	102.82	6561100.0
2022-06-03	AGGH	ETF	23.75	23.75	23.7013	23.7013	350.0
2022-06-03	AGGY	ETF	45.46	45.59	45.46	45.51	125200.0
2022-06-03	AGNG	ETF	25.8	25.87	25.77	25.807	1200.0
2022-06-03	AGOV	ETF	80.5381	80.5381	80.5381	80.5381	2.0
2022-06-03	AGOX	ETF	22.24	22.4	22.24	22.35	33200.0
2022-06-03	AGQ	ETF	30.15	30.29	29.01	29.22	520300.0
2022-06-03	AGZ	ETF	110.38	110.47	110.33	110.38	18286.0
2022-06-03	AGZD	ETF	23.14	23.14	23.04	23.075	43200.0
2022-06-03	AHHX	ETF	9.19	9.22	9.17	9.1995	15772.0
2022-06-03	AHYB	ETF	45.52	45.521	45.47	45.47	800.0
2022-06-03	AIA	ETF	65.65	65.77	65.03	65.11	94930.0
2022-06-03	AIEQ	ETF	34.52	34.763	34.425	34.53	4800.0
2022-06-03	AIQ	ETF	23.06	23.12	22.76	22.83	12445.0
2022-06-03	AIRR	ETF	40.89	41.097	40.835	41.04	5200.0
2022-06-03	AIVI	ETF	39.58	39.64	39.43	39.5	5400.0
2022-06-03	AIVL	ETF	96.67	96.92	96.2	96.32	25100.0

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

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