PREVIEW / etf_daily / 2023-04-05

all etf daily files

  file:    by_date/etf_daily/2023/2023-04-05.parquet
  size:    109 KB
  rows:    2,942

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-05	SPY	ETF	407.91	408.7	405.88	407.6	65200200.0
2023-04-05	QQQ	ETF	318.1	319.06	314.07	315.92	62795706.0
2023-04-05	IWM	ETF	174.25	174.83	172.53	173.63	28247300.0
2023-04-05	DIA	ETF	334.0	335.45	333.76	334.82	2566600.0
2023-04-05	GLD	ETF	188.34	188.86	186.78	187.83	11440800.0
2023-04-05	TLT	ETF	107.77	108.37	107.41	108.25	23047700.0
2023-04-05	AAA	ETF	24.45	24.45	24.45	24.45	60.0
2023-04-05	AAAU	ETF	20.1	20.15	19.93	20.04	2336000.0
2023-04-05	AADR	ETF	47.59	47.59	47.03	47.2	3800.0
2023-04-05	AAPB	ETF	22.34	22.4252	21.94	22.4252	6652.0
2023-04-05	AAPD	ETF	23.7	24.09	23.6401	23.83	149152.0
2023-04-05	AAPU	ETF	23.22	23.32	22.657	22.97	167989.0
2023-04-05	AAXJ	ETF	67.88	67.99	67.27	67.49	253700.0
2023-04-05	ABEQ	ETF	28.24	28.34	28.195	28.33	3500.0
2023-04-05	ACES	ETF	44.86	44.86	43.42	43.82	64600.0
2023-04-05	ACIO	ETF	30.05	30.19	30.05	30.13	41400.0
2023-04-05	ACSI	ETF	44.1297	44.1297	44.1297	44.1297	84.0
2023-04-05	ACT	ETF	22.69	22.88	22.6	22.79	87074.0
2023-04-05	ACTV	ETF	29.33	29.33	28.99	29.0642	4568.0
2023-04-05	ACTX	ETF	0.3	0.3	0.3	0.3	2251.0
2023-04-05	ACVF	ETF	31.3	31.31	31.24	31.277	2500.0
2023-04-05	ACWF	ETF	33.551	33.575	33.39	33.503	7283.0
2023-04-05	ACWI	ETF	91.12	91.21	90.57	90.9	1678700.0
2023-04-05	ACWV	ETF	97.31	97.88	97.31	97.84	166200.0
2023-04-05	ACWX	ETF	48.94	48.99	48.61	48.77	1808852.0
2023-04-05	ADFI	ETF	8.59	8.61	8.59	8.605	12500.0
2023-04-05	ADIV	ETF	13.69	13.69	13.69	13.69	100.0
2023-04-05	ADME	ETF	34.61	34.63	34.57	34.63	11500.0
2023-04-05	ADPV	ETF	22.6644	22.6863	22.6644	22.6863	422.0
2023-04-05	AEMB	ETF	37.84	37.91	37.84	37.91	16500.0
2023-04-05	AESR	ETF	11.997	12.06	11.98	12.06	18700.0
2023-04-05	AFIF	ETF	8.82	8.86	8.82	8.835	9116.0
2023-04-05	AFK	ETF	16.14	16.14	15.89	16.01	9101.0
2023-04-05	AFMC	ETF	22.64	22.646	22.64	22.646	200.0
2023-04-05	AFSM	ETF	22.55	22.69	22.51	22.68	3700.0
2023-04-05	AFTY	ETF	16.289	16.289	16.289	16.289	100.0
2023-04-05	AGG	ETF	100.5	100.98	100.41	100.53	9883500.0
2023-04-05	AGGY	ETF	44.14	44.26	44.14	44.17	103000.0
2023-04-05	AGNG	ETF	26.97	27.12	26.95	27.04	1900.0
2023-04-05	AGOV	ETF	76.2	77.92	76.2	77.92	101.0
2023-04-05	AGOX	ETF	21.46	21.57	21.42	21.485	17200.0
2023-04-05	AGQ	ETF	33.22	33.65	32.68	33.51	899100.0
2023-04-05	AGZ	ETF	108.79	109.02	108.762	108.83	160065.0
2023-04-05	AGZD	ETF	21.74	21.81	21.71	21.765	12000.0
2023-04-05	AHYB	ETF	44.07	44.07	43.752	43.752	2000.0
2023-04-05	AIA	ETF	61.58	61.58	60.73	60.99	21278.0
2023-04-05	AIEQ	ETF	28.45	28.45	28.035	28.175	9400.0
2023-04-05	AIQ	ETF	24.3	24.3	23.7975	23.93	49384.0
2023-04-05	AIRR	ETF	45.87	45.87	44.65	45.093	73100.0
2023-04-05	AIVI	ETF	39.01	39.02	38.93	39.01	4800.0

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

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