PREVIEW / etf_daily / 2023-08-10

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-10.parquet
  size:    108 KB
  rows:    3,005

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-08-10	SPY	ETF	448.19	451.7	444.7	445.91	93005500.0
2023-08-10	QQQ	ETF	370.97	374.36	367.035	368.59	72035265.0
2023-08-10	IWM	ETF	192.24	194.12	189.89	190.72	29378800.0
2023-08-10	DIA	ETF	353.15	355.92	351.19	351.89	4133500.0
2023-08-10	GLD	ETF	178.22	178.7	177.54	177.6	5934600.0
2023-08-10	TLT	ETF	97.04	97.36	95.59	95.59	37253200.0
2023-08-10	AAA	ETF	24.79	24.79	24.775	24.775	1200.0
2023-08-10	AAAU	ETF	19.03	19.08	18.96	18.97	896800.0
2023-08-10	AADR	ETF	51.99	52.27	51.95	51.95	800.0
2023-08-10	AAPB	ETF	25.3	25.57	24.825	24.92	40475.0
2023-08-10	AAPD	ETF	21.78	21.99	21.61	21.94	104192.0
2023-08-10	AAPU	ETF	25.69	25.9799	25.29	25.39	187266.0
2023-08-10	AAXJ	ETF	67.71	68.36	67.35	67.49	814300.0
2023-08-10	ABEQ	ETF	28.29	28.29	28.081	28.081	12400.0
2023-08-10	ACES	ETF	43.79	44.02	42.83	43.02	219100.0
2023-08-10	ACIO	ETF	31.28	31.61	31.275	31.32	196500.0
2023-08-10	ACSI	ETF	47.099	47.099	47.099	47.099	100.0
2023-08-10	ACT	ETF	29.49	29.71	28.69	28.75	151577.0
2023-08-10	ACTV	ETF	32.49	32.57	32.26	32.26	7600.0
2023-08-10	ACVF	ETF	34.46	34.58	34.2	34.227	5500.0
2023-08-10	ACWF	ETF	35.92	35.92	35.65	35.6576	937.0
2023-08-10	ACWI	ETF	97.01	97.7	96.27	96.47	3729100.0
2023-08-10	ACWV	ETF	98.97	99.19	98.31	98.34	152200.0
2023-08-10	ACWX	ETF	49.92	50.2	49.54	49.61	856900.0
2023-08-10	ADFI	ETF	8.44	8.44	8.41	8.41	14100.0
2023-08-10	ADIV	ETF	13.82	13.82	13.8	13.8	100.0
2023-08-10	ADME	ETF	36.775	36.906	36.53	36.538	57600.0
2023-08-10	ADPV	ETF	25.03	25.1311	24.945	25.1311	18577.0
2023-08-10	AEMB	ETF	37.76	37.77	37.47	37.47	1100.0
2023-08-10	AESR	ETF	12.96	12.96	12.78	12.82	36500.0
2023-08-10	AFIF	ETF	8.97	8.97	8.92	8.93	6600.0
2023-08-10	AFK	ETF	15.49	15.49	15.2	15.31	3800.0
2023-08-10	AFLG	ETF	25.565	25.565	25.565	25.565	100.0
2023-08-10	AFMC	ETF	25.25	25.289	25.178	25.178	600.0
2023-08-10	AFSM	ETF	25.387	25.387	25.387	25.387	100.0
2023-08-10	AFTY	ETF	15.8	15.8	15.695	15.695	1400.0
2023-08-10	AGG	ETF	97.06	97.22	96.37	96.37	15516100.0
2023-08-10	AGGH	ETF	22.29	22.35	22.16	22.17	5378.0
2023-08-10	AGGY	ETF	42.82	42.89	42.61	42.61	177300.0
2023-08-10	AGNG	ETF	27.8	27.8	27.68	27.68	1700.0
2023-08-10	AGOV	ETF	74.88	75.8335	74.83	74.83	5641.0
2023-08-10	AGOX	ETF	23.7	23.819	23.46	23.47	20400.0
2023-08-10	AGQ	ETF	26.4	26.98	26.13	26.3	791500.0
2023-08-10	AGRH	ETF	25.6	25.625	25.6	25.625	301.0
2023-08-10	AGZ	ETF	106.6	106.85	106.51	106.51	21400.0
2023-08-10	AGZD	ETF	22.18	22.24	21.81	22.2	194900.0
2023-08-10	AHOY	ETF	20.91	20.91	20.6822	20.6822	117.0
2023-08-10	AHYB	ETF	44.18	44.18	44.065	44.065	500.0
2023-08-10	AIA	ETF	60.43	61.07	59.99	60.06	26500.0
2023-08-10	AIEQ	ETF	32.16	32.37	31.94	32.003	5200.0

> showing 50 of 3,005 rows — these rows as CSV

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