PREVIEW / etf_daily / 2023-04-06

all etf daily files

  file:    by_date/etf_daily/2023/2023-04-06.parquet
  size:    108 KB
  rows:    2,937

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
2023-04-06	SPY	ETF	406.77	409.48	405.68	409.19	63743300.0
2023-04-06	QQQ	ETF	314.24	318.55	312.82	318.05	46916496.0
2023-04-06	IWM	ETF	173.72	174.46	172.68	173.89	26366300.0
2023-04-06	DIA	ETF	334.35	335.31	333.28	334.9	2333300.0
2023-04-06	GLD	ETF	186.89	187.26	185.95	186.49	6648400.0
2023-04-06	TLT	ETF	108.42	108.87	108.39	108.53	16447300.0
2023-04-06	AAA	ETF	24.47	24.5	24.462	24.49	4515.0
2023-04-06	AAAU	ETF	19.95	19.99	19.85	19.89	3308700.0
2023-04-06	AADR	ETF	47.6	47.88	47.55	47.55	900.0
2023-04-06	AAPB	ETF	22.2127	22.64	22.2001	22.5622	14787.0
2023-04-06	AAPD	ETF	24.06	24.0893	23.67	23.7	169853.0
2023-04-06	AAPU	ETF	22.73	23.29	22.69	23.22	76988.0
2023-04-06	AAXJ	ETF	67.28	67.9	67.15	67.78	367600.0
2023-04-06	ABEQ	ETF	28.25	28.39	28.25	28.39	6600.0
2023-04-06	ACES	ETF	43.31	43.99	43.3	43.75	221600.0
2023-04-06	ACIO	ETF	30.125	30.265	30.11	30.22	25500.0
2023-04-06	ACSI	ETF	44.0399	44.2802	44.0399	44.2802	3219.0
2023-04-06	ACT	ETF	22.85	23.19	22.85	22.94	94825.0
2023-04-06	ACTV	ETF	28.99	29.13	28.98	29.1	11513.0
2023-04-06	ACVF	ETF	31.03	31.37	31.03	31.304	2700.0
2023-04-06	ACWF	ETF	33.46	33.6495	33.43	33.6304	4399.0
2023-04-06	ACWI	ETF	90.72	91.36	90.52	91.26	1758100.0
2023-04-06	ACWV	ETF	97.82	98.26	97.82	98.14	119300.0
2023-04-06	ACWX	ETF	48.76	49.08	48.66	48.97	465045.0
2023-04-06	ADFI	ETF	8.58	8.61	8.58	8.58	6800.0
2023-04-06	ADIV	ETF	13.72	13.72	13.7	13.7	300.0
2023-04-06	ADME	ETF	34.55	34.76	34.55	34.7	10900.0
2023-04-06	ADPV	ETF	22.64	22.66	22.64	22.6588	1805.0
2023-04-06	AEMB	ETF	37.945	37.945	37.945	37.945	100.0
2023-04-06	AESR	ETF	12.0	12.07	12.0	12.04	16100.0
2023-04-06	AFIF	ETF	8.85	8.85	8.781	8.8	20189.0
2023-04-06	AFK	ETF	15.96	16.01	15.85	15.93	12030.0
2023-04-06	AFLG	ETF	23.87	23.87	23.837	23.837	200.0
2023-04-06	AFMC	ETF	22.555	22.555	22.555	22.555	100.0
2023-04-06	AFSM	ETF	22.67	22.67	22.6	22.61	2800.0
2023-04-06	AFTY	ETF	16.235	16.235	16.235	16.235	100.0
2023-04-06	AGG	ETF	100.56	100.69	100.44	100.44	6105200.0
2023-04-06	AGGY	ETF	44.15	44.23	44.14	44.16	88600.0
2023-04-06	AGNG	ETF	27.21	27.42	27.21	27.42	3500.0
2023-04-06	AGOV	ETF	76.735	76.735	76.735	76.735	5.0
2023-04-06	AGOX	ETF	21.416	21.62	21.415	21.47	23900.0
2023-04-06	AGQ	ETF	33.05	33.66	32.44	33.37	708700.0
2023-04-06	AGZ	ETF	108.83	108.9931	108.795	108.8594	19545.0
2023-04-06	AGZD	ETF	21.835	21.835	21.72	21.735	28000.0
2023-04-06	AHYB	ETF	43.78	43.99	43.78	43.957	400.0
2023-04-06	AIA	ETF	60.7	61.53	60.561	61.23	53784.0
2023-04-06	AIEQ	ETF	28.09	28.36	27.8	28.25	9800.0
2023-04-06	AIQ	ETF	23.86	24.15	23.7	24.04	35717.0
2023-04-06	AIRR	ETF	45.11	45.11	44.73	44.74	56600.0
2023-04-06	AIVI	ETF	39.36	39.38	39.36	39.37	700.0

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

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