PREVIEW / etf_daily / 2023-05-17

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-17.parquet
  size:    110 KB
  rows:    2,979

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-05-17	SPY	ETF	412.35	415.86	410.64	415.23	87287000.0
2023-05-17	QQQ	ETF	328.24	331.71	327.04	331.12	47486124.0
2023-05-17	IWM	ETF	173.43	176.5	172.16	176.12	38231600.0
2023-05-17	DIA	ETF	332.14	335.17	330.89	334.61	3068800.0
2023-05-17	GLD	ETF	184.31	184.45	183.48	184.23	7474300.0
2023-05-17	TLT	ETF	103.08	103.16	102.35	102.58	21340900.0
2023-05-17	AAA	ETF	24.56	24.56	24.56	24.56	133.0
2023-05-17	AAAU	ETF	19.68	19.69	19.59	19.67	1568600.0
2023-05-17	AADR	ETF	47.42	47.96	47.42	47.96	900.0
2023-05-17	AAPB	ETF	23.8699	24.2681	23.82	24.2681	10423.0
2023-05-17	AAPD	ETF	22.77	22.9099	22.5884	22.64	140430.0
2023-05-17	AAPU	ETF	24.59	24.8584	24.3305	24.76	77262.0
2023-05-17	AAXJ	ETF	65.92	66.33	65.86	66.3	814000.0
2023-05-17	ABEQ	ETF	28.35	28.435	28.31	28.42	5400.0
2023-05-17	ACES	ETF	42.37	43.02	42.16	42.93	54900.0
2023-05-17	ACIO	ETF	29.92	30.19	29.92	30.16	89500.0
2023-05-17	ACSI	ETF	44.1278	44.1278	44.1278	44.1278	60.0
2023-05-17	ACT	ETF	23.74	24.24	23.62	24.06	636369.0
2023-05-17	ACTV	ETF	28.641	29.33	28.525	29.3001	5979.0
2023-05-17	ACVF	ETF	31.08	31.43	31.08	31.406	10600.0
2023-05-17	ACWF	ETF	33.86	34.1405	33.86	34.1405	2453.0
2023-05-17	ACWI	ETF	91.89	92.55	91.55	92.45	2749100.0
2023-05-17	ACWV	ETF	99.09	99.29	98.73	99.17	1376400.0
2023-05-17	ACWX	ETF	49.4	49.56	49.18	49.53	858010.0
2023-05-17	ADFI	ETF	8.45	8.48	8.43	8.445	66200.0
2023-05-17	ADIV	ETF	13.49	13.49	13.49	13.49	100.0
2023-05-17	ADME	ETF	34.57	34.905	34.57	34.8	23000.0
2023-05-17	ADPV	ETF	22.94	23.11	22.9	22.9922	2682.0
2023-05-17	AEMB	ETF	37.214	37.214	37.214	37.214	100.0
2023-05-17	AESR	ETF	11.98	12.067	11.98	12.034	12800.0
2023-05-17	AFIF	ETF	8.784	8.82	8.76	8.77	49738.0
2023-05-17	AFK	ETF	14.99	15.28	14.96	15.1679	3484.0
2023-05-17	AFLG	ETF	23.91	23.918	23.9	23.918	4200.0
2023-05-17	AFMC	ETF	22.89	22.97	22.89	22.936	2000.0
2023-05-17	AFSM	ETF	22.85	22.876	22.85	22.876	3000.0
2023-05-17	AFTY	ETF	15.71	15.71	15.699	15.699	100.0
2023-05-17	AGG	ETF	98.99	99.03	98.68	98.76	6318700.0
2023-05-17	AGGH	ETF	23.01	23.02	23.0005	23.0005	1059.0
2023-05-17	AGGY	ETF	43.54	43.54	43.41	43.43	66800.0
2023-05-17	AGNG	ETF	27.941	28.09	27.937	28.04	1700.0
2023-05-17	AGOV	ETF	77.0	77.0002	76.63	76.63	696.0
2023-05-17	AGOX	ETF	21.65	21.93	21.65	21.84	5200.0
2023-05-17	AGQ	ETF	30.1	30.14	29.35	29.91	608100.0
2023-05-17	AGZ	ETF	108.34	108.34	108.18	108.2	17250.0
2023-05-17	AGZD	ETF	21.795	21.805	21.69	21.78	192400.0
2023-05-17	AHOY	ETF	19.34	19.34	19.3153	19.3153	556.0
2023-05-17	AHYB	ETF	43.452	43.498	43.44	43.498	1300.0
2023-05-17	AIA	ETF	58.66	59.24	58.64	59.12	19960.0
2023-05-17	AIEQ	ETF	27.59	28.29	27.53	28.22	13200.0
2023-05-17	AIQ	ETF	24.27	24.68	24.21	24.62	127823.0

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

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